Use JavaScript to connect to the sqlserver database. Perform the CRUD operation.

Insert and query operations

Function dB () <br/>{< br/> // activity id <br/> var activeid = request. form ("activeid"); <br/> // user name <br/> var username = request. form ("username"); <br/> // mobile phone number <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; u Id = 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, chrte L, 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/>}