用Dreamweaver8向数据库输入信息
自己用Dreamweaver8做asp的会员注册网页，自己试了试注册了几个用户，可打开数据库后,并没有注册写入的信息，而编号是增加的。如何解决？<%setconn=Ser...
自己用Dreamweaver8做asp的会员注册网页，自己试了试注册了几个用户，可打开数据库后,并没有注册写入的信息，而编号是增加的。如何解决？
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.open "DRIVER=Driver do Microsoft Access (*.mdb);UID=admin;PWD=;DBQ="&Server.MapPath("db1.mdb")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>注册页面</title>
<style type="text/css">
<!--
body {
margin-top: 0px;
margin-bottom: 0px;
background-image: url();
background-repeat: no-repeat;
}
.STYLE1 {color: #FF0000}
-->
</style></head>
<body>
<table width="800" height="597" border="0" align="center" cellspacing="0">
<tr>
<td height="597" align="center" valign="top" background="img/beijing.jpg"><table width="800" border="0" cellspacing="0">
<tr>
<td width="91" height="114"> </td>
<td width="310"> </td>
<td width="304" align="center" valign="bottom"><img src="img/zcym2.jpg" width="257" height="76" /></td>
<td width="87"> </td>
</tr>
<%
set rst=Server.CreateObject("ADODB.recordset")
set rst1=conn.Execute("insert into user (u_user,u_code) values ('" & request.form("f_user") & "','" & request.form("f_code") & "')")
%>
<tr>
<td height="74"> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
<tr>
<td height="322"> </td>
<td colspan="2" bgcolor="#F9F9F9"><form id="form1" name="form1" method="post" action="1.asp"><table width="90%" border="1" align="center" cellpadding="5" cellspacing="0">
<tr>
<td colspan="3">请在下面填写您的注册资料，红色<span class="STYLE1">*</span>号所标示的选项为必填项</td>
</tr>
<tr>
<td width="24%" align="right">用户名：</td>
<td width="37%" align="left"><input name="f_user" type="text" id="f_user" /></td>
<td width="39%" align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">密码：</td>
<td align="left"><input name="f_code" type="password" id="f_code" /></td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">姓名：</td>
<td align="left"><input name="f_name" type="text" id="f_name" /></td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">性别：</td>
<td align="left"><select name="f_sex" id="f_sex">
<option value="男" selected="selected">男</option>
<option value="女">女</option>
</select> </td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">年龄：</td>
<td align="left"><input name="f_age" type="text" id="f_age" size="8" /></td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td colspan="3" align="center">
<input type="submit" name="Submit" value="提交注册资料" />
<input type="reset" name="Submit2" value="重置表单" /></td>
</tr>
</table>
</form>
</td>
<td> </td>
</tr>
<tr>
<td height="69"> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</body>
</html> 展开
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.open "DRIVER=Driver do Microsoft Access (*.mdb);UID=admin;PWD=;DBQ="&Server.MapPath("db1.mdb")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>注册页面</title>
<style type="text/css">
<!--
body {
margin-top: 0px;
margin-bottom: 0px;
background-image: url();
background-repeat: no-repeat;
}
.STYLE1 {color: #FF0000}
-->
</style></head>
<body>
<table width="800" height="597" border="0" align="center" cellspacing="0">
<tr>
<td height="597" align="center" valign="top" background="img/beijing.jpg"><table width="800" border="0" cellspacing="0">
<tr>
<td width="91" height="114"> </td>
<td width="310"> </td>
<td width="304" align="center" valign="bottom"><img src="img/zcym2.jpg" width="257" height="76" /></td>
<td width="87"> </td>
</tr>
<%
set rst=Server.CreateObject("ADODB.recordset")
set rst1=conn.Execute("insert into user (u_user,u_code) values ('" & request.form("f_user") & "','" & request.form("f_code") & "')")
%>
<tr>
<td height="74"> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
<tr>
<td height="322"> </td>
<td colspan="2" bgcolor="#F9F9F9"><form id="form1" name="form1" method="post" action="1.asp"><table width="90%" border="1" align="center" cellpadding="5" cellspacing="0">
<tr>
<td colspan="3">请在下面填写您的注册资料，红色<span class="STYLE1">*</span>号所标示的选项为必填项</td>
</tr>
<tr>
<td width="24%" align="right">用户名：</td>
<td width="37%" align="left"><input name="f_user" type="text" id="f_user" /></td>
<td width="39%" align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">密码：</td>
<td align="left"><input name="f_code" type="password" id="f_code" /></td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">姓名：</td>
<td align="left"><input name="f_name" type="text" id="f_name" /></td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">性别：</td>
<td align="left"><select name="f_sex" id="f_sex">
<option value="男" selected="selected">男</option>
<option value="女">女</option>
</select> </td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td align="right">年龄：</td>
<td align="left"><input name="f_age" type="text" id="f_age" size="8" /></td>
<td align="left"><span class="STYLE1">*</span></td>
</tr>
<tr>
<td colspan="3" align="center">
<input type="submit" name="Submit" value="提交注册资料" />
<input type="reset" name="Submit2" value="重置表单" /></td>
</tr>
</table>
</form>
</td>
<td> </td>
</tr>
<tr>
<td height="69"> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</body>
</html> 展开
若以下回答无法解决问题，邀请你更新回答
展开全部
<%
set rst=Server.CreateObject("ADODB.recordset")
set rst1=conn.Execute("insert into user (u_user,u_code) values ('" & request.form("f_user") & "','" & request.form("f_code") & "')")
%>
改成
<%
if request("action")="add" then
conn.Execute("insert into user (u_user,u_code) values ('" & request.form("f_user") & "','" & request.form("f_code") & "')")
end if
%>
<form id="form1" name="form1" method="post" action="1.asp">
改成
<form id="form1" name="form1" method="post" action="1.asp?action=add">
set rst=Server.CreateObject("ADODB.recordset")
set rst1=conn.Execute("insert into user (u_user,u_code) values ('" & request.form("f_user") & "','" & request.form("f_code") & "')")
%>
改成
<%
if request("action")="add" then
conn.Execute("insert into user (u_user,u_code) values ('" & request.form("f_user") & "','" & request.form("f_code") & "')")
end if
%>
<form id="form1" name="form1" method="post" action="1.asp">
改成
<form id="form1" name="form1" method="post" action="1.asp?action=add">
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
