Spring集成Ibatis详细介绍

Spring集成Ibatis

    对于spring集成ibatis，主要用到spring提供的一个重要的类

“org.springframework.orm.ibatis.SqlMapClientFactoryBean”。这个类是两者集成的接口。本来在ibatis中要配置的数据源，事物管理现在都交给spring来做就可以了。

    以下是两者集成的图示：

具体结构图如下：

具体代码如下：

【person.java】

public class Person {
	private String id;
	private String name;
	private int num;
	private Date birthday;

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getNum() {
		return num;
	}

	public void setNum(int num) {
		this.num = num;
	}

	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

}

【SIImpl.java】

public class SIImpl extends SqlMapClientDaoSupport implements SI {

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.cll.si.dao.SI#insert(com.cll.si.model.Person)
	 */
	@Override
	public void insert(Person person) {
		getSqlMapClientTemplate().insert("sql_insert", person);
	}
	/*
	 * dao类一般都继承SqlMapClientDaoSupport类，用它提供的getSqlMapClientTemplate()方法
	 * 类对数据库进行相应的操作。
	 * */
}

【SI.java】

public interface SI {

	public abstract void insert(Person person);

}

【SIImpl.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>
	<typeAlias alias="person" type="com.cll.si.model.Person" />

	<!-- 第一个 -->
	<update id="sql_insert" parameterClass="person">
		insert into
			STUDENT(id,name,num,birthday)
		values
		(
			#id#,
			#name#,
			#num#,
			#birthday#
		)
	</update>
</sqlMap>

【ApplicationContext.xml】

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
		http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.1.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd">

	<!-- 加载这个路径下的配置文件 -->
	<context:property-placeholder location="classpath:c3p0.properties" />

	<!-- 加载这个路径下的配置文件 <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> 
		<property name="location" value="classpath:c3p0.properties"></property> </bean> -->

	<!-- 配置dataSource -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<!-- 用户名 -->
		<property name="user" value="${jdbc.username}" />
		<!-- 用户密码 -->
		<property name="password" value="${jdbc.password}" />
		<property name="driverClass" value="${jdbc.driverClass}" />
		<property name="jdbcUrl" value="${jdbc.jdbcUrl}" />

		<!--连接池中保留的最大连接数。默认值: 15 -->
		<property name="maxPoolSize" value="20" />
		<!-- 连接池中保留的最小连接数，默认为：3 -->
		<property name="minPoolSize" value="2" />
		<!-- 初始化连接池中的连接数，取值应在minPoolSize与maxPoolSize之间，默认为3 -->
		<property name="initialPoolSize" value="2" />

		<!--最大空闲时间，60秒内未使用则连接被丢弃。若为0则永不丢弃。默认值: 0 -->
		<property name="maxIdleTime" value="60"></property>

		<!-- 当连接池连接耗尽时，客户端调用getConnection()后等待获取新连接的时间，超时后将抛出SQLException，如设为0则无限期等待。单位毫秒。默认: 
			0 -->
		<property name="checkoutTimeout" value="3000" />

		<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。默认值: 3 -->
		<property name="acquireIncrement" value="2" />

		<!--定义在从数据库获取新连接失败后重复尝试的次数。默认值: 30 ；小于等于0表示无限次 -->
		<property name="acquireRetryAttempts" value="0" />

		<!--重新尝试的时间间隔，默认为：1000毫秒 -->
		<property name="acquireRetryDelay" value="1000" />

		<!--关闭连接时，是否提交未提交的事务，默认为false，即关闭连接，回滚未提交的事务 -->
		<property name="autoCommitOnClose" value="false"></property>

		<!--c3p0将建一张名为Test的空表，并使用其自带的查询语句进行测试。如果定义了这个参数那么属性preferredTestQuery将被忽略。你不能在这张Test表上进行任何操作，它将只供c3p0测试使用。默认值: 
			null -->
		<property name="automaticTestTable" value="Test"></property>

		<!--如果为false，则获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常，但是数据源仍有效保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试获取连接失败后该数据源将申明已断开并永久关闭。默认: 
			false -->
		<property name="breakAfterAcquireFailure" value="false"></property>

		<!--每60秒检查所有连接池中的空闲连接。默认值: 0，不检查 -->
		<property name="idleConnectionTestPeriod" value="60"></property>
		<!--c3p0全局的PreparedStatements缓存的大小。如果maxStatements与maxStatementsPerConnection均为0，则缓存不生效，只要有一个不为0，则语句的缓存就能生效。如果默认值: 
			0 -->
		<property name="maxStatements" value="100"></property>
		<!--maxStatementsPerConnection定义了连接池内单个连接所拥有的最大缓存statements数。默认值: 0 -->
		<property name="maxStatementsPerConnection" value="0"></property>
	</bean>

	<!-- spring整合ibatis -->
	<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
		<!-- name="configLocation"固定写法 -->
		<property name="configLocation">
			<value>classpath:SqlMapConfig.xml</value>
		</property>
		<!-- name="dataSource"固定写法 -->
		<property name="dataSource">
			<ref local="dataSource" />
		</property>
	</bean>

	<!-- spring-dao-service -->
	<bean id="siImpl" class="com.cll.si.dao.SIImpl">
		<!-- sqlMapClient必需 -->
		<property name="sqlMapClient">
			<ref local="sqlMapClient" />
		</property>
	</bean>

