JDBC学习笔记01【JDBC快速入门、JDBC各个类详解、JDBC之CRUD练习】

布满荆棘的人生 2022-10-28 10:07 219阅读 0赞

>  *  **黑马程序员-JDBC文档（腾讯微云）JDBC笔记.pdf：[https://share.weiyun.com/Kxy7LmRm][https_share.weiyun.com_Kxy7LmRm]**
> 
> 1.  [JDBC学习笔记01【JDBC快速入门、JDBC各个类详解、JDBC之CRUD练习】][JDBC_01_JDBC_JDBC_JDBC_CRUD]
> 2.  [JDBC学习笔记02【ResultSet类详解、JDBC登录案例练习、PreparedStatement类详解】][JDBC_02_ResultSet_JDBC_PreparedStatement]
> 3.  [JDBC学习笔记03【JDBC事务管理、数据库连接池、JDBCTemplate】][JDBC_03_JDBC_JDBCTemplate]

**目录**

01 JDBC快速入门

今日内容

JDBC\_概念

JDBC\_快速入门

驱动jar包解析

IntelliJ IDEA 2017.3.4 x64 新建项目、新建模块

Idea 新建包 不分级 解决方法

将 MySQL驱动jar包 添加到 Idea项目 中

Idea 连接 MySQL数据库 代码

02 JDBC各个类详解

Idea 导入 项目

JDBC各个类详解\_DriverManager

DriverManager 获取数据库连接

JDBC各个类详解\_Connection

获取执行sql的对象

管理事务

JDBC各个类详解\_Statement

03 JDBC之CRUD练习

JDBC练习\_insert语句

account表 添加一条记录

JDBC练习\_update语句

account表 修改记录

JDBC练习\_update、DDL语句

account表 删除一条记录

执行DDL语句

--------------------

# 01 JDBC快速入门 #

## 今日内容 ##

> 1.  JDBC基本概念
> 2.  快速入门
> 3.  对JDBC中各个接口和类详解

## JDBC\_概念 ##

> **1. 概念：**Java DataBase Connectivity  Java 数据库连接， Java语言操作数据库  
>     \* JDBC本质：其实是官方（sun公司）定义的一套操作所有关系型数据库的规则，即接口。各个数据库厂商去实现这套接口，提供数据库驱动jar包。我们可以使用这套接口（JDBC）编程，真正执行的代码是驱动jar包中的实现类。

>  *  Person 接口：eat()方法   Worker实现类      Person p = new Worker(); // 父类引用指向子类对象
>  *  p.eat(); // 会调用Worker()实现类的eat方法，产生多态调用
>  *  JDBC编程，以接口类型调用方法。导入驱动jar包后，真正执行的是驱动jar包实现类对应的实现方法。

> ![20210205183710426.png][]

## JDBC\_快速入门 ##

> **2. 快速入门：**  
> **    \* 步骤：**  
>         1. 导入驱动jar包 mysql-connector-java-5.1.37-bin.jar  
>             1.复制mysql-connector-java-5.1.37-bin.jar到项目的libs目录下  
>             2.右键-->Add As Library  
>         2. 注册驱动  
>         3. 获取数据库连接对象 Connection  
>         4. 定义sql  
>         5. 获取执行sql语句的对象 Statement  
>         6. 执行sql，接受返回结果  
>         7. 处理结果  
>         8. 释放资源
> 
> **    \* 代码实现：**  
>          //1. 导入驱动jar包  
>         //2.注册驱动  
>         Class.forName("com.mysql.jdbc.Driver");  
>         //3.获取数据库连接对象  
>         Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db3", "root", "root");  
>         //4.定义sql语句  
>         String sql = "update account set balance = 500 where id = 1";  
>         //5.获取执行sql的对象 Statement  
>         Statement stmt = conn.createStatement();  
>         //6.执行sql  
>         int count = stmt.executeUpdate(sql);  
>         //7.处理结果  
>         System.out.println(count);  
>         //8.释放资源  
>         stmt.close();  
>         conn.close();

### 驱动jar包解析 ###

> ![20210205193014214.png][]  ![20210205193219991.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70][]  ![20210205193419728.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1][]

### IntelliJ IDEA 2017.3.4 x64 新建项目、新建模块 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 5][]

> **新建模块**
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 6][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 7][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 8][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 9][]

### Idea 新建包 不分级 解决方法 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 10][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 11][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 12][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 13][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 14][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 15][]

### 将 MySQL驱动jar包 添加到 Idea项目 中 ###

