Spring之事务操作（配置文件）

UserDao.java

package helloworld.tx;

import org.springframework.jdbc.core.JdbcTemplate;

public class UserDao {

    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    //    实现添加操作
    public void add() {
        // 调用jdbcTemplate对象中的方法实现操作
        String sql = "insert into salary value(?,?)";
        // 表结构：name(varchar 20),salary(int 20)
        int rows = jdbcTemplate.update(sql, "Tom", 10000);
        System.out.println("插入行数：" + rows);
        rows = jdbcTemplate.update(sql, "Jerry", 10000);
        System.out.println("插入行数：" + rows);
    }

    //    减少
    public void reduce(String name,int num) {
        // 调用jdbcTemplate对象中的方法实现操作
        String sql = "update salary set salary = (salary - ?) where name= ?";
        // 表结构：name(varchar 20),salary(int 20)
        int rows = jdbcTemplate.update(sql, num, name);
        System.out.println("修改行数：" + rows);
    }

    //    增加
    public void increase(String name,int num) {
        // 调用jdbcTemplate对象中的方法实现操作
        String sql = "update salary set salary = (salary + ?) where name= ?";
        // 表结构：name(varchar 20),salary(int 20)
        int rows = jdbcTemplate.update(sql, num, name);
        System.out.println("修改行数：" + rows);
    }


}

 

UserSerivce.java

package helloworld.tx;

public class UserSerivce {
    private UserDao userDao;

    public void setUserDao(UserDao userDao) {
        this.userDao = userDao;
    }

    public void add(){
        userDao.add();
    }

//    工资调整
    public void updateAccount(){

        userDao.reduce("Tom",1000);

//        制造异常
//        int n = 100/0;

        userDao.increase("Jerry",1000);

    }

}

 

TestTX.java

package helloworld.tx;

import org.junit.Before;
import org.junit.Ignore;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

/*
* 事务操作举例
* */
public class TestTX {
    @Before
    public void beforeRun() {
        System.out.println("beforeRun");
    }

//    插入数据
    @Ignore
    @Test
    public void add() {
        ApplicationContext context =
                new ClassPathXmlApplicationContext("beans_tx.xml");
        UserSerivce userSerivce = (UserSerivce) context.getBean("userSerivce");
        userSerivce.add();
    }

    @Test
    public void update() {
        ApplicationContext context =
                new ClassPathXmlApplicationContext("beans_tx.xml");
        UserSerivce userSerivce = (UserSerivce) context.getBean("userSerivce");
        userSerivce.updateAccount();
    }

}

 

beans_tx.xml

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:contexnt="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-2.5.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<!--事务配置文件-->

    <!--配置c3p0连接池-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <!--注入属性-->
        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
        <property name="jdbcUrl" value="jdbc:mysql://192.168.184.130:3306/gxrdb"></property>
        <property name="user" value="root"></property>
        <property name="password" value="root"></property>
    </bean>

    
    <!-- 第一步、配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!-- 第二步、配置事务增强 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <!--做事务操作-->
        <tx:attributes>
            <!--事务操作的方法的匹配规则-->
            <!--name：方法名；propagation：隔离级别-->
            <tx:method name="update*" propagation="REQUIRED"/>
            <tx:method name="add"/>
        </tx:attributes>
    </tx:advice>
    <!-- 第三步、配置切面-->
    <aop:config>
        <!--切入点-->
        <!-- *表示任意方法；..表示任意参数-->
        <aop:pointcut id="pointcut1" expression="execution(* helloworld.tx.UserSerivce.*(..))"></aop:pointcut>
        <!--切面-->
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut1"></aop:advisor>
    </aop:config>


    <!--创建service对象，注入dao对象-->
    <bean id="userSerivce" class="helloworld.tx.UserSerivce">
        <property name="userDao" ref="userDao"></property>
    </bean>

    <!--创建DAO对象，注入JdbcTemplate对象-->
    <bean id="userDao" class="helloworld.tx.UserDao">
        <property name="jdbcTemplate" ref="jdbcTemplate"></property>
    </bean>

    <!--创建JdbcTemplate对象，注入连接池dataSource-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

</beans>