学习 ibatisnet + castle 笔记

最近想学习 ibatisnet + castle ,并想在项目中加以应用,看了网上许多资料,本以为瞒简单的,
谁想自己动手时还是费了不少功夫的 :)   ,先将自己的学习心得和自己建的项目贴出来,供大家分享和研究,
我也是初学,写的有不对的地方还望大家多多指教哈.

1.  下载castle 和 ibatisnet 的 dll文件,

    注意:目前为止,castle版本最高支持 ibatisnet 的 datamapper的版本是1.5,dataaccess 版本1.8
   
    所以需下载castle 1.0 和 ibatyisnet的 1.5 版本

2.  框架 模仿 npetshop2 的架构 并且稍做了简化,去掉了其页面采用castle控制的部分,具体框架如下:
   
    ATS.Domain  系统领域,所有数据库实体的对象,数据载体,在其他各个层都要用到
    ATS.Persistence  持久层,持久化数据到数据库,其中包括 interface(接口) 和 mapperDao(实现)
    ATS.Service  服务层,系统用到的所有业务方法,调用 ATS.Persistence层,其中包括 Implement(实现) 和 Interface(接口)
    ATS.Test  测试层 ,用 NUnit 测试
    ATS.Web   页面层(最终与用户交互)
    ATS.Common   系统公共层,公用方法和类

3.  首先需要配置 web.config 文件, 在<configuration>节点下新增 如下节点供castle使用

<? xml version="1.0" ?>
<!--  
    注意: 除了手动编辑此文件以外，您还可以使用 
    Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的
     “网站”->“Asp.Net 配置”选项。
    设置和注释的完整列表在 
    machine.config.comments 中，该文件通常位于 
    WindowsMicrosoft.NetFrameworkv2.xConfig 中
-->
< configuration >
     < configSections >
         < section  name ="castle"  type ="Castle.Windsor.Configuration.AppDomain.CastleSectionHandler, Castle.Windsor" />
     </ configSections >

     < castle >
         <!-- 扩展castle 将 ibatisnet 当作插件和 castle 相结合 -->
         < include  uri ="file://facilities.config" />
         <!-- 此文件告诉castel 哪个接口 由 哪个类 实现 -->
         < include  uri ="file://services.config" />
     </ castle >
    
     < appSettings />
     < connectionStrings />
     < system .web >
         <!--  
            设置 compilation debug="true" 将调试符号插入
            已编译的页面中。但由于这会 
            影响性能，因此只在开发过程中将此值 
            设置为 true。
         -->
         < compilation  debug ="true" />
         <!--
            通过 <authentication> 节可以配置 ASP.NET 使用的 
            安全身份验证模式，
            以标识传入的用户。 
         -->
         < authentication  mode ="Windows" />
         <!--
            如果在执行请求的过程中出现未处理的错误，
            则通过 <customErrors> 节可以配置相应的处理步骤。具体说来，
            开发人员通过该节可以配置
            要显示的 html 错误页
            以代替错误堆栈跟踪。

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
         -->
     </ system.web >
</ configuration >

使用以上配置时,需要将所有配置文件默认放在web应用程序的根目录下,castle 会自动从 web.config中读取

4.  配置 facilities.config 文件 (程序根目录下)

<? xml version="1.0" encoding="utf-8"  ?>
     < configuration >

         < facilities >
             <!-- 为Castle 扩展 ibatisnet -->
             < facility  id ="ibatis"  type ="Castle.Facilities.IBatisNetIntegration.IBatisNetFacility, Castle.Facilities.IBatisNetIntegration"   >
                 < sqlMap  id ="sqlServerSqlMap"  config ="sqlMap.config"   />
             </ facility >
             <!-- 为Castle 扩展 事务处理功能 -->
             < facility  id ="transaction"  type ="Castle.Facilities.AutomaticTransactionManagement.TransactionFacility, Castle.Facilities.AutomaticTransactionManagement"   />

         </ facilities >
     </ configuration >

这样 castle 就可以自动将 ibatisnet 管理起来了,需要ibatisnet的时候会自动运行 ibatisnet

5.  配置 services.config 文件

<? xml version="1.0" encoding="utf-8"  ?>
     < configuration >
         < components >
             < component
                       id ="Employees"
                      service ="ATS.Service.Interface.IEmployeesService, ATS.Service"
                      type ="ATS.Service.Implement.EmployeesService, ATS.Service"   />

         </ components >
     </ configuration >