</beans>

【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>
	<!--是否启用缓存机制,是否启用延迟加载机制 ,是否启用字节码增强机制,是否启用错误处理机制,最大并发请求数,最大Session数, 最大并发事务数,是否启用名称空间 -->
	<settings cacheModelsEnabled="true" lazyLoadingEnabled="true"
		enhancementEnabled="true" errorTracingEnabled="true" maxRequests="32"
		maxSessions="10" maxTransactions="5" useStatementNamespaces="true" />

	<!-- 将xml配置文件加入进来 -->
	<sqlMap resource="com/cll/si/dao/SIImpl.xml" />
</sqlMapConfig>

【c3p0.properties】

jdbc.driverClass=oracle.jdbc.driver.OracleDriver
jdbc.jdbcUrl=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.username=crown
jdbc.password=orcl

#\u8FDE\u63A5\u6C60\u4E2D\u4FDD\u7559\u7684\u6700\u5927\u8FDE\u63A5\u6570\u3002\u9ED8\u8BA4\u503C: 15
maxPoolSize=20
#\u8FDE\u63A5\u6C60\u4E2D\u4FDD\u7559\u7684\u6700\u5C0F\u8FDE\u63A5\u6570\uFF0C\u9ED8\u8BA4\u4E3A\uFF1A3
minPoolSize=2
#\u521D\u59CB\u5316\u8FDE\u63A5\u6C60\u4E2D\u7684\u8FDE\u63A5\u6570\uFF0C\u53D6\u503C\u5E94\u5728minPoolSize\u4E0EmaxPoolSize\u4E4B\u95F4\uFF0C\u9ED8\u8BA4\u4E3A3
initialPoolSize=2

#\u6700\u5927\u7A7A\u95F2\u65F6\u95F4\uFF0C60\u79D2\u5185\u672A\u4F7F\u7528\u5219\u8FDE\u63A5\u88AB\u4E22\u5F03\u3002\u82E5\u4E3A0\u5219\u6C38\u4E0D\u4E22\u5F03\u3002\u9ED8\u8BA4\u503C: 0
maxIdleTime=60

#\u5F53\u8FDE\u63A5\u6C60\u8FDE\u63A5\u8017\u5C3D\u65F6\uFF0C\u5BA2\u6237\u7AEF\u8C03\u7528getConnection()\u540E\u7B49\u5F85\u83B7\u53D6\u65B0\u8FDE\u63A5\u7684\u65F6\u95F4\uFF0C\u8D85\u65F6\u540E\u5C06\u629B\u51FASQLException\uFF0C\u5982\u8BBE\u4E3A0\u5219\u65E0\u9650\u671F\u7B49\u5F85\u3002\u5355\u4F4D\u6BEB\u79D2\u3002\u9ED8\u8BA4: 0 
checkoutTimeout=3000

#\u5F53\u8FDE\u63A5\u6C60\u4E2D\u7684\u8FDE\u63A5\u8017\u5C3D\u7684\u65F6\u5019c3p0\u4E00\u6B21\u540C\u65F6\u83B7\u53D6\u7684\u8FDE\u63A5\u6570\u3002\u9ED8\u8BA4\u503C: 3
acquireIncrement=2

#\u5B9A\u4E49\u5728\u4ECE\u6570\u636E\u5E93\u83B7\u53D6\u65B0\u8FDE\u63A5\u5931\u8D25\u540E\u91CD\u590D\u5C1D\u8BD5\u7684\u6B21\u6570\u3002\u9ED8\u8BA4\u503C: 30 \uFF1B\u5C0F\u4E8E\u7B49\u4E8E0\u8868\u793A\u65E0\u9650\u6B21
acquireRetryAttempts=0

#\u91CD\u65B0\u5C1D\u8BD5\u7684\u65F6\u95F4\u95F4\u9694\uFF0C\u9ED8\u8BA4\u4E3A\uFF1A1000\u6BEB\u79D2
acquireRetryDelay=1000

