spring配置文件:
java测试代码:
<?xml version="1.0" encoding="GB2312"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://toolkit.alibaba-inc.com/dtd/spring/spring-beans.dtd">
<beans>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8" />
<property name="username" value="root" />
<property name="password" value="admin"/>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>
<bean id="transactionTemplate" class="org.springframework.transaction.support.TransactionTemplate">
<property name="transactionManager">
<ref local="transactionManager"/>
</property>
</bean>
<!-- ======================================================================== -->
<!-- iBatis SQL map定义 -->
<!-- ======================================================================== -->
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:com/igoolu/test/sqlmap-config.xml" />
<property name="sqlMapClientProperties">
<map>
<entry key="baseurl">
<bean class="com.alibaba.service.spring.support.GetResourceAsURL">
<property name="location" value="classpath:com/igoolu/test/sqlmap-config.xml"/>
<property name="parent" value="true"/>
</bean>
</entry>
</map>
</property>
</bean>
<bean id="queryDao" class="com.taobao.dw.dal.query.dao.ibatis.IbatisGenericDaoImpl">
<property name="sqlMapClient">
<ref bean="sqlMapClient" />
</property>
</bean>
</beans>
java测试代码:
import java.sql.SQLException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionTemplate;
import com.ibatis.sqlmap.client.SqlMapClient;
/**
* TODO Comment of MainTest
*
* @author summersun_ym
* @version $Id: MainTest.java 2010-11-26 下午11:48:37 $
*
*/
public class MainTest {
public ApplicationContext context = null;
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
MainTest test = new MainTest();
test.init();
test.test();
}
public void init() {
context = new ClassPathXmlApplicationContext("com/igoolu/test/spring-beans.xml");
}
public void test() throws SQLException {
TransactionTemplate transactionTemplate = (TransactionTemplate)context.getBean("transactionTemplate");
final SqlMapClient sqlMapClient = (SqlMapClient)context.getBean("sqlMapClient");
//final GenericDao queryDao = (GenericDao)context.getBean("queryDao");
/** 事物入口 */
transactionTemplate.execute(new TransactionCallback() {
/** 这里执行业务逻辑 */
public Object doInTransaction(TransactionStatus status) {
try {
sqlMapClient.insert("Test.insert_count"); //成功语句
sqlMapClient.insert("Test.insert_count11"); //失败语句
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
});
}
}