Bootstrap4+MySQL前后端综合实训-Day06-AM【eclipse详细配置Tomcat、开发web项目、servlet、连接MySQL8.0数据库、用户登录界面的编写与验证、分页查询】

浅浅的花香味﹌ 2022-12-23 06:46 227阅读 0赞

> [【Bootstrap4前端框架+MySQL数据库】前后端综合实训【10天课程 博客汇总表 详细笔记】【附：实训所有代码】][Bootstrap4_MySQL_10_ _]

***目   录***

eclipse重置视图

MySQL数据库——建数据库、建数据库

sql代码

Tomcat环境配置

下载tomcat压缩包

百度搜索“Tomcat”

下载Tomcat压缩包

解压tomcat压缩包

在eclipse中配置tomcat环境

机房电脑

版本：eclipse-jee-2019-12-R-win32-x86\_64.zip

jdk版本太高，导致tomcat配置失败的说明

tomcat启动测试

tomcat按步骤配置仍然失败的解决方法——Projects Facts -> Runtimes

tomcat启动成功页面

tomcat启动失败——需要配置JAVA\_HOME

更改tomcat端口号

eclipse测试Java项目中的数据库连接类（实体类）

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException异常解决方法

MySQL8.0 jar包下载

eclipse——MySQL8.0连接数据库

新建web项目

将jar包放到lib文件夹下

Jnuit——测试

关闭项目

运行项目

用户登录界面的编写与验证

UserInfoDao.java（验证用户信息：遍历数据表）

LoginServlet.java（跳转到servlet验证用户信息）

登录失败，重新登录页面（servlet重定向）

分页查询用户数据

下载 bootstrap-table

在html页面中引入bootstrap-table

返回json格式数据

fast JSON——jar包

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

# eclipse重置视图 #

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70][]

# MySQL数据库——建数据库、建数据库 #

## sql代码 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1][]

