⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 searchnewuser.asp

📁 大家好
💻 ASP
字号:
<%@ LANGUAGE="VBSCRIPT" %>
<%if isempty(request("username")) then
response.redirect ("default.htm")
end if
DbPath = SERVER.MapPath("db1.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=server.createobject("adodb.recordset")
sqltext="select username from user_info where username='"&request("username")&"'"
rs.open sqltext,conn
if rs.bof or rs.eof then
rs.close
conn.close
set rs=nothing
set conn=nothing
else
response.write "wrong password!<a href='default.htm'>return homepage</a>"
rs.close
conn.close
set rs=nothing
set conn=nothing
response.end
end if
%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>新用户注册</title>
</head>

<body bgcolor="#FFFAD9">

<p align="center"><font color="#8484FF"><strong><big>新用户注册</big></strong></font></p>

<form method="POST" action="insertnewuser.asp">
  <input type="hidden" name="username" value="<%=request("username")%>"><div align="center"><center><table
  border="1" width="50%" borderColorDark="#FFFFFF" borderColorLight="#000000"
  cellspacing="0">
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">用户名</td>
      <td width="73%" bgcolor="#DDDDFF">&nbsp;<font color="#0000FF"><b><i><%=request("username")%></i></b></font></td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">密&nbsp; 码</td>
      <td width="73%" bgcolor="#DDDDFF"><input type="password" name="password" size="20"
      tabindex="2"><font color="#FF0000"><b>*</b></font></td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">校验密码</td>
      <td width="73%" bgcolor="#DDDDFF"><input type="password" name="verpsw" size="20"
      tabindex="3"><font color="#FF0000"><b>*</b></font></td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">E-mail</td>
      <td width="73%" bgcolor="#DDDDFF"><input type="text" name="email" size="20" tabindex="4"><font
      color="#FF0000"><b>*</b></font></td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">性 别</td>
      <td width="73%" bgcolor="#DDDDFF"><select name="sex" size="1">
        <option selected value="先生">先 生</option>
        <option value="小姐">小 姐</option>
        <option value="不告诉你">不告诉你</option>
      </select></td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">出生年月</td>
      <td width="73%" bgcolor="#DDDDFF"><input type="text" name="born" size="20" tabindex="5">例:1975-4-15</td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">主&nbsp; 页</td>
      <td width="73%" bgcolor="#DDDDFF"><input type="text" name="homepage" size="20"
      tabindex="6" value="http://"></td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">城&nbsp; 市</td>
      <td width="73%" bgcolor="#DDDDFF"><input type="text" name="city" size="20" tabindex="7"><font
      color="#FF0000"><b>*</b></font></td>
    </tr>
    <tr>
      <td width="27%" bgcolor="#DDDDFF" align="center">电&nbsp; 话</td>
      <td width="73%" bgcolor="#DDDDFF"><input type="text" name="phone" size="20" tabindex="8"><font
      color="#0000FF">BP</font>或<font color="#0000FF">ICQ</font>也可</td>
    </tr>
    <tr>
      <td width="100%" bgcolor="#DDDDFF" colspan="2">&nbsp; 签&nbsp; 名(不能超过120字)</td>
    </tr>
    <tr>
      <td width="100%" bgcolor="#DDDDFF" colspan="2">&nbsp;&nbsp; <textarea rows="6"
      name="signs" cols="40" tabindex="9"></textarea></td>
    </tr>
    <tr>
      <td width="30%" bgcolor="#DDDDFF" colspan="2"><div align="center"><center><p><input
      type="submit" value="递交" name="B1" tabindex="10">&nbsp; <input type="reset"
      value="清除" name="B2" tabindex="11"></td>
    </tr>
  </table>
  </center></div>
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -