<%
on error resume next
strconnection="driver={mysql odbc 3.51 driver};database=0101;server=localhost;uid=root;password=root"
'无需配置dsn
set adodataconn = server.createobject("adodb.connection")
adodataconn.open strconnection
strquery = "select * from user"
response.write strquery
set rs = adodataconn.execute(strquery)
if not rs.bof then
do while not rs.eof
%>
<%=rs("id")%><br>
<%
if not rs.eof then rs.movenext
loop
else
response.write "none"
end if
%>
-------------------
评论