/*
    SQLyog Ultimate v11.22 (64 bit)
    MySQL - 5.5.56 : Database - news_manager
    *********************************************************************
    */
    
    
    /*!40101 SET NAMES utf8 */;
    
    /*!40101 SET SQL_MODE=''*/;
    
    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    CREATE DATABASE /*!32312 IF NOT EXISTS*/`news_manager` /*!40100 DEFAULT CHARACTER SET utf8 */;
    
    USE `news_manager`;
    
    /*Table structure for table `item_user` */
    
    DROP TABLE IF EXISTS `item_user`;
    
    CREATE TABLE `item_user` (
      `item_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户栏目关系主键',
      `user_id` int(11) DEFAULT NULL COMMENT '用户主键ID',
      `item_id` int(11) DEFAULT NULL COMMENT '栏目ID',
      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
      PRIMARY KEY (`item_user_id`),
      KEY `FK_Reference_1` (`user_id`),
      KEY `FK_Reference_2` (`item_id`),
      CONSTRAINT `FK_Reference_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`user_id`),
      CONSTRAINT `FK_Reference_2` FOREIGN KEY (`item_id`) REFERENCES `news_item` (`item_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='栏目与用户之间的关系表';
    
    /*Data for the table `item_user` */
    
    insert  into `item_user`(`item_user_id`,`user_id`,`item_id`,`create_time`,`update_time`) values (1,1,1,'2020-11-19 16:09:41','2020-11-19 16:10:58'),(2,1,2,'2020-11-19 16:09:50','2020-11-19 16:11:21'),(3,2,4,'2020-11-19 16:11:31','2020-11-19 16:11:35');
    
    /*Table structure for table `logs_info` */
    
    DROP TABLE IF EXISTS `logs_info`;
    
    CREATE TABLE `logs_info` (
      `logs_id` int(11) NOT NULL AUTO_INCREMENT,
      `user_id` int(11) DEFAULT NULL COMMENT '用户主键ID',
      `logs_content` char(10) DEFAULT NULL,
      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
      PRIMARY KEY (`logs_id`),
      KEY `FK_Reference_4` (`user_id`),
      CONSTRAINT `FK_Reference_4` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`user_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='操作日志表';
    
    /*Data for the table `logs_info` */
    
    insert  into `logs_info`(`logs_id`,`user_id`,`logs_content`,`create_time`,`update_time`) values (1,1,'login','2020-11-19 16:11:51','2020-11-19 16:11:56'),(2,2,'delete:new','2020-11-19 16:12:25','2020-11-19 16:12:45'),(3,4,'insert:new','2020-11-19 16:13:17','2020-11-19 16:13:21');
    
    /*Table structure for table `news_info` */
    
    DROP TABLE IF EXISTS `news_info`;
    
    CREATE TABLE `news_info` (
      `news_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '新闻主键',
      `item_id` int(11) DEFAULT NULL COMMENT '栏目ID',
      `news_title` varchar(255) NOT NULL COMMENT '新闻标题',
      `news_image` varchar(255) DEFAULT NULL COMMENT '新闻图片',
      `news_content` text COMMENT '新闻内容',
      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
      PRIMARY KEY (`news_id`),
      KEY `FK_Reference_3` (`item_id`),
      CONSTRAINT `FK_Reference_3` FOREIGN KEY (`item_id`) REFERENCES `news_item` (`item_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='新闻详情表';
    
    /*Data for the table `news_info` */
    
    insert  into `news_info`(`news_id`,`item_id`,`news_title`,`news_image`,`news_content`,`create_time`,`update_time`) values (2,3,'图书馆维修，暂停开放一天','','新学期学费......','2020-11-19 16:09:21','2020-11-23 09:17:09'),(3,1,'新能源召回大户特斯拉的“美式”傲慢｜观潮','http://pics1.baidu.com/feed/71cf3bc79f3df8dcecfa18268a75ee8c46102829.jpeg?token=32875797d2ded1ed2a9334df610bccf7','新浪科技 花子健\r\n从“硬件升级”到“召回”，理想汽车只用了5天。\r\n而不久前的威马汽车召回事件，前后耗时23天，威马汽车将之定义为“史上最快召回”。如果仅仅是简单对比，理想汽车无疑刷新了历史记录。\r\n对于新造车势力来说，受限于工艺和新技术，召回是大概率事件。目前除了小鹏未有实际的召回经历之外，蔚来汽车、威马汽车以及理想汽车，包括外来者特斯拉，都遇到过召回。只不过，中国新造车势力和特斯拉表现出来的态度截然不同。\r\n“惶恐”的造车新势力\r\n11月1日，理想汽车在媒体沟通会上宣布了针对前悬架下摆臂球销和底盘的“免费升级”，其中前悬架下摆臂球销受力太低与理想ONE多次出现断轴事件有关系。\r\n但理想汽车的措辞遭到质疑。一方面是理想汽车CEO李想公开承认“升级肯定是因为产品有缺陷，我们是在行驶当中发生碰撞断掉的几率高于平均值。”而另外一方面，则是在一开始否认“召回”，以“免费升级”代替。\r\n理想汽车销售服务副总裁刘杰强调，升级和那种由于车辆本身在行驶过程中出现故障和质量问题的召回，是不一样的。11月6日，理想汽车最终宣布召回10469辆理想ONE，占已交付车辆的将近50%。\r\n官方披露的信息显示，截至2020年10月31日，理想ONE累计发生了97起前悬架碰撞事故，其中前悬架下摆臂球头从球销脱出的情况超过10起，造成了理想汽车在碰撞之后断轴的严重事故。','2020-11-23 09:01:17','2020-11-23 09:01:17');
    
    /*Table structure for table `news_item` */
    
    DROP TABLE IF EXISTS `news_item`;
    
    CREATE TABLE `news_item` (
      `item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '栏目ID',
      `item_name` varchar(255) NOT NULL COMMENT '栏目名称',
      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
      PRIMARY KEY (`item_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='新闻栏目';
    
    /*Data for the table `news_item` */
    
    insert  into `news_item`(`item_id`,`item_name`,`create_time`,`update_time`) values (1,'新闻处',NULL,'2020-11-19 16:04:37'),(2,'教务处',NULL,'2020-11-19 16:04:37'),(3,'财务处',NULL,'2020-11-19 16:04:38'),(4,'保卫处',NULL,'2020-11-19 16:04:38');
    
    /*Table structure for table `user_info` */
    
    DROP TABLE IF EXISTS `user_info`;
    
    CREATE TABLE `user_info` (
      `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户主键ID',
      `user_name` varchar(255) NOT NULL COMMENT '用户名',
      `user_pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户密码',
      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
      PRIMARY KEY (`user_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8 COMMENT='用户信息表';
    
    /*Data for the table `user_info` */
    
    insert  into `user_info`(`user_id`,`user_name`,`user_pwd`,`create_time`,`update_time`) values (1,'zhangsan','123','2020-11-19 14:30:51','2020-11-20 09:59:57'),(2,'李四','234','2020-11-19 14:34:49','2020-11-19 14:35:36'),(4,'王五','123','2020-11-19 16:03:02','2020-11-19 16:03:02'),(5,'赵柳','123456','2020-11-20 09:15:26','2020-11-20 09:15:26'),(8,'田七','123456','2020-11-20 09:43:30','2020-11-20 09:43:30'),(11,'123213','31231','2020-11-23 14:20:42','2020-11-23 14:20:44'),(12,'234234','43564564','2020-11-23 14:20:47','2020-11-23 14:20:51'),(13,'userName1','123456','2020-11-23 14:21:55','2020-11-23 14:21:55'),(14,'userName2','123456','2020-11-23 14:21:55','2020-11-23 14:21:55'),(15,'userName3','123456','2020-11-23 14:21:55','2020-11-23 14:21:55'),(16,'userName4','123456','2020-11-23 14:21:55','2020-11-23 14:21:55'),(17,'userName5','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(18,'userName6','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(19,'userName7','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(20,'userName8','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(21,'userName9','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(22,'userName10','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(23,'userName11','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(24,'userName12','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(25,'userName13','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(26,'userName14','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(27,'userName15','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(28,'userName16','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(29,'userName17','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(30,'userName18','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(31,'userName19','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(32,'userName20','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(33,'userName21','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(34,'userName22','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(35,'userName23','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(36,'userName24','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(37,'userName25','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(38,'userName26','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(39,'userName27','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(40,'userName28','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(41,'userName29','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(42,'userName30','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(43,'userName31','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(44,'userName32','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(45,'userName33','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(46,'userName34','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(47,'userName35','123456','2020-11-23 14:21:56','2020-11-23 14:21:56'),(48,'userName36','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(49,'userName37','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(50,'userName38','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(51,'userName39','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(52,'userName40','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(53,'userName41','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(54,'userName42','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(55,'userName43','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(56,'userName44','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(57,'userName45','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(58,'userName46','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(59,'userName47','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(60,'userName48','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(61,'userName49','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(62,'userName50','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(63,'userName51','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(64,'userName52','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(65,'userName53','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(66,'userName54','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(67,'userName55','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(68,'userName56','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(69,'userName57','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(70,'userName58','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(71,'userName59','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(72,'userName60','123456','2020-11-23 14:21:57','2020-11-23 14:21:57'),(73,'userName61','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(74,'userName62','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(75,'userName63','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(76,'userName64','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(77,'userName65','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(78,'userName66','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(79,'userName67','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(80,'userName68','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(81,'userName69','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(82,'userName70','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(83,'userName71','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(84,'userName72','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(85,'userName73','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(86,'userName74','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(87,'userName75','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(88,'userName76','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(89,'userName77','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(90,'userName78','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(91,'userName79','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(92,'userName80','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(93,'userName81','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(94,'userName82','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(95,'userName83','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(96,'userName84','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(97,'userName85','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(98,'userName86','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(99,'userName87','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(100,'userName88','123456','2020-11-23 14:21:58','2020-11-23 14:21:58'),(101,'userName89','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(102,'userName90','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(103,'userName91','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(104,'userName92','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(105,'userName93','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(106,'userName94','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(107,'userName95','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(108,'userName96','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(109,'userName97','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(110,'userName98','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(111,'userName99','123456','2020-11-23 14:21:59','2020-11-23 14:21:59'),(112,'userName100','123456','2020-11-23 14:21:59','2020-11-23 14:21:59');
    
    /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

# Tomcat环境配置 #

## 下载tomcat压缩包 ##

### 百度搜索“Tomcat” ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2][]

### 下载Tomcat压缩包 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3][]
> 
> ![20201123164828415.png][]

### 解压tomcat压缩包 ###

> ![20201123165013902.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4][]

## 在eclipse中配置tomcat环境 ##

### 机房电脑 ###

> ![20201123165316163.png][]   ![2020112316533923.png][]
> 
> ![20201123165415434.png][]
> 
> ![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][]
> 
> 选择tomcat压缩包的解压路径（bin的上一级目录）：
> 
> ![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][]
> 
> ![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][]

### 版本：eclipse-jee-2019-12-R-win32-x86\_64.zip ###

> ![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][]
> 
> 选择tomcat压缩包的解压路径（bin的上一级目录）：
> 
> ![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][]
> 
> 选择tomcat压缩包的解压路径（bin的上一级目录）：
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 21][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 22][]
> 
> ![20201124001613217.png][]
> 
> ![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][]

### jdk版本太高，导致tomcat配置失败的说明 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 26][]
> 
> 删除eclipse... 重新搞一遍...
> 
> jdk11版本太高，把jdk卸载干净，换成jdk8就行了。
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 27][]

## tomcat启动测试 ##

> ![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][]

### tomcat按步骤配置仍然失败的解决方法——Projects Facts -> Runtimes ###

> 关闭eclipse，重新打开eclipse，应该也可以。
> 
> ![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][]

### tomcat启动成功页面 ###

>  *  [http://127.0.0.1:8080/][http_127.0.0.1_8080]
>  *  [http://localhost:8080/][http_localhost_8080]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 33][]

## tomcat启动失败——需要配置JAVA\_HOME ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 34][]
> 
> C:\\Java\\jdk1.8.0\_152
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 35][]
> 
> ![20201123170943274.png][]

## 更改tomcat端口号 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 36][]

# eclipse测试Java项目中的数据库连接类（实体类） #

> 5个数据表：每个数据表都要有3个相应的Java类。
> 
> ![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][]

> **package com.newcapec.dao; // dao层包（模板Dao）模板代码、固定写法**
> 
>  *  BaseDao.java：应用于5个数据表的Java接口 实现“增删改查”的接口
> 
> **package com.newcapec.entity; // 实体entity**
> 
>  *  NewsInfoEntity.java：新闻实体类
>  *  UserInfoEntity.java：管理员实体类
> 
> **package com.newcapec.test; // 测试包**
> 
> **package com.newcapec.utils; // 工具包**
> 
>  *  DBUtils.java：获取数据库连接的工具类
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 39][]   ![20201123231848426.png][]

## com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException异常解决方法 ##

> [原文链接][Link 1]
> 
>  *  第1步：使用最新的MySQL驱动jar包。
>  *  第2步：把驱动的类名改为：`static String driver="com.mysql.cj.jdbc.Driver";`
>  *  第3步：在访问mysql的url后加入时区设置：`static String url="jdbc:mysql://localhost:3306/test?characterEncoding=utf-8&serverTimezone=UTC"; // `(UTC表示标准时区)

## MySQL8.0 jar包下载 ##

> [原文链接][Link 2]——[mysql 8.0.15 jar包下载地址][mysql 8.0.15 jar]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 40][]
> 
> ![20201123233813920.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 41][]

package com.newcapec.utils;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    
    import com.mysql.jdbc.Driver;
    
    /**
     * 获取与数据库的连接 此处后期需要使用阿里巴巴的druid数据库连接池优化
     * 
     * @author user
     *
     */
    public class DBUtils {
    	
    	public static Connection openConn() throws ClassNotFoundException, SQLException {
    		// 连接数据库四要素
    		// url username password driver
    		String user = "root";
    		String password = "root";
    //		String driver = "com.mysql.jdbc.Driver";
    //		String url = "jdbc:mysql://127.0.0.1:3306/news_manager?characterEncoding=UTF-8";
    		String driver = "com.mysql.cj.jdbc.Driver";
    		String url = "jdbc:mysql://localhost:3306/news_manager?characterEncoding=utf-8&serverTimezone=UTC";// (UTC表示标准时区)
    		// 注册数据库驱动
    		Class.forName(driver);
    		return DriverManager.getConnection(url, user, password);
    	}
    
    }

## eclipse——MySQL8.0连接数据库 ##

> [原文链接：JavaWeb 中 MySQL8.0.19 解决java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver的问题][JavaWeb _ MySQL8.0.19 _java.lang.ClassNotFoundException_ com.mysql.cj.jdbc.Driver]
> 
> **问题所在：**我电脑MySQL版本是8.0.19，但是mysql的jar包却是5.1.39的，jar包与本地MySQL版本不对应导致。  
> **解决步骤：**  
> 1.首先将websurver/WebContent/WEB-INF/lib/目录下的mysql-connecctor-java-5.1.39-bin.jar删除，然后将mysql-connector-java-8.0.19.jar引入。右击mysql-connector-java-8.0.19.jar选择图中的选项，将其Add to Build Path。  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5MTU2Nzcw_size_16_color_FFFFFF_t_70]   ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 42][]  
> 然后在Java Build Path中显示如图，  
> ![在这里插入图片描述][20200328220516112.png]  
> 2. 将Class.forName的内容换成”com.mysql.cj.jdbc.Driver”  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5MTU2Nzcw_size_16_color_FFFFFF_t_70 1]
> 
> 3.在conn = DriverManager.getConnection中添加serverTimezone = GMT%2B8，如图。完成之后就不会再报错了。  
> ![在这里插入图片描述][20200328220611311.png]

> 数据库连接成功！
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 43][]

