【无标题】Spring中的事务管理 /事务的XML配置写法

@Repository
public class RoleDaoImp implements RoleDao{
    @Override
    public void del() {
        System.out.println("删除");
    }

    @Override
    public void add() {
        System.out.println("添加");
    }

    @Override
    public void transIn(Integer inid,Integer money) {
        String sql = "UPDATE user SET balance = balance+? WHERE uid = ?";
        jdbcTemplate.update(sql, money, inid);
    }

    private JdbcTemplate jdbcTemplate;
    @Autowired
    public void setDataSource(DataSource ds){
        this.jdbcTemplate = new JdbcTemplate(ds);
    }

    public void transOut(Integer outid,Integer money) {
        String sql = "UPDATE user SET balance = balance-? WHERE uid = ?";
        jdbcTemplate.update(sql, money, outid);
    }


}

service层

@Service
@Transactional
public class RoleServiceImp implements RoleService{
    @Autowired
    private RoleDao roleDao;
    public void trans(Integer outId, Integer inId,Integer money) {
        roleDao.transOut(outId, money);
        roleDao.transIn(inId,money);
    }

    @Transactional(readOnly = true)
    public void queryAll(){
        //TODO
    }
}

spring.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="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
       https://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
    <!--配置DI注解解析器-->
    <context:annotation-config/>
    <!--扫描包-->
    <context:component-scan base-package="cn.hp"/>
   <!--配置读取外部jdbc文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>

    <!--c3p0配置-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driverClass}"/>
        <property name="jdbcUrl" value="${jdbc.jdbcUrl}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <tx:advice id="transactionInterceptor" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="*" propagation="REQUIRED"/>
        </tx:attributes>
    </tx:advice>
    <!--AOP配置-->
    <aop:config>
            <!--配置切入点-->
        <aop:pointcut id="pointcut1" expression="execution(* cn.hp.service.RoleServiceImp.*(..))"/>
        <aop:advisor advice-ref="transactionInterceptor" pointcut-ref="pointcut1"/>
    </aop:config>

</beans>

测试类

@RunWith(SpringRunner.class)
@ContextConfiguration("classpath:spring.xml")
public class UserDaoTest66 {
    @Resource
    private RoleServiceImp serviceImp;
    @Test
    public void test(){
        serviceImp.trans(3,2,50);
    }
}