springboot+mybatis+bootstrap+jsp+pagehelper实现分页查询

springboot+jsp实现分页查询

• 新建项目我就不说了，这里就当完成了，。。。。。还是说点吧！ 省略pagehelper具体用法，省略pom文件里的一些依赖解释，省略分页的具体操作， 我写的这篇博客，只要你会Ctrl+c+v就会了。
  
  项目建好，这里我的项目名是 springbootmybatisjsp ，文件是application.yml 样式模块是bootstrap
  项目目录结构如下图
  

数据库数据

user表

/*
Navicat MySQL Data Transfer

Source Server         : 何城东
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : user

Target Server Type    : MYSQL
Target Server Version : 50624
File Encoding         : 65001

Date: 2019-08-30 12:48:21
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `pass` varchar(255) DEFAULT NULL,
  `sexid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '何城东', '521', '1');
INSERT INTO `user` VALUES ('2', '李冠频', '123', '1');
INSERT INTO `user` VALUES ('3', '李明杨', '456', '1');
INSERT INTO `user` VALUES ('4', '贺小田 ', '789 ', '1');
INSERT INTO `user` VALUES ('5', '彭婕', '111', '0');
INSERT INTO `user` VALUES ('6', '刘艳玲', '121', '0');
INSERT INTO `user` VALUES ('7', '胡雪宁', '122', '0');
INSERT INTO `user` VALUES ('8', '简学云', '445', '1');
INSERT INTO `user` VALUES ('9', '郭圆', '777', '0');
INSERT INTO `user` VALUES ('10', '隆琴', '999', '0');
INSERT INTO `user` VALUES ('11', '公子', '269', '0');

usersex表

/*
Navicat MySQL Data Transfer

Source Server         : 何城东
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : user

Target Server Type    : MYSQL
Target Server Version : 50624
File Encoding         : 65001

Date: 2019-08-30 12:48:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for usersex
-- ----------------------------
DROP TABLE IF EXISTS `usersex`;
CREATE TABLE `usersex` (
  `sexid` int(11) NOT NULL,
  `sex` varchar(255) NOT NULL,
  PRIMARY KEY (`sexid`,`sex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of usersex
-- ----------------------------
INSERT INTO `usersex` VALUES ('0', '女');
INSERT INTO `usersex` VALUES ('1', '男');

接下来把原有的application.protest删了，新建application.yml，并在里面放入如图

server:
  port: 8080

spring:
  mvc:
    view:
      suffix: .jsp
      prefix: /WEB-INF/jsp/
  datasource:
    name: test
    url: jdbc:mysql://localho