Spring07

知识点： Spring 声明式事务

    一.基于注解和配置类的Spring-jdbc环境搭建

              1. 准备项目，pom.xml

<dependencies>     <!--spring context依赖-->     <!--当你引入Spring Context依赖之后，表示将Spring的基础依赖引入了-->     <dependency>         <groupId>org.springframework</groupId>         <artifactId>spring-context</artifactId>         <version>6.0.6</version>     </dependency>     <!--注解-->     <dependency>         <groupId>jakarta.annotation</groupId>         <artifactId>jakarta.annotation-api</artifactId>         <version>2.1.1</version>     </dependency>     <!-- 数据库驱动 和 连接池-->     <dependency>         <groupId>mysql</groupId>         <artifactId>mysql-connector-java</artifactId>         <version>8.0.25</version>     </dependency>     <dependency>         <groupId>com.alibaba</groupId>         <artifactId>druid</artifactId>         <version>1.2.8</version>     </dependency>     <!-- spring-jdbc -->     <dependency>         <groupId>org.springframework</groupId>         <artifactId>spring-jdbc</artifactId>         <version>6.0.6</version>     </dependency>     <!--日志-->     <dependency>         <groupId>ch.qos.logback</groupId>         <artifactId>logback-classic</artifactId>         <version>1.2.3</version>     </dependency>     <!--lombok-->     <dependency>         <groupId>org.projectlombok</groupId>         <artifactId>lombok</artifactId>         <version>1.18.26</version>     </dependency>     <!--junit5测试-->     <dependency>         <groupId>org.junit.jupiter</groupId>         <artifactId>junit-jupiter-api</artifactId>         <version>5.3.1</version>     </dependency> <!--test测试-->     <dependency>         <groupId>org.springframework</groupId>         <artifactId>spring-test</artifactId>         <version>6.0.6</version>         <scope>test</scope>     </dependency> </dependencies>

注意：引入logback.xml的日志文件

      2. 外部配置文件 jdbc.properties

jdbc.url=jdbc:mysql://localhost:3306/studb?serverTimezone=UTC jdbc.userName=root jdbc.userPwd= jdbc.driverClass=com.mysql.cj.jdbc.Driver

       3.Spring 配置类

@Configuration          //标识是一个配置类 @ComponentScan("com.bdqn")     //开启注解扫描 @PropertySource("classpath:jdbc.properties")     //加载jdbc属性配置文件获取属性 public class SpringConfig {     //@Value 通常用于注入外部化属性     @Value("${jdbc.url}")     private String url;     @Value("${jdbc.driverClass}")     private String driver;     @Value("${jdbc.userName}")     private String username;     @Value("${jdbc.userPwd}")     private String password;     /**      * 创建数据源对象:druid连接池