ibatis3整合spring

因为ibatis3现在还是测试版，spring也没有出相应的整合。所以，我根据spring整合hibernate的原理，也出来show一下，高手就不要笑我了。开工

主要是的文件有:
Ibatis3SessionFactory.java 这个是由spring读取ibatis配置文件，并产生sessionFactory工厂的

Ibatis3DaoSupport.java 我们的dao主要继承它了，因为它有一个模板类，定义了许多方法.

IBatis3DaoTemplate.java 不是上面的说的模板类

SqlSessionCallback.java 回调方法。

一 . 我们先来看一下Ibatis3SessionFactory.java

Java代码
package com.ibatis3;

import java.io.IOException;
import java.io.Reader;

import javax.sql.DataSource;

import org.apache.ibatis.builder.xml.XMLConfigBuilder;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.defaults.DefaultSqlSessionFactory;
import org.apache.ibatis.transaction.managed.ManagedTransactionFactory;
import org.springframework.beans.factory.FactoryBean;
import org.springframework.beans.factory.InitializingBean;
import org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy;
/*
* session工厂类
*/
public class Ibatis3SessionFactory implements FactoryBean, InitializingBean {
private String configLocation;

private DataSource dataSource;

private SqlSessionFactory sqlSessionFactory;

private boolean useTransactionAwareDataSource = true;

private String environmentId = "development";

public void setEnvironmentId(String environmentId) {
this.environmentId = environmentId;
}

public void setUseTransactionAwareDataSource(
boolean useTransactionAwareDataSource) {
this.useTransactionAwareDataSource = useTransactionAwareDataSource;
}

public Object getObject() throws Exception {
return this.sqlSessionFactory;
}

public Class getObjectType() {
return (this.sqlSessionFactory != null ? this.sqlSessionFactory
.getClass() : SqlSessionFactory.class);
}

public boolean isSingleton() {
return true;
}

public void afterPropertiesSet() throws Exception {
this.sqlSessionFactory = this.buildSqlSessionFactory(configLocation);
}
protected SqlSessionFactory buildSqlSessionFactory(String configLocation)
throws IOException {
if (configLocation == null) {
throw new IllegalArgumentException(
"configLocation entry is required");
}
DataSource dataSourceToUse = this.dataSource;
if (this.useTransactionAwareDataSource
&& !(this.dataSource instanceof TransactionAwareDataSourceProxy)) {
dataSourceToUse = new TransactionAwareDataSourceProxy(
this.dataSource);
}

Environment environment = new Environment(environmentId,
new ManagedTransactionFactory(), dataSourceToUse);

Reader reader = Resources.getResourceAsReader(configLocation);
XMLConfigBuilder parser = new XMLConfigBuilder(reader, null, null);
Configuration config = parser.parse();
config.setEnvironment(environment);

return new DefaultSqlSessionFactory(config);
}

public DataSource getDataSource() {
return dataSource;
}

public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}

public void setConfigLocation(String configLocation) {
this.configLocation = configLocation;
}
}
package com.ibatis3;

import java.io.IOException;
import java.io.Reader;

import javax.sql.DataSource;

import org.apache.ibatis.builder.xml.XMLConfigBuilder;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.defaults.DefaultSqlSessionFactory;
import org.apache.ibatis.transaction.managed.ManagedTransactionFactory;
import org.springframework.beans.factory.FactoryBean;
import org.springframework.beans.factory.InitializingBean;
import org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy;
/*
* session工厂类
*/
public class Ibatis3SessionFactory implements FactoryBean, InitializingBean {
private String configLocation;

private DataSource dataSource;

private SqlSessionFactory sqlSessionFactory;

private boolean useTransactionAwareDataSource = true;

private String environmentId = "development";

public void setEnvironmentId(String environmentId) {
this.environmentId = environmentId;
}

public void setUseTransactionAwareDataSource(
boolean useTransactionAwareDataSource) {
this.useTransactionAwareDataSource = useTransactionAwareDataSource;
}

public Object getObject() throws Exception {
return this.sqlSessionFactory;
}

public Class getObjectType() {
return (this.sqlSessionFactory != null ? this.sqlSessionFactory
.getClass() : SqlSessionFactory.class);
}

public boolean isSingleton() {
return true;
}

public void afterPropertiesSet() throws Exception {
this.sqlSessionFactory = this.buildSqlSessionFactory(configLocation);
}
protected SqlSessionFactory buildSqlSessionFactory(String configLocation)
throws IOException {
if (configLocation == null) {
throw new IllegalArgumentException(
"configLocation entry is required");
}
DataSource dataSourceToUse = this.dataSource;
if (this.useTransactionAwareDataSource
&& !(this.dataSource instanceof TransactionAwareDataSourceProxy)) {
dataSourceToUse = new TransactionAwareDataSourceProxy(
this.dataSource);
}

Environment environment = new Environment(environmentId,
new ManagedTransactionFactory(), dataSourceToUse);

Reader reader = Resources.getResourceAsReader(configLocation);
XMLConfigBuilder parser = new XMLConfigBuilder(reader, null, null);
Configuration config = parser.parse();
config.setEnvironment(environment);

return new DefaultSqlSessionFactory(config);
}

public DataSource getDataSource() {
return dataSource;
}

public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}

