Spring XML配置4种数据源，以及配置事务的两种方式

电玩女神 2022-10-17 10:47 210阅读 0赞

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwMTc1Mw_size_16_color_FFFFFF_t_70]  
废话不多说，直接上代码，感情不深不深，都在代码里

<?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:p="http://www.springframework.org/schema/p"
           xmlns:c="http://www.springframework.org/schema/c"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:mvc="http://www.springframework.org/schema/mvc"
           xsi:schemaLocation="
    	http://www.springframework.org/schema/beans
    	http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
    	http://www.springframework.org/schema/aop
    	http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
    	http://www.springframework.org/schema/tx
    	http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
    	http://www.springframework.org/schema/context
    	http://www.springframework.org/schema/context/spring-context-3.2.xsd
    	http://www.springframework.org/schema/mvc
    	http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">
    
        
        
        
        
        <context:property-placeholder location="classpath:jdbc.properties"/>
        
        
        
        
        
        
        
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
            <property name="driverClassName" value="${jdbc.driverClassName}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
        
    
        
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource"/>
        </bean>
        <tx:annotation-driven transaction-manager="transactionManager"/>
        
    
        
    
        
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <tx:advice id="myAdvice" transaction-manager="transactionManager">
            
            <tx:attributes>
                <tx:method name="buy" isolation="DEFAULT" propagation="REQUIRED" rollback-for="java.lang.NullPointerException"/>
                <tx:method name="add*" isolation="REPEATABLE_READ" propagation="REQUIRES_NEW"/>
                <tx:method name="modify*" isolation="DEFAULT" propagation="REQUIRED"/>
                <tx:method name="remove*"/>
                
                <tx:method name="*" isolation="DEFAULT" propagation="SUPPORTS" read-only="true"/>
            </tx:attributes>
        </tx:advice>
    
        
        <aop:config>
            
            <aop:pointcut id="servicePt" expression="execution(* *..service..*.*(..))"/>
            
            <aop:advisor advice-ref="myAdvice" pointcut-ref="servicePt"/>
        </aop:config>
    
        
    
    
    
    
    </beans>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDAwMTc1Mw_size_16_color_FFFFFF_t_70]: /images/20221014/12ddf3c0032a42b587e132281883d6f1.png