UC知道Asp用户注册
来源：百度知道 编辑：UC知道 时间：2024/05/26 13:02:29
在用户注册时，我为了检测用户提交的用户名是否被别的用户已用，采用以下代码时，出现错误，请各位帮帮忙，谢谢！
<!--#include file=security.asp-->
<%
no1=request.Form("no")
DbPath = SERVER.MapPath("student.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=Server.Createobject("ADODB.Recordset")
rs.open "select * from imformation where studentno='"& no1 &"'", conn,2,3
If rs.BOF Then
rs.close()
%>
<script language="javascript">
alert("用户 <%=no1%> 已经被人使用!")
/* window.location="writer_to_access.asp"*/
</script>
<% Else
存入数据库代码
End if
%>
<!--#include file=security.asp-->
<%
no1=request.Form("no")
DbPath = SERVER.MapPath("student.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=Server.Createobject("ADODB.Recordset")
rs.open "select * from imformation where studentno='"& no1 &"'", conn,2,3
If rs.BOF Then
rs.close()
%>
<script language="javascript">
alert("用户 <%=no1%> 已经被人使用!")
/* window.location="writer_to_access.asp"*/
</script>
<% Else
存入数据库代码
End if
%>
rs.open "select * from imformation where studentno='"& no1 &"'", conn,2,3
If rs.BOF Then 当没找到这个数据时应该能注册
rs.close()
%>
<script language="javascript">
alert("用户 <%=no1%> 已经被人使用!")
/* window.location="writer_to_access.asp"*/
</script>
而你上面的语句是说当studentno='"& no1 &"'", 为假时显示("用户 <%=no1%> 已经被人使用!")
是不是反了？
<!--#include file=security.asp-->
<%
no1=request.Form("no")
DbPath = SERVER.MapPath("student.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=Server.Createobject("ADODB.Recordset")
rs.open "select * from imformation where studentno='"& no1 &"'", conn,2,3
if rs.eof and rs.bof Then
Response.Write(&q