public void setConfigLocation(String configLocation) {
this.configLocation = configLocation;
}
}

上面代码也借鉴了网络上部分代码，因为转来转去，也不知谁是原创。

二. 下面是最简单的回调函数:

Java代码
package com.ibatis3;

import org.apache.ibatis.session.SqlSession;

public interface SqlSessionCallback {
public Object doInSqlSession(SqlSession session);
}
package com.ibatis3;

import org.apache.ibatis.session.SqlSession;

public interface SqlSessionCallback {
public Object doInSqlSession(SqlSession session);
}

三.模板类

Java代码
package com.ibatis3;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import javax.sql.DataSource;

import org.apache.ibatis.session.ResultHandler;
import org.apache.ibatis.session.RowBounds;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.taglibs.standard.tag.common.sql.DataSourceUtil;
import org.springframework.jdbc.datasource.DataSourceUtils;
import org.springframework.jdbc.support.JdbcAccessor;
import org.springframework.transaction.support.TransactionSynchronizationManager;

public class IBatis3DaoTemplate extends JdbcAccessor {
private SqlSessionFactory sessionFactory;

public IBatis3DaoTemplate(SqlSessionFactory factory) {
this.sessionFactory = factory;
}

public SqlSession openSession() {
SqlSession session = (SqlSession) TransactionSynchronizationManager
.getResource(sessionFactory);
if (session == null) {
session = sessionFactory.openSession();
}
return session;
}

public void setSessionFactory(SqlSessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}

public List executeFind(SqlSessionCallback callback) {
return (List) execute(callback);
}

public Object execute(SqlSessionCallback callback) {

SqlSession session = openSession();

Object obj = callback.doInSqlSession(session);
if (session != null)
session.close();

return obj;
}

// 删除,根据语句
public int delete(final String statement) {
return delete(statement, null);
}

// 删除，根据语句，带条件
public int delete(final String statement, final Object param) {
return (Integer) execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.delete(statement, param);
else
return session.delete(statement);
}
});
}

// 修改带条件
public int update(final String statement, final Object param) {
return (Integer) execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.update(statement, param);
else
return session.update(statement);
}
});
}

// 修改不带条件
public int update(final String statement) {
return update(statement, null);
}

// 增加带条件
public int insert(final String statement, final Object param) {
return (Integer) execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.insert(statement, param);
else
return session.insert(statement);
}
});
}

// 增加不带条件
public int insert(final String statement) {
return insert(statement, null);
}

// 查询分页
public List selectList(final String statement, final Object param,
final RowBounds bounds) {
return executeFind(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (statement == null)
throw new IllegalArgumentException(
"Sql 'statement' require");
if (bounds != null && param != null)
return session.selectList(statement, param, bounds);
else if (bounds!=null)
return session.selectList(statement, null, bounds);
else if (param != null) {
return session.selectList(statement, param);
}

else
return session.selectList(statement);

}
});
}

// 条件分页
public List selectList(final String statement, final Object param,
int skip, int limit) {
return selectList(statement, param, new RowBounds(skip, limit));
}

// 查询不分页
public List selectList(final String statement, final Object param) {
return selectList(statement, param, null);
}

// 查询不带条件
public List selectList(final String statement) {
return selectList(statement, null);
}

// 条件查带处理查询结果,带分页
public void select(final String statement, final Object param,
final RowBounds bounds, final ResultHandler handler) {
if (statement == null || handler == null)
throw new IllegalArgumentException(
"'statement' and 'handler' require");

execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (handler != null && bounds != null && param != null)
session.select(statement, param, bounds, handler);
else if (bounds == null)
session.select(statement, param, handler);

return null;
}
});
}

// 自己处理查询结果 ，不带分页
public void select(final String statement, final Object param,
final ResultHandler handler) {
select(statement, param, null, handler);
}

// 查唯一结果
public Object selectOne(final String statement) {
return selectOne(statement, null);
}