# 新建web项目 #

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 44][]   ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 45][]
> 
> ![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][]   ![20201124162403972.png][]

## 将jar包放到lib文件夹下 ##

> ![20201124162647747.png][]

## Jnuit——测试 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 49][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 50][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 51][]   ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 52][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 53][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 54][]

# 关闭项目 #

> 把不用的项目关闭！！！
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 55][]

# 运行项目 #

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 56][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 57][]   ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 58][]

# 用户登录界面的编写与验证 #

> ![20201124171304963.png][]
> 
> 在login.html页面提交用户信息（用户名与密码），后台跳转到LoginServlet.java页面，在LoginServlet.java页面调用UserInfoDao.java中的login()方法遍历数据表，验证用户信息。

## login.html（用户登录页面） ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 59][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 60][]

<!DOCTYPE html>
    <html>
    <head>
    <meta charset="utf-8">
    <title></title>
    
    <link rel="stylesheet" href="bootstrap4/css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="font-awesome-4.7.0/css/font-awesome.min.css" />
    
    <script src="jquery/jquery.min.js"></script>
    
    <script src="js/popper.min.js"></script>
    
    <script src="bootstrap4/js/bootstrap.min.js"></script>
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <style type="text/css">
    	header, footer {
    		height: 100px;
    		/* background-color: #005CBF; */
    	}
    	
    	body {
    		display: flex;
    		flex-direction: column;
    		min-height: 100vh;
    	}
    	
    	#main {
    		flex-grow: 1;
    		background-image: url(img/banner.jpg);
    		background-repeat: no-repeat;
    		background-size: cover;
    		display: flex;
    		align-items: center;
    		justify-content: flex-end;
    	}
    	
    	#login {
    		height: 400px;
    		width: 400px;
    		background-color: white;
    		margin-right: 100px;
    		border-radius: 10px;
    	}
    </style>
    <title>login</title>
    </head>
    <body>
    	<header></header>
    	<div id="main">
    		<div id="login">
    			<form style="padding: 20px;" action="LoginServlet" method="post">
    				<div class="input-group mb-3">
    					<div class="input-group-prepend">
    						<span class="input-group-text"><i class="fa fa-user"></i></span>
    					</div>
    					<input type="text" name="userName" class="form-control"	placeholder="请输入用户名">
    				</div>
    				<div class="input-group mb-3">
    					<div class="input-group-prepend">
    						<span class="input-group-text"><i class="fa fa-lock"></i></span>
    					</div>
    					<input type="text" name="userPwd" class="form-control" placeholder="Username">
    				</div>
    				<button type="submit" class="btn btn-info form-control">登录</button>
    			</form>
    		</div>
    	</div>
    	<footer></footer>
    </body>
    </html>

