spring2.5整合ibatis

SqlMapClient对象

这个对象是iBatis操作数据库的接口（执行CRUD等操作），它也可以执行事务管理等操作。这个类是我们使用iBATIS的最主要的类。

tomcat下的数据源配置信息，，awp.xml

<?xml version="1.0" encoding="UTF-8"?><Context docBase="awp" path="/awp" reloadable="false"><!–tomcat管理数据库连接–><Resourceauth="Container"name="jdbc/awpiq"type="javax.sql.DataSource"password="Awp1234561"driverClassName="com.sybase.jdbc3.jdbc.SybDriver"maxIdle="2"maxWait="5000"username="awp"url="jdbc:sybase:Tds:10.112.7.19:2638/awp-AWP"maxActive="10"/></Context>

application.xml

<?xml version="1.0" encoding="UTF-8"?>w<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN"""><beans><bean id="IqDataSource"class="org.springframework.jndi.JndiObjectFactoryBean"><property name="jndiName"><value>java:comp/env/jdbc/awpiq</value></property></bean><bean id="sqlMap_iqClient"class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"><property name="configLocation"><value>SqlMapIqConfig.xml</value> </property><property name="transactionConfigClass"ref="transactionConfigClass" /><property name="dataSource" ref="IqDataSource" /></bean><bean id="transactionConfigClass" class="java.lang.Class"factory-method="forName"><constructor-arg index="0"value="com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransactionConfig" /></bean></beans>

DefaultSqlMap.java

package com.bank.common;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class DefaultSqlMap {public static ApplicationContext context = null;static{ context=new ClassPathXmlApplicationContext(new String[]{"applicationContext-Iq.xml"}); }}

SqlMapIqFactory.java

package com.bank.common;import com.ibatis.sqlmap.client.SqlMapClient;public class SqlMapIqFactory extends DefaultSqlMap{private static SqlMapClient sqlMap = null;static{sqlMap=(SqlMapClient) context.getBean("sqlMap_iqClient"); }public static SqlMapClient getSqlMapInstance(){return sqlMap; } }SqlMapIqConfig.xml<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"""><sqlMapConfig><sqlMap resource="com/foo/maps/user.xml"/></sqlMapConfig>UserDAOImpl.javaimport org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; public class UserDAOImpl extends SqlMapClientDaoSupport{ }spring管理bean dao<bean id="userDao" class="com.foo.dao.UserDAOImpl"><property name="sqlMapClient" ref="sqlMapClient"/> <!– 装配SqlMapClientFactoryBean –> </bean>

而这些目标凝结成希望的萌芽，在汗水与泪水浇灌下，绽放成功之花。