一个简单的iBatis示例

    在将要进行开发的系统中，我们要使用iBatis做为数据库的中间件，今天参照了一些开发文档写了一个demo，详细如下：
SqlMapConfig.xml
-------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
    <settings
    cacheModelsEnabled="true"
    enhancementEnabled="true"
    lazyLoadingEnabled="true"
    errorTracingEnabled="true"
    maxRequests="128"
    maxSessions="10"
    maxTransactions="5"
    useStatementNamespaces="false" />
    <typeAlias alias="territory" type="Territory"/>
    <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver"
                value="oracle.jdbc.driver.OracleDriver" />
            <property name="JDBC.ConnectionURL"
                value="jdbc:oracle:thin:@192.168.1.1:1521:mydb" />
            <property name="JDBC.Username" value="123" />
            <property name="JDBC.Password" value="123" />
        </dataSource>
    </transactionManager>
    <sqlMap resource="Territory.xml" />
</sqlMapConfig>


Territory.xml
---------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Territory">
    <typeAlias alias="territoty" type="Territory" />
    <select id="getTerritory" parameterClass="java.lang.Integer"
        resultClass="territoty">
        <![CDATA[
      select *  from com_territory      
           ]]>
    </select>
    <update id="updateTerritory" parameterClass="territoty">
        <![CDATA[
            UPDATE com_territoty
            SET
            territory_id=#territory_id#,
            territory_ad=#territory_ad#
            WHERE territory_id = #territory_id#
          ]]>
    </update>
    <insert id="insertTerritory" parameterClass="territoty">
            INSERT INTO com_territoty ( territory_id, territory_ad)
            VALUES ( #territory_id#, #territory_ad# )
    </insert>
</sqlMap>
（未完待续）