《asp net2 0 三层 架构》由会员分享,可在线阅读,更多相关《asp net2 0 三层 架构(12页珍藏版)》请在金锄头文库上搜索。
1、ASP NET2 0 三层架构1第一层表示层用通俗的语言就是UI界面,再通俗点就是我们平时上网时看到的界面。2第二层业务逻辑层,说白了,就是一个类,该类利用下边一层(数据访问层的方法返回的结果DataSet)把各个数据对象分解,再从新以更小的对象存储起来(更加的有机体)等待上层的应用。3第三层数据访问曾。该层说白了也是一个类。该类其实是把数据库里的数据用该类的方法(以sql查询为核心)执行。(SRUD);下面给出示例代码:界面:web.congfig数据访问层代码:usingSystem.Web;usingSystem.Configuration;usingSystem.Data;usingS
2、ystem.Data.SqlClient;publicclassAuthorDB/构造函数publicAuthorDB()/获取state集合。返回DataSet,并通过DropDownList显示publicstaticDataSetGetStates()/获取连接字符串stringconnectionString=ConfigurationManager.ConnectionStringsPubsConnectionString.ConnectionString;/创建并设置SqlConnectionSqlConnectiondbConnection=newSqlConnection(co
3、nnectionString);/定义SQL查询语句stringqueryString=Selectdistinctstatefromauthors;/创建并设置SqlCommandSqlCommanddbCommand=newSqlCommand();dbCommand.Connection=dbConnection;dbCommand.CommandType=CommandType.Text;dbCommand.CommandText=queryString;/创建SqlDataAdapter,并获取数据SqlDataAdapterdataAdapter=newSqlDataAdapter
4、(dbCommand);DataSetds=newDataSet();dataAdapter.Fill(ds);/返回数据returnds;/根据state参数,获取数据记录。返回DataSet,并通过GridView显示publicstaticDataSetGetAuthorsByState(stringstate)/获取连接字符串stringconnectionString=ConfigurationManager.ConnectionStringsPubsConnectionString.ConnectionString;/创建并设置SqlConnectionSqlConnectiond
5、bConnection=newSqlConnection(connectionString);/定义SQL查询语句stringqueryString=Selectau_id,au_lname,au_fname,statefromauthorswherestate=state;/创建并设置SqlCommandSqlCommanddbCommand=newSqlCommand();dbCommand.Connection=dbConnection;dbCommand.CommandType=CommandType.Text;dbCommand.CommandText=queryString;/设置
6、SqlParameterSqlParameterdbParameter_state=newSqlParameter();dbParameter_state.ParameterName=state;dbParameter_state.Value=state;dbParameter_state.DbType=DbType.StringFixedLength;/向SqlCommmand中添加SqlParameterdbCommand.Parameters.Add(dbParameter_state);/创建SqlDataAdapter,并获取数据SqlDataAdapterdataAdapter=n
7、ewSqlDataAdapter(dbCommand);DataSetds=newDataSet();dataAdapter.Fill(ds);/返回数据returnds;/更新数据记录publicstaticintUpdateAuthor(stringau_id,stringau_lname,stringau_fname,stringstate)/获取连接字符串stringconnectionString=ConfigurationManager.ConnectionStringsPubsConnectionString.ConnectionString;/创建并设置SqlConnectio
8、nSqlConnectiondbConnection=newSqlConnection(connectionString);/定义SQL查询语句stringqueryString=UPDATEauthorsSETau_fname=au_fname,au_lname=au_lname,state=stateWHEREau_id=au_id;/创建并设置SqlCommandSqlCommanddbCommand=newSqlCommand();dbCommand.Connection=dbConnection;dbCommand.CommandType=CommandType.Text;dbCom
9、mand.CommandText=queryString;/设置参数au_idSqlParameterdbParameter_au_id=newSqlParameter();dbParameter_au_id.ParameterName=au_id;dbParameter_au_id.Value=au_id;dbParameter_au_id.DbType=DbType.String;/向SqlCommmand中添加au_iddbCommand.Parameters.Add(dbParameter_au_id);/设置参数au_lnameSqlParameterdbParameter_au_l
10、name=newSqlParameter();dbParameter_au_lname.ParameterName=au_lname;dbParameter_au_lname.Value=au_lname;dbParameter_au_lname.DbType=DbType.String;/向SqlCommmand中添加au_lnamedbCommand.Parameters.Add(dbParameter_au_lname);/设置参数au_fnameSqlParameterdbParameter_au_fname=newSqlParameter();dbParameter_au_fname
11、.ParameterName=au_fname;dbParameter_au_fname.Value=au_fname;dbParameter_au_fname.DbType=DbType.String;/向SqlCommmand中添加au_fnamedbCommand.Parameters.Add(dbParameter_au_fname);/设置参数stateSqlParameterdbParameter_state=newSqlParameter();dbParameter_state.ParameterName=state;dbParameter_state.Value=state;d
12、bParameter_state.DbType=DbType.StringFixedLength;/向SqlCommmand中添加statedbCommand.Parameters.Add(dbParameter_state);/执行SQL语句,并且返回受影响的行数introwsAffected=0;dbConnection.Open();tryrowsAffected=dbCommand.ExecuteNonQuery();finallydbConnection.Close();returnrowsAffected;业务实体类代码:usingSystem;publicclassAuthor#
13、region定义私有字段privatestring_id;privatestring_firstname;privatestring_lastName;privatestring_state;#endregion#region定义属性/定义属性IDpublicstringIDgetreturn_id;set_id=value;/定义属性FirstNamepublicstringFirstNamegetreturn_firstname;set_firstname=value;/定义属性LastNamepublicstringLastNamegetreturn_lastName;set_lastN
14、ame=value;/定义属性StatepublicstringStategetreturn_state;set_state=value;#endregion#region定义构造函数/定义构造函数1publicAuthor()/定义构造函数2publicAuthor(stringid,stringlastname,stringfirstname,stringstate)this.ID=id;this.FirstName=firstname;this.LastName=lastname;this.State=state;#endregion业务逻辑类代码:usingSystem;usingSystem.Data;usingSystem.Collections.Generic;publicclassAuthorsComponent#region定义构造函数publicAuthorsComponent()#endregion#region实现方法/根据参数state和sortExpression,实现获取Author对象集合并对其排序publicListAuthorGetAuthorsByState(stringstate,stringsortExpression)/初始化Author对象集合实例ListAuthorauthors=newListAuthor();/从数据访问层