可以发现: 服务(接口) IEmployeesService 由 EmployeesService 类实现 ,castle 会自动装配,
    即在请求需要调用IEmployeesService 接口中的方法时,会自动实例化EmployeesService类,并调用其中相应的方法

6.  编写ibatisnet 的配置文件 sqlmap.config

<? xml version="1.0" encoding="utf-8"  ?>
     < sqlMapConfig 
       xmlns ="http://ibatis.apache.org/dataMapper"  
      xmlns:xsi ="http://www.w3.org/2001/XMLSchema-instance" >

         < settings >
             < setting  useStatementNamespaces ="false" />
         </ settings >

         <!-- database providers -->
         < providers  resource ="providers.config" />

         <!--  Database connection information  -->
         < database >
             < provider  name ="sqlServer2.0" />
             < dataSource  name ="DocumentSystem"  connectionString ="server=.SQLExpress;database=Northwind;uid=sa;pwd=" />
         </ database >

         < sqlMaps >
             <!-- 设置sqlmap,所有实体的数据库操作 -->
             < sqlMap  resource ="../ATS.Persistence/Maps/Employees.xml"   />
         </ sqlMaps >

     </ sqlMapConfig >

以上设置 ibatisnet 对实体进行数据库操作的 sqlmap.

7.  设置 dao.config 文件

<? xml version="1.0" encoding="utf-8" ?>
     < daoConfig  xmlns ="http://ibatis.apache.org/dataAccess"  xmlns:xsi ="http://www.w3.org/2001/XMLSchema-instance" >
         <!-- Optional if resource -->

         < providers  resource ="providers.config" />

         < context  id ="SqlMapDao"  default ="true" >


             <!-- ==== Sql Server : SqlClient configuration ========= -->


             < database >
                 < provider  name ="sqlServer2.0" />
                 < dataSource  name ="Airfares"  connectionString ="server=.SQLExpress;database=Northwind;user id=sa;password=;" />
             </ database >

             < daoSessionHandler  id ="SqlMap" >
                 < property  name ="resource"  value ="sqlMap.config" />
             </ daoSessionHandler >

             < daoFactory >
                 < dao  interface ="ATS.Persistence.Interface.IEmployeesDao, ATS.Persistence"
                    implementation ="ATS.Persistence.MapperDao.EmployeesSqlMapDao, ATS.Persistence" />
             </ daoFactory >
         </ context >

     </ daoConfig >

主要是 <daoFactory> 节点, 设置 dao 运行时的接口对应的实现类,即:IEmployeesDao 由 EmployeesSqlMapDao实现

8. providers.config 可以从ibatisnet的帮助文档里找到,或去网站下载

    编写 Employees.xml 文件 ,主要是编写sql语句

