2、在IIS默認(rèn)WWW目錄下創(chuàng)建test.asp，用notebook編輯，輸入以下代碼 <% set conn=server.createobject("adodb.connection") dns="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=user1;PassWord=pass1;Data Source=oradb" conn.Open dns
SQL="insert into test(a) values(sysdate)" set rs=conn.execute(SQL)
set rs=nothing conn.close set conn=nothing %>
<% set conn=server.createobject("adodb.connection") dns="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=user1;Password=pass1;Data Source=oradb" conn.Open dns
SQL="select to_char(a,'hh24:mi:ss') from test" set rs=conn.execute(SQL)
do while (not rs.eof) %> <table border=1> <tr><td><%=rs.fields(0).value%></font></td> </tr> <% rs.movenext loop
rs.close set rs=nothing conn.close set conn=nothing %>
