NET中三層構架開發(fā)實例---用戶注冊系統(tǒng)

1、NET中三層構架開發(fā)實例-用戶注冊系統(tǒng).txt39人生旅程并不是一帆風順的，逆境失意會經(jīng)常伴隨著我們，但人性的光芒往往在不如意中才顯示出來，希望是激勵我們前進的巨大的無形的動力。40奉獻是愛心，勇于付出，你一定會收到意外之外的饋贈。數(shù)據(jù)庫基類usingSystem;usingSystem.Data;usingSystem.Data.SqlClient;namespaceHaiSky.HtJob/<summary>/DbClass的摘要說明。/</summary>publicclassDbClassprivatestringconnectionString;protect

2、edSqlConnectionConnection;publicDbClass(stringnewConnectionString)connectionString=newConnectionString;Connection=newSqlConnection(connectionString);publicstringConnectionStringgetreturnconnectionString;privateSqlCommandBuildQueryCommand(stringstoredProcName,IDataParameterparameters)SqlCommandcomman

3、d=newSqlCommand(storedProcName,Connection);command.CommandType=CommandType.StoredProcedure;foreach(SqlParameterparameterinparameters)command.Parameters.Add(parameter);returncommand;privateSqlCommandBuildIntCommand(stringstoredProcName,IDataParameterparameters)SqlCommandcommand=BuildQueryCommand(stor

4、edProcName,parameters);command.Parameters.Add(newSqlParameter("ReturnValue",SqlDbType.Int,4,ParameterDirection.ReturnValue,false,0,0,string.Empty,DataRowVersion.Default,null);returncommand;protectedintRunProcedure(stringstoredProcName,IDataParameterparameters,outintrowsAffected)intresult;C

5、onnection.Open();SqlCommandcommand=BuildIntCommand(storedProcName,parameters);rowsAffected=command.ExecuteNonQuery();result=(int)command.Parameters"ReturnValue".Value;Connection.Close();returnresult;protectedSqlDataReaderRunProcedure(stringstoredProcName,IDataParameterparameters)SqlDataRea

6、derreturnReader;Connection.Open();SqlCommandcommand=BuildQueryCommand(storedProcName,parameters);command.CommandType=CommandType.StoredProcedure;returnReader=command.ExecuteReader();returnreturnReader;protectedDataSetRunProcedure(stringstoredProcName,IDataParameterparameters,stringtableName)DataSetd

7、ataSet=newDataSet();Connection.Open();SqlDataAdaptersqlDA=newSqlDataAdapter();sqlDA.SelectCommand=BuildQueryCommand(storedProcName,parameters);sqlDA.Fill(dataSet,tableName);Connection.Close();returndataSet;protectedvoidRunProcedure(stringstoredProcName,IDataParameterparameters,DataSetdataSet,stringt

8、ableName)Connection.Open();SqlDataAdaptersqlDA=newSqlDataAdapter();sqlDA.SelectCommand=BuildIntCommand(storedProcName,parameters);sqlDA.Fill(dataSet,tableName);Connection.Close();商務層基類邏輯層usingSystem;namespaceWrox.WebModules.BusinesspublicclassBizObjectpublicBizObject()下面是用戶注冊系統(tǒng)開發(fā)的三層構架實例：數(shù)據(jù)庫基類采用上面提供的

9、代碼。1、用戶注冊模塊數(shù)據(jù)層開發(fā)：usingSystem;usingSystem.Data;usingSystem.Data.SqlClient;usingHaiSky.HtJob;usingSystem.Xml;namespaceHaiSky.HtJob.Accounts.AccountsDatapublicclassUser:HaiSky.HtJob.HaiSkyDbObjectpublicUser(stringnewConnectionString):base(newConnectionString)/直接路由連接字符串publicintCreate(stringuser_nm,stri

10、nguser_pwd)introwsAffected;newSqlParameterparameters=SqlParameter("user_nm",SqlDbType.Char,16),newSqlParameter("user_pwd",SqlDbType.Char,16);parameters0.Value=user_nm;parameters1.Value=user_pwd;parameters2.Direction=ParameterDirection.Output;tryRunProcedure("IF_user_info&quo

11、t;,parameters,outrowsAffected);catchreturn(int)parameters2.Value;2、用戶注冊商務層開發(fā)：usingSystem;usingSystem.Configuration;usingHaiSky.HtJob.Accounts.AccountsData;namespaceHaiSky.HtJob.Accounts.AccountBusinesspublicclassUser:HaiSky.HtJob.HaiSkyBizObjectintuserID;stringuserName;stringuserPwd;stringstrConn;pu

12、blicUser()strConn=ConfigurationSettings.AppSettings"strConn"publicintCareate()AccountsData.UserdataUser=newAccountsData.User(strConn);userID=dataUser.Create(userName,userPwd);returnuserID;publicintUserIDgetreturnuserID;setuserID=value;publicstringUserNamegetreturnuserName;setuserName=value

13、;publicstringUserPwdgetreturnuserPwd;setuserPwd=value;3、用戶注冊表示層開發(fā)：usingSystem;usingSystem.Collections;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Web;usingSystem.Web.SessionState;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.HtmlControls;usingHa

14、iSky.HtJob.Accounts.AccountBusiness;namespaceHaiSky.HtJob.Modules.AccountspublicclassRegister:System.Web.UI.PageprotectedSystem.Web.UI.WebControls.TextBoxTextBox1;protectedSystem.Web.UI.WebControls.TextBoxTextBox2;protectedSystem.Web.UI.WebControls.TableTable1;protectedSystem.Web.UI.WebControls.Butt

15、onButton1;privatevoidPage_Load(objectsender,System.EventArgse)Table1.Rows0.Cells0.Visible=false;#regionWebFormDesignergeneratedcodeoverrideprotectedvoidOnInit(EventArgse)InitializeComponent();base.OnInit(e);privatevoidInitializeComponent()this.Button1.Click+=newSystem.EventHandler(this.Button1_Click

16、);this.Load+=newSystem.EventHandler(this.Page_Load);#endregionprivatevoidButton1_Click(objectsender,System.EventArgse)inti;這里輸出返newHtJob.Accounts.AccountBusiness.UserBusinessUserHtJob.Accounts.AccountBusiness.User();BusinessUser.UserName=TextBox1.Text;BusinessUser.UserPwd=TextBox2.Text;i=BusinessUser.Careate();Response.Write(i.ToStri