ASP操作Mysql
ASP操作Mysql,asp读取mysql数据,asp操作mysql表,asp修改mysql表,asp删除mysql表
在此只是读取了mysql表,其他跟asp操作access,sql一样
<%
'定义mysql的地址,用户名,密码,以及库名
dim mysql_address,mysql_username,mysql_password,mysql_DBName
mysql_address="localhost"
mysql_username="root"
mysql_password="root"
mysql_tableName="fisker_table"
'连接数据库
dim conn
dim connstr
connstr = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER="&mysql_address&"; DATABASE="&mysql_DBName&"; UID="&mysql_username&";PASSWORD="&mysql_password&"; OPTION=3"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr
'查询记录
dim sql
sql="select * FROM TABLE_NAME"
dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn
If rs.eof Then
Response.Write("No records returned.")
Else
Do While not rs.eof
Response.write rs("FIRST_FIELD_NAME")
Response.write rs("SECOND_FIELD_NAME")
Response.write rs("THIRD_FIELD_NAME")
rs.MoveNext
Loop
End If
rs.Close
Set rs=nothing
conn.Close
Set conn=nothing
%>