#\u5173\u95ED\u8FDE\u63A5\u65F6\uFF0C\u662F\u5426\u63D0\u4EA4\u672A\u63D0\u4EA4\u7684\u4E8B\u52A1\uFF0C\u9ED8\u8BA4\u4E3Afalse\uFF0C\u5373\u5173\u95ED\u8FDE\u63A5\uFF0C\u56DE\u6EDA\u672A\u63D0\u4EA4\u7684\u4E8B\u52A1
autoCommitOnClose=false

#c3p0\u5C06\u5EFA\u4E00\u5F20\u540D\u4E3ATest\u7684\u7A7A\u8868\uFF0C\u5E76\u4F7F\u7528\u5176\u81EA\u5E26\u7684\u67E5\u8BE2\u8BED\u53E5\u8FDB\u884C\u6D4B\u8BD5\u3002\u5982\u679C\u5B9A\u4E49\u4E86\u8FD9\u4E2A\u53C2\u6570\u90A3\u4E48\u5C5E\u6027preferredTestQuery\u5C06\u88AB\u5FFD\u7565\u3002\u4F60\u4E0D\u80FD\u5728\u8FD9\u5F20Test\u8868\u4E0A\u8FDB\u884C\u4EFB\u4F55\u64CD\u4F5C\uFF0C\u5B83\u5C06\u53EA\u4F9Bc3p0\u6D4B\u8BD5\u4F7F\u7528\u3002\u9ED8\u8BA4\u503C:
automaticTestTable=Test

#\u5982\u679C\u4E3Afalse\uFF0C\u5219\u83B7\u53D6\u8FDE\u63A5\u5931\u8D25\u5C06\u4F1A\u5F15\u8D77\u6240\u6709\u7B49\u5F85\u8FDE\u63A5\u6C60\u6765\u83B7\u53D6\u8FDE\u63A5\u7684\u7EBF\u7A0B\u629B\u51FA\u5F02\u5E38\uFF0C\u4F46\u662F\u6570\u636E\u6E90\u4ECD\u6709\u6548\u4FDD\u7559\uFF0C\u5E76\u5728\u4E0B\u6B21\u8C03\u7528getConnection()\u7684\u65F6\u5019\u7EE7\u7EED\u5C1D\u8BD5\u83B7\u53D6\u8FDE\u63A5\u3002\u5982\u679C\u8BBE\u4E3Atrue\uFF0C\u90A3\u4E48\u5728\u5C1D\u8BD5\u83B7\u53D6\u8FDE\u63A5\u5931\u8D25\u540E\u8BE5\u6570\u636E\u6E90\u5C06\u7533\u660E\u5DF2\u65AD\u5F00\u5E76\u6C38\u4E45\u5173\u95ED\u3002\u9ED8\u8BA4: false
breakAfterAcquireFailure=false

#\u6BCF60\u79D2\u68C0\u67E5\u6240\u6709\u8FDE\u63A5\u6C60\u4E2D\u7684\u7A7A\u95F2\u8FDE\u63A5\u3002\u9ED8\u8BA4\u503C: 0\uFF0C\u4E0D\u68C0\u67E5
idleConnectionTestPeriod=60
#c3p0\u5168\u5C40\u7684PreparedStatements\u7F13\u5B58\u7684\u5927\u5C0F\u3002\u5982\u679CmaxStatements\u4E0EmaxStatementsPerConnection\u5747\u4E3A0\uFF0C\u5219\u7F13\u5B58\u4E0D\u751F\u6548\uFF0C\u53EA\u8981\u6709\u4E00\u4E2A\u4E0D\u4E3A0\uFF0C\u5219\u8BED\u53E5\u7684\u7F13\u5B58\u5C31\u80FD\u751F\u6548\u3002\u5982\u679C\u9ED8\u8BA4\u503C: 0
maxStatements=100
#maxStatementsPerConnection\u5B9A\u4E49\u4E86\u8FDE\u63A5\u6C60\u5185\u5355\u4E2A\u8FDE\u63A5\u6240\u62E5\u6709\u7684\u6700\u5927\u7F13\u5B58statements\u6570\u3002\u9ED8\u8BA4\u503C: 0
maxStatementsPerConnection=0

【web.xml】

<!-- 配置spring的监听器 -->
  <!-- needed for ContextLoaderListener -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:ApplicationContext.xml</param-value>
	</context-param>

	<!-- Bootstraps the root web application context before servlet initialization -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

最后附上DAO层和 Service层的rose设计图：

最后附上DAO层和 Service层的rose设计图：