> 导入驱动jar包 mysql-connector-java-5.1.37-bin.jar  
>             1.复制mysql-connector-java-5.1.37-bin.jar到项目的libs目录下  
>             2.右键-->Add As Library
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 16][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 17][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 18][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 19][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 20][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 21][]

### Idea 连接 MySQL数据库 代码 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 22][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 23][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 24][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 25][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 26][]
> 
> 运行文件JdbcDemo1.java文件，出现如下信息（百度查了一下，可能电脑内存不够...），重新点击运行按钮，又好了。
> 
> \# There is insufficient memory for the Java Runtime Environment to continue.  
> \# Native memory allocation (malloc) failed to allocate 1048576 bytes for AllocateHeap  
> \# An error report file with more information is saved as:  
> \# F:\\JetBrains\\1ideaSpace\\itcast\\hs\_err\_pid2904.log
> 
> ![20210205202010509.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 27][]

package cn.itcast.jdbc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.Statement;
    
    /**
     * JDBC快速入门
     */
    public class JdbcDemo1 {
        public static void main(String[] args) throws Exception {
            //1.导入驱动jar包
            //2.注册驱动
            Class.forName("com.mysql.jdbc.Driver"); // 把类通过Class.forName()加载进内存
            //3.获取数据库连接对象
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db3", "root", "root");
            //4.定义sql语句
            String sql = "update account set balance = 2000 where id = 1";
            //5.获取执行sql的对象 Statement
            Statement stmt = conn.createStatement();
            //6.执行sql
            int count = stmt.executeUpdate(sql);
            //7.处理结果
            System.out.println(count);
            //8.释放资源
            stmt.close();
            conn.close();
        }
    }

# 02 JDBC各个类详解 #

## Idea 导入 项目 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 28][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 29][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 30][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 31][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 32][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 33][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 34][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 35][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 36][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 37][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 38][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 39][]

## JDBC各个类详解\_DriverManager ##

> 3. 详解各个对象：  
>     1. DriverManager：驱动管理对象  
>         \* 功能：  
>             1. 注册驱动：告诉程序该使用哪一个数据库驱动jar包  
>                 static void registerDriver(Driver driver) :注册与给定的驱动程序 DriverManager 。   
>                 写代码使用：  Class.forName("com.mysql.jdbc.Driver");  
>                 通过查看源码发现：在com.mysql.jdbc.Driver类中存在静态代码块  
>                  static \{  
>                         try \{  
>                             java.sql.DriverManager.registerDriver(new Driver());  
>                         \} catch (SQLException E) \{  
>                             throw new RuntimeException("Can't register driver!");  
>                         \}  
>                     \}
> 
>                 注意：mysql5之后的驱动jar包可以省略注册驱动的步骤。  
>             2. 获取数据库连接
> 
>     2. Connection：数据库连接对象
> 
>     3. Statement：执行sql的对象
> 
>     4. ResultSet：结果集对象,封装查询结果

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 40][]
> 
> ![20210205204131913.png][]
> 
> ![20210205204431507.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 41][]

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 42][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 43][]

## JDBC各个类详解\_DriverManager ##

> **3. 详解各个对象：**  
> **    1. DriverManager：驱动管理对象**  
>         \* 功能：  
>             **1. 注册驱动：告诉程序该使用哪一个数据库驱动jar包**  
>                 static void registerDriver(Driver driver) :注册与给定的驱动程序 DriverManager 。   
>                 写代码使用：  Class.forName("com.mysql.jdbc.Driver");  
>                 通过查看源码发现：在com.mysql.jdbc.Driver类中存在静态代码块  
>                  static \{  
>                         try \{  
>                             java.sql.DriverManager.registerDriver(new Driver());  
>                         \} catch (SQLException E) \{  
>                             throw new RuntimeException("Can't register driver!");  
>                         \}  
>                     \}
> 
>                 注意：mysql5之后的驱动jar包可以省略注册驱动的步骤。  
>             **2. 获取数据库连接：**  
>                 \* 方法：static Connection getConnection(String url, String user, String password)   
>                 \* 参数：  
>                     \* url：指定连接的路径  
>                         \* 语法：jdbc:mysql://ip地址(域名):端口号/数据库名称  
>                         \* 例子：jdbc:mysql://localhost:3306/db3  
>                         \* 细节：如果连接的是本机mysql服务器，并且mysql服务默认端口是3306，则url可以简写为：jdbc:mysql:///数据库名称  
>                     \* user：用户名  
>                     \* password：密码

### DriverManager 获取数据库连接 ###

