1、创建配置类,使用配置类替代xml配置文件
    image.png
    image.png
    image.png
    image.png

    测试
    image.png

    1. package com.atguigu.spring5.config;
    2. import com.alibaba.druid.pool.DruidDataSource;
    3. import org.springframework.context.annotation.Bean;
    4. import org.springframework.context.annotation.ComponentScan;
    5. import org.springframework.context.annotation.Configuration;
    6. import org.springframework.jdbc.core.JdbcTemplate;
    7. import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    8. import org.springframework.transaction.annotation.EnableTransactionManagement;
    9. /**
    10. * @author Dxkstart
    11. * @create 2021-10-30-19:29
    12. */
    13. @Configuration
    14. @ComponentScan(basePackages = "com.atguigu") //组件扫描
    15. @EnableTransactionManagement //开启事务
    16. public class TxConfig {
    17. //创建数据库连接池
    18. @Bean
    19. public DruidDataSource getDruidDataSource(){
    20. DruidDataSource druidDataSource = new DruidDataSource();
    21. druidDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    22. druidDataSource.setUrl("jdbc:mysql:///user_db?characterEncoding=utf-8");
    23. druidDataSource.setUsername("root");
    24. druidDataSource.setPassword("abc123");
    25. return druidDataSource;
    26. }
    27. //创建JdbcTemplate对象
    28. @Bean
    29. public JdbcTemplate getJdbcTemplate(DruidDataSource druidDataSource){
    30. //到IOC容器中根据类型找到dataSource
    31. JdbcTemplate jdbcTemplate = new JdbcTemplate();
    32. //注入dataSource
    33. jdbcTemplate.setDataSource(druidDataSource);
    34. return jdbcTemplate;
    35. }
    36. //创建事务管理器
    37. @Bean
    38. public DataSourceTransactionManager getDataSourceTransactionManager(DruidDataSource druidDataSource){
    39. DataSourceTransactionManager transactionManager = new DataSourceTransactionManager();
    40. transactionManager.setDataSource(druidDataSource);
    41. return transactionManager;
    42. }
    43. }