JavaScript数据库连接

1. function db()  
2.     {         
3.         //活动编号  
4.         var activeid = Request.Form("activeid");  
5.         //用户名  
6.         var username = Request.Form("username");  
7.         //手机号码  
8.         var mobile = Request.Form("mobile");          
9.         var conn= Server.CreateObject("ADODB.connection");  
10.         var rs= Server.CreateObject("adodb.recordset");  
11.         var userid = getUserIdByName(username);       
12.         conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");  
13.         var sql = "insert into user (activeid,userid,chrtel,dtappenddate) values("+activeid+","+userid+",'"+mobile+"',getdate())";  
14.         rs.open(sql,conn);  
15.                 rs.close();  
16.   conn.close();  
17.   rs=null;  
18.   conn=null;  
19. }     
20. function getUserIdByName(username)  
21. {  
22.         var conn= Server.CreateObject("ADODB.connection");  
23.         var rs= Server.CreateObject("adodb.recordset");  
24.         conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");  
25.         var sql = "select userid from RegUsers where chrname='"+username+"'";         
26.         rs.open(sql,conn);        
27.         if(!rs.EOF)       
28.         {  
29.             return rs("userid");  
30.         }  
31. rs.close();  
32.   conn.close();  
33.   rs=null;  
34.   conn=null;  
35. }  
36.   
37. function baoming()  
38. {  
39.     var conn= Server.CreateObject("ADODB.connection");  
40.     var rs= Server.CreateObject("adodb.recordset");  
41.     conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");  
42.   
43.     var sql = "select userid,activeid,chrtel,CONVERT(varchar(30),dtappenddate,20) as dtappenddate from baoming order by id desc";  
44.     rs.open(sql,conn);  
45.     var i =1;  
46.     while(!rs.EOF && i<31)  
47.     {                     
48.             Response.Write("<tr align='center'>");  
49.             Response.Write("<td>"+i +"</td>");    
50.             Response.Write("<td>"+ getUserNameById(rs('userid')) +"</td>");  
51.             Response.Write("<td>"+ getActiveNameById(rs('activeid')) +"</td>");  
52.             Response.Write("<td>"+ rs('chrtel') +"</td>");  
53.             Response.Write("<td>"+ rs('dtappenddate') +"</td>");  
54.             Response.Write("</tr>");  
55.             i++;  
56.             rs.movenext;  
57.     }  
58.     rs.close();  
59.   conn.close();  
60.   rs=null;  
61.   conn=null;  
62. }