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.1java.mysql.port=3306java.mysql.url=jdbc/:mysql/://${java.mysql.server}/:${java.mysql.port}/${java.mysql.database}java.mysql.database=schooljava.mysql.username=rootjava.mysql.password=rootjava.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{TeacherDAOteacherDAO = (TeacherDAO) context.getBean("teacherDAO");List<Teacher> list = teacherDAO.getTeacherList();System.out.println(list.size());}catch (Exception e) {e.printStackTrace();}}}

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