<? xml version="1.0" encoding="UTF-8"  ?>  
     < sqlMap  namespace ="Employees"  xmlns ="http://ibatis.apache.org/mapping"  xmlns:xsi ="http://www.w3.org/2001/XMLSchema-instance" >  
         < alias >
             < typeAlias  alias ="Employees"  type ="ATS.Domain.Employees, ATS.Domain"   />
         </ alias >
         < resultMaps >
             < resultMap  id ="SelectResult"  class ="Employees" >
                 < result  property ="EmployeeID"  column ="employeeid"   />
                 < result  property ="LastName"  column ="lastname"   />
                 < result  property ="FirstName"  column ="firstname"   />
                 < result  property ="Title"  column ="title"   />
                 < result  property ="TitleOfCourtesy"  column ="titleofcourtesy"   />
                 < result  property ="BirthDate"  column ="birthdate"   />
                 < result  property ="HireDate"  column ="hiredate"   />
                 < result  property ="Address"  column ="address"   />
                 < result  property ="City"  column ="city"   />
                 < result  property ="Region"  column ="region"   />
                 < result  property ="PostalCode"  column ="postalcode"   />
                 < result  property ="Country"  column ="country"   />
                 < result  property ="HomePhone"  column ="homephone"   />
                 < result  property ="Extension"  column ="extension"   />
                 < result  property ="Photo"  column ="photo"   />
                 < result  property ="Notes"  column ="notes"   />
                 < result  property ="ReportsTo"  column ="reportsto"   />
                 < result  property ="PhotoPath"  column ="photopath"   />
             </ resultMap >
         </ resultMaps >
        
         < statements >
             < select  id ="SelectEmployees"  parameterClass ="int"  resultMap ="SelectResult" >
                Select 
                      employeeid,
                      lastname,
                      firstname,
                      title,
                      titleofcourtesy,
                      birthdate,
                      hiredate,
                      address,
                      city,
                      region,
                      postalcode,
                      country,
                      homephone,
                      extension,
                      photo,
                      notes,
                      reportsto,
                      photopath
                From Employees
                 < dynamic  prepend ="WHERE" >
                     < isParameterPresent >
                        employeeid=#EmployeeID# 
                     </ isParameterPresent >
                 </ dynamic >
             </ select >
            
             < select  id ="BaseSelectEmployees"  parameterClass ="int"  resultMap ="SelectResult" >
                Select 
                      employeeid,
                      lastname,
                      firstname,
                      title,
                      titleofcourtesy,
                      birthdate,
                      hiredate,
                      address,
                      city,
                      region,
                      postalcode,
                      country,
                      homephone,
                      extension,
                      photo,
                      notes,
                      reportsto,
                      photopath
                From Employees
             </ select >
            
             < select  id ="ChildSelectEmployees"  parameterClass ="int"  resultMap ="SelectResult"  extends ="BaseSelectEmployees" >
                
             </ select >
                    
             < insert  id ="InsertEmployees"  parameterClass ="Employees" >
                Insert Into Employees (
                      employeeid,
                      lastname,
                      firstname,
                      title,
                      titleofcourtesy,
                      birthdate,
                      hiredate,
                      address,
                      city,
                      region,
                      postalcode,
                      country,
                      homephone,
                      extension,
                      photo,
                      notes,
                      reportsto,
                      photopath
                )Values(
                     #EmployeeID#,
                     #LastName#,
                     #FirstName#,
                     #Title#,
                     #TitleOfCourtesy#,
                     #BirthDate#,
                     #HireDate#,
                     #Address#,
                     #City#,
                     #Region#,
                     #PostalCode#,
                     #Country#,
                     #HomePhone#,
                     #Extension#,
                     #Photo#,
                     #Notes#,
                     #ReportsTo#,
                     #PhotoPath#
                )
             </ insert >
            
             < update  id ="UpdateEmployees"  parameterClass ="Employees" >
                Update Employees Set 
                    employeeid=#EmployeeID#,
                    lastname=#LastName#,
                    firstname=#FirstName#,
                    title=#Title#,
                    titleofcourtesy=#TitleOfCourtesy#,
                    birthdate=#BirthDate#,
                    hiredate=#HireDate#,
                    address=#Address#,
                    city=#City#,
                    region=#Region#,
                    postalcode=#PostalCode#,
                    country=#Country#,
                    homephone=#HomePhone#,
                    extension=#Extension#,
                    photo=#Photo#,
                    notes=#Notes#,
                    reportsto=#ReportsTo#,
                    photopath=#PhotoPath#
                 < dynamic  prepend ="WHERE" >
                     < isParameterPresent >
                        employeeid=#EmployeeID#
                     </ isParameterPresent >
                 </ dynamic >
             </ update >
            
             < delete  id ="DeleteEmployees"  parameterClass ="int" >
                Delete From Employees
                 < dynamic  prepend ="WHERE" >
                     < isParameterPresent >
                        employeeid=#EmployeeID#
                     </ isParameterPresent >
                 </ dynamic >
             </ delete >
            
         </ statements >
     </ sqlMap >

 

9.  接下来需要在 global中初始化 castle 容器:
    1. 定义自己的容器类,这样可以在容器中初始化 ibatisnet的dao,即读取dao.config文件,将接口和实现类保存起来,
       以后使用时直接取出即可,并在castle容器中加入DaoManager 对象实例 ,代码如下:(此类放在ATS.Common 中)

         using  System;
         using  System.Configuration;
         using  Castle.Windsor;
         using  IBatisNet.DataAccess;
         using  IBatisNet.DataAccess.Configuration;

         namespace  ATS.Common
         ... {
            /**//// <summary>
            /// 自定义的容器类,初始化容器的时候,初始化dao,
            /// 定义好的持久层的接口和实现类加载
            /// </summary>
            public class ATSContainer : WindsorContainer
            ...{
                public ATSContainer(Castle.Windsor.Configuration.IConfigurationInterpreter inter) : base(inter)
                ...{
                    // Add DaoManager
                    DomDaoManagerBuilder builder = new DomDaoManagerBuilder();
                    builder.Configure(@"dao.config");

                    this.Kernel.AddComponentInstance("DaoManager", typeof(DaoManager), DaoManager.GetInstance("SqlMapDao"));
                }
            }
        }

 

