首页 / 更多教程 / SpringBoot 分页处理
SpringBoot 分页处理
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了SpringBoot 分页处理，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含34437字，纯文字阅读大概需要50分钟。
内容图文
开始主要是要使用已经设计好的数据库
--
----------------------------------------------------
--
用户
--
----------------------------------------------------
--
Table structure for `sys_user`
--
----------------------------------------------------
CREATE
TABLE
`sys_user` (
`id`
bigint
NOT
NULL AUTO_INCREMENT COMMENT ‘编号‘,
`name` varchar(50) NOTNULL COMMENT ‘用户名‘,
`password` varchar(100) COMMENT ‘密码‘,
`salt` varchar(40) COMMENT ‘盐‘,
`email` varchar(100) COMMENT ‘邮箱‘,
`mobile` varchar(100) COMMENT ‘手机号‘,
`status` tinyint COMMENT ‘状态 0：禁用 1：正常‘,
`dept_id` bigint(20) COMMENT ‘机构ID‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
`del_flag` tinyintDEFAULT0 COMMENT ‘是否删除 -1：已删除 0：正常‘,
PRIMARYKEY (`id`),
UNIQUEINDEX (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘用户‘;
-- ----------------------------------------------------
-- 机构
-- ------------------------------------------------
-- Table structure for `sys_dept`
-- ------------------------------------------------CREATETABLE `sys_dept` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`name` varchar(50) COMMENT ‘机构名称‘,
`parent_id` bigint COMMENT ‘上级机构ID，一级机构为0‘,
`order_num` int COMMENT ‘排序‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
`del_flag` tinyintDEFAULT0 COMMENT ‘是否删除 -1：已删除 0：正常‘,
PRIMARYKEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘机构管理‘;
-- ------------------------------------------------
-- 角色
-- ------------------------------------------------
-- Table structure for `sys_role`
-- ------------------------------------------------CREATETABLE `sys_role` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`name` varchar(100) COMMENT ‘角色名称‘,
`remark` varchar(100) COMMENT ‘备注‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
`del_flag` tinyintDEFAULT0 COMMENT ‘是否删除 -1：已删除 0：正常‘,
PRIMARYKEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘角色‘;
-- ------------------------------------------------
-- 菜单
-- ------------------------------------------------
-- Table structure for `sys_menu`
-- ------------------------------------------------CREATETABLE `sys_menu` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`name` varchar(50) COMMENT ‘菜单名称‘,
`parent_id` bigint COMMENT ‘父菜单ID，一级菜单为0‘,
`url` varchar(200) COMMENT ‘菜单URL‘,
`perms` varchar(500) COMMENT ‘授权(多个用逗号分隔，如：user:view,user:create)‘,
`type` int COMMENT ‘类型 0：目录 1：菜单 2：按钮‘,
`icon` varchar(50) COMMENT ‘菜单图标‘,
`order_num` int COMMENT ‘排序‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
`del_flag` tinyintDEFAULT0 COMMENT ‘是否删除 -1：已删除 0：正常‘,
PRIMARYKEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘菜单管理‘;
-- ------------------------------------------------
-- 用户与角色对应关系
-- ------------------------------------------------
-- Table structure for `sys_user_role`
-- ------------------------------------------------CREATETABLE `sys_user_role` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`user_id` bigint COMMENT ‘用户ID‘,
`role_id` bigint COMMENT ‘角色ID‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
PRIMARYKEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘用户与角色对应关系‘;
-- ------------------------------------------------
-- 角色与机构对应关系
-- ------------------------------------------------
-- Table structure for `sys_role_dept`
-- ------------------------------------------------CREATETABLE `sys_role_dept` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`role_id` bigint COMMENT ‘角色ID‘,
`dept_id` bigint COMMENT ‘机构ID‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
PRIMARYKEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘角色与机构对应关系‘;
-- ------------------------------------------------
-- 角色与菜单对应关系
-- ------------------------------------------------
-- Table structure for `sys_role_menu`
-- ------------------------------------------------CREATETABLE `sys_role_menu` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`role_id` bigint COMMENT ‘角色ID‘,
`menu_id` bigint COMMENT ‘菜单ID‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
PRIMARYKEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘角色与菜单对应关系‘;
-- ------------------------------------------------
-- 用户Token
-- ------------------------------------------------
-- Table structure for `sys_user_token`
-- ------------------------------------------------CREATETABLE `sys_user_token` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`user_id` bigintNOTNULL,
`token` varchar(100) NOTNULL COMMENT ‘token‘,
`expire_time` datetimeDEFAULTNULL COMMENT ‘过期时间‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
PRIMARYKEY (`id`),
UNIQUEKEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘用户Token‘;
-- ------------------------------------------------
-- 系统日志
-- ------------------------------------------------
-- Table structure for `sys_log`
-- ------------------------------------------------CREATETABLE `sys_log` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`user_name` varchar(50) COMMENT ‘用户名‘,
`operation` varchar(50) COMMENT ‘用户操作‘,
`method` varchar(200) COMMENT ‘请求方法‘,
`params` varchar(5000) COMMENT ‘请求参数‘,
`time` bigintNOTNULL COMMENT ‘执行时长(毫秒)‘,
`ip` varchar(64) COMMENT ‘IP地址‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
PRIMARYKEY (`id`)
) ENGINE=`InnoDB` DEFAULTCHARACTERSET utf8 COMMENT=‘系统日志‘;
-- ------------------------------------------------
-- 数据字典
-- ------------------------------------------------
-- Table structure for `sys_dict`
-- ------------------------------------------------DROPTABLEIFEXISTS `sys_dict`;
CREATETABLE `sys_dict` (
`id` bigintNOTNULL AUTO_INCREMENT COMMENT ‘编号‘,
`value` varchar(100) NOTNULL COMMENT ‘数据值‘,
`label` varchar(100) NOTNULL COMMENT ‘标签名‘,
`type` varchar(100) NOTNULL COMMENT ‘类型‘,
`description` varchar(100) NOTNULL COMMENT ‘描述‘,
`sort` decimal(10,0) NOTNULL COMMENT ‘排序（升序）‘,
`create_by` varchar(50) COMMENT ‘创建人‘,
`create_time` datetime COMMENT ‘创建时间‘,
`last_update_by` varchar(50) COMMENT ‘更新人‘,
`last_update_time` datetime COMMENT ‘更新时间‘,
`remarks` varchar(255) DEFAULTNULL COMMENT ‘备注信息‘,
`del_flag` tinyintDEFAULT0 COMMENT ‘是否删除 -1：已删除 0：正常‘,
PRIMARYKEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘字典表‘;
-- --------------------------------------
-- 初始数据
-- --------------------------------------
-- Records of `sys_user`
-- --------------------------------------INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘1‘, ‘admin‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘4‘, ‘admin@qq.com‘, ‘13612345678‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘2‘, ‘Louis‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘6‘, ‘louis@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘3‘, ‘Kobe‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘7‘, ‘kobe@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘4‘, ‘Iverson‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘8‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘5‘, ‘Iverson5‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘12‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘6‘, ‘Iverson6‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘12‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘7‘, ‘Iverson7‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘13‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘8‘, ‘Iverson8‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘14‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘9‘, ‘Iverson9‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘15‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘10‘, ‘Iverson10‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘4‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘11‘, ‘Iverson11‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘6‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_user` (`id`, `name`, `password`, `salt`, `dept_id`, `email`, `mobile`, `status`, `create_time`) VALUES (‘12‘, ‘Iverson12‘, ‘9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d‘, ‘YzcmCZNvbXocrsz9dm8e‘, ‘15‘, ‘iverson@qq.com‘, ‘18200932238‘, ‘1‘, ‘2018-08-14 11:11:11‘);
-- --------------------------------------
-- Records of `sys_role`
-- --------------------------------------INSERTINTO `sys_role` (`id`, `name`, `remark`, `create_time`) VALUES (‘1‘, ‘admin‘, ‘超级管理员‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_role` (`id`, `name`, `remark`, `create_time`) VALUES (‘2‘, ‘dev‘, ‘开发人员‘, ‘2018-08-14 11:11:11‘);
INSERTINTO `sys_role` (`id`, `name`, `remark`, `create_time`) VALUES (‘3‘, ‘test‘, ‘测试人员‘, ‘2018-08-14 11:11:11‘);
-- --------------------------------------
-- Records of `sys_user_role`
-- --------------------------------------INSERTINTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (‘1‘, ‘1‘, ‘1‘);
INSERTINTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (‘2‘, ‘2‘, ‘1‘);
INSERTINTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (‘3‘, ‘3‘, ‘2‘);
INSERTINTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (‘4‘, ‘4‘, ‘3‘);
-- --------------------------------------
-- Records of `sys_dept`
-- --------------------------------------INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘1‘, ‘0‘, ‘轻尘集团‘, ‘0‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘2‘, ‘1‘, ‘北京分公司‘, ‘1‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘3‘, ‘1‘, ‘上海分公司‘, ‘2‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘4‘, ‘3‘, ‘技术部‘, ‘0‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘6‘, ‘3‘, ‘宣传部‘, ‘1‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘7‘, ‘3‘, ‘销售部‘, ‘2‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘8‘, ‘3‘, ‘市场部‘, ‘3‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘9‘, ‘0‘, ‘牧尘集团‘, ‘1‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘10‘, ‘9‘, ‘北京分公司‘, ‘1‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘11‘, ‘9‘, ‘上海分公司‘, ‘2‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘12‘, ‘10‘, ‘技术部‘, ‘1‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘13‘, ‘10‘, ‘宣传部‘, ‘2‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘14‘, ‘11‘, ‘销售部‘, ‘1‘, ‘0‘);
INSERTINTO `sys_dept` (`id`, `parent_id`, `name`, `order_num`, `del_flag`) VALUES (‘15‘, ‘11‘, ‘市场部‘, ‘2‘, ‘0‘);
-- --------------------------------------
-- Records of `sys_menu`
-- --------------------------------------INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘1‘, ‘0‘, ‘系统管理‘, NULL, NULL, ‘0‘, ‘fa el-icon-setting‘, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘2‘, ‘1‘, ‘用户管理‘, ‘/sys/user‘, NULL, ‘1‘, ‘el-icon-service‘, ‘1‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘3‘, ‘1‘, ‘机构管理‘, ‘/sys/dept‘, NULL, ‘1‘, ‘el-icon-news‘, ‘2‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘4‘, ‘1‘, ‘角色管理‘, ‘/sys/role‘, NULL, ‘1‘, ‘el-icon-view‘, ‘4‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘5‘, ‘1‘, ‘菜单管理‘, ‘/sys/menu‘, NULL, ‘1‘, ‘el-icon-menu‘, ‘5‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘6‘, ‘1‘, ‘SQL监控‘, ‘/druid/sql‘, NULL, ‘1‘, ‘el-icon-info‘, ‘6‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘8‘, ‘1‘, ‘系统日志‘, ‘/sys/log‘, ‘sys:log:view‘, ‘1‘, ‘el-icon-info‘, ‘7‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘9‘, ‘2‘, ‘查看‘, NULL, ‘sys:user:view‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘10‘, ‘2‘, ‘新增‘, NULL, ‘sys:user:add‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘11‘, ‘2‘, ‘修改‘, NULL, ‘sys:user:edit‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘12‘, ‘2‘, ‘删除‘, NULL, ‘sys:user:delete‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘13‘, ‘3‘, ‘查看‘, NULL, ‘sys:dept:view‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘14‘, ‘3‘, ‘新增‘, NULL, ‘sys:dept:add‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘15‘, ‘3‘, ‘修改‘, NULL, ‘sys:dept:edit‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘16‘, ‘3‘, ‘删除‘, NULL, ‘sys:dept:delete‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘17‘, ‘4‘, ‘查看‘, NULL, ‘sys:role:view‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘18‘, ‘4‘, ‘新增‘, NULL, ‘sys:role:add‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘19‘, ‘4‘, ‘修改‘, NULL, ‘sys:role:edit‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘20‘, ‘4‘, ‘删除‘, NULL, ‘sys:role:delete‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘21‘, ‘5‘, ‘查看‘, NULL, ‘sys:menu:view‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘22‘, ‘5‘, ‘新增‘, NULL, ‘sys:menu:add‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘23‘, ‘5‘, ‘修改‘, NULL, ‘sys:menu:edit‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘24‘, ‘5‘, ‘删除‘, NULL, ‘sys:menu:delete‘, ‘2‘, NULL, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘25‘, ‘0‘, ‘内容管理‘, NULL, NULL, ‘0‘, ‘el-icon-document‘, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘26‘, ‘25‘, ‘栏目管理‘, ‘/content/category‘, NULL, ‘1‘, ‘el-icon-tickets‘, ‘1‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘27‘, ‘25‘, ‘文章管理‘, ‘/content/artical‘, NULL, ‘1‘, ‘el-icon-tickets‘, ‘2‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘28‘, ‘0‘, ‘使用案例‘, NULL, NULL, ‘0‘, ‘el-icon-picture-outline‘, ‘0‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘29‘, ‘28‘, ‘国际化‘, ‘/demo/i18n‘, NULL, ‘1‘, ‘el-icon-edit‘, ‘1‘);
INSERTINTO `sys_menu` (`id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (‘30‘, ‘28‘, ‘换皮肤‘, ‘/demo/theme‘, NULL, ‘1‘, ‘el-icon-picture‘, ‘2‘);
-- --------------------------------------
-- Records of `sys_role_menu`
-- --------------------------------------INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘1‘, ‘2‘, ‘25‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘2‘, ‘2‘, ‘26‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘3‘, ‘2‘, ‘27‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘4‘, ‘2‘, ‘28‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘5‘, ‘2‘, ‘29‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘6‘, ‘2‘, ‘30‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘7‘, ‘3‘, ‘25‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘8‘, ‘3‘, ‘26‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘9‘, ‘3‘, ‘27‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘10‘, ‘3‘, ‘28‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘11‘, ‘3‘, ‘29‘);
INSERTINTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (‘12‘, ‘3‘, ‘30‘);
-- --------------------------------------
-- Records of `sys_dict`
-- --------------------------------------INSERTINTO `sys_dict` (`id`, `value`, `label`, `type`, `description`, `sort`) VALUES (‘1‘, ‘male‘, ‘男‘, ‘sex‘, ‘男性‘, ‘0‘);
INSERTINTO `sys_dict` (`id`, `value`, `label`, `type`, `description`, `sort`) VALUES (‘2‘, ‘female‘, ‘女‘, ‘sex‘, ‘女性‘, ‘1‘);
然后使用Mybatis-Generator自动生成Model，还有Mapper类，以及*.xml文件
一、首先在pom.xml中引入pagehelper-spring-boot-starter包
<
dependency
>
<
groupId
>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>${pagehelper.version}</version></dependency>
完整的pom如下：
<
project
xmlns
="http://maven.apache.org/POM/4.0.0"
xmlns:xsi
="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation
="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
>
<
modelVersion
>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.0.4.RELEASE</version><relativePath /><!-- lookup parent from repository --></parent><groupId>com.louis.springboot.demo</groupId><artifactId>springboot-demo</artifactId><version>0.0.1-SNAPSHOT</version><packaging>jar</packaging><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><java.version>1.8</java.version><mybatis.spring.version>1.3.2</mybatis.spring.version><com.alibaba.druid.version>1.1.10</com.alibaba.druid.version><log4j.version>1.2.17</log4j.version><pagehelper.version>1.2.5</pagehelper.version></properties><dependencies><!-- spring boot --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><!-- mybatis --><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>${mybatis.spring.version}</version></dependency><!-- mysql --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>${com.alibaba.druid.version}</version></dependency><!-- log4j --><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>${log4j.version}</version></dependency><!-- swagger --><dependency><groupId>io.springfox</groupId><artifactId>springfox-swagger2</artifactId><version>2.9.2</version></dependency><dependency><groupId>io.springfox</groupId><artifactId>springfox-swagger-ui</artifactId><version>2.9.2</version></dependency><!-- pagehelper --><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>${pagehelper.version}</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins><!-- 打包时拷贝MyBatis的映射文件 --><resources><resource><directory>src/main/java</directory><includes><include>**/sqlmap/*.xml</include></includes><filtering>false</filtering></resource><resource><directory>src/main/resources</directory><includes><include>**/*.*</include></includes><filtering>true</filtering></resource></resources></build></project>
二、然后开始编写请求的PageRequest.java和PageResult.java类
PageRequest.java
public
class
PageRequest {
/**
* 当前页码
*/
private
int
pageNum;
/**
* 每页数量
*/
private
int
pageSize;
public
int
getPageNum() {
return
pageNum;
}
public
int
getPageSize() {
return
pageSize;
}
public
void setPageNum(int pageNum) {
this.pageNum = pageNum;
}
publicvoid setPageSize(int pageSize) {
this.pageSize = pageSize;
}
}
PageResult.java
public
class
PageResult {
//
当前页码
private
int
pageNum;
//
每页数量
private
int
pageSize;
//
数据总条数
private
long
totalSize;
//
页码总数
private
int
totalPages;
//
数据
private List<?> conent;
publicint getPageNum() {
return pageNum;
}
publicint getPageSize() {
return pageSize;
}
publiclong getTotalSize() {
return totalSize;
}
publicint getTotalPages() {
return totalPages;
}
public List<?> getConent() {
return conent;
}
publicvoid setPageNum(int pageNum) {
this.pageNum = pageNum;
}
publicvoid setPageSize(int pageSize) {
this.pageSize = pageSize;
}
publicvoid setTotalSize(long totalSize) {
this.totalSize = totalSize;
}
publicvoid setTotalPages(int totalPages) {
this.totalPages = totalPages;
}
publicvoid setConent(List<?> conent) {
this.conent = conent;
}
}
三、然后开始编写Controller类
@RestController
@RequestMapping("menu")
publicclass SysMenuController {
@Autowired
private SysMenuService sysMenuService;
/**
* @Title: findPage
* @Description: 此处controller要使用POST的请求方式，主要是@RequestBody 提交的数据需要时POST形式提交
* @param pageRequest
* @return HttpResult 返回类型
* @throws*/
@PostMapping(value = "/findPage")
public HttpResult findPage(@RequestBody PageRequest pageRequest ) {
return HttpResult.ok(this.sysMenuService.findPage(pageRequest ));
}
}
SysMenuService.java
public
interface SysMenuService extends CurdService<SysMenu>{
/**
* @Title: findPage
* @Description: 分页查询接口
* @param@param pageQuery
* @param@return 参数说明
* @return Object 返回类型
* @throws*/
PageResult findPage(PageRequest pageRequest);
}
SysMenuServiceImpl.java
@Service
public
class SysMenuServiceImpl implements SysMenuService {
@Autowired
private SysMenuMapper sysMenuMapper;
/*
* Title: save
*Description:
* @param record
* @return
* @see com.louis.kitty.core.service.CurdService#save(java.lang.Object)
*/
@Override
publicint save(SysMenu record) {
returnthis.sysMenuMapper.insertSelective(record);
}
/*
* Title: upate
*Description:
* @param record
* @return
* @see com.louis.kitty.core.service.CurdService#upate(java.lang.Object)
*/
@Override
publicint upate(SysMenu record) {
returnthis.sysMenuMapper.updateByPrimaryKeySelective(record);
}
/*
* Title: delete
*Description:
* @param record
* @return
* @see com.louis.kitty.core.service.CurdService#delete(java.lang.Object)
*/
@Override
publicint delete(SysMenu record) {
returnthis.sysMenuMapper.deleteByPrimaryKey(record.getId());
}
/*
* Title: delete
*Description:
* @param records
* @return
* @see com.louis.kitty.core.service.CurdService#delete(java.util.List)
*/
@Override
publicint delete(List<SysMenu> records) {
for (SysMenu record : records) {
delete(record);
}
return 1;
}
/*
* Title: findById
*Description:
* @param id
* @return
* @see com.louis.kitty.core.service.CurdService#findById(java.lang.Long)
*/
@Override
public SysMenu findById(Long id) {
returnthis.sysMenuMapper.selectByPrimaryKey(id);
}
/*
* Title: findPage
*Description:
* @param pageResult
* @return
* @see com.louis.kitty.core.service.CurdService#findPage(com.louis.kitty.admin.page.PageRequest)
*/
@Override
public PageResult findPage(PageRequest pageRequest) {
return PageUtils.getPageResult(pageRequest, pageInfo(pageRequest));
}
/**
* @Title: pageInfo
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param@param pageRequest
* @param@return 参数说明
* @return PageInfo<?> 返回类型
* @throws*/private PageInfo<SysMenu> pageInfo(PageRequest pageRequest) {
int pageNum = pageRequest.getPageNum();
int pageSize = pageRequest.getPageSize();
PageHelper.startPage(pageNum, pageSize);
List<SysMenu> sysMenus = this.sysMenuMapper.findPage();
returnnew PageInfo<SysMenu>(sysMenus);
}
}
其中基础服务类如下CurdService.java
/**
* @ClassName: CurdService
* @Description: 通用CURD操作
*
@author
lr
* @date 2018年11月6日 上午10:42:23
*
*/
public
interface CurdService<T> {
/**
* @Title: save
* @Description: 保存操作
* @param@param record
* @param@return 参数说明
* @return int 返回类型
* @throws*/int save(T record);
/**
* @Title: upate
* @Description: 更新操作
* @param@param record
* @param@return 参数说明
* @return int 返回类型
* @throws*/int upate(T record);
/**
* @Title: delete
* @Description: 删除操作
* @param@param record
* @param@return 参数说明
* @return int 返回类型
* @throws*/int delete(T record);
/**
* @Title: delete
* @Description: 批量删除操作
* @param@param records
* @param@return 参数说明
* @return int 返回类型
* @throws*/int delete(List<T> records);
/**
* @Title: findById
* @Description: 根据ID查询
* @param@param id
* @param@return 参数说明
* @return T 返回类型
* @throws*/
T findById(Long id);
/**
* @Title: findPage
* @Description: 分页查询
* @param pageRequest 自定义统一分页查询要求
* @return PageResult 自定义统一分返回类型
* @throws*/
PageResult findPage(PageRequest pageRequest);
}
controller的返回结果HttpResult.java
/**
* @ClassName: HttpResult
* @Description: TODO(这里用一句话描述这个类的作用)
*
@author
lr
* @date 2018年11月6日 上午10:32:30
*
*/
public
class
HttpResult {
private
int
code;
private
String msg;
private
Object data;
public
static
HttpResult error() {
return error(HttpStatus.SC_INTERNAL_SERVER_ERROR, "未知异常，请联系管理员");
}
publicstatic HttpResult error(String msg) {
return error(HttpStatus.SC_INTERNAL_SERVER_ERROR, msg);
}
publicstatic HttpResult error(int code, String msg) {
HttpResult r = new HttpResult();
r.setCode(code);
r.setMsg(msg);
return r;
}
publicstatic HttpResult ok() {
returnnew HttpResult();
}
publicstatic HttpResult ok(Object data) {
HttpResult r = new HttpResult();
r.setData(data);
return r;
}
publicstatic HttpResult ok(String msg) {
HttpResult r = new HttpResult();
r.setMsg(msg);
return r;
}
publicint getCode() {
return code;
}
public String getMsg() {
return msg;
}
public Object getData() {
return data;
}
publicvoid setCode(int code) {
this.code = code;
}
publicvoid setMsg(String msg) {
this.msg = msg;
}
publicvoid setData(Object data) {
this.data = data;
}
}
ReflectionUtils.java 类如下：
import
java.lang.reflect.InvocationTargetException;
import
java.lang.reflect.Method;
/**
* 反射相关辅助方法
*
@author
Louis
* @date Aug 19, 2018
*/
public
class
ReflectionUtils {
/**
* 根据方法名调用指定对象的方法
*
@param
object 要调用方法的对象
*
@param
method 要调用的方法名
*
@param
args 参数对象数组
*
@return
*/
public
static
Object invoke(Object object, String method, Object... args) {
Object result = null;
Class<? extends Object> clazz = object.getClass();
Method queryMethod = getMethod(clazz, method, args);
if(queryMethod != null) {
try {
result = queryMethod.invoke(object, args);
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (IllegalArgumentException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
} else {
try {
thrownew NoSuchMethodException(clazz.getName() + " 类中没有找到 " + method + " 方法。");
} catch (NoSuchMethodException e) {
e.printStackTrace();
}
}
return result;
}
/**
* 根据方法名和参数对象查找方法
* @param clazz
* @param name
* @param args 参数实例数据
* @return*/publicstatic Method getMethod(Class<? extends Object> clazz, String name, Object[] args) {
Method queryMethod = null;
Method[] methods = clazz.getMethods();
for(Method method:methods) {
if(method.getName().equals(name)) {
Class<?>[] parameterTypes = method.getParameterTypes();
if(parameterTypes.length == args.length) {
boolean isSameMethod = true;
for(int i=0; i<parameterTypes.length; i++) {
Object arg = args[i];
if(arg == null) {
arg = "";
}
if(!parameterTypes[i].equals(args[i].getClass())) {
isSameMethod = false;
}
}
if(isSameMethod) {
queryMethod = method;
break ;
}
}
}
}
return queryMethod;
}
}
然后启动就可以看到接口数据了：
主要返回的数据如下：
{
"code": 0,
"msg": null,
"data": {
"pageNum": 1,
"pageSize": 10,
"totalSize": 29,
"totalPages": 3,
"conent": [
{
"id": 1,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 0,
"name": "系统管理",
"url": null,
"perms": null,
"type": 0,
"icon": "fa el-icon-setting",
"orderNum": 0,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 2,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 1,
"name": "用户管理",
"url": "/sys/user",
"perms": null,
"type": 1,
"icon": "el-icon-service",
"orderNum": 1,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 3,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 1,
"name": "机构管理",
"url": "/sys/dept",
"perms": null,
"type": 1,
"icon": "el-icon-news",
"orderNum": 2,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 4,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 1,
"name": "角色管理",
"url": "/sys/role",
"perms": null,
"type": 1,
"icon": "el-icon-view",
"orderNum": 4,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 5,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 1,
"name": "菜单管理",
"url": "/sys/menu",
"perms": null,
"type": 1,
"icon": "el-icon-menu",
"orderNum": 5,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 6,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 1,
"name": "SQL监控",
"url": "/druid/sql",
"perms": null,
"type": 1,
"icon": "el-icon-info",
"orderNum": 6,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 8,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 1,
"name": "系统日志",
"url": "/sys/log",
"perms": "sys:log:view",
"type": 1,
"icon": "el-icon-info",
"orderNum": 7,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 9,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 2,
"name": "查看",
"url": null,
"perms": "sys:user:view",
"type": 2,
"icon": null,
"orderNum": 0,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 10,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 2,
"name": "新增",
"url": null,
"perms": "sys:user:add",
"type": 2,
"icon": null,
"orderNum": 0,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
},
{
"id": 11,
"createBy": null,
"createTime": null,
"lastUpdateBy": null,
"lastUpdateTime": null,
"parentId": 2,
"name": "修改",
"url": null,
"perms": "sys:user:edit",
"type": 2,
"icon": null,
"orderNum": 0,
"delFlag": 0,
"parentName": null,
"level": null,
"children": null
}
]
}
}
原文：https://www.cnblogs.com/lr393993507/p/9914408.html
内容总结
以上是互联网集市为您收集整理的SpringBoot 分页处理全部内容，希望文章能够帮你解决SpringBoot 分页处理所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】