你只能用VBStript连,你那写的是VBStript放在了JAVAStript里,所以不对,下面是链接数据库的ASP代码! <% strConnection = "dsn=hc188;driver={myodbd driver};server=localhost;uid=root;pwd=;database=hc188" Set adoDataConn = Server.CreateObject("ADODB.Connection") adoDataConn.Open strConnection strQuery = "SELECT * FROM user" Set rs = adoDataConn.Execute(strQuery) If Not rs.BOF Then %> <TABLE> <TR> <TD<b>username</b></TD> <TD><b>password</b></TD> </TR> <% Do While Not rs.EOF %> <TR> <TD><%=rs("username")%></TD> <TD><%=rs("password")%></TD> </TR> <% rs.MoveNext Loop %> </TABLE> <% Else Response.Write("Sorry, no data found.") End If rs.Close adoDataConn.Close Set adoDataConn = Nothing Set rsEmailData = Nothing %>
我正用ASP做网页,如何才能把用户在网页上输入的内容添加到MySQL中,还有如何从MySQL里检索数据?并返回显示到客户端呢?
<head><title>CONFIRM</title></head>
<body><p> PLEASE CONFIRM YOUR KINTAIHYOU </p>
<script language="javascript">
document.write("<table align=center border = 1>");
var alltime=0;
……
document.write("<p align=center>");
document.write("<input type=button name=confirm value='CONFIRM' onclick='submit();'>");
document.write("</p>");
function submit () {
//SUBMIT DATABASE
<%
set conn=Server.CreateObject("ADOBD.Connection")
conn.Open("DRIVER={MySQL ODBC 3.51 Driver} SERVER=localhost DATABASE=kintaidb UID=root PWD= OPTION=3")
%>
alert ("submit");
<%
Conn.close
%>
}
</script>
</body>
</html>
怎么就连不上呢???
strConnection = "dsn=hc188;driver={myodbd driver};server=localhost;uid=root;pwd=;database=hc188"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection strQuery = "SELECT * FROM user"
Set rs = adoDataConn.Execute(strQuery)
If Not rs.BOF Then
%>
<TABLE>
<TR>
<TD<b>username</b></TD>
<TD><b>password</b></TD>
</TR>
<%
Do While Not rs.EOF
%>
<TR>
<TD><%=rs("username")%></TD>
<TD><%=rs("password")%></TD>
</TR>
<%
rs.MoveNext
Loop
%>
</TABLE>
<%
Else
Response.Write("Sorry, no data found.")
End If rs.Close
adoDataConn.Close
Set adoDataConn = Nothing
Set rsEmailData = Nothing
%>