使用JavaScript串連SqlServer資料庫。執行CRUD操作。

插入和查詢操作

function db()<br />{<br />//活動編號<br />var activeid = Request.Form("activeid");<br />//使用者名稱<br />var username = Request.Form("username");<br />//手機號碼<br />var mobile = Request.Form("mobile");<br />var conn= Server.CreateObject("ADODB.connection");<br />var rs= Server.CreateObject("adodb.recordset");<br />var userid = getUserIdByName(username);<br />conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");<br />var sql = "insert into user (activeid,userid,chrtel,dtappenddate) values("+activeid+","+userid+",'"+mobile+"',getdate())";<br />rs.open(sql,conn);<br /> rs.close();<br /> conn.close();<br /> rs=null;<br /> conn=null;<br />}<br />function getUserIdByName(username)<br />{<br />var conn= Server.CreateObject("ADODB.connection");<br />var rs= Server.CreateObject("adodb.recordset");<br />conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");<br />var sql = "select userid from RegUsers where chrname='"+username+"'";<br />rs.open(sql,conn);<br />if(!rs.EOF)<br />{<br />return rs("userid");<br />}<br />rs.close();<br /> conn.close();<br /> rs=null;<br /> conn=null;<br />}</p><p>function baoming()<br />{<br />var conn= Server.CreateObject("ADODB.connection");<br />var rs= Server.CreateObject("adodb.recordset");<br />conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");</p><p>var sql = "select userid,activeid,chrtel,CONVERT(varchar(30),dtappenddate,20) as dtappenddate from baoming order by id desc";<br />rs.open(sql,conn);<br />var i =1;<br />while(!rs.EOF && i<31)<br />{<br />Response.Write("<tr align='center'>");<br />Response.Write("<td>"+i +"</td>");<br />Response.Write("<td>"+ getUserNameById(rs('userid')) +"</td>");<br />Response.Write("<td>"+ getActiveNameById(rs('activeid')) +"</td>");<br />Response.Write("<td>"+ rs('chrtel') +"</td>");<br />Response.Write("<td>"+ rs('dtappenddate') +"</td>");<br />Response.Write("</tr>");<br />i++;<br />rs.movenext;<br />}<br />rs.close();<br /> conn.close();<br /> rs=null;<br /> conn=null;<br />}