spring数据源配置及事务管理--jdbc

两种数据源配置和两种事务管理

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
 
 <aop:config proxy-target-class="true"/><!-- cglib实现代理，不需要借口 -->
 
 <bean id="dataSource_jdbc" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
  <property name="url" value="jdbc:mysql://localhost:3306/ppt?useUnicode=true&amp;characterEncoding=UTF-8"/>
  <property name="username" value="root"/>
  <property name="password" value="root"/>
 </bean>
 
 <bean id="dataSource_dbcp" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  <property name="password" value="root"/>
  <property name="username" value="root"/>
  <property name="url" value="jdbc:mysql://localhost:3306/ppt?useUnicode=true&amp;characterEncoding=UTF-8"/>
  <property name="maxActive" value="20"/>
  <property name="maxIdle" value="15"/>
  <property name="minIdle" value="5"/>
  <property name="maxWait" value="60000"/>
  <property name="initialSize" value="1"/>
  <property name="removeAbandoned" value="true"/>
  <property name="removeAbandonedTimeout" value="180"/>
  <property name="logAbandoned" value="true"/>
  <property name="timeBetweenEvictionRunsMillis" value="3600000"/>
  <property name="minEvictableIdleTimeMillis" value="3600000"/>
  <property name="defaultAutoCommit" value="false"/>
 </bean>
 
 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >
  <property name="dataSource">
   <ref local="dataSource_dbcp"/>
  </property>
 </bean>
 
 <bean id="jdbcDemo" class="com.csair.dao.JdbcDemo">
  <property name="jdbcTemplate">
   <ref local="jdbcTemplate"/>
  </property>
 </bean>
 
 <!-- 事务管理 -->
 <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource">
   <ref local="dataSource_dbcp"/>
  </property>
 </bean>
 <!-- 注解实现事务管理 -->
 <!-- <tx:annotation-driven transaction-manager="dataSourceTransactionManager"/> -->
 
 <!-- aop实现事务管理 -->
 <aop:config>
  <aop:pointcut expression="execution(* com.csair.dao.**.*(..))" id="pointCut"/>
  <aop:advisor advice-ref="adive" pointcut-ref="pointCut"/>
 </aop:config>
 <tx:advice id="adive" transaction-manager="dataSourceTransactionManager">
  <tx:attributes>
   <tx:method name="insert*" propagation="REQUIRED"/>
  </tx:attributes>
 </tx:advice>
</beans>

 

测试

package com.csair.dao;

import java.util.List;
import java.util.Map;

import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.transaction.annotation.Transactional;
@Transactional
public class JdbcDemo {

 private  JdbcTemplate jdbcTemplate;
 
 public static void main(String[] args) {
  String configLocation = "applicationContext-jdbc.xml";
  ClassPathXmlApplicationContext contenxt = new ClassPathXmlApplicationContext(configLocation);
  JdbcDemo demo = contenxt.getBean("jdbcDemo", JdbcDemo.class);
  demo.insert();
  demo.query();
  
 }
 public void query() {
  String sql = "select * from user";
  List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);
  System.out.println("Object: " + list.toString());
  int count = jdbcTemplate.queryForInt("select count(*) from user");
  System.out.print("count: " + count);
 }
 public void insert() {
  String insert = "insert into user(username, password) values('okok','koko')";
  jdbcTemplate.execute(insert);
 }
 
 public JdbcTemplate getJdbcTemplate() {
  return jdbcTemplate;
 }
 public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
  this.jdbcTemplate = jdbcTemplate;
 }
 
 
}