功能介绍
本系统用户角色有：
用户端功能有：首页、留言板、书籍信息、在线听书、留言板、个人中心
管理端功能有：个人中心、书籍分类管理、资讯分类管理、书籍管理、用户管理、资讯管理、系统管理
更多功能请看运行截图！
使用技术
开发语言：Java
使用框架：ssm
前端技术：JavaScript、VUE.js（2.X）、css3
数据库：MySQL 5.7
数据库管理工具：Navicat或sqlyog
开发工具：IDEA或Eclipse均可
项目截图
数据库脚本
/*SQLyog Ultimate v11.3 (64 bit)MySQL - 5.7.32-log : Database - zaixiantingshu**********************************************************************//*!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*/`zaixiantingshu` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `zaixiantingshu`;/*Table structure for table `config` */DROP TABLE IF EXISTS `config`;CREATE TABLE `config` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`name` varchar(100) NOT NULL COMMENT '配置参数名称',`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='配置文件';/*Data for the table `config` */insert into `config`(`id`,`name`,`value`) values (1,'轮播图1','http://localhost:8080/zaixiantingshu/upload/config1.jpg'),(2,'轮播图2','http://localhost:8080/zaixiantingshu/upload/config2.jpg'),(3,'轮播图3','http://localhost:8080/zaixiantingshu/upload/config3.jpg');/*Table structure for table `dictionary` */DROP TABLE IF EXISTS `dictionary`;CREATE TABLE `dictionary` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`dic_code` varchar(200) DEFAULT NULL COMMENT '字段',`dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',`code_index` int(11) DEFAULT NULL COMMENT '编码',`index_name` varchar(200) DEFAULT NULL COMMENT '编码名字 Search111 ',`super_id` int(11) DEFAULT NULL COMMENT '父字段id',`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='字典';/*Data for the table `dictionary` */insert into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (1,'sex_types','性别类型',1,'男',NULL,NULL,'-02-25 19:17:40'),(2,'sex_types','性别类型',2,'女',NULL,NULL,'-02-25 19:17:40'),(3,'shangxia_types','上下架',1,'上架',NULL,NULL,'-02-25 19:17:40'),(4,'shangxia_types','上下架',2,'下架',NULL,NULL,'-02-25 19:17:40'),(5,'shuji_types','书籍分类',1,'书籍分类1',NULL,NULL,'-02-25 19:17:40'),(6,'shuji_types','书籍分类',2,'书籍分类2',NULL,NULL,'-02-25 19:17:40'),(7,'shuji_types','书籍分类',3,'书籍分类3',NULL,NULL,'-02-25 19:17:40'),(8,'shuji_types','书籍分类',4,'书籍分类4',NULL,NULL,'-02-25 19:17:40'),(9,'shuji_collection_types','收藏表类型',1,'收藏',NULL,NULL,'-02-25 19:17:40'),(10,'zixun_types','资讯类型',1,'资讯类型1',NULL,NULL,'-02-25 19:17:40'),(11,'zixun_types','资讯类型',2,'资讯类型2',NULL,NULL,'-02-25 19:17:40'),(12,'shuji_types','书籍分类',5,'书籍分类5',NULL,'','-02-25 19:54:50');/*Table structure for table `liuyan` */DROP TABLE IF EXISTS `liuyan`;CREATE TABLE `liuyan` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`liuyan_name` varchar(200) DEFAULT NULL COMMENT '留言标题 Search111 ',`liuyan_text` text COMMENT '留言内容',`reply_text` text COMMENT '回复内容',`insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2 nameShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='留言板';/*Data for the table `liuyan` */insert into `liuyan`(`id`,`yonghu_id`,`liuyan_name`,`liuyan_text`,`reply_text`,`insert_time`,`update_time`,`create_time`) values (1,3,'留言标题1','留言内容1','回复信息1','-02-25 19:20:14','-02-25 19:20:14','-02-25 19:20:14'),(2,1,'留言标题2','留言内容2','回复信息2','-02-25 19:20:14','-02-25 19:20:14','-02-25 19:20:14'),(3,1,'留言标题3','留言内容3','回复信息3','-02-25 19:20:14','-02-25 19:20:14','-02-25 19:20:14'),(4,2,'留言标题4','留言内容4','回复信息4','-02-25 19:20:14','-02-25 19:20:14','-02-25 19:20:14'),(5,3,'留言标题5','留言内容5','回复信息5','-02-25 19:20:14','-02-25 19:20:14','-02-25 19:20:14'),(6,1,'标题111','内容111','回复111','-02-25 19:52:21','-02-25 19:55:05','-02-25 19:52:21');/*Table structure for table `shuji` */DROP TABLE IF EXISTS `shuji`;CREATE TABLE `shuji` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`shuji_name` varchar(200) DEFAULT NULL COMMENT '书籍名称 Search111 ',`shuji_photo` varchar(200) DEFAULT NULL COMMENT '书籍照片',`shuji_types` int(11) DEFAULT NULL COMMENT '书籍分类 Search111',`shuji_file` varchar(200) DEFAULT NULL COMMENT '书籍文件',`shuji_music` varchar(200) DEFAULT NULL COMMENT '音频',`shuji_clicknum` int(11) DEFAULT NULL COMMENT '点击次数 ',`shangxia_types` int(11) DEFAULT NULL COMMENT '是否上架 ',`shuji_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',`shuji_content` text COMMENT '书籍介绍',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='书籍';/*Data for the table `shuji` */insert into `shuji`(`id`,`yonghu_id`,`shuji_name`,`shuji_photo`,`shuji_types`,`shuji_file`,`shuji_music`,`shuji_clicknum`,`shangxia_types`,`shuji_delete`,`shuji_content`,`create_time`) values (1,3,'书籍名称1','http://localhost:8080/zaixiantingshu/upload/shuji1.jpg',2,'http://localhost:8080/zaixiantingshu/upload/file.rar','http://localhost:8080/zaixiantingshu/upload/music.mp3',171,1,1,'书籍介绍1','-02-25 19:20:14'),(2,2,'书籍名称2','http://localhost:8080/zaixiantingshu/upload/shuji2.jpg',2,'http://localhost:8080/zaixiantingshu/upload/file.rar','http://localhost:8080/zaixiantingshu/upload/music.mp3',493,1,1,'书籍介绍2','-02-25 19:20:14'),(3,3,'书籍名称3','http://localhost:8080/zaixiantingshu/upload/shuji3.jpg',3,'http://localhost:8080/zaixiantingshu/upload/file.rar','http://localhost:8080/zaixiantingshu/upload/music.mp3',314,1,1,'书籍介绍3','-02-25 19:20:14'),(4,2,'书籍名称4','http://localhost:8080/zaixiantingshu/upload/shuji4.jpg',4,'http://localhost:8080/zaixiantingshu/upload/file.rar','http://localhost:8080/zaixiantingshu/upload/music.mp3',336,1,1,'书籍介绍4','-02-25 19:20:14'),(5,2,'书籍名称5','http://localhost:8080/zaixiantingshu/upload/shuji5.jpg',1,'http://localhost:8080/zaixiantingshu/upload/file.rar','http://localhost:8080/zaixiantingshu/upload/music.mp3',419,1,1,'书籍介绍5','-02-25 19:20:14');/*Table structure for table `shuji_collection` */DROP TABLE IF EXISTS `shuji_collection`;CREATE TABLE `shuji_collection` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`shuji_id` int(11) DEFAULT NULL COMMENT '书籍',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`shuji_collection_types` int(11) DEFAULT NULL COMMENT '类型',`insert_time` timestamp NULL DEFAULT NULL COMMENT '收藏时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 photoShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='书籍收藏';/*Data for the table `shuji_collection` */insert into `shuji_collection`(`id`,`shuji_id`,`yonghu_id`,`shuji_collection_types`,`insert_time`,`create_time`) values (1,1,3,1,'-02-25 19:20:14','-02-25 19:20:14'),(2,2,3,1,'-02-25 19:20:14','-02-25 19:20:14'),(3,3,2,1,'-02-25 19:20:14','-02-25 19:20:14'),(4,4,2,1,'-02-25 19:20:14','-02-25 19:20:14'),(5,5,2,1,'-02-25 19:20:14','-02-25 19:20:14'),(6,2,1,1,'-02-25 19:52:03','-02-25 19:52:03'),(7,3,1,1,'-02-25 19:52:05','-02-25 19:52:05'),(8,1,1,1,'-02-25 19:52:09','-02-25 19:52:09');/*Table structure for table `shuji_liuyan` */DROP TABLE IF EXISTS `shuji_liuyan`;CREATE TABLE `shuji_liuyan` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`shuji_id` int(11) DEFAULT NULL COMMENT '书籍',`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',`shuji_liuyan_text` text COMMENT '留言内容',`insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',`reply_text` text COMMENT '回复内容',`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='书籍留言';/*Data for the table `shuji_liuyan` */insert into `shuji_liuyan`(`id`,`shuji_id`,`yonghu_id`,`shuji_liuyan_text`,`insert_time`,`reply_text`,`update_time`,`create_time`) values (1,1,1,'留言内容1','-02-25 19:20:14','回复信息1','-02-25 19:20:14','-02-25 19:20:14'),(2,2,3,'留言内容2','-02-25 19:20:14','回复信息2','-02-25 19:20:14','-02-25 19:20:14'),(3,3,3,'留言内容3','-02-25 19:20:14','回复信息3','-02-25 19:20:14','-02-25 19:20:14'),(4,4,2,'留言内容4','-02-25 19:20:14','回复信息4','-02-25 19:20:14','-02-25 19:20:14'),(5,5,1,'留言内容5','-02-25 19:20:14','回复信息5','-02-25 19:20:14','-02-25 19:20:14'),(6,5,1,'111','-02-25 19:32:33',NULL,NULL,'-02-25 19:32:33'),(7,4,1,'好呀','-02-25 19:51:55',NULL,NULL,'-02-25 19:51:55'),(8,2,1,'宿舍','-02-25 19:52:36','回复内容11','-02-25 19:54:16','-02-25 19:52:36');/*Table structure for table `token` */DROP TABLE IF EXISTS `token`;CREATE TABLE `token` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`userid` bigint(20) NOT NULL COMMENT '用户id',`username` varchar(100) NOT NULL COMMENT '用户名',`tablename` varchar(100) DEFAULT NULL COMMENT '表名',`role` varchar(100) DEFAULT NULL COMMENT '角色',`token` varchar(200) NOT NULL COMMENT '密码',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='token表';/*Data for the table `token` */insert into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,6,'admin','users','管理员','xjfu8sp64k88qigqnu6i9bufcr05ls52','-02-25 19:23:07','-02-25 20:54:33'),(2,1,'a1','yonghu','用户','ta1eyleijl1gfxfibtjcmgi0c5yf38h4','-02-25 19:27:25','-02-25 20:51:36'),(3,2,'a2','yonghu','用户','sq727bya5za887vu5lxmfdw1d02wqab8','-02-25 19:53:06','-02-25 20:53:07');/*Table structure for table `users` */DROP TABLE IF EXISTS `users`;CREATE TABLE `users` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(100) NOT NULL COMMENT '用户名',`password` varchar(100) NOT NULL COMMENT '密码',`role` varchar(100) DEFAULT '管理员' COMMENT '角色',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员';/*Data for the table `users` */insert into `users`(`id`,`username`,`password`,`role`,`addtime`) values (6,'admin','admin','管理员','-04-27 14:51:13');/*Table structure for table `yonghu` */DROP TABLE IF EXISTS `yonghu`;CREATE TABLE `yonghu` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(200) DEFAULT NULL COMMENT '账户',`password` varchar(200) DEFAULT NULL COMMENT '密码',`yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户姓名 Search111 ',`yonghu_phone` varchar(200) DEFAULT NULL COMMENT '用户手机号',`yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '用户身份证号',`yonghu_photo` varchar(200) DEFAULT NULL COMMENT '用户头像',`sex_types` int(11) DEFAULT NULL COMMENT '性别',`yonghu_email` varchar(200) DEFAULT NULL COMMENT '电子邮箱',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户';/*Data for the table `yonghu` */insert into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`yonghu_phone`,`yonghu_id_number`,`yonghu_photo`,`sex_types`,`yonghu_email`,`create_time`) values (1,'a1','123456','用户姓名1','17703786901','410224199610232001','http://localhost:8080/zaixiantingshu/upload/yonghu1.jpg',1,'1@','-02-25 19:20:14'),(2,'a2','123456','用户姓名2','17703786902','410224199610232002','http://localhost:8080/zaixiantingshu/upload/yonghu2.jpg',1,'2@','-02-25 19:20:14'),(3,'a3','123456','用户姓名3','17703786903','41022419961023','http://localhost:8080/zaixiantingshu/upload/yonghu3.jpg',1,'3@','-02-25 19:20:14');/*Table structure for table `zixun` */DROP TABLE IF EXISTS `zixun`;CREATE TABLE `zixun` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`zixun_name` varchar(200) DEFAULT NULL COMMENT '资讯名称 Search111 ',`zixun_photo` varchar(200) DEFAULT NULL COMMENT '资讯图片 ',`zixun_types` int(11) NOT NULL COMMENT '资讯类型 ',`insert_time` timestamp NULL DEFAULT NULL COMMENT '资讯发布时间 ',`zixun_content` text COMMENT '资讯详情 ',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='书籍资讯';/*Data for the table `zixun` */insert into `zixun`(`id`,`zixun_name`,`zixun_photo`,`zixun_types`,`insert_time`,`zixun_content`,`create_time`) values (1,'资讯名称1','http://localhost:8080/zaixiantingshu/upload/zixun1.jpg',1,'-02-25 19:20:14','资讯详情1','-02-25 19:20:14'),(2,'资讯名称2','http://localhost:8080/zaixiantingshu/upload/zixun2.jpg',1,'-02-25 19:20:14','资讯详情2','-02-25 19:20:14'),(3,'资讯名称3','http://localhost:8080/zaixiantingshu/upload/zixun3.jpg',1,'-02-25 19:20:14','资讯详情3','-02-25 19:20:14'),(4,'资讯名称4','http://localhost:8080/zaixiantingshu/upload/zixun4.jpg',2,'-02-25 19:20:14','资讯详情4','-02-25 19:20:14'),(5,'资讯名称5','http://localhost:8080/zaixiantingshu/upload/zixun5.jpg',1,'-02-25 19:20:14','资讯详情5','-02-25 19:20:14');/*!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 */;
