1、applicationContext.xml
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation" value="classpath:sqlMapConfig.xml"/> <property name="dataSource" ref="dataSource"/> </bean> <!-- 创建sqlMapClientTemplate --> <bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate"> <constructor-arg> <ref bean="sqlMapClient" /> </constructor-arg> </bean>
2、sqlMapConfig.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> <!-- cacheModelsEnabled : 是否启用SqlMapClient上的缓存机制 enhancementEnabled : 是否针对POJO启用字节码增强机getter/setter的调用效能 errorTracingEnabled : 是否启用错误日志,在开发期间建议设为"true" lazyLoadingEnabled : 是否启用延迟加载机制 maxRequests : 最大并发请求数(Statement并发数) maxSessions : 最大Session数,即当前最大允许的并发SqlMapClient数 maxTransactions : 最大并发事务数 useStatementNamespaces : 是否使用Statement命名空间, 默认为false, 建议设为true; --> <settings cacheModelsEnabled="true" enhancementEnabled="true" errorTracingEnabled="true" lazyLoadingEnabled="true" maxRequests="64" maxSessions="32" maxTransactions="16" useStatementNamespaces="false" /> <!-- 配置Ibatis要使用的SqlMap文件信息 --> <sqlMap resource="com/iss/beans/sqlmap/UserEntity.xml"/> </sqlMapConfig>
3、applicationContext-dao.xml
<bean id="baseDAO" class="com.iss.common.core.BaseDAOImpl"> <property name="sqlMapClientTemplate" ref="sqlMapClientTemplate" /> </bean> <bean id="userDAO" class="com.iss.dao.impl.UserDAOImpl" parent="baseDAO"> </bean>
4、web.xml
<!-- Spirng --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <context-param> <param-name>contextConfigLocation</param-name> <param-value> classpath:spring/applicationContext-dao.xml, classpath:spring/applicationContext-service.xml, classpath:spring/applicationContext-action.xml, classpath:spring/applicationContext.xml, </param-value> </context-param>