IBatis_Net使用实例

最新推荐文章于 2025-10-21 22:09:11 发布

转载最新推荐文章于 2025-10-21 22:09:11 发布 · 515 阅读

文章标签：

#ibatis #string #datagrid #database #encoding #assembly

本文介绍了IBatis.Net的基本配置过程，包括SqlMap.config文件设置、数据源连接配置及User.xml映射文件定义等关键步骤，并通过一个具体的测试示例展示了如何使用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();
        }