当前位置:首页 » 注册证书 » asp注册

asp注册

发布时间: 2020-12-23 01:39:20

❶ asp.net登录及注册代码

创建两个类调用
(有时代码都正确但还是注册不了,可能是数据表有问题,删除重表建一张)

****************************************person类:

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// <summary>
///person 的摘要说明
/// </summary>
public class person
{
public string uName;
public string uPwd;
public string uSex;
public person()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
}

*********************************************personOperate类

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

/// <summary>
///personOperate 的摘要说明
/// </summary>
public class personOperate
{
public personOperate()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection createConnection()
{
SqlConnection con = new SqlConnection("server=.;database=log;uid=sa;pwd=sa");
return con;
}
public static bool insertOperate(person p)
{
try
{
SqlConnection con =personOperate.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand("insert into www values(@uName,@uPwd,@uSex)", con);
SqlParameter para = new SqlParameter("@uName", SqlDbType.VarChar, 50);
para.Value = p.uName;
cmd.Parameters.Add(para);
para = new SqlParameter("@uPwd", SqlDbType.VarChar, 50);
para.Value = p.uPwd;
cmd.Parameters.Add(para);
para = new SqlParameter("@uSex", SqlDbType.VarChar, 2);
para.Value = p.uSex;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
return true;
}
catch (Exception e)
{
return false;
}
}
}

********************************************注册页面代码

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btgo_Click(object sender, EventArgs e)
{
person p = new person();
p.uName = this.tbUser.Text;
p.uPwd = this.tbPwd.Text;

if (this.rbman.Checked)
{
p.uSex = "男";
}
else
{
p.uSex = "女";
}
if(personOperate.insertOperate(p))
{
Response.Write("注册成功");

}
else
{
Response.Write("失败");
}

Res

注册二代码:

protected void btnsend_Click(object sender, EventArgs e)
{
SqlConnection con = DB.createConnection();
con.Open();
string cmdtext = "insert into newreplay(mname,msubject,mcontent,mphone,madd,mqq,mmail,mhttp,mface,mip,mdatetime,mreplaytime) values(@name,@subject,@content,@phone,@add,@qq,@mail,@http,@face,@ip,@datetime,@datetime)";
SqlCommand cmd = new SqlCommand(cmdtext, con);
cmd.Parameters.Add("@name", SqlDbType.VarChar, 50);
cmd.Parameters["@name"].Value = this.tname.Text;
cmd.Parameters.Add("@subject", SqlDbType.VarChar, 50);
cmd.Parameters["@subject"].Value = this.tsubject.Text;
cmd.Parameters.Add("@content", SqlDbType.Text);
cmd.Parameters["@content"].Value = this.tcontent.Text;
cmd.Parameters.Add("@phone", SqlDbType.VarChar, 50);
cmd.Parameters["@phone"].Value = this.tphone.Text;
cmd.Parameters.Add("@add", SqlDbType.VarChar, 50);
cmd.Parameters["@add"].Value = this.tadd.Text;
cmd.Parameters.Add("@qq", SqlDbType.VarChar, 50);
cmd.Parameters["@qq"].Value = this.tqq.Text;
cmd.Parameters.Add("@mail", SqlDbType.VarChar, 50);
cmd.Parameters["@mail"].Value = this.tmail.Text;
cmd.Parameters.Add("@http", SqlDbType.VarChar, 50);
cmd.Parameters["@http"].Value = this.thttp.Text;
cmd.Parameters.Add("@face", SqlDbType.VarChar, 50);
cmd.Parameters["@face"].Value = this.dface.SelectedValue.ToString();
cmd.Parameters.Add("@ip", SqlDbType.VarChar, 50);
cmd.Parameters["@ip"].Value = GetIP();
cmd.Parameters.Add("@datetime", SqlDbType.DateTime);
cmd.Parameters["@datetime"].Value = DateTime.Now.ToString();
try
{
cmd.ExecuteNonQuery();
con.Close();

Response.Write("<script>alert('发表成功')</script>");
this.tadd.Text = "";
this.tcontent.Text = "";
this.thttp.Text = "";
this.tmail.Text = "";
this.tsubject.Text = "";
this.tphone.Text = "";
this.tname.Text = "";
this.tqq.Text = "";
}
catch (Exception error)
{
throw new System.Exception(error.Message);
}
}

登陆:

public partial class LOGIN : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = DB.createConnec();
con.Open();
SqlCommand cmd = new SqlCommand("select * from LOGIN where name='" + this.TextBox1.Text + "'and password='" + this.TextBox2.Text + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["username"] = dr["name"]; //从数据库读出
Session["userpassword"] = dr["password"]; //从数据库读出
if ((int)Session["userpassword"] == 1) //类型要注意 还有一种是SESSION["WWW"].TOSTRING()=="1"; //!=
{
Response.Redirect("TIME.aspx");

}
else if ((int)Session["userpassword"] == 2)
{
Response.Redirect("add.aspx");

}
else
{
Response.Redirect("list.aspx");
}
}
else
{
Response.Write("ksks");
}
con.Close();
}
}

