ibatis学习笔记(五)>>>>>>>ibatis和Spring整合实例

1.导入相关的ibatis和spring所需要的包。Spring是一个开源框架，它由Rod Johnson创建。它是为了解决企业应用开发的复杂性而创建的。Spring使用基本的JavaBean来完成以前只可能由EJB完成的事情。然而，Spring的用途不仅限于服务器端的开发。从简单性、可测试性和松耦合的角度而言，任何Java应用都可以从Spring中受益。

2.项目相关配置文件database-config.properties(数据库配置属性文件)、SqlConfig-ibatis.xml（ibatis配置文件）、 TEACHER_SqlMap.xml（java实体和数据库sql配置文件）、spring-context.xml（Spring相关配置）。

database-config.properties文件内容

java.mysql.server=127.0.0.1 java.mysql.port=3306 java.mysql.url=jdbc/:mysql/://${java.mysql.server}/:${java.mysql.port}/${java.mysql.database} java.mysql.database=school java.mysql.username=root java.mysql.password=root java.mysql.driver=com.mysql.jdbc.Driver

SqlConfig-ibatis.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" /> <typeHandler callback="org.springframework.orm.ibatis.support.BlobByteArrayTypeHandler" javaType="[B" jdbcType="BLOB" /> <typeHandler callback="org.springframework.orm.ibatis.support.ClobStringTypeHandler" javaType="java.lang.String" jdbcType="CLOB" /> <sqlMap resource="com/yjpeng/ibatis/sqlmap/TEACHER_SqlMap.xml" /> </sqlMapConfig>

TEACHER_SqlMap.xml文件内容

 <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" > <sqlMap namespace="TEACHER"> <typeAlias type="com.yjpeng.ibatis.model.Teacher" alias="teacher" /> <resultMap class="teacher" id="teacherResult"> <result column="id" property="id" jdbcType="INT" /> <result column="name" property="name" jdbcType="VARCHAR" /> <result column="address" property="address" jdbcType="VARCHAR" /> </resultMap> <select id="teacher_getTeacherList" resultMap="teacherResult"> select * from teacher </select> </sqlMap>

spring-context.xml文件内容

 <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <!-- spring加载数据库配置属性文件 --> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>database-config.properties</value> </list> </property> </bean> <!-- 数据源的配置 使用从c3p0配置连接池 --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass"> <value>${java.mysql.driver}</value> </property> <property name="jdbcUrl"> <value>${java.mysql.url}</value> </property> <property name="user"> <value>${java.mysql.username}</value> </property> <property name="password"> <value>${java.mysql.password}</value> </property> <property name="acquireIncrement"> <value>5</value> </property> <!-- 最小连接数 --> <property name="minPoolSize"> <value>10</value> </property> <!-- 最大的连接数 --> <property name="maxPoolSize"> <value>100</value> </property> <!-- 一个连接的最大闲置时间3秒 --> <property name="maxIdleTime"> <value>3</value> </property> <!-- 连接池某个连接的最大statement数 --> <property name="maxStatementsPerConnection"> <value>100</value> </property> <!-- 连接时的最大statement数 --> <property name="maxStatements"> <value>2000</value> </property> <!-- 间隔30秒检查所有连接池中的空闲连接 --> <property name="idleConnectionTestPeriod"> <value>30</value> </property> <!-- 初始的链接池大小 --> <property name="initialPoolSize"> <value>2</value> </property> <!-- 定义在从数据库获取新连接失败后重复尝试获取30次 --> <property name="acquireRetryAttempts"> <value>30</value> </property> <property name="breakAfterAcquireFailure"> <value>true</value> </property> <property name="testConnectionOnCheckout"> <value>false</value> </property> </bean> <bean id="mysqlLobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler"></bean> <!-- 整合ibatis文件 --> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="dataSource"> <ref local="dataSource"/> </property> <property name="sqlMapClientProperties"> <props> <prop key="jdbcDriver">${java.mysql.driver}</prop> </props> </property> <property name="configLocation"> <value>ibatis/SqlConfig-ibatis.xml</value> </property> <property name="lobHandler"> <ref bean="mysqlLobHandler" /> </property> </bean> <!-- modify 100323 to mysql 使用spring+ibatis处理oracle LOB --> <bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor" /> <bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" > <property name="nativeJdbcExtractor"> <ref bean="nativeJdbcExtractor" /> </property> </bean> <!-- 完毕 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource"> <ref local="dataSource"/> </property> </bean> <bean id="baseTransactionProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true"> <property name="transactionManager"> <ref bean="transactionManager"/> </property> <property name="transactionAttributes"> <props> <prop key="*">PROPAGATION_REQUIRED</prop> </props> </property> </bean> <!-- dao类相关 --> <bean id="teacherDAO" class="com.yjpeng.springibatis.dao.TeacherDAOImpl"> <property name="sqlMapClient"> <ref bean="sqlMapClient"/> </property> </bean> </beans>

TeacherDao.java文件内容

package com.yjpeng.springibatis.dao; import java.util.List; import com.yjpeng.ibatis.model.Teacher; public interface TeacherDAO { List<Teacher> getTeacherList(); }

TeacherDAOImpl.java文件内容

import java.io.Reader; import java.sql.SQLException; import java.util.List; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; import com.yjpeng.ibatis.model.Teacher; public class TeacherDAOImpl extends SqlMapClientDaoSupport implements TeacherDAO { public List<Teacher> getTeacherList() { List<Teacher> list = getSqlMapClientTemplate().queryForList("teacher_getTeacherList", null); return list; } public static void main(String[] args) { ApplicationContext context = new ClassPathXmlApplicationContext("spring/spring-context.xml"); try{ TeacherDAO teacherDAO = (TeacherDAO) context.getBean("teacherDAO"); List<Teacher> list = teacherDAO.getTeacherList(); System.out.println(list.size()); }catch (Exception e) { e.printStackTrace(); } } }

运行TeacherDAOImpl就可以出结果了，一个简单的ibatis跟Spring结合的实例就Ok了。