2. global中初始化容器:

using  System;
         using  System.Data;
         using  System.Configuration;
         using  System.Collections;
         using  System.Web;
         using  System.Web.Security;
         using  System.Web.SessionState;


         using  Castle.Windsor;
         using  Castle.Windsor.Configuration.Interpreters;
         using  Castle.Core.Resource;
         using  ATS.Common;

         namespace  ATS.Web
         ... {
            public class Global : System.Web.HttpApplication, IContainerAccessor
            ...{

                private static WindsorContainer container;

                protected void Application_Start(object sender, EventArgs e)
                ...{
                    try
                    ...{
                        //初始化容器,采用从默认(从Web.config中读取默认块)文件中读取
                        container = new ATSContainer(new XmlInterpreter(new ConfigResource()));
                    }
                    catch (ConfigurationException ex)
                    ...{
                        string msg = ex.Message;
                    }
                }

                protected void Application_End(object sender, EventArgs e)
                ...{
                    container.Dispose();
                }

                IContainerAccessor Members#region IContainerAccessor Members

                public IWindsorContainer Container
                ...{
                    get ...{ return container; }
                }

                #endregion
            }
        }

 

3. 在ATS.Common 中定义 ContainerAccessorUtil.cs类 ,此类主要用来获取容器,
            在使用时可以从容器中取出接口:

           

// 从容器中取出接口

IEmployeesService _IEmployeesService  =  (ContainerAccessorUtil.GetContainer())[ " Employees " ]  as  IEmployeesService;
            
// 并调用此接口的方法,系统会自动实例化实现IEmployeesService 的类,并调用其中的GetEmployeesList方法

IList < Employees >  employees  =  _IEmployeesService.GetEmployeesList();

 

10. 定义实体类:(domain)

     namespace  ATS.Domain
     ... {
        using System;
        
        /**//// <summary>
        /// Employees 
        /// </summary>
        [Serializable]
        public class Employees
        ...{
            public Employees()
            ...{
                
            }
            
            private int _employeeid;
            private string _lastname;
            private string _firstname;
            private string _title;
            private string _titleofcourtesy;
            private DateTime _birthdate;
            private DateTime _hiredate;
            private string _address;
            private string _city;
            private string _region;
            private string _postalcode;
            private string _country;
            private string _homephone;
            private string _extension;
            private System.Byte[] _photo;
            private string _notes;
            private int _reportsto;
            private string _photopath;
            
            /**////<sumary>
            /// EmployeeID
            ///</sumary>
            public int EmployeeID
            ...{
                get...{return _employeeid;}
                set...{_employeeid = value;}
            }
            /**////<sumary>
            /// LastName
            ///</sumary>
            public string LastName
            ...{
                get...{return _lastname;}
                set...{_lastname = value;}
            }
            /**////<sumary>
            /// FirstName
            ///</sumary>
            public string FirstName
            ...{
                get...{return _firstname;}
                set...{_firstname = value;}
            }
            /**////<sumary>
            /// Title
            ///</sumary>
            public string Title
            ...{
                get...{return _title;}
                set...{_title = value;}
            }
            /**////<sumary>
            /// TitleOfCourtesy
            ///</sumary>
            public string TitleOfCourtesy
            ...{
                get...{return _titleofcourtesy;}
                set...{_titleofcourtesy = value;}
            }
            /**////<sumary>
            /// BirthDate
            ///</sumary>
            public DateTime BirthDate
            ...{
                get...{return _birthdate;}
                set...{_birthdate = value;}
            }
            /**////<sumary>
            /// HireDate
            ///</sumary>
            public DateTime HireDate
            ...{
                get...{return _hiredate;}
                set...{_hiredate = value;}
            }
            /**////<sumary>
            /// Address
            ///</sumary>
            public string Address
            ...{
                get...{return _address;}
                set...{_address = value;}
            }
            /**////<sumary>
            /// City
            ///</sumary>
            public string City
            ...{
                get...{return _city;}
                set...{_city = value;}
            }
            /**////<sumary>
            /// Region
            ///</sumary>
            public string Region
            ...{
                get...{return _region;}
                set...{_region = value;}
            }
            /**////<sumary>
            /// PostalCode
            ///</sumary>
            public string PostalCode
            ...{
                get...{return _postalcode;}
                set...{_postalcode = value;}
            }
            /**////<sumary>
            /// Country
            ///</sumary>
            public string Country
            ...{
                get...{return _country;}
                set...{_country = value;}
            }
            /**////<sumary>
            /// HomePhone
            ///</sumary>
            public string HomePhone
            ...{
                get...{return _homephone;}
                set...{_homephone = value;}
            }
            /**////<sumary>
            /// Extension
            ///</sumary>
            public string Extension
            ...{
                get...{return _extension;}
                set...{_extension = value;}
            }
            /**////<sumary>
            /// Photo
            ///</sumary>
            public System.Byte[] Photo
            ...{
                get...{return _photo;}
                set...{_photo = value;}
            }
            /**////<sumary>
            /// Notes
            ///</sumary>
            public string Notes
            ...{
                get...{return _notes;}
                set...{_notes = value;}
            }
            /**////<sumary>
            /// ReportsTo
            ///</sumary>
            public int ReportsTo
            ...{
                get...{return _reportsto;}
                set...{_reportsto = value;}
            }
            /**////<sumary>
            /// PhotoPath
            ///</sumary>
            public string PhotoPath
            ...{
                get...{return _photopath;}
                set...{_photopath = value;}
            }
        }
    }

 

