会python真的可以为所欲为0(回)
359天前
这里还有人吗1(回)
544天前这里还有人吗0(回)
544天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
769天前到处都是羊，不想上班0(回)
849天前
鸽子
0(回)
853天前<script language="javascript" runat="server"> |
var conn=new ActiveXObject("ADODB.Connection"); |
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("data.mdb"); |
conn.Open(); |
var rs = new ActiveXObject("ADODB.Recordset"); |
rs.LockType=rs.CursorType=1; |
//rs.ActiveConnection=conn; |
//rs.Source="SELECT id,text FROM [Tree]"; |
var sql="SELECT id,text FROM [Tree]"; |
rs.Open(sql,conn); |
while (!rs.EOF) |
...{ |
Response.Write(rs("text")+" "); |
rs.MoveNext(); |
} |
rs.Close; |
rs=null; |
conn.Close(); |
conn=null; |
</script> |
哦，错了 |
不要用server.mappath() |
可以使用路径。不要用server.mappath() |
<script language="javascript" runat="server"> |
var conn=new ActiveXObject("ADODB.Connection"); |
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myTest.mdb"; |
conn.Open(); |
var rs = new ActiveXObject("ADODB.Recordset"); |
rs.LockType=rs.CursorType=1; |
var sql="SELECT * FROM 用户信息表"; |
rs.Open(sql,conn); |
rs.pagesize=5; |
rs.absolutepage=1; |
document.write("<table border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#0000FF\" width=\"80%\" align=\"center\"> "); |
for (i=0;i<rs.pagesize;i++){ |
document.write("<tr bgcolor='#FFFFFF' align='center'> <td>"+rs("username")+"</td></tr>") |
rs.movenext |
} |
document.writeln("</table>") |
</script> |
