|
本文前提是下載MYSQLX 地址為http://www.amedea.cz/mysqlx/DownloadFiles/MySQLX.zip
這個工具其實是MYSQL的組件對象模塊.同樣它也支持Delphi, Visual Basic, Visual C++, C++ Builder等工具的調用.以下是在ASP里的調用方法.
正確安裝MYSQLX之后.ASP即可用一下方法訪問MYSQL
<%@ language="JavaScript" %>
...
<%
con = Server.CreateObject("MySQL.Connection");
con.Connect("localhost", "root", "", "MyDatabase", 3306, 0);
sql = "select FirstName, LastName from Customers";
if (!con.Query(sql))
Response.Write("ERROR: ".concat(con.ErrMsg()));
else
{
%>
<table>
<tr>
<td class="header">
First name
</td>
<td class="header">
Last name
</td>
</tr>
<%
rs = Server.Create("MySQL.RecordSet");
rs.Connection = con;
while (rs.Next())
{
%>
<tr>
<td class="row">
<%= rs["FirstName"] %>
</td>
<td class="row">
<%= rs["LastName"] %>
</td>
</tr>
<%
};
%>
</table>
<%
};
%>
...
|
