数据库实验报告【太原理工大学】

Love The Way You Lie 2023-09-29 11:02 20阅读 0赞

## 数据库实验报告 ##

`温馨提示：仅供参考！`

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

#### 目录 ####

*  数据库实验报告
 *   *  一、交互式 SQL 语句的使用
     *   *  1.数据定义
         *  2.数据操作
         *  3.数据查询操作
     *  二、用户鉴别与数据控制
     *   *  1.使用 SSMS 的图形界面创建用户并授权
         *  使用ＳＱＬ语句创建用户并授权
         *  3.检查权限控制
         *  4.撤销权限
     *  三、数据完整性
     *   *  1.声明完整性约束
         *  2.检查完整性约束
         *  3.触发器的定义及使用

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

### 一、交互式 SQL 语句的使用 ###

#### 1.数据定义 ####

`创建、修改、删除基本表`  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_16_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16 1]

`创建索引`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center]

`创建视图`  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_17_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 1]

#### 2.数据操作 ####

`插入数据`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 2]

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 3]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 4]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 5]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 6]

`修改数据`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 7]

`删除数据`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 8]

#### 3.数据查询操作 ####

`单表查询`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 9]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 10]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 11]  
`分组统计`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 12]  
`连接查询`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 13]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 14]  
`嵌套查询`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 15]

`集合查询`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 16]  
`视图操作`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 17]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 18]

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

### 二、用户鉴别与数据控制 ###

#### 1.使用 SSMS 的图形界面创建用户并授权 ####

`使用 SSMS 的图形界面创建登录名`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 19]  
`使用 SSMS 的图形界面创建数据库用户`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 20]  
`使用 SSMS 的图形界面进行授权，设置用户对对象的访问权限`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 21]

#### 使用ＳＱＬ语句创建用户并授权 ####

`创建登录名`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 22]  
`创建数据库用户`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_10_color_FFFFFF_t_70_g_se_x_16_pic_center]  
`授权`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 23]

#### 3.检查权限控制 ####

`检查王明的权限`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 24]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 25]

`why?so what?`

> 原因：我们前面仅仅是对王明授予了查看Student表的权限，但是并没有设置其他的权限，所以此时他仅可以查看Student表，但是无法对其内容进行增删改，也无法查看和访问Course表和SC表。

`检查李刚的权限`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 26]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 27]

`过来，给你一JIO`

> 我们对李刚授予了查看Student表和对该表进行增删改的权限，但是对于Course表，他仅有查看的权限，其他操作是被拒绝的。

`增加李刚的权限`  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 28]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 29]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_11_color_FFFFFF_t_70_g_se_x_16_pic_center]

#### 4.撤销权限 ####

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 30]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 31]

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

### 三、数据完整性 ###

#### 1.声明完整性约束 ####

`创建基本表及约束`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 32]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 33]  
`插入数据`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 34]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 35]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_19_color_FFFFFF_t_70_g_se_x_16_pic_center]

`修改约束`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 36]

#### 2.检查完整性约束 ####

`检查主键约束`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 37]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 38]

`检查唯一约束`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 39]

`检查默认值、允许空值列`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 40]

`检查非空约束`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 41]

`检查 CHECK 约束`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 42]  
`检查外键约束`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 43]

#### 3.触发器的定义及使用 ####