// 查唯一结果带条件
public Object selectOne(final String statement, final Object param) {
if (statement == null)
throw new IllegalArgumentException("Sql 'statement' require");
return execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.selectOne(statement, param);
else
return session.selectOne(statement);

}
});
}

}
package com.ibatis3;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import javax.sql.DataSource;

import org.apache.ibatis.session.ResultHandler;
import org.apache.ibatis.session.RowBounds;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.taglibs.standard.tag.common.sql.DataSourceUtil;
import org.springframework.jdbc.datasource.DataSourceUtils;
import org.springframework.jdbc.support.JdbcAccessor;
import org.springframework.transaction.support.TransactionSynchronizationManager;

public class IBatis3DaoTemplate extends JdbcAccessor {
private SqlSessionFactory sessionFactory;

public IBatis3DaoTemplate(SqlSessionFactory factory) {
this.sessionFactory = factory;
}

public SqlSession openSession() {
SqlSession session = (SqlSession) TransactionSynchronizationManager
.getResource(sessionFactory);
if (session == null) {
session = sessionFactory.openSession();
}
return session;
}

public void setSessionFactory(SqlSessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}

public List executeFind(SqlSessionCallback callback) {
return (List) execute(callback);
}

public Object execute(SqlSessionCallback callback) {

SqlSession session = openSession();

Object obj = callback.doInSqlSession(session);
if (session != null)
session.close();

return obj;
}

// 删除,根据语句
public int delete(final String statement) {
return delete(statement, null);
}

// 删除，根据语句，带条件
public int delete(final String statement, final Object param) {
return (Integer) execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.delete(statement, param);
else
return session.delete(statement);
}
});
}

// 修改带条件
public int update(final String statement, final Object param) {
return (Integer) execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.update(statement, param);
else
return session.update(statement);
}
});
}

// 修改不带条件
public int update(final String statement) {
return update(statement, null);
}

// 增加带条件
public int insert(final String statement, final Object param) {
return (Integer) execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.insert(statement, param);
else
return session.insert(statement);
}
});
}

// 增加不带条件
public int insert(final String statement) {
return insert(statement, null);
}

// 查询分页
public List selectList(final String statement, final Object param,
final RowBounds bounds) {
return executeFind(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (statement == null)
throw new IllegalArgumentException(
"Sql 'statement' require");
if (bounds != null && param != null)
return session.selectList(statement, param, bounds);
else if (bounds!=null)
return session.selectList(statement, null, bounds);
else if (param != null) {
return session.selectList(statement, param);
}

else
return session.selectList(statement);

}
});
}

// 条件分页
public List selectList(final String statement, final Object param,
int skip, int limit) {
return selectList(statement, param, new RowBounds(skip, limit));
}

// 查询不分页
public List selectList(final String statement, final Object param) {
return selectList(statement, param, null);
}

// 查询不带条件
public List selectList(final String statement) {
return selectList(statement, null);
}

// 条件查带处理查询结果,带分页
public void select(final String statement, final Object param,
final RowBounds bounds, final ResultHandler handler) {
if (statement == null || handler == null)
throw new IllegalArgumentException(
"'statement' and 'handler' require");

execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (handler != null && bounds != null && param != null)
session.select(statement, param, bounds, handler);
else if (bounds == null)
session.select(statement, param, handler);

return null;
}
});
}

// 自己处理查询结果 ，不带分页
public void select(final String statement, final Object param,
final ResultHandler handler) {
select(statement, param, null, handler);
}

// 查唯一结果
public Object selectOne(final String statement) {
return selectOne(statement, null);
}

// 查唯一结果带条件
public Object selectOne(final String statement, final Object param) {
if (statement == null)
throw new IllegalArgumentException("Sql 'statement' require");
return execute(new SqlSessionCallback() {

public Object doInSqlSession(SqlSession session) {
if (param != null)
return session.selectOne(statement, param);
else
return session.selectOne(statement);

}
});
}

}

四.Ibatis3DaoSupport支持类

Java代码
package com.ibatis3;

import org.springframework.dao.support.DaoSupport;

import org.springframework.transaction.support.TransactionSynchronizationManager;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSession;

import javax.sql.DataSource;
/*
* Dao类
* 主要接收传入的sessionFactory
* 取得模板
*/
public class Ibatis3DaoSupport extends DaoSupport {
private SqlSessionFactory sessionFactory;
private IBatis3DaoTemplate template;

public void createTemplate(){
this.template = new IBatis3DaoTemplate(sessionFactory);
}

public IBatis3DaoTemplate getTemplate() {
//System.out.println(template);
return template;
}

public void setTemplate(IBatis3DaoTemplate template) {
this.template = template;
}

//创建或得到session
public SqlSession openSession() {

SqlSession session = (SqlSession) TransactionSynchronizationManager
.getResource(sessionFactory);
if (session == null) {
session = sessionFactory.openSession();
}

return session;
}

public SqlSessionFactory getSessionFactory() {
return sessionFactory;
}

public void setSessionFactory(SqlSessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
this.template = new IBatis3DaoTemplate(sessionFactory);

}


@Override
protected void checkDaoConfig() throws IllegalArgumentException {

if (sessionFactory == null) {
throw new IllegalArgumentException(
"Property 'sessionFactory' or 'template' is required");
}

}

}
package com.ibatis3;

