Code666 (代码贴、代码片段)

[JavaScript] 私用----js连接数据库P1 →→→→→进入此内容的聊天室

来自 , 2020-11-23, 写在 JavaScript, 查看 105 次.
URL http://www.code666.cn/view/70c639df
  1. <script language="javascript" runat="server">
  2. var conn=new ActiveXObject("ADODB.Connection");
  3. conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("data.mdb");
  4. conn.Open();
  5. var rs = new ActiveXObject("ADODB.Recordset");
  6. rs.LockType=rs.CursorType=1;
  7. //rs.ActiveConnection=conn;
  8. //rs.Source="SELECT id,text FROM [Tree]";
  9. var sql="SELECT id,text FROM [Tree]";
  10. rs.Open(sql,conn);
  11. while (!rs.EOF)
  12. ...{
  13.  Response.Write(rs("text")+" ");
  14.  rs.MoveNext();
  15. }
  16. rs.Close;
  17. rs=null;
  18. conn.Close();
  19. conn=null;
  20. </script>
  21. 哦，错了
  22. 不要用server.mappath()
  23. 可以使用路径。不要用server.mappath()
  24.  
  25. <script language="javascript" runat="server">
  26. var conn=new ActiveXObject("ADODB.Connection");
  27. conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myTest.mdb";
  28. conn.Open();
  29. var rs = new ActiveXObject("ADODB.Recordset");
  30. rs.LockType=rs.CursorType=1;
  31. var sql="SELECT * FROM 用户信息表";
  32. rs.Open(sql,conn);
  33. rs.pagesize=5;
  34. rs.absolutepage=1;
  35. document.write("<table border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#0000FF\" width=\"80%\" align=\"center\"> ");
  36. for (i=0;i<rs.pagesize;i++){
  37. document.write("<tr bgcolor='#FFFFFF' align='center'> <td>"+rs("username")+"</td></tr>")
  38. rs.movenext
  39. }
  40. document.writeln("</table>")
  41.  
  42.  
  43. </script>

回复 "私用----js连接数据库P1"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666