`定义触发器`

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 44]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 45]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 46]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 47]

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_16_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/8019d900d3ce40bfa0df1055e5ca352a.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_16,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/64b3f7fe51d24257b450fd89bb60956e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/b57566138a1443418ed0d513bc9c98c5.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center]: https://img-blog.csdnimg.cn/32ddf55bdd5148719c9038360c434b63.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_17_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/aa8626ccf43349ac8ee20805f065ed6f.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_17,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 1]: https://img-blog.csdnimg.cn/7e9a421695a840018b0c6df6b1ea73ae.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 2]: https://img-blog.csdnimg.cn/e21f457e1a5547d7b46c5b32bb690f3c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 3]: https://img-blog.csdnimg.cn/ee6dd96ad55340319e11c34868665e54.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 4]: https://img-blog.csdnimg.cn/336ebf2f7d034c99b41eb19b95c5d1ca.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 5]: https://img-blog.csdnimg.cn/ed98ac6671d34501ad94f26dcb5a0591.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 6]: https://img-blog.csdnimg.cn/cd63c0a6ebdb458a99cd4bfe4fbf3b06.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 7]: https://img-blog.csdnimg.cn/9d62babb95a84782a95f501b7ca36db4.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 8]: https://img-blog.csdnimg.cn/dbad570f55084e1ea86e77361ae59a33.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 9]: https://img-blog.csdnimg.cn/6831419797154466b700c84661dccf81.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 10]: https://img-blog.csdnimg.cn/f07c9c7ce0bd401c9db3a209dc78e73e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 11]: https://img-blog.csdnimg.cn/3ee27cecd76f4eac923f371eb3439c6e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 12]: https://img-blog.csdnimg.cn/3cdf7ecf73484afa8b25621c7b842b59.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 13]: https://img-blog.csdnimg.cn/883c53d086b64c60bde0765005943320.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 14]: https://img-blog.csdnimg.cn/1009ffac1adb433ab53e07c690664769.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 15]: https://img-blog.csdnimg.cn/86abd6269cc7403486d7284c312c7089.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 16]: https://img-blog.csdnimg.cn/b619c5415bce4d93b893d59a7a97428e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 17]: https://img-blog.csdnimg.cn/543631e0467e4e2ebbf68f93531337e1.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 18]: https://img-blog.csdnimg.cn/1bc53f7787784881b8a2c9503f9665ab.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 19]: https://img-blog.csdnimg.cn/ec1a9daa82c1465596a36c6ce8722e73.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 20]: https://img-blog.csdnimg.cn/a65ec8e239dd4dcbb5358512b852b2c4.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 21]: https://img-blog.csdnimg.cn/9e0ecf583d6b4447808622be1da117d6.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 22]: https://img-blog.csdnimg.cn/21c1a13220714109b756bbf1c8c33bfb.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_10_color_FFFFFF_t_70_g_se_x_16_pic_center]: https://img-blog.csdnimg.cn/d6994b1074c24edca208d0281dc32e4e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_10,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 23]: https://img-blog.csdnimg.cn/2f14dbc1e6f147f887bee93ccb71d024.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 24]: https://img-blog.csdnimg.cn/a35a809d8eb74e55ad7f29025a95bae9.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 25]: https://img-blog.csdnimg.cn/a5c08dc764d64df9a52b436855e2c9d2.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 26]: https://img-blog.csdnimg.cn/e7852e769fe64dd1bd261f18ca8c7ac0.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 27]: https://img-blog.csdnimg.cn/cddcc0ae4a814f9ab3d8be1409be1df7.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 28]: https://img-blog.csdnimg.cn/e4ccdc1d5d184058b5241c836a061942.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 29]: https://img-blog.csdnimg.cn/0971ee7e9e974897b19b64a046cc2c5a.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_11_color_FFFFFF_t_70_g_se_x_16_pic_center]: https://img-blog.csdnimg.cn/f5fa88de2dcd4efa9fbeb66707850542.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_11,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 30]: https://img-blog.csdnimg.cn/8a4d1eab00d5402eb28f1d3a0dbdb88f.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 31]: https://img-blog.csdnimg.cn/115ff4ac62b14477b7fc7585fe10992d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 32]: https://img-blog.csdnimg.cn/e87cc2920b8940b784fb54c103374e07.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 33]: https://img-blog.csdnimg.cn/62b3a2ec649446f29a56abd54ce8a49d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 34]: https://img-blog.csdnimg.cn/9627336f31a14ee3829a4ef06d93014e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 35]: https://img-blog.csdnimg.cn/9ff93af042bb4551bd22f13d85bbadab.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_19_color_FFFFFF_t_70_g_se_x_16_pic_center]: https://img-blog.csdnimg.cn/c72b3738f17c4d02888fc45db4bcc91c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_19,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 36]: https://img-blog.csdnimg.cn/2b5d4be03c124dfd9fe924f1827d1248.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 37]: https://img-blog.csdnimg.cn/02efdab5d3e24a52bb87b8db5a19fe0e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 38]: https://img-blog.csdnimg.cn/dc2b47226f714af591bc44f7850ca8fb.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 39]: https://img-blog.csdnimg.cn/7be9b08ee1524ff89ca9f9e7ad06315e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 40]: https://img-blog.csdnimg.cn/849d9a787271467eb81654c030506372.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 41]: https://img-blog.csdnimg.cn/9e7baeb3d61e4e439bcf58ef480aced7.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 42]: https://img-blog.csdnimg.cn/8f84d6d9a07547c891ec7d80967cdf75.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 43]: https://img-blog.csdnimg.cn/35d551135f7a496f9dabfcbf2e9faea2.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 44]: https://img-blog.csdnimg.cn/945a320de1bf4f19a465f1b929652e1d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 45]: https://img-blog.csdnimg.cn/800e83a554c54d54a8302586ecb78d60.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 46]: https://img-blog.csdnimg.cn/a07eefe4aa7544d9a05ca50b129af071.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5bCP54y05a2QIE02_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 47]: https://img-blog.csdnimg.cn/a856d0659364460aab56293aa1b9fe4b.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5bCP54y05a2QIE02,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center