person_do.asp

基于ASP的SQL小区物业管理系统课程设计

<!--#include file="sub/conn.asp"-->
<%
   dim room_id,oname,realname,password,question,answer,email,pro,odate
   id=Trim(Request.Form("id"))
   oname=Trim(Request.Form("oname"))
   realname=Trim(Request.Form("realname"))
   password=Trim(Request.Form("password"))
   answer=Trim(Request.Form("answer"))
   email=Trim(Request.Form("email"))
   pro=Trim(Request.Form("pro"))
   set cmd=Server.CreateObject("ADODB.COMMAND")
   cmd.ActiveConnection=conn
   cmd.CommandText="update userlist set username='"&oname&"',realname='"&realname&"',password='"&password&"',answer='"&answer&"',email='"&email&"',priority='"&pro&"' where id="&id
   cmd.execute
   Response.Redirect("person.asp")
%>