下面是用户注册系统开发的三层构架实例:数据库基类采用上面提供的代码。 1、用户注册模块数据层开发: using System; using System.Data; using System.Data.SqlClient; using HaiSky.HtJob; using System.Xml; namespace HaiSky.HtJob.Accounts.AccountsData { public class User : HaiSky.HtJob.HaiSkyDbObject { public User(string newConnectionString) : base(newConnectionString) {//直接路由连接字符串} public int Create(string user_nm,string user_pwd) { int rowsAffected; SqlParameter[] parameters = {new SqlParameter("@user_nm",SqlDbType.Char,16), new SqlParameter("@user_pwd",SqlDbType.Char,16)}; parameters[0].Value = user_nm; parameters[1].Value = user_pwd; parameters[2].Direction = ParameterDirection.Output; try { RunProcedure("IF_user_info",parameters,out rowsAffected); } catch { } return (int)parameters[2].Value; } } } 2、用户注册商务层开发: using System; using System.Configuration; using HaiSky.HtJob.Accounts.AccountsData; namespace HaiSky.HtJob.Accounts.AccountBusiness { public class User : HaiSky.HtJob.HaiSkyBizObject { int userID; string userName; string userPwd; string strConn; public User() { strConn = ConfigurationSettings.AppSettings["strConn"]; } public int Careate() { AccountsData.User dataUser = new AccountsData.User(strConn); userID = dataUser.Create(userName,userPwd); return userID; } public int UserID { get { return userID; } set { userID = value; } } public string UserName { get { return userName; } set { userName = value; } } public string UserPwd { get { return userPwd; } set { userPwd = value; } } } } 3、 用户注册表示层开发: using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using HaiSky.HtJob.Accounts.AccountBusiness; namespace HaiSky.HtJob.Modules.Accounts { public class Register : System.Web.UI.Page { protected System.Web.UI.WebControls.TextBox TextBox1; protected System.Web.UI.WebControls.TextBox TextBox2; protected System.Web.UI.WebControls.Table Table1; protected System.Web.UI.WebControls.Button Button1; private void Page_Load(object sender, System.EventArgs e) { Table1.Rows[0].Cells[0].Visible = false; } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { InitializeComponent(); base.OnInit(e); } private void InitializeComponent() { this.Button1.Click += new System.EventHandler(this.Button1_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void Button1_Click(object sender, System.EventArgs e) { int i; HtJob.Accounts.AccountBusiness.User BusinessUser = new HtJob.Accounts.AccountBusiness.User(); BusinessUser.UserName = TextBox1.Text; BusinessUser.UserPwd = TextBox2.Text; i = BusinessUser.Careate(); Response.Write (i.ToString()); //这里输出返回值 } } } 4、该系统调用的存储过程: CREATE PROCEDURE IF_user_info (@user_nm char(16),@user_pwd char(16),@user_ID int output) AS insert user_info(user_nm,user_pwd) values(@user_nm,@user_pwd) set @user_ID = @@identity IF @@ERROR > 0 BEGIN RAISERROR ('Insert of Article failed', 16, 1) |
.NET中三层构架开发实例-用户注册系统
最新推荐文章于 2022-03-08 21:12:29 发布