springboot+mybatis+shiro+bootstrap+Mysql网上书店管理系统源码

/* SQLyog Ultimate v12.14 (64 bit) MySQL - 5.5.40 : Database - bookstore ********************************************************************* */ /*!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*/`bookstore` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `bookstore`; /*Table structure for table `book_category` */ DROP TABLE IF EXISTS `book_category`; CREATE TABLE `book_category` ( `cate_id` int(16) NOT NULL AUTO_INCREMENT, `parent_id` int(16) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `status` int(1) DEFAULT NULL, `sort_order` int(4) DEFAULT NULL, `is_parent` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, PRIMARY KEY (`cate_id`), KEY `parent_id` (`parent_id`), CONSTRAINT `book_category_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `book_category` (`cate_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; /*Data for the table `book_category` */ insert into `book_category`(`cate_id`,`parent_id`,`name`,`status`,`sort_order`,`is_parent`,`created`,`updated`) values (2,NULL,'科技',1,1,0,'2018-11-01 09:43:46','2018-11-01 09:43:49'), (3,NULL,'文学经典',1,1,0,'2018-11-01 09:46:08','2018-11-01 09:46:11'), (4,NULL,'人文社科',1,1,0,'2018-11-01 09:46:33','2018-11-01 09:46:35'), (5,NULL,'生活',1,1,0,'2018-11-01 09:47:09','2018-11-01 09:47:12'), (6,NULL,'童书',1,1,0,'2018-11-01 09:47:44','2018-11-01 09:47:48'), (7,NULL,'小说',1,1,0,'2018-11-01 15:50:56','2018-11-01 15:50:58'); /*Table structure for table `book_desc` */ DROP TABLE IF EXISTS `book_desc`; CREATE TABLE `book_desc` ( `book_id` int(11) NOT NULL, `book_desc` text, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, PRIMARY KEY (`book_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `book_desc` */ insert into `book_desc`(`book_id`,`book_desc`,`created`,`updated`) values (1,'<p><br/><a href=\"http://store.dangdang.com/gys_04099_dytg\" style=\"color: rgb(26, 102, 179); font-family: &quot;Hiragino Sans GB&quot;, Verdana, Simsun; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\"><img src=\"/ueditor/jsp/upload/image/20181124/1543065820217043526.jpg\"/></a></p>','2018-11-24 21:23:43','2018-11-24 21:23:43'), (185,'<ul class=\"key clearfix list-paddingleft-2\" style=\"list-style-type: none;\"><li><p>开 本：16开</p></li><li><p>纸 张：胶版纸</p></li><li><p>包 装：平装-胶订</p></li><li><p>是否套装：否</p></li><li><p>国际标准书号ISBN：9787111573319</p></li><li><p>所属分类：<span class=\"lie\" style=\"display: block; padding: 0px; font-family: sinsun; clear: both;\"><a target=\"_bland\" href=\"http://category.dangdang.com/cp01.00.00.00.00.00.html\" class=\"green\" style=\"text-decoration-line: none; color: rgb(26, 102, 179);\">图书</a>&gt;<a target=\"_bland\" href=\"http://category.dangdang.com/cp01.54.00.00.00.00.html\" class=\"green\" style=\"text-decoration-line: none; color: rgb(26, 102, 179);\">计算机/网络</a>&gt;<a target=\"_bland\" href=\"http://category.dangdang.com/cp01.54.06.00.00.00.html\" class=\"green\" style=\"text-decoration-line: none; color: rgb(26, 102, 179);\">程序设计</a>&gt;<a target=\"_bland\" href=\"http://category.dangdang.com/cp01.54.06.06.00.00.html\" class=\"green\" style=\"text-decoration-line: none; color: rgb(26, 102, 179);\">Java</a></span></p></li></ul><p><a class=\"browser browser_op\" style=\"height: 0px; font-size: 0px; line-height: 0; overflow: hidden; color: rgb(100, 100, 100); position: absolute; right: -90px; top: -58px; font-family: &quot;Hiragino Sans GB&quot;, Verdana, Simsun; white-space: normal; background-color: rgb(255, 255, 255);\"></a></p><ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p>快速直达</p></li><li><p><a><span class=\"icon\" style=\"position: absolute; left: 0px; top: 15px; display: block; width: 8px; height: 8px; overflow: hidden; background: url(&quot;../images/product_sprites.png&quot;) 0px -500px no-repeat;\"></span>内容简介</a></p></li><li><p><a style=\"color: rgb(255, 40, 50);\"><span class=\"icon\" style=\"position: absolute; left: -12px; top: 15px; display: block; width: 7px; height: 7px; overflow: hidden; background-image: url(&quot;../images/product_sprites.png&quot;); background-position: -15px -500px; background-size: initial; background-repeat: no-repeat; background-attachment: initial; background-origin: initial; background-clip: initial;\"></span>目　　录</a></p></li><li><p><a><span class=\"icon\" style=\"position: absolute; left: 0px; top: 15px; display: block; width: 8px; height: 8px; overflow: hidden; background: url(&quot;../images/product_sprites.png&quot;) 0px -500px no-repeat;\"></span>前　　言</a></p></li></ul><p><a style=\"color: rgb(100, 100, 100);\"><span style=\"display: block; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 14px; line-height: 18px; font-family: &quot;Microsoft Yahei&quot;; margin: 0px auto; text-align: center;\">下载免费当当读书</span></a></p><p><a href=\"http://book.dangdang.com/20181106_1hu0\" target=\"_blank\" style=\"text-decoration-line: none; color: rgb(26, 102, 179);\"><img src=\"/ueditor/jsp/upload/image/20181111/1541927607930084356.jpg\" alt=\"\"/></a></p><p><span style=\"float: left; border-left: 2px solid rgb(255, 40, 50); padding: 0px 30px 2px 6px; background: url(&quot;../images/product_sprites.png&quot;) right -525px no-repeat rgb(229, 229, 229); height: 22px; margin-bottom: -2px; position: relative; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 14px; line-height: 22px; font-family: &quot;Microsoft Yahei&quot;; color: rgb(50, 50, 50);\">内容简介</span></p><p>本书是Java领域有影响力和价值的著作之一，由拥有20多年教学与研究经验的Java技术专家撰写（获Jolt大奖），与《Java编程思想》齐名，10余年全球畅销不衰，广受好评。第10版根据JavaSE8全面更新，同时修正了第9版中的不足，系统全面讲解了Java语言的核心概念、语法、重要特性和开发方法，包含大量案例，实践性强。</p><p><span style=\"float: left; border-left: 2px solid rgb(255, 40, 50); padding: 0px 30px 2px 6px; background: url(&quot;../images/product_sprites.png&quot;) right -525px no-repeat rgb(229, 229, 229); height: 22px; margin-bottom: -2px; position: relative; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 14px; line-height: 22px; font-family: &quot;Microsoft Yahei&quot;; color: rgb(50, 50, 50);\">目　　录</span></p><p>目　　录<br/>译者序<br/>前言<br/>第1章　Java SE 8的流库 1<br/>1.1　从迭代到流的操作 1<br/>1.2　流的创建 3<br/>1.3　f?ilter、map和f?latMap方法 6<br/>1.4　抽取子流和连接流 8<br/>1.5　其他的流转换 8<br/>1.6　简单约简 9<br/>1.7　Optional类型 11<br/>1.7.1　如何使用Optional值 11<br/>1.7.2　不适合使用Optional值的方式 12<br/>1.7.3　创建Optional值 13</p><p><a class=\"section_show_more\" style=\"color: rgb(80, 80, 80); padding: 0px 15px; height: 22px; overflow: hidden; line-height: 22px; background: url(&quot;../images/product_sprites.png&quot;) 0px -95px repeat-x; border: 1px solid rgb(230, 230, 230); float: right; border-radius: 3px; margin-left: 10px; font-size: 12px;\">显示全部信息</a></p><p><span style=\"float: left; border-left: 2px solid rgb(255, 40, 50); padding: 0px 30px 2px 6px; background: url(&quot;../images/product_sprites.png&quo