要是可以给我好评好么!我在收集分数

❷ asp注册登陆代码

1,(index.asp 用户登陆页面)
<!-- #include file="conn.asp" -->
<!-- blog.soowooo.cn 悠悠长假期 -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>会员</title>
<style type="text/css">
<!--
body,td,th {
font-family: 宋体;
font-size: 14px;
}
-->
</style>
</head>
<body>
<center>
<p>会员注册系统</p>
<form name="form1" method="post" action="login.asp">
<table width="34%" border="0">
<tr>
<td width="33%" height="30">用户名:</td>
<td width="67%" height="30"><input name="username" type="text" id="username" size="15"></td>
</tr>
<tr>
<td height="30">密 码:</td>
<td height="30"><input name="password" type="password" id="password" size="15"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Submit" value="确定">
<input type="reset" name="Submit" value="重置"></td>
</tr>
<tr>
<td colspan="2"><a href="reg.asp" target="_self">注册</a></td>
</tr>
</table>
</form>
</center>
</body>

</html>

2,(login.asp 用户数据处理文件)

<!-- #include file="conn.asp" -->
<%
'打开数据库判断用户是否存在,info为表名,username为字段名
set rsc=server.createobject("adodb.recordset")
sqlc="select * from info where username='"&request.Form("username")&"' and password='"&request.Form("password")&"'"
rsc.open sqlc,conn,1,1
session("username")=rsc("username")
session("password")=rsc("password")
session.Timeout=30
set rsc=nothing
response.Redirect("change.asp")
'如果用户不存在,session("username")为空
%>
3,(change.asp 用户信息修改页面)
<!-- #include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改</title>
<style type="text/css">
<!--
body,td,th {
font-size: 14px;
}
-->
</style></head>
<center>
<body>
<br>
<%

