📄 add.asp

📁 dreamwaver+asp用于SQLSERVER用户注册登陆和修改密码的动态网页源码

💻 ASP

字号:

<!--#include file="connection.asp" -->
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
<meta name="Microsoft Theme" content="none">
</head>

<body background=images/cyprbk.jpg>
<%
 Sub zhuce( )
  account=Request("T1")
  name=Request("T2")
  pwd=Request("T3")
  sex=Request("D1")
  if(account="" or pwd="") then
     response.write"<SCRIPT language=JavaScript>alert('用户名和密码不能为空！'); </SCRIPT>"
  else
     sql="select count(*) from username where account=" & SqlStr(account) 
     set rs=conn.Execute(sql)
     if(rs.fields(0).Value=0) then
        sql="insert into username (account,name,pwd,sex) values("
        sql=sql & SqlStr(account) &","
        sql=sql & SqlStr(name) &","
        sql=sql & SqlStr(pwd) &","
        sql=sql & SqlStr(sex) &")"
        conn.Execute sql   
        Response.Write "注册成功，恭喜您！"
     else
        Response.Write "已存在该用户名，请重新输入！"
      End if
      
      rs.close
      set rs=nothing
   End if
End Sub
%>

<form method="POST" action="add.asp">
  <p align="left">　</p>
  <p align="left">　</p>
  <p align="center">　</p>
  <p align="left">　</p>
  <p align="left"><font size="5"><b>请输入您的相关信息：</b></font></p>
  <p align="left"><font size="5"><b> <font color="#CC0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  *</font>用户名：<input type="text" name="T1" size="20">&nbsp;&nbsp;&nbsp;&nbsp;呢&nbsp;&nbsp;   
  称：<input type="text" name="T2" size="20"></b></font></p>                            
  <p align="left"><font size="5"><b><font color="#CC0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  *</font>密&nbsp; 码：<input name="T3" size="20" type="password">&nbsp;&nbsp;&nbsp;&nbsp;性&nbsp;&nbsp;                                
  别：<select size="1" name="D1">                             
    <option selected>男</option>
    <option>女</option>
  </select></b></font></p>                            
  <p align="center"><font size="7"><input type="submit" value="注册" name="B1" style="font-family: 宋体; font-size: 12pt; font-weight: bold; color: #800000; padding: 0"></font></p>
</form>
<p align="center">　  
<% 
  if(Request("B1")="注册")  then
   zhuce() 
  End if
%>
</p>
</body>
<% conn.close %>
</html>
</script>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -