ASPÁ¬½ÓMySQLÊý¾Ý¿âµÄ·½·¨

ASPÁ¬½ÓMySQLÊý¾Ý¿âµÄ·½·¨
 
 
 
ASPµÈÓïÑÔÁ¬½ÓmysqlÊý¾Ý¿â£¬¿ÉÒÔͨ¹ý°²×°mysqlµÄODBCÇý¶¯£¬Í¨¹ýÅäÖÃODBCÊý¾ÝÔ´£¬Á¬½Ó²¢²Ù×÷Êý¾Ý¿â¡£
mysql odbc 3.51°æ
ÏÂÔصØÖ·:
http://dev.mysql.com/downloads/connector/odbc/3.51.html
£¼%
'²âÊÔ¶ÁÈ¡MySqlÊý¾Ý¿âµÄÄÚÈÝ
strconnection="driver={mysql odbc 3.51 driver};database=weste_net;server=localhost;uid=root;password="
'ÎÞÐèÅäÖÃdsn
set adodataconn = server.createobject("adodb.connection")
adodataconn.open strconnection
strquery = "select * from News"
set rs = adodataconn.execute(strquery)
if not rs.bof then
%£¾
£¼table£¾
£¼tr£¾
£¼td£¼b£¾ÐòÁкţ¼/b£¾£¼/td£¾
£¼td£¾£¼b£¾±êÌ⣼/b£¾£¼/td£¾
£¼/tr£¾
£¼%
do while not rs.eof
%£¾
£¼tr£¾
£¼td£¾£¼%=rs("News_id")%£¾£¼/td£¾
£¼td£¾£¼%=rs("News_Title")%£¾£¼/td£¾
£¼/tr£¾
£¼%
rs.movenext
loop
%£¾
£¼/table£¾
£¼%
else
response.write("ÎÞÊý¾Ý.")
end if
rs.close
adodataconn.close
set adodataconn = nothing
set rsemaildata = nothing
%£¾
PS£ºÈôÏëÖ±½ÓʹÓÃÒÔÉÏ´úÂ룬Ç뽫ȫ½Ç·ûºÅ“£¼£¾”Ìæ»»³É°ë½Ç·ûºÅ“<>”¡£