28,391
社区成员
发帖
与我相关
我的任务
分享
<a href="user_amend.asp?uri=<%=rs.Fields("userid")%>">修改</a> 这段代码是连接修改页面并让修改页面根据ID显示出数据
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<form name="form1" action="user_amend.asp" method="post">
<%
Dim conn,rs,txtsql
set conn = server.CreateObject("ADODB.Connection")
conn.connectionstring = "driver=microsoft access driver (*.mdb);dbq=" & server.MapPath("/test") & "\exam.mdb"
conn.open
set rs = server.CreateObject("ADODB.RecordSet")
if len(Request.Form("txtname"))>0 then
txtsql = "UPDATE user SET username='" & Request.Form("txtname") & "',userpass='" & Request.Form("txtpass") & "',sex='" & Request.Form("selectsex") & "',address='" & Request.Form("txtaddr") & "',mail='" & Request.Form("txtmail") & "'where userid='" & Request.Form("uri") & "'"
conn.Execute txtsql
end if
txtsql = "select * from user where userid=" & Request.Form("uri") & ""
rs.Open txtsql,conn,1,3
if not rs.eof then
%>
<P align=center>修改用户信息<p>
<P align=center>用 户 名 <input name="txtname" value="<%=Request.Form("username")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>用户密码 <input type="text" name="txtpass" value="<%=Request.Form("userpass")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>
性 别 <SELECT id=select1 name=selectsex value="<%=Request.Form("sex")%>" style="WIDTH: 159px"><OPTION></OPTION><OPTION value=男>男</OPTION><OPTION value=女>女</OPTION></SELECT><p>
<P align=center>
地 址 <input name="txtaddr" value="<%=Request.Form("address")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>电子邮件 <input name="txtmail" value="<%=Request.Form("mail")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>
<input type="hidden" name="uri" value="<%=Request.Form("uri")%>">
<input type="submit" name="button1" value="保存">
<input type="button" name="button2" value="返回"><p>
<%
end if
rs.close
set rs = nothing
conn.Close
set conn = nothing
%>
</form>
<script language="VBScript">
<!--
sub button2_OnClick()
window.location.href="userinfo.asp"
end sub
-->
</script>
</BODY>
</HTML>
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<form name="form1" action="user_amend.asp" method="post">
<%
Dim conn,rs,txtsql
set conn = server.CreateObject("ADODB.Connection")
conn.connectionstring = "driver=microsoft access driver (*.mdb);dbq=" & server.MapPath("/test") & "\exam.mdb"
conn.open
set rs = server.CreateObject("ADODB.RecordSet")
if len(Request.Form("txtname"))>0 then
txtsql = "UPDATE user SET username='" & Request.Form("txtname") & "',userpass='" & Request.Form("txtpass") & "',sex='" & Request.Form("selectsex") & "',address='" & Request.Form("txtaddr") & "',mail='" & Request.Form("txtmail") & "'where userid='" & Request.Form("uri") & "'"
conn.Execute txtsql
end if
txtsql = "select * from user where userid=" & Request.QueryString("uri") & ""
rs.Open txtsql,conn,1,3
if not rs.eof then
%>
<P align=center>修改用户信息<p>
<P align=center>用 户 名 <input name="txtname" value="<%=Rs("username")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>用户密码 <input type="text" name="txtpass" value="<%=Rs("userpass")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>
性 别 <SELECT id=select1 name=selectsex value="<%=Rs("sex")%>" style="WIDTH: 159px"><OPTION></OPTION><OPTION value=男>男</OPTION><OPTION value=女>女</OPTION></SELECT><p>
<P align=center>
地 址 <input name="txtaddr" value="<%=Rs("address")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>电子邮件 <input name="txtmail" value="<%=Rs("mail")%>" style="WIDTH: 159px; HEIGHT: 24px" size=21><p>
<P align=center>
'<input type="hidden" name="uri" value="<%=Rs("uri")%>">
<input type="submit" name="button1" value="保存">
<input type="button" name="button2" value="返回"><p>
<%
end if
rs.close
set rs = nothing
conn.Close
set conn = nothing
%>
</form>
<script language="VBScript">
<!--
sub button2_OnClick()
window.location.href="userinfo.asp"
end sub
-->
</script>
</BODY>
</HTML>
txtsql = "select * from user where userid=" & Request.Form("uri") & ""
你是用GET方式传的值,改成txtsql = "select * from user where userid=" & Request.QueryString("uri") & ""