set rsc=server.createobject("adodb.recordset")
sqlc="select * from info where username='"&session("username")&"' and password='"&session("password")&"'"
rsc.open sqlc,conn,1,1
nr=rsc("password")
username=rsc("username")
password=rsc("password")
sex=rsc("sex")
qq=rsc("qq")
mail=rsc("mail")
add=rsc("add")
personalinfo=rsc("personalinfo")
vv=rsc("ntime")
set rsc=nothing
if nr="" then
response.Redirect("index.asp")
end if
if strcomp(nr,request.Form("password"))=0 then
response.Write("欢迎你!"&request.Form("username"))
response.Write("你是在"&vv&"注册的")
session("username")=request.Form("username")
end if
if session("username")="" then
response.Redirect("index.asp")
end if
%>
<form name="form1" method="post" action="change.asp?ac=ch">
<table width="39%" height="105" border="0" >
<tr>
<td width="27%" height="30">用户名:</td>
<td width="73%" height="30"><input name="username" type="text" id="username" value="<%=username%>">
*</td>
</tr>
<tr>
<td height="30">密 码:</td>
<td height="30"><input name="password" type="text" id="password" value="<%=password%>">
*</td>
</tr>
<tr>
<td height="30">性 别:</td>
<td height="30"><input name="sex" type="text" id="sex" value="<%=sex%>"></td>
</tr>
<tr>
<td height="30">QQ:</td>
<td height="30"><input name="qq" type="text" id="qq" value="<%=qq%>"></td>
</tr>
<tr>
<td height="30">Mail:</td>
<td height="30"><input name="mail" type="text" id="mail" value="<%=mail%>"></td>
</tr>
<tr>
<td height="30">地 址:</td>
<td height="30"><input name="add" type="text" id="add" value="<%=add%>"></td>
</tr>
<tr>
<td>介绍</td>
<td><textarea name="personalinfo" cols="30" rows="6" id="personalinfo"><%=personalinfo%></textarea></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="修改">
<a href="change.asp?se=y" target="_self">退出系统</a></td>
<% if strcomp(request.QueryString("se"),"y")=0 then
session("username")=""
response.Redirect("index.asp")
end if
%>
</tr>
</table>
</form>
<%
if strcomp(request.QueryString("ac"),"ch")=0 then
set rs=server.createobject("adodb.recordset")
sql="select * from info where username='"&session("username")&"'"
rs.open sql,conn,1,3
rs("username")=request.Form("username")
rs("password")=request.Form("password")
rs("mail")=request.Form("mail")
rs("sex")=request.Form("sex")
rs("qq")=request.Form("qq")
rs("add")=request.Form("add")
rs("personalinfo")=request.Form("personalinfo")
rs.update
set rs=nothing
response.Write("修改完成!")
end if
%>
</body>
</center>
</html>
4,(reg.asp 新用户注册页面)
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户注册</title>
<style type="text/css">
<!--
body,td,th {
font-family: 宋体;
font-size: 14px;
}
-->
</style>
</head>
<body>
<center>
用户注册<br>
<%
=request.QueryString("msg")
%>
<form name="form1" method="post" action="addnewdata.asp?ac=adser">
<table width="39%" height="105" border="0" >
<tr>
<td width="27%" height="30">用户名:</td>
<td width="73%" height="30"><input name="username" type="text" id="username">
*</td>
</tr>
<tr>
<td height="30">密码:</td>
<td height="30"><input name="password" type="password" id="password">
*</td>
</tr>
<tr>
<td height="30">确定密码:</td>
<td height="30"><input name="password2" type="password" id="password2">
*</td>
</tr>
<tr>
<td height="30">性别:</td>
<td height="30"><input name="sex" type="text" id="sex"></td>
</tr>
<tr>
<td height="30">QQ:</td>
<td height="30"><input name="qq" type="text" id="qq"></td>
</tr>
<tr>
<td height="30">Mail:</td>
<td height="30"><input name="mail" type="text" id="mail"></td>
</tr>
<tr>
<td height="30">地址:</td>
<td height="30"><input name="add" type="text" id="add"></td>
</tr>
<tr>
<td>个人介绍</td>
<td><textarea name="personalinfo" cols="30" rows="6" id="personalinfo"></textarea></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
5,(addnewdata.asp 新用户注册数据处理文件)
<!-- #include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>成功</title>
</head>
<body>
<%
ac=request.QueryString("ac")
msg="注册错误信息"
if request.Form("username")="" then
msg=msg&"<br>"&"用户名不能为空"
end if
if strcomp(cstr(request.Form("password")),cstr(request.Form("password2")))<>0 then
msg=msg&"<br>"&"两次密码输入不同"
end if

if len(request.Form("password"))<6 then
msg=msg&"<br>"&"密码太简单"
end if

