<!-- Configure a datasource to use with this SQL Map using SimpleDataSource.
Notice the use of the properties from the above resource -->
<transactionManager type="JDBC" >
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="${driver}"/>
<property name="JDBC.ConnectionURL" value="${url}"/>
<property name="JDBC.Username" value="${username}"/>
<property name="JDBC.Password" value="${password}"/>
<property name="JDBC.DefaultAutoCommit" value="true" />
<property name="Pool.MaximumActiveConnections" value="10"/>
<property name="Pool.MaximumIdleConnections" value="5"/>
<property name="Pool.MaximumCheckoutTime" value="120000"/>
<property name="Pool.TimeToWait" value="500"/>
<property name="Pool.PingQuery" value="select 1 from author"/>
<property name="Pool.PingEnabled" value="false"/>
<property name="Pool.PingConnectionsOlderThan" value="1"/>
<property name="Pool.PingConnectionsNotUsedFor" value="1"/>
</dataSource>
</transactionManager>
<!-- Identify all SQL Map XML files to be loaded by this SQL map. Notice the paths
are relative to the classpath. For now, we only have one… -->
<sqlMap resource="com/ibatis/sqlmap/author.xml" />
</sqlMapConfig>

3. 配置SqlMap.xml文件
這里我們命名為author.xml

<select id="getAuthor" parameterClass="int" resultClass="Author">
 SELECT auth_id as id,auth_name as name,auth_age as age,auth_tel as telephone,auth_address as address FROM author WHERE auth_id = #id#
</select>

<statement id="getAllAuthor" resultMap="authorResult">
 SELECT * FROM author
</statement>

<insert id="insertAuthor" parameterMap="authorParameter">
 INSERT INTO author (auth_name,auth_age,auth_tel,auth_address) VALUES (?,?,?,?)
</insert>

<update id="updateAuthor" parameterClass="Author">
 UPDATE author set auth_name=#name# WHERE auth_id = #id#
</update>

<delete id="deleteAuthor" parameterClass="int">
 delete from author WHERE auth_id = #id#
</delete>

</sqlMap>

（三） 程序調(diào)用
由于源代碼很長(zhǎng)，所以這里我只給出一些簡(jiǎn)單的程序調(diào)用方法，所以如果有人想要源代碼的話，可以留下你的郵箱。
1. 初始化一個(gè)SqlMapClient對(duì)象，代碼如下：
public class SqlMapConf
{
    private static SqlMapClient sqlMapClient;
    static
 {
  try
  {
      System.out.println("sqlMapClient initing.....");
   String resource = "SqlMapConfig.xml";
   Reader reader = Resources.getResourceAsReader (resource);
   sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
  }
  catch (Exception e)
  {
   e.printStackTrace();
   throw new RuntimeException ("Error initializing MyAppSqlConfig class. Cause: " +e);
  }
 }
    public static SqlMapClient getInstance()
    {
        return sqlMapClient;
    } 
}

2. 然后要為Author表寫一個(gè)bean，代碼如下：
public class Author
{
    private int id;
    private int age;
    private String name;  
    private String address;
    private String telephone;
   
    public int getId()
    {
        return id;
    }
    public void setId(int id)
    {
        this.id=id;
    }
    public int getAge()
    {
        return age;
    }
    public void setAge(int age)
    {
        this.age=age;
    }
    public String getName()
    {
        return name;
    }
    public void setName(String name)
    {
        this.name=name;
    }
   
    public String getAddress()
    {
        return address;
    }
    public void setAddress(String address)
    {
        this.address=address;
    }
    public String getTelephone()
    {
        return telephone;
    }
    public void setTelephone(String telephone)
    {
        this.telephone=telephone;
    }
}

3. 程序調(diào)用：
這里將只示范一下getAuthor、insertAuthor1、updateAuthor和deleteAuthor的方法。
首先應(yīng)該得到一個(gè)SqlMapClient實(shí)例：
SqlMapClient sqlMapClient = SqlMapConf.getInstance();

（1） getAuthor：
 Author author = (Author)sqlMapClient.queryForObject("getAuthor", new Integer(1));
（2） getAllAuthor
 List authorList = (List)sqlMapClient.queryForList("getAllAuthor", null);
（3） insertAuthor：
 Author author = new Author();
 author.setName("作者三");
 author.setAge(31);
 author.setAddress("南京");
 author.setTelephone("025-987654321");
 sqlMapClient.insert(operaName, author);
（4） updateAuthor
 Author author = new Author();
 author.setName("Updated");
 author.setId(authorID);
 sqlMapClient.update(operaName, author);       
（5） deleteAuthor
 sqlMapClient.delete("deleteAuthor", new Integer(authorID));

這里只是做一個(gè)簡(jiǎn)單的例子，希望能夠幫助快速的入門，而并沒有對(duì)IBatis的原理進(jìn)行剖析，不過通過這幾個(gè)調(diào)用，我想你可能能夠猜到IBatis的一部分運(yùn)作原理了，關(guān)于IBatis的原理以及高級(jí)應(yīng)用，請(qǐng)關(guān)注后續(xù)文章。