11.  定义ATS.Persistence.Interface.IEmployeesDao.cs 类

     namespace  ATS.Persistence.MapperDao
     ... {
        using System;
        using System.Collections;
        using System.Collections.Generic;
        using IBatisNet.Common;
        using IBatisNet.DataMapper;
        using IBatisNet.Common.Exceptions;

        using ATS.Domain;
        using ATS.Persistence.Interface;

        /**//// <summary>
        /// EmployeesSqlMapDao
        /// </summary>
        public class EmployeesSqlMapDao : BaseSqlMapDao, IEmployeesDao
        ...{
            public EmployeesSqlMapDao ()
            ...{
                //
                // TODO: 此处添加EmployeesSqlMapDao的构造函数
                //
            }

            /**//// <summary>
            /// 得到列表
            /// </summary>
            public IList<Employees> GetEmployeesList()
            ...{
                return ExecuteQueryForList<Employees>("SelectEmployees",null);
            }

            /**//// <summary>
            /// 新建
            /// </summary>
            public void AddEmployees(Employees employees)
            ...{
                ExecuteInsert("InsertEmployees",employees);
            }
            /**//// <summary>
            /// 修改
            /// </summary>
            public void UpdateEmployees(Employees employees)
            ...{
                ExecuteUpdate("UpdateEmployees",employees);
            }
            
            /**//// <summary>
            /// 得到明细
            /// </summary>
            /// <param name="id"></param>
            /// <returns></returns>
            public Employees GetEmployeesDetail(System.Int32 EmployeeID)
            ...{
                return ExecuteQueryForObject<Employees>("SelectEmployees",EmployeeID);
            }

            /**//// <summary>
            /// 删除
            /// </summary>
            /// <param name="id"></param>
            public void DeleteEmployees(System.Int32 EmployeeID)
            ...{
                ExecuteDelete("DeleteEmployees",EmployeeID);
            }
            

        }
    }

BaseSqlMapDao.cs 文件

 

using  System;
using  System.Collections;
using  System.Collections.Generic;
using  IBatisNet.Common.Pagination;
using  IBatisNet.DataMapper;
using  IBatisNet.DataMapper.Exceptions;
using  IBatisNet.DataMapper.Configuration;
using  IBatisNet.DataAccess;
using  IBatisNet.DataAccess.DaoSessionHandlers;
using  IBatisNet.DataAccess.Exceptions;
using  IBatisNet.DataAccess.Interfaces;
using  IBatisNet.Common.Utilities;
using  ATS.Common;

