asp读取mysql_ASP读取MYSQL数据库的方法,ASP读取mysql数据库的演示代码

ASP读取MYSQL数据库测试

strconnection="driver={mysql odbc 5.1 driver};database=数据库名;server=localhost;uid=数据库用户名;password=数据库密码"

set adodataconn = server.createobject("adodb.connection")

adodataconn.open strconnection

strquery = "select * from 数据库的一个表名"

set rs = adodataconn.execute(strquery)

if not rs.bof then

%>

do while not rs.eof

%>

rs.movenext

loop

%>

else

response.write("无数据.")

end if

rs.close

adodataconn.close

set adodataconn = nothing

set rsemaildata = nothing

%>