reg.asp

一个简单的图书管理系统！毕业论文

<link href="style.css" type="text/css" rel="stylesheet">
<!--#include file="conn.asp"-->
<%if request("reg")="yes" then
set rs=server.createobject("adodb.recordset")
sql="select * from u where name='"&trim(request("name"))&"'"
rs.open sql,db,1,3 
if not rs.eof or not rs.bof then
response.write "<script>alert('用户名已经存在！');history.go(-1)</script>"
else

pwd1=trim(request("pwd"))
pwd2=trim(request("pwd1"))
if request("name")<>"" and pwd1=pwd2 and pwd1<>"" then'如果输入合法 执行插入操作 否则提示错误
sql1="insert into u(name,pwd,loan_num,lock) values('"&request("name")&"','"&request("pwd")&"',0,'0')"
'db.execute(sql1)
response.write "<script>alert('注册成功！');window.location.href='index.asp'</script>"
else 
response.write "<script>alert('输入错误！');history.go(-1)</script>"
end if 
end if
else
%>
<form  method="post" action="">
<table class=1 width="333" border="0" align="center" cellpadding="3" cellspacing="0">
          <tr > 
            <td colspan="2" align="center">注册用户</td>
          </tr>
          <tr align="center"> 
            <td align="center"  class="2">用户名:</td>
            <td align="center"  class="2"> 
              <input name="name" type="text" id="name" size="15">
              </td>
          </tr>
          <tr align="center"> 
		  <td align="center"  class="2">密码:</td>
            <td align="center"  class="2"> 
              <input name="pwd" type="password" id="pwd" size="10">
              </td>
		  </tr>
		   <tr align="center"> 
		  <td align="center"  class="2">核实密码:</td>
            <td align="center"  class="2"> 
              <input name="pwd1" type="password" id="pwd1" size="10">
              </td>
		  </tr>
          <tr align="center"> 
            <td colspan="2"> 
              <input type="submit"  value="注册">
              &nbsp; 
              <input type="reset"  value="重置">
              <input name="reg" type="hidden" id="active" value="yes">
              </td>
          </tr>
        </table>
		</form><%end if%>