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("注册成功!")
<%
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
%