UC知道用Dreamweaver8向数据库输入信息
来源：百度知道 编辑：UC知道 时间：2024/05/31 12:09:57
自己用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/bei
<%
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/bei
<%
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">