Spring - 事务篇

Spring - 事务篇

---

---

1. 指路 - Spring AOP 篇
2. 指路 - Spring IoC 篇

---

1. Spring整合JDBC

1.1 使用spring-jdbc操作数据库

• 主要内容：学习使用JdbcTemplate API和如何使用Spring管理JdbcTemplate

1. 创建项目引入依赖

<dependencies>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>5.2.13.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.2.13.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.16</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
    <dependency>
        <groupId>com.mchange</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.5.2</version>
    </dependency>
</dependencies>

<build>
    <plugins>
        <!--编译插件-->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>3.8.0</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
            </configuration>
        </plugin>
    </plugins>
</build>

2. 测试连接

@Test
public void test() throws PropertyVetoException {
   
    // 创建数据源
    ComboPooledDataSource dataSource = new ComboPooledDataSource();
    dataSource.setDriverClass("com.mysql.cj.jdbc.Driver");
    dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/数据库名?serverTimezone=Asia/Shanghai&" +
            "characterEncoding=utf8&useUnicode=true&useSSL=false");
    dataSource.setUser("用户名");
    dataSource.setPassword("密码");
    // 使用JDBCTemplate
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String sql = "INSERT INTO 表名(字段名1,字段名2) VALUES (?,?)";
    int update = jdbcTemplate.update(sql,