## UserInfoDao.java（验证用户信息：遍历数据表） ##

> 主要是login()方法对用户信息进行验证！
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 61][]

## LoginServlet.java（跳转到servlet验证用户信息） ##

package com.newcapec.servlet;
    
    import java.io.IOException;
    import java.sql.SQLException;
    
    import javax.servlet.ServletException;
    import javax.servlet.annotation.WebServlet;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import com.newcapec.dao.UserInfoDao;
    import com.newcapec.entity.UserInfoEntity;
    
    /**
     * Servlet implementation class LoginServlet
     */
    @WebServlet(name = "/LoginServlet", urlPatterns = "/LoginServlet")
    public class LoginServlet extends HttpServlet {
    	
    	private UserInfoDao userInfoDao = new UserInfoDao();
    	private static final long serialVersionUID = 1L;
    
    	/**
    	 * @see HttpServlet#HttpServlet()
    	 */
    	public LoginServlet() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	/**
    	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		// TODO Auto-generated method stub
    		response.getWriter().append("Served at: ").append(request.getContextPath());
    	}
    
    	/**
    	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    	 *      response)
    	 */
    	// 注意：在正规开发中 登录密码需要加密
    	// 需要有验证码
    	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		request.setCharacterEncoding("UTF-8");
    		String userName = request.getParameter("userName");
    		String userPwd = request.getParameter("userPwd");
    		try {
    			UserInfoEntity userInfoEntity = userInfoDao.login(userName, userPwd);
    			if (userInfoEntity != null) {
    				// 登录成功
    				request.getSession().setAttribute("userInfo", userInfoEntity);
    				response.sendRedirect("index.html");
    			} else {
    				// 登录失败 重定向
    				response.sendRedirect("loginFailure.html");
    			}
    		} catch (ClassNotFoundException | SQLException e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    
    }

### 登录失败，重新登录页面（servlet重定向） ###

>  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 62][]

