网站用户登录、注册和修改密码常用代码，采用三层架构

最新推荐文章于 2024-05-03 17:06:56 发布

bl_song

最新推荐文章于 2024-05-03 17:06:56 发布

阅读量4.5k

点赞数

文章标签： textbox server null parameters string asp

本文链接：https://blog.csdn.net/bl_song/article/details/5407929

版权

创建用户表的Sql语句，数据库为SQL Server2000：

create table "User" ( UserID int not null, UserName varchar(50) null, UserPwd varchar(50) null, UserCode varchar(50) null, UserRole varchar(50) null, CreatTime datetime null default getdate(), UpdateTime datetime null default getdate(), Define1 varchar(50) null, Define2 varchar(50) null, constraint PK_USER primary key nonclustered (UserID) ) go

1.用户登录功能的实现:

已经使用LiTianPing的动软代码生成器生成了三层架构，以下是添加的代码。

(1)DAL层的User.cs中添加两个方法：

/// <summary> /// 用户登录 /// </summary> /// <param name="userName"></param> /// <param name="password"></param> /// <returns></returns> public HJMS.Model.User CheckUser(string userName,string password) { HJMS.Model.User userInfo=new Model.User(); int num = 0;string str = ""; StringBuilder strSql = new StringBuilder(); strSql.Append(" select top 1 UserID,UserName,UserPwd from User"); strSql.Append(" where UserName=@UserName"); SqlParameter[] pt = {new SqlParameter("@UserName", SqlDbType.VarChar),}; pt[0].Value = userName.ToLower(); using(SqlDataReader reader=DbHelperSQL.ExecuteReader(strSql.ToString(),pt)) { if(reader.Read()) { num = reader.GetInt32(0); str = reader[2].ToString(); } } if(num!=0) { if(str==password) { userInfo.UserPwd = password; StringBuilder strSql2 = new StringBuilder(); strSql.Append(" select top 1 UserID,UserName,UserPwd,UserCode,UserRole,CreatTime,UpdateTime,Define1,Define2 from User"); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters2 = {new SqlParameter("@PerID", SqlDbType.Int,4)}; parameters2[0].Value = num; using (SqlDataReader reader2 = DbHelperSQL.ExecuteReader(strSql2.ToString(), parameters2)) { if (reader2.Read()) { userInfo.UserID = reader2[0] == null ? 0 : reader2.GetInt32(0); userInfo.UserName = reader2[1].ToString(); userInfo.UserCode = reader2[3].ToString(); userInfo.UserRole = reader2[4].ToString(); userInfo.CreatTime = reader2.GetDateTime(5); userInfo.UpdateTime = reader2.GetDateTime(6); userInfo.Define1 = reader2[7].ToString(); userInfo.Define2 = reader2[8].ToString(); } } } } return userInfo; } /// <summary> /// 根据用户名获得用户实体 /// </summary> /// <param name="userName"></param> /// <returns></returns> public HJMS.Model.User GetModelByUserName(string userName) { StringBuilder strSql = new StringBuilder(); strSql.Append(" select top 1 UserID,UserName,UserPwd,UserCode,UserRole,CreatTime,UpdateTime,Define1,Define2 from User"); strSql.Append(" where UserName=@UserName"); SqlParameter[] pt = {new SqlParameter("@UserName", SqlDbType.VarChar)}; pt[0].Value = userName; HJMS.Model.User user = new Model.User(); DataTable dtUser = DbHelperSQL.Query(strSql.ToString(), pt).Tables[0]; if (dtUser.Rows.Count > 0) { if (dtUser.Rows[0]["UserID"].ToString() != "") { user.UserID = int.Parse(dtUser.Rows[0]["UserID"].ToString()); } user.UserName = dtUser.Rows[0]["UserName"].ToString(); user.UserPwd = dtUser.Rows[0]["UserPwd"].ToString(); user.UserCode = dtUser.Rows[0]["UserCode"].ToString(); user.UserRole = dtUser.Rows[0]["UserRole"].ToString(); user.CreatTime = Convert.ToDateTime(dtUser.Rows[0]["CreateTime"]); user.UpdateTime = Convert.ToDateTime(dtUser.Rows[0]["UpdateTime"]); user.Define1 = dtUser.Rows[0]["Define1"].ToString(); user.Define2 = dtUser.Rows[0]["Define2"].ToString(); return user; } else { return null; } }

