Spring XML事务配置

事先准备：
配置数据源对象
用<bean>实例化各个业务对象。

1.配置事务管理器。

<bean id="transactionManager" class="org.springframework.jdbc.datasourceManager">
　　<property name="datasource" ref="datasource"></property>
</bean>

2.配置事务属性

<tx:advice id="txAdvice" transaction-manager="transactionManager">
    <tx:attributes>
        <tx:method name="方法名" propagation="REQUIRES_NEW"/>    <!--新开事务-->
        <tx:method name="*"/>                                    <!--使用原有事务-->
    </tx:attributes>
</tx:advice>

3.配置事务切入点，注入事务属性

<aop:config>
    <aop:pointcut expression="execution(.......)" id="txPointCut"/>
    <aop:advisor advice-ref="txtAdvice" pointcut-ref="txtPointCut"/>
</aop:config>

 

下面看一个实例：

准备工作：导入c3p0、Spring框架、Mysql、AOP的jar包，并配置好

db.properties 

driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/mydb
user=root
password=
minPoolSize=5
maxPoolSize=20
initialPoolSize=5

1.做两个接口IInfoDao和IWorkDao

package com.itnba.maya.dao;

public interface IInfoDao {
    public void delete(String code);
}

package com.itnba.maya.dao;

public interface IWorkDao {
    public void deleteByInfoCode(String code);
}

2.做两个类继承以上两个接口：InfoDao和WorkDao

package com.itnba.maya.daoImpl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import com.itnba.maya.dao.IInfoDao;


public class InfoDao implements IInfoDao {
    
    private JdbcTemplate jdbcTemplate;
    
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public void delete(String code) {
    
        String sql = "delete from info where code=?";
        jdbcTemplate.update(sql, code);    
        int n = 5/0;
    }
}

package com.itnba.maya.daoImpl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import com.itnba.maya.dao.IWorkDao;

public class WorkDao implements IWorkDao {
    
    private JdbcTemplate jdbcTemplate;
    
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public void deleteByInfoCode(String code) {

        String sql = "delete from work where infoCode=?";
        jdbcTemplate.update(sql,code);        
    }
}

3.向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"
    default-autowire="byName"
    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.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
        
    <context:property-placeholder location="classpath:db.properties"/>
    <!-- 生成连接池 -->
    <bean class="com.mchange.v2.c3p0.ComboPooledDataSource" id="dataSource">
        <property name="driverClass" value="${driverClass}"></property>
        <property name="jdbcUrl" value="${jdbcUrl}"></property>
        <property name="user" value="${user}"></property>
        <property name="password" value="${password}"></property>
        <property name="minPoolSize" value="${minPoolSize}"></property>
        <property name="maxPoolSize" value="${maxPoolSize}"></property>
        <property name="initialPoolSize" value="${initialPoolSize}"></property>
    </bean>
    
    <!-- 生成JdbcTemplate -->
    <bean class="org.springframework.jdbc.core.JdbcTemplate" id="jdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <bean class="com.itnba.maya.daoImpl.InfoDao" id="infoDao">
        <property name="jdbcTemplate" ref="jdbcTemplate"></property>
    </bean>
    <bean class="com.itnba.maya.daoImpl.WorkDao" id="workDao">
        <property name="jdbcTemplate" ref="jdbcTemplate"></property>
    </bean>
    <bean class="com.itnba.maya.serviceImpl.InfoService" id="infoService">
        <property name="workDao" ref="workDao"></property>
        <property name="infoDao" ref="infoDao"></property>
    </bean>
    
    
    <!-- 配置事务管理器 -->
    <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="*" propagation="REQUIRED"/>
        </tx:attributes>
    </tx:advice>
    
    <aop:config>
        <aop:pointcut expression="execution(* com.itnba.maya..*.*(..))" id="pointCut"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointCut"/>
    </aop:config>
    
</beans>

4.建立业务接口并用类继承

IInfoService接口

package com.itnba.maya.service;

public interface IInfoService {
    public void delete(String code);
}

InfoService类

package com.itnba.maya.serviceImpl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import com.itnba.maya.dao.IInfoDao;
import com.itnba.maya.dao.IWorkDao;
import com.itnba.maya.service.IInfoService;


public class InfoService implements IInfoService {

    
    private IWorkDao workDao;
    
    private IInfoDao infoDao;
    
    
    public void setWorkDao(IWorkDao workDao) {
        this.workDao = workDao;
    }


    public void setInfoDao(IInfoDao infoDao) {
        this.infoDao = infoDao;
    }


    @Override
    public void delete(String code) {
        workDao.deleteByInfoCode(code);
        infoDao.delete(code);
    }

}

5.创建测试类并运行

package com.itnba.maya.test;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.itnba.maya.dao.IInfoDao;
import com.itnba.maya.dao.IWorkDao;
import com.itnba.maya.service.IInfoService;
import com.itnba.maya.serviceImpl.TestAll;

public class Test {

    private static ApplicationContext context = null;
    private static IInfoDao infoDao = null;
    private static IWorkDao workDao = null;
    private static IInfoService infoService=null;
    
    
    static{
        context = new ClassPathXmlApplicationContext("beans.xml");
        infoDao = (IInfoDao)context.getBean("infoDao");
        workDao = (IWorkDao)context.getBean("workDao");
        infoService = (IInfoService)context.getBean("infoService");
        
    }
    
    public static void main(String[] args) {

        infoService.delete("p009");        
    }    
}

运行结果：”p009“未删除成功

 

 

取消掉事务控制后再运行，”p009“已删除