import org.springframework.dao.support.DaoSupport;

import org.springframework.transaction.support.TransactionSynchronizationManager;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSession;

import javax.sql.DataSource;
/*
* Dao类
* 主要接收传入的sessionFactory
* 取得模板
*/
public class Ibatis3DaoSupport extends DaoSupport {
private SqlSessionFactory sessionFactory;
private IBatis3DaoTemplate template;

public void createTemplate(){
this.template = new IBatis3DaoTemplate(sessionFactory);
}

public IBatis3DaoTemplate getTemplate() {
//System.out.println(template);
return template;
}

public void setTemplate(IBatis3DaoTemplate template) {
this.template = template;
}

//创建或得到session
public SqlSession openSession() {

SqlSession session = (SqlSession) TransactionSynchronizationManager
.getResource(sessionFactory);
if (session == null) {
session = sessionFactory.openSession();
}

return session;
}

public SqlSessionFactory getSessionFactory() {
return sessionFactory;
}

public void setSessionFactory(SqlSessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
this.template = new IBatis3DaoTemplate(sessionFactory);

}

@Override
protected void checkDaoConfig() throws IllegalArgumentException {

if (sessionFactory == null) {
throw new IllegalArgumentException(
"Property 'sessionFactory' or 'template' is required");
}

}

}

五.ibatis配置文件,我放在src下面

Java代码
<?xml version="1.0" encoding="UTF-8"?>
;!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">

;configuration>
<mappers>
<mapper resource="com/pojos/Dep.xml"/>
</mappers>
;/configuration>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">

<configuration>
<mappers>
<mapper resource="com/pojos/Dep.xml"/>
</mappers>
</configuration>

很简单，就是装载些映射文件，其实可以sessionFactory中完成。

六. pojo类和映射文件就不贴出了，请看附件

七. spring的配置文件，用了声明式事务.

Java代码
<?xml version="1.0" encoding="UTF-8"?>

lt;beans xmlns="http://www.springframework.org/schema/beans"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
<!-- - - - - - - - Apache Dbcp Pool - - - - - - - -->
<bean id="datasource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<property name="username" value="scott" />
<property name="password" value="tiger" />
<property name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:ora92" />
</bean>

<!-- sqlMapClientSessionBean -->
<bean id="sessionFactory"
class="com.ibatis3.Ibatis3SessionFactory">
<property name="configLocation" value="sqlMapConfig.xml"></property>
<property name="dataSource" ref="datasource"></property>
</bean>

<!-- dao -->
<bean id="depDao" class="com.dao.DepDaoImpl">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>

<!-- - - - - - - spring Transaction Manager - - - - - - - -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="datasource" />
</bean>
<!-- - - - - - - spring Transaction Attribute - - - - - - - -->
<tx:advice id="transactionAdvice"
transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
<!--****** weave *********-->
<aop:config>
<aop:advisor advice-ref="transactionAdvice"
pointcut="execution(* com.test.*.*(..))" />
</aop:config>


lt;/beans>


<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
<!-- - - - - - - - Apache Dbcp Pool - - - - - - - -->
<bean id="datasource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<property name="username" value="scott" />
<property name="password" value="tiger" />
<property name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:ora92" />
</bean>

<!-- sqlMapClientSessionBean -->
<bean id="sessionFactory"
class="com.ibatis3.Ibatis3SessionFactory">
<property name="configLocation" value="sqlMapConfig.xml"></property>
<property name="dataSource" ref="datasource"></property>
</bean>

<!-- dao -->
<bean id="depDao" class="com.dao.DepDaoImpl">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>

<!-- - - - - - - spring Transaction Manager - - - - - - - -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="datasource" />
</bean>
<!-- - - - - - - spring Transaction Attribute - - - - - - - -->
<tx:advice id="transactionAdvice"
transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
<!--****** weave *********-->
<aop:config>
<aop:advisor advice-ref="transactionAdvice"
pointcut="execution(* com.test.*.*(..))" />
</aop:config>

</beans>

完整代码请下载下面附件，因本人水平有限，请勿用在生产环境：）

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/qqzhuyuehe/archive/2010/03/26/5419989.aspx