版权声明：转载原创文章请以超链接形式请注明原文章出处，尊重作者，尊重原创！
恰饭广告
实现效果：
数据库表：
项目的数据模块图：
BLL层：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using WebApplication1.DAL;
using WebApplication1.Model;
namespace WebApplication1.BLL
{
public class UserInfoBLL
{
UserInfoDAL userInfoDal = new UserInfoDAL();
public UserInfo SelectUser(string userName)
{
return userInfoDal.SelectUser(userName);
}
public void Insert(UserInfo user)
{
userInfoDal.Insert(user);
}
}
}
DAL层：
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using WebApplication1.Model;
namespace WebApplication1.DAL
{
public class UserInfoDAL
{
SQLHelper sqlHelp = new SQLHelper();
#region 查找用户
public UserInfo SelectUser(string userName)
{
UserInfo user = new UserInfo();
SqlDataReader reader = sqlHelp.ExecuteSqlReader("select * from T_login where username=@userName",
new SqlParameter("@userName", userName));
while (reader.Read())
{
user.userName = reader.GetString(1);
}
reader.Close();
return user;
}
#endregion
#region 用户注册
public void Insert(UserInfo user)
{
sqlHelp.ExecuteNonQuery(@"INSERT INTO T_login
(username,password)
VALUES
(@UserName,@password)",
new SqlParameter("@userName", user.userName),
new SqlParameter("@password", user.password));
}
#endregion
}
}
Model层（Entity类）：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace WebApplication1.Model
{
public class UserInfo
{
public string userName { get; set; }
public string password { get; set; }
}
}
UI层：
WebForm1.aspx代码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<script type="text/javascript" src="https://idaobin.com/test/jquery-3.2.1.js"></script>
<script type="text/javascript">
function JudgeUserName() {
$.ajax({
type: "GET",
url: "UserHandler.ashx",
dataType: "html",
data: "userName=" + $("#txtUserName").val() + "&" + "pwd=" + $("#txtPwd").val(),
beforeSend: function (XMLHttpRequest) {
$("#showResult").text("正在查询");
//Pause(this,100000);
},
success: function (msg) {
$("#showResult").html(msg);
$("#showResult").css("color", "red");
},
complete: function (XMLHttpRequest, textStatus) {
//隐藏正在查询图片
},
error: function () {
//错误处理
}
});
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtUserName" runat="server" onblur="JudgeUserName();"></asp:TextBox>
<span id="showResult"></span>
</div>
<asp:TextBox ID="txtPwd" runat="server" TextMode="Password"></asp:TextBox>
<p>
<input id="Button1" type="button" value="注册" onclick="JudgeUserName();" />
</p>
</form>
</body>
</html>
UserHandler.ashx代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using WebApplication1.BLL;
using WebApplication1.Model;
namespace WebApplication1
{
/// <summary>
/// UserHandler 的摘要说明
/// </summary>
public class UserHandler : IHttpHandler
{
UserInfo user = new UserInfo();
UserInfoBLL userBll = new UserInfoBLL();
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string userName = context.Request.QueryString["userName"].ToString();
string password = context.Request.QueryString["pwd"].ToString();
user = userBll.SelectUser(userName);
if (userName == user.userName)
{
context.Response.Write("用户名已经存在！");
return;
}
else if (userName=="")
{
context.Response.Write("用户名不能为空！");
return;
}
else if (password=="")
{
context.Response.Write("密码不能为空！");
return;
}
else
{
user.userName = userName;
user.password = password;
userBll.Insert(user);
context.Response.Write("注册成功！");
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
}
还有数据库访问类（SQLHelper.cs）代码太多就不贴出来了
GitHub源码下载：https://github.com/kiritobin/NOReflushReg
原文链接：https://www.idaobin.com/archives/1268.html
让我恰个饭吧.ヘ(￣ω￣ヘ)
支付宝 ——————- 微信
恰饭广告
