以access数据库做实验，目的是显示字段名称和字段值
总的来说javascript想要读取记录集中的数据还是先要把记录集格式化成Enumerator对象，Enumerator 对象提供了访问集合的任何成员的方法，其操作与 VBScript 中的 For...Each 语句相似。
vbscript实现:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open Server.MapPath("db.mdb")
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "select * from users", conn
do until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write("=")
Response.Write(x.value)
Response.Write("<br />")
next
Response.Write("<br />")
rs.MoveNext
loop
rs.close
conn.close
%>
javascript实现:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<%
var conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open (Server.MapPath("db.mdb"))
var rs = Server.CreateObject("ADODB.recordset")
rs.Open ("select * from users", conn)
while (!rs.EOF) {
e = new Enumerator(rs.Fields)
for (; !e.atEnd(); e.moveNext()) {
x = e.item();
Response.Write(x.name)
Response.Write("=")
Response.Write(x.value)
Response.Write("<br />")
}
Response.Write("<br />")
rs.MoveNext()
}
rs.Close()
conn.Close()
%>
总的来说javascript想要读取记录集中的数据还是先要把记录集格式化成Enumerator对象，Enumerator 对象提供了访问集合的任何成员的方法，其操作与 VBScript 中的 For...Each 语句相似。
vbscript实现:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open Server.MapPath("db.mdb")
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "select * from users", conn
do until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write("=")
Response.Write(x.value)
Response.Write("<br />")
next
Response.Write("<br />")
rs.MoveNext
loop
rs.close
conn.close
%>
javascript实现:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<%
var conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open (Server.MapPath("db.mdb"))
var rs = Server.CreateObject("ADODB.recordset")
rs.Open ("select * from users", conn)
while (!rs.EOF) {
e = new Enumerator(rs.Fields)
for (; !e.atEnd(); e.moveNext()) {
x = e.item();
Response.Write(x.name)
Response.Write("=")
Response.Write(x.value)
Response.Write("<br />")
}
Response.Write("<br />")
rs.MoveNext()
}
rs.Close()
conn.Close()
%>
网友评论(0)：
