SqlMapClient对象
这个对象是iBatis操作数据库的接口(执行CRUD等操作),它也可以执行事务管理等操作。这个类是我们使用iBATIS的最主要的类。
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN"
"http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans>
<span style="white-space:pre"> </span><bean id="IqDataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/awpiq</value>
</property>
<span style="white-space:pre"> </span></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"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<sqlMap resource="com/foo/maps/user.xml"/>
</sqlMapConfig>UserDAOImpl.java
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
public class UserDAOImpl extends SqlMapClientDaoSupport{
}<bean id="userDao" class="com.foo.dao.UserDAOImpl"> <property name="sqlMapClient" ref="sqlMapClient"/> <!-- 装配SqlMapClientFactoryBean --> </bean>
原文:http://blog.csdn.net/u010081710/article/details/43673085