UC知道ASP问题啊！！高手帮帮忙！！谢谢了
来源：百度知道 编辑：UC知道 时间：2024/07/04 06:44:53
是一个信息写入数据库的ASP代码
<!--#include file="head.asp"-->
<table width="779" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="780" height="13" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="13" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="269" align="center" valign="middle">
<%
dim username,realname,xb,userpassword,userpwd,ask,answer,email
dim year,month,day,qq,tel,phone,addr,kfzl,qm
dim sql
submit=request("Submit")
if submit="提交" then
username=request("username")
realname=request("realname")
xb=request("xb")
userpassword=request("userpassword")
userpwd=request(
<!--#include file="head.asp"-->
<table width="779" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="780" height="13" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="13" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="269" align="center" valign="middle">
<%
dim username,realname,xb,userpassword,userpwd,ask,answer,email
dim year,month,day,qq,tel,phone,addr,kfzl,qm
dim sql
submit=request("Submit")
if submit="提交" then
username=request("username")
realname=request("realname")
xb=request("xb")
userpassword=request("userpassword")
userpwd=request(
1,先在这个set rs=server.CreateObject("ADODB.Recordset")
sql="select * from dbo.user where username='"& username &"'"之前加上
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};uid="你的用户名";pwd="你的密码";dbq="+Server.MapPath("你的数据库名")
2,再在它之后加上
rs.open sql,conn,1,1(或者2,3)
或者直接把原句（set rs部分)去掉conn.execute sql
总的就应该是这样：
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};uid="你的用户名";pwd="你的密码";dbq="+Server.MapPath("你的数据库名")
sql="select * from dbo.user where username='"& username &"'"
conn.execute sql
或者
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};uid="你的用户名";pwd="你的密码";dbq=