UC知道asp表单提交信息处理
来源：百度知道 编辑：UC知道 时间：2024/05/28 06:47:38
<%
select case request("action")
case "add"
call add()
case "editor"
call editor()
end select
sub add()
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from user where username="&trim(request("username")),conn,1,1
if rs.recordcount<>0 then
response.Write("<script language=javascript>alert('用户名已存在,请重新填写');history.back()</script>")
rs.close
set rs=nothing
else
rs.open "insert into user (username,password,qq,sex,emaile) values ('"&request("username")&"','"&request("password")&"','"&request("qq")&"','"&request("sex")&"','"&request("emaile")&"')",conn,1,3
response.Write("<script language=javascript>alert('添加成功！');histor
select case request("action")
case "add"
call add()
case "editor"
call editor()
end select
sub add()
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from user where username="&trim(request("username")),conn,1,1
if rs.recordcount<>0 then
response.Write("<script language=javascript>alert('用户名已存在,请重新填写');history.back()</script>")
rs.close
set rs=nothing
else
rs.open "insert into user (username,password,qq,sex,emaile) values ('"&request("username")&"','"&request("password")&"','"&request("qq")&"','"&request("sex")&"','"&request("emaile")&"')",conn,1,3
response.Write("<script language=javascript>alert('添加成功！');histor
if rs.recordcount<>0 then
response.Write("<script language=javascript>alert('用户名已存在,请重新填写');history.back()</script>")
rs.close
set rs=nothing
如果rs.recordcount<>0，rs已经close
如果rs.recordcount=0 rs根本没有close
紧跟着又来个
rs.open "insert into user (username,password,qq,sex,emaile) values ('"&request("username")&"','"&request("password")&"','"&request("qq")&"','"&request("sex")&"','"&request("emaile")&"')",conn,1,3
当然要出错了
其实根本不用再 open 第二个rs
直接用
CONN.execute( "insert into user (username,password,qq,sex,emaile) values ('"&request("username")&"','"&request("password")&"','"&request("qq")&"','"&request("sex")&"','&q