UC知道ASP中怎样通过提产表单的方式个改数据库中的记录?
来源：百度知道 编辑：UC知道 时间：2024/05/29 07:57:53
请帮我改改
<!--#include file="conn.asp"--><head>
<meta content="text/html; charset=GB2312">
</head>
<%
student_num=Request.form("student_num")
exec="select * from students where student_num='"&student_num&"'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open exec,conn,1,3
%>
<%do while not rs.eof%>
<%
if request.form("subb")<>"" then
rs("student_num")=request.form("student_num")
rs("name")=request.form("name")
rs("sex")=request.form("sex")
rs("age")=request.form("age")
rs("department")=request.form("department")
rs("class")=request.form("class")
rs("address")=request.form("address")
rs("phone_num")=request.f
<!--#include file="conn.asp"--><head>
<meta content="text/html; charset=GB2312">
</head>
<%
student_num=Request.form("student_num")
exec="select * from students where student_num='"&student_num&"'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open exec,conn,1,3
%>
<%do while not rs.eof%>
<%
if request.form("subb")<>"" then
rs("student_num")=request.form("student_num")
rs("name")=request.form("name")
rs("sex")=request.form("sex")
rs("age")=request.form("age")
rs("department")=request.form("department")
rs("class")=request.form("class")
rs("address")=request.form("address")
rs("phone_num")=request.f
少了个页面开关。初次执行时，不要让他执行到你的修改代码。
一般用 if student_num<>"" then
执行修改
else
不执行修改
end
然后
<form action="#" method="post">