# 分页查询用户数据 #

## 下载 bootstrap-table ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 63][]

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 64][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 65][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 66][]
> 
> ![20201124180736209.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 67][]   ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 68][]

### 在html页面中引入bootstrap-table ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 69][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 70][]

## 返回json格式数据 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 71][]

### fast JSON——jar包 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 72][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 73][]

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 74][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 75][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 76][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 77][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 78][]
> 
> ![20201124183743495.png][]

> ![20201124183849278.png][]

> ![20201124185037711.png][]
> 
> [分页查询代码详见：Bootstrap4+MySQL前后端综合实训-Day06-PM【分页查询用户数据】][Bootstrap4_MySQL_-Day06-PM]

[Bootstrap4_MySQL_10_ _]: https://blog.csdn.net/weixin_44949135/article/details/109722002
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70]: /images/20221120/73b82173a59246f1ad48cdc58ac1e6ce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1]: /images/20221120/9068f28f58b64caeb29ca422c12f510a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2]: /images/20221120/c2270b18aea84a98a8571ff255383308.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201123164344423.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201123164828415.png]: https://img-blog.csdnimg.cn/20201123164828415.png
[20201123165013902.png]: https://img-blog.csdnimg.cn/20201123165013902.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201123165225875.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201123165316163.png]: https://img-blog.csdnimg.cn/20201123165316163.png
[2020112316533923.png]: https://img-blog.csdnimg.cn/2020112316533923.png
[20201123165415434.png]: https://img-blog.csdnimg.cn/20201123165415434.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20201123165451190.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 6]: https://img-blog.csdnimg.cn/20201123165510148.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]: https://img-blog.csdnimg.cn/2020112316553027.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 8]: https://img-blog.csdnimg.cn/20201123165554808.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]: https://img-blog.csdnimg.cn/20201123165619554.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 10]: https://img-blog.csdnimg.cn/20201123165646697.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]: https://img-blog.csdnimg.cn/20201123165657271.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 12]: https://img-blog.csdnimg.cn/20201123165800113.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]: https://img-blog.csdnimg.cn/2020112400055792.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 14]: https://img-blog.csdnimg.cn/20201124000655946.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]: https://img-blog.csdnimg.cn/202011240007461.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 16]: https://img-blog.csdnimg.cn/20201124001100238.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]: https://img-blog.csdnimg.cn/20201124001218353.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 18]: https://img-blog.csdnimg.cn/2020112400134397.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 19]: https://img-blog.csdnimg.cn/20201124001440513.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]: https://img-blog.csdnimg.cn/20201124001517981.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 21]: https://img-blog.csdnimg.cn/20201124001544497.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 22]: https://img-blog.csdnimg.cn/20201124001559926.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201124001613217.png]: https://img-blog.csdnimg.cn/20201124001613217.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 23]: https://img-blog.csdnimg.cn/20201124001625490.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]: https://img-blog.csdnimg.cn/2020112400163860.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 25]: https://img-blog.csdnimg.cn/20201124001651425.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 26]: https://img-blog.csdnimg.cn/20201124001921125.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 27]: https://img-blog.csdnimg.cn/20201124154141668.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 28]: https://img-blog.csdnimg.cn/20201123170039400.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]: https://img-blog.csdnimg.cn/20201124003144963.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 30]: https://img-blog.csdnimg.cn/20201123170615265.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]: https://img-blog.csdnimg.cn/20201124172720695.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 32]: https://img-blog.csdnimg.cn/2020112417280051.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[http_127.0.0.1_8080]: http://127.0.0.1:8080/
[http_localhost_8080]: http://localhost:8080/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 33]: https://img-blog.csdnimg.cn/20201123171222865.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 34]: https://img-blog.csdnimg.cn/20201123170212760.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]: https://img-blog.csdnimg.cn/20201123170826396.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201123170943274.png]: https://img-blog.csdnimg.cn/20201123170943274.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 36]: https://img-blog.csdnimg.cn/20201124161937965.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]: https://img-blog.csdnimg.cn/20201123232254816.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 38]: https://img-blog.csdnimg.cn/20201123233250876.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 39]: https://img-blog.csdnimg.cn/20201123231830581.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201123231848426.png]: https://img-blog.csdnimg.cn/20201123231848426.png
[Link 1]: https://blog.csdn.net/q1406689423/article/details/89845338
[Link 2]: https://blog.csdn.net/mlhr666/article/details/88563893
[mysql 8.0.15 jar]: https://dev.mysql.com/downloads/file/?id=484819
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 40]: https://img-blog.csdnimg.cn/20201123233734108.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201123233813920.png]: https://img-blog.csdnimg.cn/20201123233813920.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 41]: https://img-blog.csdnimg.cn/20201123233832531.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[JavaWeb _ MySQL8.0.19 _java.lang.ClassNotFoundException_ com.mysql.cj.jdbc.Driver]: https://blog.csdn.net/qq_39156770/article/details/105169689
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5MTU2Nzcw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200328215945354.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5MTU2Nzcw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 42]: https://img-blog.csdnimg.cn/20201124155700597.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20200328220516112.png]: https://img-blog.csdnimg.cn/20200328220516112.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5MTU2Nzcw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200328220545259.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5MTU2Nzcw,size_16,color_FFFFFF,t_70
[20200328220611311.png]: https://img-blog.csdnimg.cn/20200328220611311.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 43]: https://img-blog.csdnimg.cn/20201124155731345.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 44]: https://img-blog.csdnimg.cn/20201124160548992.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 45]: https://img-blog.csdnimg.cn/20201124162249789.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 46]: https://img-blog.csdnimg.cn/2020112416230126.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 47]: https://img-blog.csdnimg.cn/20201124162320710.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 48]: https://img-blog.csdnimg.cn/2020112416244270.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201124162403972.png]: https://img-blog.csdnimg.cn/20201124162403972.png
[20201124162647747.png]: https://img-blog.csdnimg.cn/20201124162647747.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 49]: https://img-blog.csdnimg.cn/20201124162748703.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 50]: https://img-blog.csdnimg.cn/20201124162811387.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 51]: https://img-blog.csdnimg.cn/20201124162840170.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 52]: https://img-blog.csdnimg.cn/20201124162852203.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 53]: https://img-blog.csdnimg.cn/20201124162909242.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 54]: https://img-blog.csdnimg.cn/20201124164124970.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 55]: https://img-blog.csdnimg.cn/20201124165639431.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 56]: https://img-blog.csdnimg.cn/20201124165823797.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 57]: https://img-blog.csdnimg.cn/20201124170000425.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 58]: https://img-blog.csdnimg.cn/20201124170021100.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201124171304963.png]: https://img-blog.csdnimg.cn/20201124171304963.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 59]: https://img-blog.csdnimg.cn/20201124170617135.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 60]: https://img-blog.csdnimg.cn/20201124171906662.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 61]: https://img-blog.csdnimg.cn/20201124171047381.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 62]: https://img-blog.csdnimg.cn/20201124172105272.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 63]: https://img-blog.csdnimg.cn/20201124180647357.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 64]: https://img-blog.csdnimg.cn/20201124180752480.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 65]: https://img-blog.csdnimg.cn/20201124180807976.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 66]: https://img-blog.csdnimg.cn/2020112418083520.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201124180736209.png]: https://img-blog.csdnimg.cn/20201124180736209.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 67]: https://img-blog.csdnimg.cn/2020112418100315.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 68]: https://img-blog.csdnimg.cn/20201124181105364.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 69]: https://img-blog.csdnimg.cn/20201124182011969.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 70]: https://img-blog.csdnimg.cn/20201124182457376.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 71]: https://img-blog.csdnimg.cn/20201124182841693.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 72]: https://img-blog.csdnimg.cn/20201124183058650.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 73]: https://img-blog.csdnimg.cn/20201124183225475.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 74]: https://img-blog.csdnimg.cn/2020112418335068.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 75]: https://img-blog.csdnimg.cn/20201124183414289.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 76]: https://img-blog.csdnimg.cn/20201124183456145.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 77]: https://img-blog.csdnimg.cn/20201124183539424.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 78]: https://img-blog.csdnimg.cn/20201124183625270.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[20201124183743495.png]: https://img-blog.csdnimg.cn/20201124183743495.png
[20201124183849278.png]: https://img-blog.csdnimg.cn/20201124183849278.png
[20201124185037711.png]: https://img-blog.csdnimg.cn/20201124185037711.png
[Bootstrap4_MySQL_-Day06-PM]: https://blog.csdn.net/weixin_44949135/article/details/110000993