> ![20210206091446758.png][]
> 
> jdbc:mysql://ip地址(域名):端口号/数据库名称，端口号：找到计算机上安装的MySQL服务器。
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 44][]

## JDBC各个类详解\_Connection ##

> **    2. Connection：数据库连接对象（代表了当前代码和数据库之间的桥梁）。**  
>         1. 功能：  
>             1. 获取执行sql 的对象  
>                 \* Statement createStatement()  
>                 \* PreparedStatement prepareStatement(String sql)    
>             2. 管理事务：  
>                 \* 开启事务：setAutoCommit(boolean autoCommit) ：调用该方法设置参数为false，即开启事务  
>                 \* 提交事务：commit()   
>                 \* 回滚事务：rollback()

### 获取执行sql的对象 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 45][]
> 
> ![20210206092523919.png][]
> 
> ![2021020609255343.png][]

### 管理事务 ###

> **事务：**
> 
> ![20210206092820455.png][]
> 
> ![20210206092739965.png][]
> 
> ![20210206092932731.png][]

## JDBC各个类详解\_Statement ##

> **    3. Statement：执行sql的对象**  
> **        1. 执行sql**  
>             1. boolean execute(String sql) ：可以执行任意的sql（了解）  
>             2. int executeUpdate(String sql) ：执行DML(insert、update、delete)语句、DDL(create、alter、drop)语句  
>                 \* 返回值：影响的行数，可以通过这个影响的行数判断DML语句是否执行成功。返回值>0，则执行成功；反之，则失败。  
>             3. ResultSet executeQuery(String sql) ：执行DQL（select）语句

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 46][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 47][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 48][]
> 
> ![20210206094140561.png][]

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 49][]
> 
> ![20210206094432309.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 50][]

> ![20210206094822847.png][]

# 03 JDBC之CRUD练习 #

## JDBC练习\_insert语句 ##

> **    3. Statement：执行sql的对象**  
> **        1. 执行sql**  
>             1. boolean execute(String sql) ：可以执行任意的sql 了解   
>             2. int executeUpdate(String sql) ：执行DML（insert、update、delete）语句、DDL(create，alter、drop)语句  
>                 \* 返回值：影响的行数，可以通过这个影响的行数判断DML语句是否执行成功 返回值>0的则执行成功，反之，则失败。  
>             3. ResultSet executeQuery(String sql)  ：执行DQL（select)语句  
>         **2. 练习：**  
>             1. account表 添加一条记录  
>             2. account表 修改记录  
>             3. account表 删除一条记录
> 
>             代码：...

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 51][]

### account表 添加一条记录 ###

> ![20210206095859988.png][]  ![20210206095912858.png][]
> 
> ![20210206100135722.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 52][]
> 
> ![20210206100730714.png][]

