spring编程式事物

spring配置文件：

<?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;
            }
        });


    }
}