asp数据库提交问题

来源:百度知道 编辑:UC知道 时间:2024/06/06 02:15:45
<!--#include file=conn.asp-->
<%
dim zh , mm , zm ,shouji, qq , nr
zh=trim(request.Form("t1"))
mm=trim(request.Form("t2"))
zm=trim(request.Form("t3"))
shouji=trim(request.Form("t4"))
qq=trim(request.Form("t5"))
rn=trim(request.Form("t6"))

if zh="" or mm="" then
response.Write("账号或密码不能为空")
response.end

end if

if mm<>zm then
response.Write("重复密码不正确,请重新填写")
response.end

end if

sql="select * from zhanghao "
set rs=server.CreateObject("adodb.recordset")
rs.open sql ,conn,1,1

do while not rs.eof

if zh=rs("username") then
response.Write("账号以存在")
response.End
else
response.Write("注册成功!")

<!--#include file=conn.asp-->
<%
dim zh , mm , zm ,shouji, qq , nr
zh=trim(request.Form("t1"))
mm=trim(request.Form("t2"))
zm=trim(request.Form("t3"))
shouji=trim(request.Form("t4"))
qq=trim(request.Form("t5"))
rn=trim(request.Form("t6"))

if zh="" or mm="" then
response.Write("账号或密码不能为空")
response.end
end if

if mm<>zm then
response.Write("重复密码不正确,请重新填写")
response.end
end if

sql="select * from zhanghao "
set rs=server.CreateObject("adodb.recordset")
rs.open sql ,conn,1,3

if not (rs.eof and rs.bof) then
response.Write("账号以存在")
else
rs.addnew
rs("用户名")=
rs("密码")=
rs.update
response.Write("注册成功!")
end if
rs.close
%