package cn.itcast.jdbc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    /**
     * account表 添加一条记录 insert 语句
     */
    public class JDBCDemo2 {
        public static void main(String[] args) {
            Statement stmt = null;
            Connection conn = null;
            try {
                //1. 注册驱动
                Class.forName("com.mysql.jdbc.Driver");
                //2. 定义sql
                String sql = "insert into account values(null,'王五',3000)";
                //3.获取Connection对象
                conn = DriverManager.getConnection("jdbc:mysql:///db3", "root", "root");
                //4.获取执行sql的对象 Statement
                stmt = conn.createStatement();
                //5.执行sql
                int count = stmt.executeUpdate(sql);//影响的行数
                //6.处理结果
                System.out.println(count);
                if (count > 0) {
                    System.out.println("添加成功！");
                } else {
                    System.out.println("添加失败！");
                }
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                //stmt.close();
                //7. 释放资源
                //避免空指针异常
                if (stmt != null) {
                    try {
                        stmt.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
                if (conn != null) {
                    try {
                        conn.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }

## JDBC练习\_update语句 ##

### account表 修改记录 ###

> ![20210206101136764.png][]

package cn.itcast.jdbc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    /**
     * account表 修改记录
     */
    public class JDBCDemo3 {
        public static void main(String[] args) {
            Connection conn = null;
            Statement stmt = null;
            try {
                //1.注册驱动
                Class.forName("com.mysql.jdbc.Driver");
                //2.获取连接对象
                conn = DriverManager.getConnection("jdbc:mysql:///db3", "root", "root");
                //3.定义sql
                String sql = "update account set balance = 1500 where id = 3";
                //4.获取执行sql对象
                stmt = conn.createStatement();
                //5.执行sql
                int count = stmt.executeUpdate(sql);
                //6.处理结果
                System.out.println(count);
                if (count > 0) {
                    System.out.println("修改成功！");
                } else {
                    System.out.println("修改失败！");
                }
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                //7.释放资源
                if (stmt != null) {
                    try {
                        stmt.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
                if (conn != null) {
                    try {
                        conn.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }

## JDBC练习\_update、DDL语句 ##

### account表 删除一条记录 ###

> ![20210206101423846.png][]

package cn.itcast.jdbc;
    
    import cn.itcast.util.JDBCUtils;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    /**
     * account表 删除一条记录
     */
    public class JDBCDemo4 {
        public static void main(String[] args) {
            Connection conn = null;
            Statement stmt = null;
            try {
                //1. 注册驱动
                Class.forName("com.mysql.jdbc.Driver");
                //2.获取连接对象
                conn = DriverManager.getConnection("jdbc:mysql:///db3", "root", "root");
                //conn = JDBCUtils.getConnection("jdbc:mysql:///db3", "root", "root");
                //3.定义sql
                String sql = "delete from account where id = 3";
                //4.获取执行sql对象
                stmt = conn.createStatement();
                //5.执行sql
                int count = stmt.executeUpdate(sql);
                //6.处理结果
                System.out.println(count);
                if (count > 0) {
                    System.out.println("删除成功！");
                } else {
                    System.out.println("删除失败！");
                }
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                //7.释放资源
                if (stmt != null) {
                    try {
                        stmt.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
                if (conn != null) {
                    try {
                        conn.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }

### 执行DDL语句 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 53][]

package cn.itcast.jdbc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    /**
     * 执行DDL语句
     */
    public class JDBCDemo5 {
        public static void main(String[] args) {
            Connection conn = null;
            Statement stmt = null;
            try {
                //1. 注册驱动
                Class.forName("com.mysql.jdbc.Driver");
                //2.获取连接对象
                conn = DriverManager.getConnection("jdbc:mysql:///db3", "root", "root");
                //3.定义sql
                String sql = "create table student (id int, name varchar(20))";
                //4.获取执行sql对象
                stmt = conn.createStatement();
                //5.执行sql
                int count = stmt.executeUpdate(sql);
                //6.处理结果
                System.out.println(count);
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                //7.释放资源
                if (stmt != null) {
                    try {
                        stmt.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
                if (conn != null) {
                    try {
                        conn.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }

> 加油，赶紧学，宁死不玩~

[https_share.weiyun.com_Kxy7LmRm]: https://share.weiyun.com/Kxy7LmRm
[JDBC_01_JDBC_JDBC_JDBC_CRUD]: https://blog.csdn.net/weixin_44949135/article/details/113701706
[JDBC_02_ResultSet_JDBC_PreparedStatement]: https://blog.csdn.net/weixin_44949135/article/details/113708612
[JDBC_03_JDBC_JDBCTemplate]: https://blog.csdn.net/weixin_44949135/article/details/113724109
[20210205183710426.png]: /images/20221024/62fbb18ed38249478b7fd0edeeb8b844.png
[20210205193014214.png]: https://img-blog.csdnimg.cn/20210205193014214.png
[20210205193219991.png]: /images/20221024/0deb159cb41f4866bd908504b3df22ac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210205193304346.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20210205193419728.png]: /images/20221024/81a72908c1e44d8d9749202ec1afe4a5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1]: /images/20221024/fa75da518cd646438c2a69bf9bc267a9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20210205194339150.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3]: /images/20221024/fece33520dee47f598cdbdc381c147db.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20210205194528813.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 5]: /images/20221024/eafe1b8e4e324abd8bb2716d33c8bdea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20210205194731684.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 7]: /images/20221024/35e1e7e50e6648f189310ef9d8175927.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20210205194821176.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 9]: /images/20221024/73c89df693584d3a8571188c4c888187.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/2021020519555087.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 11]: /images/20221024/05c285c03fc147ddbcb75dc666616b45.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20210205195833206.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 13]: /images/20221024/c72b495409af4b5bbae725c63eb10260.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/20210205195937698.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 15]: /images/20221024/14532bafa3c64ed682bff0136f264d40.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 16]: https://img-blog.csdnimg.cn/20210205200154331.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 17]: /images/20221024/edc69043911e42b591f12f17b0ed1990.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 18]: /images/20221024/316f888e27e0455daa471351d24833f5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 19]: https://img-blog.csdnimg.cn/20210205200341582.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 20]: /images/20221024/3b3b5c5540ff495f86f79640872501db.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 21]: /images/20221024/974a16a103ef4010b1c6c343d060d0cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 22]: /images/20221024/e69c637bd83c4f2e9b531e82465b0c6a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 23]: https://img-blog.csdnimg.cn/20210205201128566.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 24]: /images/20221024/5e407df9e32e446ea00351ee92306eea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 25]: /images/20221024/a783efd608ff44c98fea7b2c70c0ea06.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 26]: /images/20221024/e8ac14ea9d15478b848599dcc05a8a5c.png
[20210205202010509.png]: /images/20221024/3fb6e44306c44e7c9df5641aa4888581.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 27]: /images/20221024/586f9f91039f4604955ee3bb537bd0fe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 28]: https://img-blog.csdnimg.cn/20210205202854347.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 29]: /images/20221024/6e5995de9e944ec1a63865e0ac8c6aef.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 30]: https://img-blog.csdnimg.cn/20210205202943404.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 31]: /images/20221024/2151f448f86c4da5a2e3f245a069d084.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 32]: https://img-blog.csdnimg.cn/20210205203020213.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 33]: /images/20221024/c3bc8e727ab24841b7884285adf69c64.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 34]: https://img-blog.csdnimg.cn/20210205203154205.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 35]: /images/20221024/bb25c7fe49b347c9a3cebcfc65923923.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 36]: https://img-blog.csdnimg.cn/20210205203220695.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 37]: /images/20221024/cd2b9b9aaa5e47e3abec76f3ccb053a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 38]: /images/20221024/fe5e1d519b1d47278625fedfdcefb234.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 39]: /images/20221024/33e79c7a84e948209c444f751979da81.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 40]: /images/20221024/8355e997001849c5bb1a42834ca27987.png
[20210205204131913.png]: /images/20221024/85426614149d49ddb27b06fb186ba598.png
[20210205204431507.png]: /images/20221024/a8ee999a12c24cdf92868ff92a903c1d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 41]: /images/20221024/ecc75d1a03a045cdabd33c143b31c927.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 42]: /images/20221024/332f51d40d0047bb8fa436aeee248510.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 43]: /images/20221024/4fc9de69a08e4c808df54ac971a354ea.png
[20210206091446758.png]: /images/20221024/27e6743c3a434779b863625b6e820c82.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 44]: /images/20221024/a0a72ddf079d415382758f4dd1b2d530.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 45]: /images/20221024/96653393c080420ba05f9f7287b89008.png
[20210206092523919.png]: /images/20221024/ef063ae191024844aaa64ede399fd596.png
[2021020609255343.png]: /images/20221024/a12f195d59f14eada7f758d25ffd2721.png
[20210206092820455.png]: /images/20221024/d84fb12570484cc78f071f01d8dc0dd3.png
[20210206092739965.png]: /images/20221024/871a103d38ea427daa3111ba666bfcb7.png
[20210206092932731.png]: /images/20221024/661ebe51df9e4823829e4f0bac9f5da5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 46]: /images/20221024/495376ca39444ee0b7e079f15283a038.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 47]: /images/20221024/1cec7c8af6b44570b26cf5eb9c870751.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 48]: /images/20221024/22efe2feb75e4130a016cf703e2c55d8.png
[20210206094140561.png]: /images/20221024/0c79ffc9bd914fbd8bc031526798adac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 49]: /images/20221024/9ba50a0973ad4cf785ab260538399e20.png
[20210206094432309.png]: /images/20221024/cbfbf982dd8341588aa18bb289957fab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 50]: /images/20221024/b42be977b6e84548aaeeb4a284b3223e.png
[20210206094822847.png]: /images/20221024/f0d6b9a6363149188ee040bbf6aa924b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 51]: /images/20221024/34caa3eb210e4df9b2bf7cd88e690231.png
[20210206095859988.png]: https://img-blog.csdnimg.cn/20210206095859988.png
[20210206095912858.png]: /images/20221024/58ed2e874b7e4f99b8e0c18dcb989e19.png
[20210206100135722.png]: /images/20221024/128e15f7082142318b2e7f4b61fed530.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 52]: /images/20221024/f002e3ab9c3d4c9182483a56efc5e49e.png
[20210206100730714.png]: /images/20221024/479f64e18def49b5b76b67362dd10bb6.png
[20210206101136764.png]: /images/20221024/44a5f38b8aa74489ad10e58aa32a678e.png
[20210206101423846.png]: /images/20221024/577cddf6663949d9b436a4f384838882.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 53]: /images/20221024/4a752b9a100246db9e04b7d0903c1b48.png