spring+ibatis配置

spring-dao.xml配置

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="classpath:/sql-map-config.xml"/>
<property name="dataSource" ref="dataSource"/>
</bean>

sql-map-config.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
<settings enhancementEnabled="true" maxTransactions="20"
maxRequests="32" maxSessions="10"/>

<sqlMap resource="sqlmaps/XXXSQL.xml"/>

</sqlMapConfig>

XXXSQL.xml配置

<sqlMap namespace="abcSQL">

<typeAlias alias="abc" type="com.ABC"/>

<resultMap id="abcResult" class="abc">
<result property="id" column="id"/>

<result property="name" column="name"/>
</resultMap>

自增主键，返回新值

<insert id="add" parameterClass="abc">
<![CDATA[
insert into abc(name)
values (#name:VARCHAR#)
]]>
<selectKey keyProperty="id" resultClass="java.lang.Long">
values IDENTITY_VAL_LOCAL()
</selectKey>
</insert>