测试用例:
事务模板类:org.springframework.transaction.support.TransactionTemplate
package com.vip.xstore.spring;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.transaction.support.TransactionTemplate;
import javax.sql.DataSource;
@Configuration
public class Config {
// 配置对应的数据源
@Bean
public DataSource dataSource(){
DriverManagerDataSource db = new DriverManagerDataSource();
db.setUsername("root");
db.setPassword("root");
db.setUrl("jdbc:mysql://localhost:3306/caraliu?useUnicode=true&characterEncoding=utf-8");
db.setDriverClassName("com.mysql.jdbc.Driver");
return db;
}
// 使用JdbcTemplate操作数据库
@Bean
public JdbcTemplate jdbcTemplate(DataSource dataSource){
return new JdbcTemplate(dataSource);
}
// 注入事务管理器
@Bean
public Da