基于Java的在线题库系统Tamguo设计源码

/* Navicat MySQL Data Transfer Source Server : dev Source Server Version : 80012 Source Host : localhost:3306 Source Database : tamguo_20181110 Target Server Type : MYSQL Target Server Version : 80012 File Encoding : 65001 Date: 2018-12-25 11:37:05 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for b_book -- ---------------------------- DROP TABLE IF EXISTS `b_book`; CREATE TABLE `b_book` ( `id` varchar(64) NOT NULL DEFAULT '' COMMENT 'ID', `category_id` varchar(64) NOT NULL DEFAULT '' COMMENT '分类ID', `book_image` varchar(255) NOT NULL DEFAULT '' COMMENT '背景图片', `owner` varchar(64) NOT NULL DEFAULT '' COMMENT '所属人', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '书籍', `seo_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo 标题', `seo_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo 关键字', `seo_description` varchar(1000) NOT NULL DEFAULT '' COMMENT 'seo 描述', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `update_date` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of b_book -- ---------------------------- INSERT INTO `b_book` VALUES ('1', 'bcyy,c', '/files/tamguo.jpg', '1065071806269284353', '理科数学必修一', '理科数学必修一', '理科数学必修一', '理科数学必修一', '2018-12-06 10:05:18', '2018-12-06 10:05:18'); INSERT INTO `b_book` VALUES ('1065126653186768898', 'zxx,lishi', '/files/201811/avatar/归还店铺选择.png', '1065071806269284353', '理科数学必修一', '理科数学必修一', '理科数学必修一', '理科数学必修一', '2018-12-06 10:11:38', '2018-12-06 10:11:38'); INSERT INTO `b_book` VALUES ('1065140605992009729', 'bcyy,c', '', '1065071806269284353', 'MyBook', 'MyBook', 'MyBook', 'MyBook', '2018-12-06 10:05:32', '2018-12-06 10:05:32'); INSERT INTO `b_book` VALUES ('1065958910688444418', 'zxx,shuxue', '', '1065071806269284353', '高中语法常考点', '高中语法常考点', '高中语法常考点', '高中语法常考点', '2018-11-23 21:23:04', '2018-11-23 21:23:04'); INSERT INTO `b_book` VALUES ('1066233676301287425', 'bcyy', '', '1065071806269284353', 'Axios 中文说明', 'Axios 中文说明', 'Axios 中文说明', 'Axios 中文说明', '2018-11-24 15:34:53', '2018-11-24 15:34:53'); INSERT INTO `b_book` VALUES ('1066236400531095553', 'bcyy', '/files/201811/avatar/u=3471481518,1845750506&fm=11&gp=0.jpg', '1065071806269284353', 'Linux入门教程', 'Linux入门教程', 'Linux入门教程', 'Linux入门教程', '2018-11-26 18:53:17', '2018-11-26 18:53:17'); INSERT INTO `b_book` VALUES ('1067009988594970626', 'bcyy', '/files/201811/avatar/timg.jpg', '1065071806269284353', 'MySQL 5.1说明文档', 'MySQL 5.1说明文档', 'MySQL 5.1说明文档', 'MySQL 5.1说明文档', '2018-11-26 18:59:40', '2018-11-26 18:59:40'); INSERT INTO `b_book` VALUES ('1067315901956567041', 'bcyy', '/files/201811/avatar/spring.jpg', '1065071806269284353', '关于Spring的思考', '关于Spring的思考', '关于Spring的思考', '关于Spring的思考', '2018-11-27 15:15:35', '2018-11-27 15:15:35'); INSERT INTO `b_book` VALUES ('1067593780321792001', 'bcyy', '', '1065071806269284353', 'AOP 的利器：ASM 3.0 介绍', 'AOP 的利器：ASM 3.0 介绍', 'AOP 的利器：ASM 3.0 介绍', 'AOP 的利器：ASM 3.0 介绍', '2018-11-28 09:39:27', '2018-11-28 09:39:27'); INSERT INTO `b_book` VALUES ('1069448618760417281', 'zxx,shuxue', '', '1065071806269284353', '人教版高中必修一', '人教版高中必修一', '人教版高中必修一', '人教版高中必修一', '2018-12-03 12:29:55', '2018-12-03 12:29:55'); -- ---------------------------- -- Table structure for b_book_category -- ---------------------------- DROP TABLE IF EXISTS `b_book_category`; CREATE TABLE `b_book_category` ( `id` varchar(64) NOT NULL DEFAULT '' COMMENT 'ID', `parent_id` varchar(64) NOT NULL COMMENT '父级编号', `parent_ids` varchar(1000) NOT NULL COMMENT '所有父级编号', `tree_sort` decimal(10,0) NOT NULL COMMENT '本级排序号（升序）', `tree_sorts` varchar(1000) NOT NULL COMMENT '所有级别排序号', `tree_leaf` char(1) NOT NULL COMMENT '是否最末级', `tree_level` decimal(4,0) NOT NULL COMMENT '层次级别', `tree_names` varchar(1000) NOT NULL COMMENT '全节点名', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称', `seo_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo 标题', `seo_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo 关键字', `seo_description` varchar(1000) NOT NULL DEFAULT '' COMMENT 'seo 描述', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `update_date` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of b_book_category -- ---------------------------- INSERT INTO `b_book_category` VALUES ('bcyy', '0', '0,bcyy,', '50', '0000000050,500000000,', '0', '1', '编程语言/编程语言', '编程语言', '专业的编程书籍托管平台 - 探书网', '文档说明、官方文档、技术文档、专业文档、开发手册、api手册、在线文档', 'book.tamguo.com 是一个面向程序员的书籍托管平台，提供书籍 、文章、博客、章节、在线文档、开发手册、文档说明、分享、打印、下载服务', '2018-11-20 17:52:25', '2018-11-20 17:52:27'); INSERT INTO `b_book_category` VALUES ('c', 'bcyy', '0,bcyy,c', '80', '0000000080,800000000,', '1', '2', '编程语言/编程语言/c', 'c语言', 'c语言', 'c语言', 'c语言', '2018-11-27 14:44:29', '2018-11-27 14:44:48'); INSERT INTO `b_book_category` VALUES ('c++', 'bcyy', '0,bcyy,c++', '90', '0000000090,900000000,', '1', '2', '编程语言/编程语言/c++', 'c++', 'c++', 'c++', 'c++', '2018-11-27 14:46:03', '2018-11-27 14:46:07'); INSERT INTO `b_book_category` VALUES ('huaxue', 'zxx', '0,zxx,huaxue', '70', '0000000070,700000000,', '0', '1', '高考/高考/化学', '化学', '化学', '化学', '化学', '2018-11-27 15:08:47', '2018-11-27 15:08:50'); INSERT INTO `b_book_category` VALUES ('java', 'bcyy', '0,bcyy,java', '60', '0000000060,600000000,', '1', '2', '编程语言/编程语言/java', 'java', 'java', 'java', 'java', '2018-11-27 14:41:22', '2018-11-27 14:41:24'); INSERT INTO `b_book_category` VALUES ('javascript', 'bcyy', '0,bcyy,javascript', '110', '00000000110,1100000000,', '1', '2', '编程语言/编程语言/javascript', 'javascript', 'javascript', 'javascript', 'javascript', '2018-11-27 14:49:07', '2018-11-27 14:49:09'); INSERT INTO `b_book_category` VALUES ('lishi', 'gaokao', '0,gaokao,lishi', '100', '00000000100,1000000000,', '0', '1', '高考/高考/历史', '历史', '历史', '历史', '历史', '2018-11-27 15:11:43', '2018-11-27 15:11:45'); INSERT INTO `b_book_category` VALUES ('mssqlserver', 'sjk', '0,sjk,mssqlserver', '80', '0000000080,800000000,', '1', '2', '数据库/数据库/mssqlserver', 'mssqlserver', 'mssqlserver', 'mssqlserver', 'mssqlserver', '2018-11-27 15:00:49', '2018-11-27 15:00:51'); INSERT INTO `b_book_category` VALUES ('mysql', 'sjk', '0,sjk,mysql', '60', '0000000060,600000000,', '1', '2', '数据库/数据库/mysql', 'mysql', 'mysql', 'mysql', 'mysql', '2018-11-27 14:56:43', '2018-11-27 14:56:45'); INSERT INTO `b_book_category` VALUES ('oracle', 'sjk', '0,sjk,mysql', '70', '0000000070,700000000,', '1', '2', '数据库/数据库/oracle', 'oracle', 'oracle', 'oracle', 'oracle', '2018-11-27 14:57:41', '2018-11-27 14:57:44'); INSERT INTO `b_book_category` VALUES ('php', 'bcyy', '0,bcyy,php', '70', '0000000070,700000000,', '1', '2', '编程语言/编程语言/php', 'php', 'php', 'php', 'php', '2018-11-27 14:43:47', '2018-11-27 14:43:50'); INSERT INTO `b_book_category` VALUES ('python', 'bcyy', '0,bcyy,python