namespace  ATS.Persistence.MapperDao
... {
    /**//// <summary>
    /// Summary description for BaseSqlMapDao.
    /// </summary>
    public class BaseSqlMapDao : IDao
    ...{
        protected const int PAGE_SIZE = 4;

        /**//// <summary>
        /// 创建并返回一个sqlmap对象
        /// （下面对持久层的操作，都需要用到）
        /// Looks up the parent DaoManager, gets the local transaction
        /// (which should be a SqlMapDaoTransaction) and returns the
        /// SqlMap associated with this DAO.
        /// </summary>
        /// <returns>The SqlMap instance for this DAO.</returns>
        protected SqlMapper GetLocalSqlMap()
        ...{
            //通过DaoManager获取本地的SqlMapper对象
            DaoManager daoManager = DaoManager.GetInstance(this) as DaoManager;
            SqlMapDaoSession sqlMapDaoSession = (SqlMapDaoSession)daoManager.LocalDaoSession;

            return sqlMapDaoSession.SqlMap as SqlMapper;
        }

        非泛型方法#region 非泛型方法
        /**//// <summary>
        /// Simple convenience method to wrap the SqlMap method of the same name.
        /// Wraps the exception with a DataAccessException to isolate the SqlMap framework.
        /// </summary>
        /// <param name="statementName"></param>
        /// <param name="parameterObject"></param>
        /// <returns></returns>
        protected IList ExecuteQueryForList(string statementName, object parameterObject)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();
            try
            ...{
                return sqlMap.QueryForList(statementName, parameterObject);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for list.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// Simple convenience method to wrap the SqlMap method of the same name.
        /// Wraps the exception with a DataAccessException to isolate the SqlMap framework.
        /// </summary>
        /// <param name="statementName"></param>
        /// <param name="parameterObject"></param>
        /// <param name="skipResults"></param>
        /// <param name="maxResults"></param>
        /// <returns></returns>
        protected IList ExecuteQueryForList(string statementName, object parameterObject, int skipResults, int maxResults)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();
            try
            ...{
                return sqlMap.QueryForList(statementName, parameterObject, skipResults, maxResults);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for list.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// Simple convenience method to wrap the SqlMap method of the same name.
        /// Wraps the exception with a DataAccessException to isolate the SqlMap framework.
        /// </summary>
        /// <param name="statementName"></param>
        /// <param name="parameterObject"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        protected IPaginatedList ExecuteQueryForPaginatedList(string statementName, object parameterObject, int pageSize)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();
            try
            ...{
                return sqlMap.QueryForPaginatedList(statementName, parameterObject, pageSize);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for paginated list.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// Simple convenience method to wrap the SqlMap method of the same name.
        /// Wraps the exception with a DataAccessException to isolate the SqlMap framework.
        /// </summary>
        /// <param name="statementName"></param>
        /// <param name="parameterObject"></param>
        /// <returns></returns>
        protected object ExecuteQueryForObject(string statementName, object parameterObject)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();

            try
            ...{
                return sqlMap.QueryForObject(statementName, parameterObject);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for object.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// Simple convenience method to wrap the SqlMap method of the same name.
        /// Wraps the exception with a DataAccessException to isolate the SqlMap framework.
        /// </summary>
        /// <param name="statementName"></param>
        /// <param name="parameterObject"></param>
        /// <returns></returns>
        protected int ExecuteUpdate(string statementName, object parameterObject)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();

            try
            ...{
                return sqlMap.Update(statementName, parameterObject);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for update.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// Simple convenience method to wrap the SqlMap method of the same name.
        /// Wraps the exception with a DataAccessException to isolate the SqlMap framework.
        /// </summary>
        /// <param name="statementName"></param>
        /// <param name="parameterObject"></param>
        /// <returns></returns>
        protected object ExecuteInsert(string statementName, object parameterObject)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();

            try
            ...{
                return sqlMap.Insert(statementName, parameterObject);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for insert.  Cause: " + e.Message, e);
            }
        }
        #endregion

        泛型方法#region 泛型方法

        /**//// <summary>
        /// 得到列表
        /// </summary>
        /// <typeparam name="T">实体类型</typeparam>
        /// <param name="statementName">操作名称，对应xml中的Statement的id</param>
        /// <param name="parameterObject">参数</param>
        /// <returns></returns>
        protected IList<T> ExecuteQueryForList<T>(string statementName, object parameterObject)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();

            try
            ...{
                return sqlMap.QueryForList<T>(statementName, parameterObject);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for list.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// 得到指定数量的记录数
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="statementName"></param>
        /// <param name="parameterObject">参数</param>
        /// <param name="skipResults">跳过的记录数</param>
        /// <param name="maxResults">最大返回的记录数</param>
        /// <returns></returns>
        protected IList<T> ExecuteQueryForList<T>(string statementName, object parameterObject, int skipResults, int maxResults)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();

            try
            ...{
                return sqlMap.QueryForList<T>(statementName, parameterObject, skipResults, maxResults);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for list.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// 查询得到对象的一个实例
        /// </summary>
        /// <typeparam name="T">对象type</typeparam>
        /// <param name="statementName">操作名</param>
        /// <param name="parameterObject">参数</param>
        /// <returns></returns>
        protected T ExecuteQueryForObject<T>(string statementName, object parameterObject)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();

            try
            ...{
                return sqlMap.QueryForObject<T>(statementName, parameterObject);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for object.  Cause: " + e.Message, e);
            }
        }

        /**//// <summary>
        /// 执行删除
        /// </summary>
        /// <param name="statementName">操作名</param>
        /// <param name="parameterObject">参数</param>
        protected void ExecuteDelete(string statementName, object parameterObject)
        ...{
            SqlMapper sqlMap = GetLocalSqlMap();

            try
            ...{
                sqlMap.Delete(statementName, parameterObject);
            }
            catch (Exception e)
            ...{
                throw new DataMapperException("Error executing query '" + statementName + "' for delete.  Cause: " + e.Message, e);
            }
        }

        #endregion
    }
}

13. 定义 ATS.Service.Interface.IEmployeesService.cs 类

 

     using  System;
     using  System.Collections.Generic;
     using  System.Text;

     using  ATS.Domain;

     namespace  ATS.Service.Interface
     ... {
        public interface IEmployeesService
        ...{
            /**//// <summary>
            /// 得到列表
            /// </summary>
            IList<Employees> GetEmployeesList();

        }
    }

14. 定义 ATS.Service.Implement.EmployeesService.cs 类

 

     using  System;
     using  System.Collections.Generic;
     using  System.Text;

     using  ATS.Persistence.Interface;
     using  ATS.Persistence.MapperDao;
     using  ATS.Service.Interface;
     using  ATS.Domain;
     using  IBatisNet.DataAccess;

     namespace  ATS.Service.Implement
     ... {
        public class EmployeesService : IEmployeesService
        ...{
            Private Fields#region Private Fields 
            private IEmployeesDao _employeesDao = null;
            private DaoManager _daoManager = null;
            #endregion

            Constructor#region Constructor
            public EmployeesService(DaoManager daoManager) 
            ...{
                _daoManager = daoManager;
                _employeesDao = _daoManager.GetDao( typeof(IEmployeesDao) ) as IEmployeesDao;
            }
            #endregion

            /**//// <summary>
            /// 得到列表
            /// </summary>
            public IList<Employees> GetEmployeesList()
            ...{
                return _employeesDao.GetEmployeesList();
            }

        }
    }

最后 在页面的aspx.cs文件中调用了, 将数据显示在 gridview 中;
以下是调用代码

 

using  System;
using  System.Data;
using  System.Configuration;
using  System.Collections;
using  System.Web;
using  System.Web.Security;
using  System.Web.UI;
using  System.Web.UI.WebControls;
using  System.Web.UI.WebControls.WebParts;
using  System.Web.UI.HtmlControls;

using  ATS.Domain;
using  ATS.Service.Implement;
using  ATS.Service.Interface;
using  ATS.Common;
using  System.Collections.Generic;

using  ATS.Common;

namespace  ATS.Web
... {
    public partial class TestForm : System.Web.UI.Page
    ...{
        IEmployeesService _IEmployeesService = null;

        protected void Page_Load(object sender, EventArgs e)
        ...{
            //从容器中取出接口(从services.config中的ID获取)
            _IEmployeesService = (ContainerAccessorUtil.GetContainer())["Employees"] as IEmployeesService;
            
            if (!IsPostBack)
            ...{
                BindData();
            }
        }

        public void BindData()
        ...{
            //使用接口的方法,容器会自动查找并调用实现类中的方法
            IList<Employees> employees = _IEmployeesService.GetEmployeesList();

            dgData.DataSource = employees;
            dgData.DataBind();
        }
    }

    
}

 

刚刚开始学习,请高手指点 :)