postmodify.asp

来自「《asp网页设计》作者沈才梁源代码,共十章」· ASP 代码 · 共 19 行

<!--#Include File=conn.asp -->
<%
ID=request.form("ID") '接收Modify.asp表单中的隐藏控件ID的值
Name=request("Name")
Sex=request("Sex")
Tel=request("Tel")
Birthday=Cdate(request("Birthday"))
Address=request("Address")
Email=request("Email")
if trim(Name)="" then 
  response.write "姓名不能为空，请重新输入！"
  response.end
end if  
SqlStr="UPDATE Userlist SET 姓名='" & Name & "',性别='" & Sex & "',电话='" & Tel & "',出生日期=#" & Birthday & "#,地址='" & Address & "',Email='" & Email & "' Where ID=" & id
Conn.Execute(SqlStr)
response.redirect "show.asp"
'修改完毕，返回show.asp页面
%>