NET中三层构架开发实例---用户注册系统.doc

NET中三层构架开发实例 - 用户注册系统.txt39人生旅程并不是一帆风顺的，逆境失意会经常伴随着我们，但人性的光辉往往在不如意中才显示出来，希望是激励我们前进的巨大的无形的动力。40奉献是爱心，勇于付出，你一定会收到意外之外的馈赠。数据库基类using System;using System.Data;using System.Data.SqlClient;namespace HaiSky.HtJob / / DbClass 的摘要说明。 / public class DbClass private string connectionString; protected SqlConnection Connection; public DbClass(string newConnectionString) connectionString = newConnectionString; Connection = new SqlConnection(connectionString); public string ConnectionString get return connectionString; private SqlCommand BuildQueryCommand(string storedProcName,IDataParameter parameters) SqlCommand command = new SqlCommand(storedProcName,Connection); command.CommandType = CommandType.StoredProcedure; foreach (SqlParameter parameter in parameters) command.Parameters.Add(parameter); return command; private SqlCommand BuildIntCommand(string storedProcName,IDataParameter parameters) SqlCommand command = BuildQueryCommand(storedProcName,parameters); command.Parameters.Add(new SqlParameter(ReturnValue,SqlDbType.Int,4, ParameterDirection.ReturnValue,false, 0, 0, string.Empty,DataRowVersion.Default,null); return command; protected int RunProcedure(string storedProcName,IDataParameter parameters,out int rowsAffected) int result; Connection.Open(); SqlCommand command = BuildIntCommand(storedProcName,parameters); rowsAffected = command.ExecuteNonQuery(); result = (int)command.ParametersReturnValue.Value; Connection.Close(); return result; protected SqlDataReader RunProcedure(string storedProcName, IDataParameter parameters ) SqlDataReader returnReader; Connection.Open(); SqlCommand command = BuildQueryCommand( storedProcName, parameters ); command.CommandType = CommandType.StoredProcedure; returnReader = command.ExecuteReader(); return returnReader; protected DataSet RunProcedure(string storedProcName, IDataParameter parameters, string tableName ) DataSet dataSet = new DataSet(); Connection.Open(); SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = BuildQueryCommand( storedProcName, parameters ); sqlDA.Fill( dataSet, tableName ); Connection.Close(); return dataSet; protected void RunProcedure(string storedProcName, IDataParameter parameters, DataSet dataSet, string tableName ) Connection.Open(); SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = BuildIntCommand( storedProcName, parameters ); sqlDA.Fill( dataSet, tableName ); Connection.Close(); 商务层基类（逻辑层）using System;namespace Wrox.WebModules.Business public class BizObject public BizObject() 下面是用户注册系统开发的三层构架实例：数据库基类采用上面提供的代码。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); parameters0.Value = user_nm; parameters1.Value = user_pwd; parameters2.Direction = ParameterDirection.Output; try RunProcedure(IF_user_info,parameters,out rowsAffected); catch return (int)parameters2.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.AppSettingsstrConn; 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.Rows0.Cells0.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();