if strcomp(msg,"注册错误信息")>0 then
response.Redirect("reg.asp?msg="&msg)
end if
if ac="adser" then
set rsc=server.createobject("adodb.recordset")
sql="select * from info where username='"&request.Form("username")&"'"
rsc.open sql,conn,1,1
ck=rsc("username")
set rsc=nothing
if ck<>"" then
msg=msg&"<br>"&"用户名被人注册"
response.Redirect("reg.asp?msg="&msg)
end if
dsql="select * from info where id is null"
set rs=server.createobject("adodb.recordset")
rs.open dsql,conn,1,3
rs.addnew
rs("username")=request.Form("username")
rs("password")=request.Form("password")
rs("mail")=request.Form("mail")
rs("sex")=request.Form("sex")
rs("qq")=request.Form("qq")
rs("add")=request.Form("add")
rs("personalinfo")=request.Form("personalinfo")
rs("ntime")=now
rs.update
set rs=nothing
%>
<center>
<a href="index.asp" target="_self">注册成功,点击登陆</a>
</center>
<%
end if
%>
</body>
</html>

6,(conn.asp 数据库连接文件)
<%
'连接数据库开始
dim conn,rs,sql
on error resume next
dbpath=server.mappath("userinfo.mdb")
set conn=server.createobject("adodb.connection")
conn.open "PROVIDER=Microsoft.jet.OLEDB.4.0;data source="&dbpath
'创建记录对象
set rs=server.createobject("adodb.recordset")
%>

7,(userinfo.mdb ACCESS 数据库)
在ACCESS中建一个表,然后在这个表中建立字段名称
表名:info

字段名称 数据类型
id 自动编号
username 文本
password 文本
sex 文本
quest 文本
qq 文本
mail 文本
personalinfo 文本
ntime 文本

❸ asp注册、登录及身份验证

注册:set rs=server.CreateObject("adodb.recordset")
rs.open "select * from bjx_User where useremail='"&trim(request("useremail"))&"' or username='"&trim(request("username"))&"'",conn,1,1
if rs.recordcount>0 then
call usererr()
rs.close
else
rs.closeset rs=server.CreateObject("adodb.recordset")
rs.open "select * from bjx_User",conn,1,3
rs.addnew
rs("username")=trim(request("username"))
rs("userpassword")=md5(trim(request("userpassword")),16)
rs("useremail")=trim(request("useremail"))
rs("Quesion")=trim(request("Quesion"))
rs("answer")=md5(trim(request("answer")),16)
rs("userzhenshiname")=trim(request("userzhenshiname"))
rs("shouhuodi")=trim(request("shouhuodi"))
rs("youbian")=trim(request("youbian"))
rs("usertel")=trim(request("usertel"))
rs("songhuofangshi")=trim(request("songhuofangshi"))
rs("fufangshi")=trim(request("fufangshi"))
rs("adddate")=now()
rs("lastlogin")=now()
rs("logins")=1rs("reglx")=1
rs("jifen")=0
rs("jiaoyijine")=0
rs("sex")=1
rs("userlastip")=Request.ServerVariables("REMOTE_ADDR")
rs.update
rs.close
set rs=nothing登录:
<!--#include file="Include/Iheeo_Conn.asp"-->
<!--#include file="Include/md5.asp" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%dim username,userpassword,comeurl,verifycode
username=replace(trim(request("username")),"'","")
userpassword2=replace(trim(request("userpassword")),"'","")
userpassword=md5(userpassword2,16)
verifycode=replace(trim(request("verifycode")),"'","")
if username="" or userpassword="" then
response.write "<script LANGUAGE='javascript'>alert('您的用户名或密码有误!');history.go(-1);</script>"
response.end
end ifif cstr(session("getcode"))<>cstr(trim(request("verifycode"))) then
response.Write "<script LANGUAGE='javascript'>alert('请输入正确的验证码!');history.go(-1);</script>"
response.end
end ifset rs=server.CreateObject("adodb.recordset")
rs.Open "select * from bjx_User where username='"&username&"' and userpassword='"&userpassword&"' " ,conn,1,3
if not(rs.bof and rs.eof) then
if userpassword=rs("userpassword") then
response.Cookies("bjx")("username")=trim(request("username"))
response.Cookies("bjx")("reglx")=rs("reglx")
response.Cookies("bjx")("jifen")=rs("jifen")
response.Cookies("bjx")("jiaoyijine")=rs("jiaoyijine")rs("lastlogin")=now()
rs("logins")=rs("logins")+1
rs("userlastip")=Request.ServerVariables("REMOTE_ADDR")
rs.Update
rs.Close
set rs=nothing
Session("GetCode")="1234"
response.write "<IFRAME SRC=bbs/login.asp?action=chk&username="&username&"&password="&userpassword2&"&codestr=1234&CookieDate=0 width=0 height=0 frameborder=no border=0 MARGINWIDTH=0 MARGINHEIGHT=0 SCROLLING=no></IFRAME>"
username=trim(request("username"))
conn.execute("delete from BJX_action where username='"&username&"' and zhuangtai=7")
conn.execute("delete from BJX_action_jp where username='"&username&"' and zhuangtai=7")
if request("linkaddress")="" then
backlink=request.servervariables("http_referer")
else
backlink=request("linkaddress")
end if
%>
正在登录,请稍等,正在为你转向......
<meta http-equiv="refresh" content="3;url=<%=backlink%>">
<%
else
response.write "<script LANGUAGE='javascript'>alert('对不起,您的用户名或密码有误!');history.go(-1);</script>"
end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起!您的用户名或密码有误!');history.go(-1);</script>"
end if%>数据库连接<%
dim startime,conn,connstr,db,rs,rs_s,rs_s1
startime=timer()
db="data/Iheeo_DB.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
%>

