20_Spring_零XML事务控制

系统管理员 2023-09-27 15:25 96阅读 0赞

创建配置类

package com.msb.config;
    import com.alibaba.druid.pool.DruidDataSource;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.ComponentScan;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.context.annotation.PropertySource;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    import org.springframework.transaction.PlatformTransactionManager;
    import org.springframework.transaction.annotation.EnableTransactionManagement;
    import javax.sql.DataSource;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    @Configuration  // 配置类标志注解
    @ComponentScan(basePackages = "com.msb") // spring包扫描
    @PropertySource("classpath:jdbc.properties") // 读取属性配置文件
    @EnableTransactionManagement // 开启事务注解
    public class SpringConfig {
        @Value("${jdbc_driver}")
        private String driver;
        @Value("${jdbc_url}")
        private String url;
        @Value("${jdbc_username}")
        private String username;
        @Value("${jdbc_password}")
        private String password;
        /*创建数据库连接池*/
        @Bean
        public DruidDataSource getDruidDataSource(){
            DruidDataSource dataSource=new DruidDataSource();
            dataSource.setDriverClassName(driver);
            dataSource.setUrl(url);
            dataSource.setUsername(username);
            dataSource.setPassword(password);
            return dataSource;
        }
        /*创建JdbcTemplate对象*/
        @Bean
        public JdbcTemplate getJdbcTemplate(DataSource dataSource){
            JdbcTemplate jdbcTemplate=new JdbcTemplate();
            jdbcTemplate.setDataSource(dataSource);
            return jdbcTemplate;
        }
        /*创建事务管理器*/
        @Bean
        public PlatformTransactionManager getPlatformTransactionManager(DataSource dataSource){
            DataSourceTransactionManager transactionManager =new DataSourceTransactionManager();
            transactionManager.setDataSource(dataSource);
            return transactionManager;
        }
    }

![3275607c8b611bc5aa4cb15fd0dae956.gif][]

![Image 1][]

测试代码

@Test()
        public void testTransaction3(){
            ApplicationContext context =new AnnotationConfigApplicationContext(SpringConfig.class);
            AccountService accountService = context.getBean(AccountService.class);
            int rows = accountService.transMoney(1, 2, 100);
            System.out.println(rows);
        }

![ae35dbab873cd70d91b7f6436b1b4d22.gif][]

![92e3a84dde58c7d2cb1a34451bf0094a.gif][]

[3275607c8b611bc5aa4cb15fd0dae956.gif]: https://img-blog.csdnimg.cn/img_convert/3275607c8b611bc5aa4cb15fd0dae956.gif
[Image 1]: 
[ae35dbab873cd70d91b7f6436b1b4d22.gif]: https://img-blog.csdnimg.cn/img_convert/ae35dbab873cd70d91b7f6436b1b4d22.gif
[92e3a84dde58c7d2cb1a34451bf0094a.gif]: https://img-blog.csdnimg.cn/img_convert/92e3a84dde58c7d2cb1a34451bf0094a.gif