基于java的图书管理系统的设计与实现+毕业论文

/* Navicat MySQL Data Transfer Source Server : 49.232.191.19 Source Server Version : 50647 Source Host : 49.232.191.19:33306 Source Database : library_layui Target Server Type : MYSQL Target Server Version : 50647 File Encoding : 65001 Date: 2021-04-01 12:15:31 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for tb_admin -- ---------------------------- DROP TABLE IF EXISTS `tb_admin`; CREATE TABLE `tb_admin` ( `admin_id` int(55) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `password` char(55) DEFAULT NULL, `nickname` varchar(255) DEFAULT NULL, `roleId` bigint(55) DEFAULT NULL, `roleName` varchar(255) DEFAULT '0', `sex` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, PRIMARY KEY (`admin_id`) USING BTREE, UNIQUE KEY `username` (`username`) USING BTREE, UNIQUE KEY `empnum` (`roleId`) USING BTREE, CONSTRAINT `fk_roleId` FOREIGN KEY (`roleId`) REFERENCES `tb_role` (`roleId`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of tb_admin -- ---------------------------- INSERT INTO `tb_admin` VALUES ('1', 'admin', 'E10ADC3949BA59ABBE56E057F20F883E', 'admin', '1', '超级管理员', '1', '13211111111', 'jack111@126.com'); -- ---------------------------- -- Table structure for tb_adminlog -- ---------------------------- DROP TABLE IF EXISTS `tb_adminlog`; CREATE TABLE `tb_adminlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `adminUsername` varchar(255) DEFAULT NULL, `loginIp` varchar(255) DEFAULT NULL, `loginTime` datetime DEFAULT NULL, `logoutTime` datetime DEFAULT NULL, `isSafeExit` int(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of tb_adminlog -- ---------------------------- INSERT INTO `tb_adminlog` VALUES ('1', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 10:42:35', '2019-12-31 10:42:58', '1'); INSERT INTO `tb_adminlog` VALUES ('2', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 10:43:09', '2019-12-31 10:43:09', '0'); INSERT INTO `tb_adminlog` VALUES ('3', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 10:47:32', '2019-12-31 10:47:32', '0'); INSERT INTO `tb_adminlog` VALUES ('4', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 10:53:09', '2019-12-31 10:53:34', '1'); INSERT INTO `tb_adminlog` VALUES ('5', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 10:53:48', '2019-12-31 10:53:48', '0'); INSERT INTO `tb_adminlog` VALUES ('6', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 10:56:38', '2019-12-31 10:56:38', '0'); INSERT INTO `tb_adminlog` VALUES ('7', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 10:58:05', '2019-12-31 10:58:59', '1'); INSERT INTO `tb_adminlog` VALUES ('8', '员工1', '0:0:0:0:0:0:0:1', '2019-12-31 10:59:24', '2019-12-31 10:59:48', '1'); INSERT INTO `tb_adminlog` VALUES ('9', '员工1', '0:0:0:0:0:0:0:1', '2019-12-31 10:59:59', '2019-12-31 11:00:08', '1'); INSERT INTO `tb_adminlog` VALUES ('10', 'jack', '0:0:0:0:0:0:0:1', '2019-12-31 11:00:20', '2019-12-31 11:20:21', '1'); INSERT INTO `tb_adminlog` VALUES ('121', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 09:25:41', '2020-07-31 09:25:41', '0'); INSERT INTO `tb_adminlog` VALUES ('122', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 09:28:23', '2020-07-31 09:28:23', '0'); INSERT INTO `tb_adminlog` VALUES ('123', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 09:29:28', '2020-07-31 09:29:28', '0'); INSERT INTO `tb_adminlog` VALUES ('124', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 11:05:54', '2020-07-31 11:05:54', '0'); INSERT INTO `tb_adminlog` VALUES ('125', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 11:09:25', '2020-07-31 11:09:25', '0'); INSERT INTO `tb_adminlog` VALUES ('126', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 11:14:36', '2020-07-31 11:14:36', '0'); INSERT INTO `tb_adminlog` VALUES ('127', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 11:17:55', '2020-07-31 11:17:55', '0'); INSERT INTO `tb_adminlog` VALUES ('128', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 11:20:26', '2020-07-31 11:21:05', '1'); INSERT INTO `tb_adminlog` VALUES ('129', 'jack', '0:0:0:0:0:0:0:1', '2020-07-31 14:09:11', '2020-07-31 14:10:59', '1'); INSERT INTO `tb_adminlog` VALUES ('130', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 14:55:26', '2020-08-01 14:55:26', '0'); INSERT INTO `tb_adminlog` VALUES ('131', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 15:27:30', '2020-08-01 15:27:30', '0'); INSERT INTO `tb_adminlog` VALUES ('132', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 15:29:17', '2020-08-01 15:29:17', '0'); INSERT INTO `tb_adminlog` VALUES ('133', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 15:39:00', '2020-08-01 15:39:00', '0'); INSERT INTO `tb_adminlog` VALUES ('134', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 15:41:31', '2020-08-01 15:41:31', '0'); INSERT INTO `tb_adminlog` VALUES ('135', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 15:46:34', '2020-08-01 15:46:34', '0'); INSERT INTO `tb_adminlog` VALUES ('136', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 15:58:12', '2020-08-01 15:58:12', '0'); INSERT INTO `tb_adminlog` VALUES ('137', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 16:08:19', '2020-08-01 16:24:24', '1'); INSERT INTO `tb_adminlog` VALUES ('138', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 19:48:42', '2020-08-01 19:48:42', '0'); INSERT INTO `tb_adminlog` VALUES ('139', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 19:58:03', '2020-08-01 19:58:03', '0'); INSERT INTO `tb_adminlog` VALUES ('140', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 19:59:43', '2020-08-01 19:59:43', '0'); INSERT INTO `tb_adminlog` VALUES ('141', 'jack', '0:0:0:0:0:0:0:1', '2020-08-01 20:07:55', '2020-08-01 20:07:55', '0'); INSERT INTO `tb_adminlog` VALUES ('142', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 09:42:12', '2020-08-02 09:42:12', '0'); INSERT INTO `tb_adminlog` VALUES ('143', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 10:05:47', '2020-08-02 10:05:47', '0'); INSERT INTO `tb_adminlog` VALUES ('144', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 10:32:54', '2020-08-02 10:32:54', '0'); INSERT INTO `tb_adminlog` VALUES ('145', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 10:36:01', '2020-08-02 10:36:01', '0'); INSERT INTO `tb_adminlog` VALUES ('146', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 10:37:55', '2020-08-02 10:37:55', '0'); INSERT INTO `tb_adminlog` VALUES ('147', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 19:23:42', '2020-08-02 19:23:42', '0'); INSERT INTO `tb_adminlog` VALUES ('148', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 19:27:12', '2020-08-02 19:29:42', '1'); INSERT INTO `tb_adminlog` VALUES ('149', 'jack', '0:0:0:0:0:0:0:1', '2020-08-02 19:29:58', '2020-08-02 19:30:28', '1'); INSERT INTO `tb_adminlog` VALUES ('150', 'jack', '0:0:0:0:0:0:0:1', '2020-08-03 10:20:26', '2020-08-03 10:20:52', '1'); INSERT INTO `tb_adminlog` VALUES ('151', 'jack', '0:0:0:0:0:0:0:1', '2020-08-03 14:28:52', '2020-08-03 14:28:52', '0'); INSERT INTO `tb_adminlog` VALUES ('152', 'jack', '0:0:0:0:0:0:0:1', '2020-08-03 14:34:04', '2020-08-03 14:36:32', '1'); INSERT INTO `tb_adminlog` VALUES ('153', 'jack', '0:0:0:0:0:0:0:1', '2020-08-03 15:34:33', '2020-08-03 15:38:01', '1'); INSERT INTO `tb_adminlog` VALUES ('154', 'jack', '0:0:0:0:0:0:0:1', '2020-08-04 18:53:25', '2020-08-04 18:53:35', '1'); INSERT INTO `tb_adminlog` VALUES ('155', 'jack', '0:0:0:0:0:0:0:1', '2020-08-04 20:17:44', '2020-08-04 20:18:01', '1'); INSERT INTO `tb_adminlog` VALUES ('156', 'jack', '0:0:0:0:0:0:0:1', '2020-08-05 17:55:51', '2020-08-05 17:55:51', '0'); INSERT INTO `tb_adminlog` VALUES ('157', 'jack', '0:0:0:0:0:0:0:1', '2020-08-05 20:48:51', '2020-08-05 20:49:08', '1'); INSERT INTO `tb_adminlog` VALUES ('158', 'jack', '127.0.0.1', '2021-03-23 10:54:00', '2021-03-23 10:54:29', '1'); INSERT INTO `tb_adminlog` VALUES ('159', 'admin', '127.0.0.1', '2021-03-23 11:12:18', '2021-03-23 11:12:18', '0'); INSERT INTO `tb_adminlog` VALUE