spring事务步骤（注解版）

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.1.2.RELEASE</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aspects</artifactId>
    <version>4.1.2.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.1.2.RELEASE</version>
</dependency>
<dependency>
    <groupId>c3p0</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.1.2</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.44</version>
</dependency>

1、dao

@Repository
public class TxDao {

    @Autowired
    private JdbcTemplate jdbcTemplate;
    
    public  void insert(){
        String sql = "insert into user(username,age) values(?,?)";
        String username = UUID.randomUUID().toString().substring(0,6);
        jdbcTemplate.update(sql,username,19);
    }
}

2、service

@Service
public class TxService {

    @Autowired
    private TxDao txDao;

    @Transactional
    public void insert(){
        txDao.insert();
        System.out.println("插入成功");

    }
}

3、配置文件

/**
 * 添加事务步骤
 * 1、在业务方法上添加 @Transactional
 * 2、在配置文件上添加 @EnableTransactionManagement
 * 3、添加事务管理器 管理数据源 public PlatformTransactionManager platformTransactionManager()；
 */

@EnableTransactionManagement
@Configuration
@ComponentScan(value = {"service","dao"})
public class TxConfig {

    //数据源的配置
    @Bean
    public DataSource dataSource() throws Exception {
        //使用c3p0数据源
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        dataSource.setDriverClass("com.mysql.jdbc.Driver");
        dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/test");
        dataSource.setUser("root");
        dataSource.setPassword("root");
        return dataSource;
    }

    //jdbcTemplate
    @Bean
    public JdbcTemplate jdbcTemplate() throws Exception {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource());
        return jdbcTemplate;
    }

    //事务管理器（最重要一步） 管理数据源
    @Bean
    public PlatformTransactionManager platformTransactionManager() throws Exception{
        DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager(dataSource());
        return  dataSourceTransactionManager;
    }
}

4、测试类

@Test
public  void test01(){
    AnnotationConfigApplicationContext applicationContext = new AnnotationConfigApplicationContext(TxConfig.class);
    TxService txService = (TxService) applicationContext.getBean("txService");
    txService.insert();
}