(2) BLL层的User.cs中添加两个方法：

/// <summary> /// 用户登录 /// </summary> /// <param name="userName"></param> /// <param name="password"></param> /// <returns></returns> public HJMS.Model.User CheckUser(string userName, string password) { return dal.CheckUser(userName, password); } /// <summary> /// 根据用户名获得用户实体 /// </summary> /// <param name="userName"></param> /// <returns></returns> public HJMS.Model.User GetModelByUserName(string userName) { return dal.GetModelByUserName(userName); }

(3)UI层就是用户界面，假设Login.aspx如下的话：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>系统登录</title> <mce:script language="javascript"></mce:script> </head> <body οnlοad="SetFocus()" style="background-color: White;" mce_style="background-color: White;"> <form id="form1" runat="server"> <table cellspacing="0" cellpadding="3" border="0" align="center" width="530px" style="margin-top: 200px;" mce_style="margin-top: 200px;"> <tr> <td style="width: 525px; height: 310px; background: url(images/background/loginbackground2.jpg) no-repeat; vertical-align: top;"> <div style="text-align: right; margin-right: 20px;" mce_style="text-align: right; margin-right: 20px;"> <div style=" text-align: left;width: 218px; height: 19px; margin-top:15px; margin-right:20px"> <asp:Label ID="lblTitle" runat="server" Text="户籍管理系统" Font-Bold="true" Font-Size="Small" Font-Names="宋体"></asp:Label> </div></div> <div id="userloginbox" style="margin: 0px 30px;" mce_style="margin: 0px 30px;"> <table cellpadding="5px;" width="450px"> <tr> <td colspan="2"> </td> </tr> <tr> <td align="right" width="50%"> <asp:Label ID="Label2" runat="server">用户名：</asp:Label> </td> <td> <asp:TextBox ID="txtUserID" runat="server" Width="150px" MaxLength="10" class="username" EnableTheming="false"></asp:TextBox> </td> </tr> <tr> <td align="right"> <asp:Label ID="Label3" runat="server">密码：</asp:Label> </td> <td> <asp:TextBox ID="txtPwd" runat="server" TextMode="Password" Width="150px" MaxLength="20" class="password" EnableTheming="false"></asp:TextBox> </td> </tr> <tr> <td> </td> <td> <asp:Button ID="btnLogin" runat="server" Text="登录" OnClick="btnLogin_Click"></asp:Button> </td> </tr> <tr> <td colspan="2" style="height: 20px;"> <asp:Label ID="lblMessage" runat="server" EnableViewState="False"></asp:Label> </td> </tr> <tr> <td colspan="2" align="right"> IE (<asp:Label ID="lblVersion" runat="server" Text="版本 6.0"></asp:Label>) </td> </tr> </table> </div> </td> </tr> </table> <br /> <br /> </form> </body> </html>

那么Login.aspx.cs页面就可以这样：

public partial class Login : System.Web.UI.Page { private HJMS.BLL.User userBll = new HJMS.BLL.User(); protected void Page_Load(object sender, EventArgs e) { } protected void btnLogin_Click(object sender, EventArgs e) { HJMS.Model.User UserInfo = userBll.CheckUser(txtUserID.Text.Trim(), txtPwd.Text.Trim()); if(UserInfo!=null&&UserInfo.UserID!=0) { HttpCookie cookie = FormsAuthentication.GetAuthCookie(UserInfo.UserName, true); cookie.Expires = DateTime.Now.AddDays(7); Response.Cookies.Add(cookie); if(Request.QueryString["ReturnUrl"]!=null) { Context.Response.Redirect(Request.QueryString["ReturnUrl"]);// 重定向到用户申请的初始页面 } else { Response.Redirect("Admin/Navigator.aspx"); } } else { Page.ClientScript.RegisterStartupScript(Page.GetType(),"Fails","alert('用户名或密码错误!');",true); } } }