usersave.asp

报名系统

<!--#include file=function.asp-->
<%CheckAdmin3%>
<!--#include file="conn.asp"-->
<%
auid=request.form("auid")
apwd=request.form("apwd")
aleave=request.form("aleave")
if auid="" or apwd="" then
response.write"<SCRIPT language=JavaScript>alert('会员员名称和密码都不能为空！');"
response.write"javascript:history.go(-1)</SCRIPT>"
Response.End
end if

set rs=server.CreateObject("ADODB.RecordSet")

if request("act")="edit" and request.QueryString("id")<>"" then
id=request("id")
sql="select * from user where id="& request.QueryString("id")
rs.open sql,conn,3,2
if not rs.eof then
rs("aleave")=aleave
rs("auid")=auid
rs("apwd")=apwd
rs.update
end if
rs.close
elseif request("act")="add" then
sql="select * from user where auid='"&auid&"'"
rs.open sql,conn,3,2
if (rs.eof and rs.bof) then
rs.addnew
rs("aleave")=aleave
rs("auid")=auid
rs("apwd")=apwd
rs.update
end if
rs.close
end if
set rs=nothing
conn.close
set conn=nothing
response.redirect "user.asp"
%>