Spring与Ibatis整合

最近公司需要一个持久层框架，让我做research，由于各方面的经验不是很充足，于是上网找到了三个持久层框架， JdbcTemplate, Ibatis， Hibernate， 经过三天的时间终于把这三个框架给整合起来，接下来就要结合公司的环境分析三个框架的利弊

首先是整合Ibatis

 

《！------------------------------IbatisApplicationContext.xml-------------------Sping的配置

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="DataIndexDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="com.mysql.jdbc.Driver"/> <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/ycc?useUnicode=true&characterEncoding=utf8" /> <property name="user" value="root" /> <property name="password" value="root"/> </bean> <bean id="DataIndexSqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation" value="classpath:DataIndexSqlMapConfig.xml" /> <property name="dataSource" ref="DataIndexDataSource" /> </bean> <bean id="DataIndexSqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate"> <property name="sqlMapClient" ref="DataIndexSqlMapClient" /> </bean> </beans> 

 

 

《！-----------------------------DataIndexSqlMapConfig.xml-------------------------Ibatis的配置

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <sqlMap resource="Student.xml"/> </sqlMapConfig>  

 

《！---------------------------Student.xml-----------------------------------------------实体类对SQl的配置

<?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> <insert id="insertSecurity"> insert into student(name,sex) values(#name#, #sex#); </insert> <select id="getSecurity" resultClass="java.util.HashMap" remapResults="true"> select * from student </select> </sqlMap> 

 

《！--------------------------BaseDao.java-----------------------------------------------

package com.ms.ibatis; import org.springframework.beans.BeansException; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.orm.ibatis.SqlMapClientTemplate; import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; import com.ms.exception.DBException; public class BaseDao extends SqlMapClientDaoSupport { public static ApplicationContext factory; public static final String DataIndex = "DataIndexSqlMapClientTemplate"; static { try { factory = new ClassPathXmlApplicationContext("IbatisApplicationContext.xml"); } catch (BeansException e) { throw new DBException(e.getMessage(), e); } } private BaseDao(){} public BaseDao(String dbName){ SqlMapClientTemplate template = (SqlMapClientTemplate) factory.getBean(dbName); this.setSqlMapClientTemplate(template); } }  

《！------------------------DataIndexDao.java---------------------------------------------

 

package com.ms.ibatis; import java.sql.SQLException; import java.util.HashMap; import java.util.List; import java.util.Map; import com.ibatis.sqlmap.client.event.RowHandler; public class DataIndexDao extends BaseDao { public DataIndexDao(){ super(BaseDao.DataIndex); } public void queryInsert() throws SQLException{ Map m = new HashMap(); m.put("name", "haha"); m.put("sex", "1"); getSqlMapClient().insert("insertSecurity", m); } public void querySelect() throws SQLException{ List<Map> l = (List<Map>)getSqlMapClient().queryForList("getSecurity"); System.out.println(l.size()); } /** * public interface RowHandler( * void handleRow(object valueObject); * ) * 作用: 允许你在某个已映射语句的结构集的处理中插入自己的动作 * @throws SQLException */ public void querySelect2() throws SQLException{ getSqlMapClient().queryWithRowHandler("getSecurity", new RowHandler(){ public void handleRow(Object valueObject) { System.out.println(((HashMap)valueObject).get("name")); } }); } public static void main(String[] args) throws SQLException{ //new DataIndexDao().queryInsert(); new DataIndexDao().querySelect(); new DataIndexDao().querySelect2(); } }