❹ asp+sql 用户注册

=====================================================
1.(建立数据库)
在SQL中建一个表,然后在这个表中建立字段名称
表名:字段名称 数据类型
id 自动编号
username 文本
password 文本
sex 文本
quest 文本
qq 文本
mail 文本
personalinfo 文本
ntime 文本
=====================================================
2.(新建数据库连接文件 conn.asp )
<%
'连接数据库开始
dim conn,rs,sql
on error resume next
dbpath=server.mappath("userinfo.mdb")
set conn=server.createobject("adodb.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称" '创建记录对象
set rs=server.createobject("adodb.recordset")
%>
======================================
3.(新建用户登陆页面index.asp )
<!-- #include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户登录</title>
</head>
<body>
<center>
<p>会员注册</p>
<form name="form1" method="post" action="login.asp">
<table width="34%" border="0">
<tr>
<td width="33%" height="30">用户名:</td>
<td width="67%" height="30"><input name="username" type="text" id="username" size="15"></td>
</tr>
<tr>
<td height="30">密 码:</td>
<td height="30"><input name="password" type="password" id="password" size="15"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Submit" value="确定">
<input type="reset" name="Submit" value="重置"></td>
</tr>
<tr>
<td colspan="2"><a href="reg.asp" target="_self">注册</a></td>
</tr>
</table>
</form>
</center>
</body></html>==============================================================4.(新建用户登录数据处理文件login.asp)<!-- #include file="conn.asp" -->
<%
'打开数据库判断用户是否存在,info为表名,username为字段名
set rsc=server.createobject("adodb.recordset")
sqlc="select * from info where username='"&request.Form("username")&"' and password='"&request.Form("password")&"'"
rsc.open sqlc,conn,1,1
if not rsc.eof and not rsc.bof then
session("username")=rsc("username")
session("password")=rsc("password")
session.Timeout=30
response.write("登录成功")
else
response.write("登录失败")
end if
%>=============================================================5.(新建用户注册页面reg.asp )
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户注册</title>
<style type="text/css">
</head>
<body>
<center>
用户注册<br>
<form name="form1" method="post" action="addnewdata.asp?ac=adser">
<table width="39%" height="105" border="0" >
<tr>
<td width="27%" height="30">用户名:</td>
<td width="73%" height="30"><input name="username" type="text" id="username">
*</td>
</tr>
<tr>
<td height="30">密码:</td>
<td height="30"><input name="password" type="password" id="password">
*</td>
</tr>
<tr>
<td height="30">确定密码:</td>
<td height="30"><input name="password2" type="password" id="password2">
*</td>
</tr>
<tr>
<td height="30">性别:</td>
<td height="30"><input name="sex" type="text" id="sex"></td>
</tr>
<tr>
<td height="30">QQ:</td>
<td height="30"><input name="qq" type="text" id="qq"></td>
</tr>
<tr>
<td height="30">Mail:</td>
<td height="30"><input name="mail" type="text" id="mail"></td>
</tr>
<tr>
<td height="30">地址:</td>
<td height="30"><input name="add" type="text" id="add"></td>
</tr>
<tr>
<td>个人介绍</td>
<td><textarea name="personalinfo" cols="30" rows="6" id="personalinfo"></textarea></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
</form>
</center>
</body>
</html>======================================================================6.(新建用户注册数据处理文件addnewdata.asp )
<!-- #include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>成功</title>
</head>
<body>
<%
ac=request.QueryString("ac")
msg="注册错误信息:"
if request.Form("username")="" then
msg=msg&"<br>"&"用户名不能为空"
end if
if strcomp(cstr(request.Form("password")),cstr(request.Form("password2")))<>0 then
msg=msg&"<br>"&"两次密码输入不同"
end ifif len(request.Form("password"))<6 then
msg=msg&"<br>"&"密码过于简单"
end ifif strcomp(msg,"注册错误信息")>0 then
response.Redirect("reg.asp?msg="&msg)
end if
if ac="adser" then
set rsc=server.createobject("adodb.recordset")
sql="select * from info where username='"&request.Form("username")&"'"
rsc.open sql,conn,1,1
ck=rsc("username")
set rsc=nothing
if ck<>"" then
msg=msg&"<br>"&"用户名被人注册"
response.Redirect("reg.asp?msg="&msg)
end if
dsql="select * from info where id is null"
set rs=server.createobject("adodb.recordset")
rs.open dsql,conn,1,3
rs.addnew
rs("username")=request.Form("username")
rs("password")=request.Form("password")
rs("mail")=request.Form("mail")
rs("sex")=request.Form("sex")
rs("qq")=request.Form("qq")
rs("add")=request.Form("add")
rs("personalinfo")=request.Form("personalinfo")
rs("ntime")=now
rs.update
set rs=nothing
%>
<center>
<a href="index.asp" target="_self">注册成功,点击登陆</a>
</center>
<%
end if
%>
</body>
</html>

❺ 用asp做一个注册页面

怎么用注册名跟来数据库源中已有的用户名进行比较?
设计一个处理注册信息的页面,有表单信息传过来的时候先打开数据库,用表单传过来的用户名与数据库里的用户名比较,如果有相等的就返回不能注册的提示
怎么比较?
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("db.mdb")
rs.open "select * from [数据表] where [user] = '"&request("user")&"'",conn,1,1
if rs.eof then
没有重名的处理
else
有重名的处理
end if

❻ asp 用户注册页面

if (user<>"" and pw1<>"") and pw2<>"" then
用户名user和密码pw1都不为空的同时重复密码pw2也不为空
if pw1=pw2 then
密码pw1等于重复密码pw2
sql="select * from 用户表内 where 用户名='"&request("reg_user")&"'"
rs.open sql,conn,1,1
查询用户名request("reg_user")是否存容在(此处好象与user又无关了,应该是user才对的)
if rs.RecordCount=0 then 等于0时查询的用户名不存在,大于0时查询的用户名存在就不能注册
conn.execute("insert into 用户表(用户名,密码,真实姓名,性别,电话,手机,电子邮件,住址,说明) values ('"+user+"','"+pw1+"','"+realname+"','"+sex+"','"+phone+"','"+mphone+"','"+email+"','"+add+"','"+inf+"')") 此代码是注册写入数据库

❼ ASP 简单注册

不知道是不是我页面在手机网页上显示的问题,看不到大于符号,如果直接显示了代码,就说明代码根本就没有运行,可能就是没有ASP标签(<%%>)或者文件类型不是ASP

❽ asp注册,怎么防止重复帐号注册..

if not rs.eof then
response.write("<script>alert('错误:用户名抄已存在,请改名!');history.go(-1)</script>")
Response.end()
else
rs.addnew
rs("username")=username
rs.update
response.write("<script>alert('提交成功');</script>")
rs.close
end if

楼主说加上去就报错.能把报错信息贴上来么?你这代码没办法看出是什么错误

❾ asp会员注册代码

IF Trim(Request.Form("passstring"))="" Or Trim(Request.Form("passstring"))<>Trim(Request.Form("repassstring")) Then
Response.Write("<script language=javascript>alert('输入错误,请检查您两次输入的新密码!');history.back();</script>")
Response.End()
End IF
IF Trim(Request.Form("userid"))="" Then
Response.Write("<script language=javascript>alert('呵呵,忘了输入管理员了!');history.back();</script>")
Response.End()
Else
userid = Trim(Request.Form("userid"))
SQLString = "Select * From table_master Where userid ='" & userid &"'"
Set MM_RecordSet = GetRecordset(SQLString)
IF Not MM_Recordset.Eof Then '判定无记录或密码不符
Response.Write("<script language=javascript>alert('该管理员已经存在,请重新输入!');history.back();</script>")
ReleaseRecordset(MM_Recordset)
Else
ReleaseRecordset(MM_Recordset)
passstring=Trim(Request.Form("passstring")) '读取用户输入的新口令
passstring=md5(passstring) '新口令一次(md5)加密
'passstring=Trim(Request.Form("userpwd")) '新口令一次(SHA-1)加密
SQLString = "INSERT INTO table_master(username,mobile,email,msn,userid,passString,regdate,logtimes,lastaccess,popedom) VALUES("
SQLString = SQLString & "'" & Trim(Request.Form("username")) &"','" &Trim(Request.Form("mobile")) & "','" & Trim(Request.Form("email")) & "','" & Trim(Request.Form("msn")) &"','" &userid & "','" &passstring &"',#" & Date() & "#,0,#" & Date() & "#,1"
SQLString = SQLString & ")"
'Response.Write(SQLString)
GetRecordset SQLString
End IF
End IF
---------------------------------------------------
这是我某个网站的管理员添加部分的代码,用户注册表单制作部分我就不给你写了,相信你能做,然后你要做的就是把这段代码中相应的部分修改一下就好了。——
----------------------------------------------------
ps:你的问题不是代码怎么改,而是你应该怎么做。代码没问题。只要把代码中提到的数据库相关的东西完善就可以了。
留下邮箱我把改完的东西发给你。

❿ ASP网站用户注册怎么写

<form action="Reg.asp" method="post" name="form1">
用户名:<input type="text" name="UserName" id="UserName" value="">
密码:<input type="password" name="UserPass" Id="UserPass" value="">
确认密码:<input type="Password" name="UserPass2" id="userpass2" value="">
E-mail:<input type="text" name="email" id="email" value="">
<input stype="submit" value="提交">
</form>
再建个reg.asp文件,用来接收数专据属并添加亓数据库即可

热点内容
美发店认证 发布:2021-03-16 21:43:38 浏览:443
物业纠纷原因 发布:2021-03-16 21:42:46 浏览:474
全国著名不孕不育医院 发布:2021-03-16 21:42:24 浏览:679
知名明星确诊 发布:2021-03-16 21:42:04 浏览:14
ipad大专有用吗 发布:2021-03-16 21:40:58 浏览:670
公务员协议班值得吗 发布:2021-03-16 21:40:00 浏览:21
知名书店品牌 发布:2021-03-16 21:39:09 浏览:949
q雷授权码在哪里买 发布:2021-03-16 21:38:44 浏览:852
图书天猫转让 发布:2021-03-16 21:38:26 浏览:707
宝宝水杯品牌 发布:2021-03-16 21:35:56 浏览:837