springboot分页展示功能_SpringBoot实战项目（三）用户列表以及分页功能实现

最新推荐文章于 2024-07-26 18:24:41 发布

weixin_39926311

最新推荐文章于 2024-07-26 18:24:41 发布

阅读量338

点赞数

文章标签： springboot分页展示功能

本文链接：https://blog.csdn.net/weixin_39926311/article/details/111542536

版权

本文展示了如何在SpringBoot项目中创建一个`sys_user`表，并插入初始数据，包括用户名、昵称、电话、邮箱等字段。同时，通过创建`sys_role`表和`sys_user_role`表，实现用户角色关联，为实现用户分页展示功能奠定了基础。

摘要由CSDN通过智能技术生成

CREATE TABLE `sys_user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_name` varchar(255) NOT NULL COMMENT '用户名',

`nick_name` varchar(255) DEFAULT NULL COMMENT '昵称',

`password` varchar(255) NOT NULL COMMENT '密码',

`sex` int(10) DEFAULT NULL COMMENT '性别 1=男',

`telephone` varchar(255) NOT NULL COMMENT '电话',

`email` varchar(255) NOT NULL COMMENT '邮箱',

`birthday` date DEFAULT NULL COMMENT '生日',

`status` int(10) NOT NULL COMMENT '状态',

`createTime` datetime NOT NULL COMMENT '创建时间',

`updateTime` datetime NOT NULL COMMENT '最后更新时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (1, '张三', '大不列颠-张三', '123456', 1, '17687206393', '300@qq.com', '2020-04-01', 1, '2020-04-07 13:38:43', '2020-04-07 13:38:52');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (2, '李四', '尼古拉斯-赵四', '123456', 1, '17687208353', '333@qq.com', '2020-04-10', 0, '2020-04-10 13:19:58', '2020-04-10 13:20:16');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (3, '王五', '隔壁老王', '000000', 1, '13245785000', '22@qq.com', '2020-04-10', 0, '2020-04-10 13:21:06', '2020-04-10 13:21:10');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (4, '赵六', '可好看', '000000', 1, '16875236945', 'aa@qq.com', '2019-10-24', 0, '2020-04-10 13:37:18', '2020-04-10 13:37:21');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (5, '陈七', '随风起舞', '123456', 2, '17687206982', '66@qq.com', NULL, 1, '2020-04-07 13:38:08', '2020-04-28 13:38:11');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (6, '王八', '铁血无双', '8888', 1, '19853687755', '88@qq.com', NULL, 0, '2020-03-31 13:38:55', '2020-04-13 13:38:59');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (7, '李九', '死亡眼神', '88888', 1, '18496775309', '77@qq.com', NULL, 0, '2020-04-30 20:14:15', '2020-04-05 20:14:19');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (8, 'admin', '逆天而行', '99999', 1, '18523698755', '55@qq.com', '2019-01-17', 1, '2020-04-01 20:15:38', '2020-03-25 20:15:42');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (9, '十一', '星星有泪', '11111', 2, '16359874588', 'bb@qq.com', '2020-04-23', 1, '2020-04-09 20:16:36', '2020-04-10 20:16:40');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (10, 'user', '穷凶极恶', '88888', 1, '15689321456', '99@qq.com', NULL, 1, '2020-04-29 20:17:26', '2020-04-13 20:17:29');

INSERT INTO `sys_user`(`id`, `user_name`, `nick_name`, `password`, `sex`, `telephone`, `email`, `birthday`, `status`, `createTime`, `updateTime`) VALUES (11, '十三', '好久时光', '00000', 2, '15286767244', 'iuouh@qq.com', NULL, 1, '2020-04-10 20:18:32', '2020-04-10 20:18:35');

CREATE TABLE `sys_role` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`role_name` varchar(255) NOT NULL COMMENT '角色名',

`remark` varchar(255) DEFAULT NULL COMMENT '角色备注',

`createTime` datetime DEFAULT NULL COMMENT '创建时间',

`updateTime` datetime NOT NULL COMMENT '最后修改时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO `sys_role`(`id`, `role_name`, `remark`, `createTime`, `updateTime`) VALUES (1, '超级管理员', '拥有本系统的一切权限', '2020-04-11 21:03:08', '2020-04-11 21:03:11');

INSERT INTO `sys_role`(`id`, `role_name`, `remark`, `createTime`, `updateTime`) VALUES (2, '普通用户', '系统权限受限', '2020-04-11 21:03:49', '2020-04-11 21:03:59');

INSERT INTO `sys_role`(`id`, `role_name`, `remark`, `createTime`, `updateTime`) VALUES (3, '测试用户', '测试专用', '2020-04-11 21:04:22', '2020-04-11 21:04:24');

CREATE TABLE `sys_user_role` (

`userId` int(11) NOT NULL,

`roleId` int(11) NOT NULL,

PRIMARY KEY (`userId`),

KEY `fk_rolerId` (`roleId`),

CONSTRAINT `fk_rolerId` FOREIGN KEY (`roleId`) REFERENCES `sys_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,

CONSTRAINT `fk_userId` FOREIGN KEY (`userId`) REFERENCES `sys_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `sys_user_role`(`userId`, `roleId`) VALUES (1, 1);

INSERT INTO `sys_user_role`(`userId`, `roleId`) VALUES (2, 2);

INSERT INTO `sys_user_role`(`userId`, `roleId`) VALUES (3, 3);