IBatis_Net使用实例

  一。下载及需要的资源
    IBatis的网址是： http://ibatis.apache.org/  包括了 IBatis for java，IBatis.Net。

二。配置IBatis.Net
       SqlMap.config ：

<? xml version = " 1.0 "  encoding = " UTF-8 "   ?>
< sqlMapConfig xmlns:xsi = " http://www.w3.org/2001/XMLSchema-instance "  xsi:noNamespaceSchemaLocation = " SqlMapConfig.xsd " >
     < settings >
         < setting cacheModelsEnabled = " true "   />
     </ settings >
     < database >
         < provider name = " ByteFx " ></ provider >
         < dataSource name = " MyFirstIBatis "  connectionString = " Database=test;Data Source=localhost;uid=aa;pwd=123 "   />
     </ database >
     < sqlMaps >
         < sqlMap resource = " User.xml "   />
     </ sqlMaps >
</ sqlMapConfig >

providers.config：这个文件提供了数据访问的一些系统配置，在IBatis.Net的下载包里可以找到。

三。类及映射文件：
       User.xml：

<? xml version = " 1.0 "  encoding = " utf-8 "   ?>
< sqlMap  namespace = " MyFirstIBatis "  xmlns:xsi = " http://www.w3.org/2001/XMLSchema-instance "  xsi:noNamespaceSchemaLocation = " SqlMap.xsd " >
     < alias >
         < typeAlias alias = " User "  assembly = " MyFirstIBatis.dll "  type = " MyFirstIBatis.User "   />
     </ alias >
     < resultMaps >
         < resultMap id = " SelectAllResult "   class = " User " >
             < result property = " Id "  column = " ID "   />
             < result property = " Name "  column = " Name "   />
             < result property = " Password "  column = " Password "   />
             < result property = " Position "  column = " Position "   />
             < result property = " Locked "  column = " Locked "   />             
         </ resultMap >
     </ resultMaps >
     < statements >
         < select id = " SelectAll "  resultMap = " SelectAllResult " >
        select  *  from accounts_user
         </ select >
     </ statements >
</ sqlMap >

    User.cs：

using  System;

namespace  MyFirstIBatis
{
    /**//// <summary>
    /// User 的摘要说明。
    /// </summary>
    public class User
    {
        private string id;
        private string name;
        private string password;
        private int position;
        private string locked;

        public string Id 
        {
            get{return id;} 
            set{id = value;}
        }

        public string Name
        {
            get{return name;} 
            set{name = value;}
        }

        public string Password 
        {
            get{return password;} 
            set{password = value;}
        }

        public int Position
        {
            get{return position;}
            set{position = value;}
        }

        public string Locked
        {
            get{return locked;} 
            set{locked = value;}
        }

    }
}

四。测试：

private   void  Button1_Click( object  sender, System.EventArgs e)
         {
            System.Collections.IList data = IBatisNet.DataMapper.Mapper.Instance().QueryForList("SelectAll",null);
            
            DataGrid1.DataSource = data;
            DataGrid1.DataBind();
        }