基于微信小程序的在线阅读系统微信小程序的实现（后端java）.zip

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50726 Source Host : localhost:3306 Source Database : novel Target Server Type : MYSQL Target Server Version : 50726 File Encoding : 65001 Date: 2022-05-01 14:33:06 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for article -- ---------------------------- DROP TABLE IF EXISTS `article`; CREATE TABLE `article` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `cate` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类别', `title` longtext COLLATE utf8mb4_unicode_ci COMMENT '标题', `content` longtext COLLATE utf8mb4_unicode_ci COMMENT '内容', `pic` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面', `created_at` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建时间', `updated_at` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新时间', `createdAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建时间', `updatedAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='文章'; -- ---------------------------- -- Records of article -- ---------------------------- -- ---------------------------- -- Table structure for banner -- ---------------------------- DROP TABLE IF EXISTS `banner`; CREATE TABLE `banner` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `title` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题', `image` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '图片', `novelId` int(11) DEFAULT '0' COMMENT '小说', `createdAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建时间', `updatedAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='轮播图表'; -- ---------------------------- -- Records of banner -- ---------------------------- INSERT INTO `banner` VALUES ('1', '极品全才', '/static/uploads/20220430/20220430153850.jpeg', '1', '2022-04-30 15:38:51', null); -- ---------------------------- -- Table structure for cate -- ---------------------------- DROP TABLE IF EXISTS `cate`; CREATE TABLE `cate` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `title` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类', `notes` longtext COLLATE utf8mb4_unicode_ci COMMENT '备注', `createdAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建时间', `updatedAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新时间', `image` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面', `mpnav` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '小程序导航', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='小说分类表'; -- ---------------------------- -- Records of cate -- ---------------------------- INSERT INTO `cate` VALUES ('1', '玄幻', '', '2022-04-30 14:47:03', null, '/static/uploads/20220430/20220430144659.jpeg', '1'); INSERT INTO `cate` VALUES ('2', '武侠', '', '2022-04-30 14:47:20', null, '/static/uploads/20220430/20220430144717.jpeg', '1'); INSERT INTO `cate` VALUES ('3', '爱情', '', '2022-04-30 14:47:31', null, '/static/uploads/20220430/20220430144729.jpeg', '1'); INSERT INTO `cate` VALUES ('4', '惊悚', '', '2022-04-30 14:48:31', null, '', '0'); INSERT INTO `cate` VALUES ('5', '网游', '', '2022-04-30 19:11:29', '2022-04-30 19:11:46', '/static/uploads/20220430/20220430191143.jpeg', '1'); INSERT INTO `cate` VALUES ('6', '军事', '', '2022-04-30 19:18:35', null, '', '0'); INSERT INTO `cate` VALUES ('7', '修仙', '', '2022-04-30 19:18:48', null, '', '0'); -- ---------------------------- -- Table structure for chapter -- ---------------------------- DROP TABLE IF EXISTS `chapter`; CREATE TABLE `chapter` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `novelId` int(11) DEFAULT '0' COMMENT '小说ID', `num` int(11) DEFAULT '0' COMMENT '序号', `title` longtext COLLATE utf8mb4_unicode_ci COMMENT '章节', `content` longtext COLLATE utf8mb4_unicode_ci COMMENT '内容', `createdAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建时间', `updatedAt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='小说章节表'; -- ---------------------------- -- Records of chapter -- ---------------------------- INSERT INTO `chapter` VALUES ('1', '1', '1', '第一章节', '<p>第一章节</p><p>第一章节</p><p>第一章节</p><p>第一章节</p><p>第一章节</p><p>第一章节</p>', '2022-04-30 16:36:31', null); INSERT INTO `chapter` VALUES ('2', '1', '2', '第二章节', '<p>第二章节第二章节第二章节</p>', '2022-04-30 16:41:42', null); INSERT INTO `chapter` VALUES ('3', '2', '1', '第一章 田头偶遇', '<p><span>天空一碧如洗，金黄色的稻穗在阵风吹拂下，犹如波涛一般起伏。</span><br><br><span>&nbsp;&nbsp;&nbsp;&nbsp;地里的农人正在挥汗如雨地忙着收割，然而，别说唱首山歌，大多数人就连喘口气说话的功夫都没有。除了偶尔飞过聒噪一下的鸟儿，只有那沙沙的收割声。</span><br><br><span>&nbsp;&nbsp;&nbsp;&nbsp;站在官道旁一道田埂上的张寿欣喜地看着这丰收的一幕，手中拿着一把稻穗，笑眯眯地看着围在身边的几个农人。</span><br><br><span>&nbsp;&nbsp;&nbsp;&nbsp;“前年收成是还不如种麦子，可去年就已经比往年略有富余，今年看这光景，只要紧赶着收完，看这光景，恐怕能比大前年的出息多六成。谁说北方不能种水稻？”</span><br><br><span>&nbsp;&nbsp;&nbsp;&nbsp;听到周围都是附和，他想到之前发现村中附近水系丰沛，很适合种水稻时，哪怕母亲吴氏犹犹豫豫最终答应尝试并开渠减租，这些佃户依旧不情不愿的场面，不禁唏嘘不已。</span></p><div class=\"google-auto-placed ap_container\" style=\"text-align: center;\"><ins data-ad-format=\"auto\" class=\"adsbygoogle adsbygoogle-noablate\" data-ad-client=\"ca-pub-4554708189793180\" data-adsbygoogle-status=\"done\" data-ad-status=\"unfilled\"><ins id=\"aswift_5_expand\" tabindex=\"0\" title=\"Advertisement\" aria-label=\"Advertisement\"><ins id=\"aswift_5_anchor\"><iframe id=\"aswift_5\" name=\"aswift_5\" sandbox=\"allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation\" width=\"920\" height=\"0\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" vspace=\"0\" hspace=\"0\" allowtransparency=\"true\" scrolling=\"no\" trusttoken=\"{&quot;type&quot;:&quot;send-redemption-record&quot;,&quot;issuers&quot;:[&quot;https://pagead2.googlesyndication.com&quot;],&quot;refreshPolicy&quot;:&quot;none&quot;,&quot;signRequestData&quot;:&quot;include&quot;,&quot;includeTimestampHeader&quot;:true,&quot;additionalSignedHeaders&quot;:[&quot;sec-time&quot;,&quot;Sec-Redemption-Record&quot;],&quot;additionalSigningData&quot;:&quot;eyJ1cmwiOiJodHRwczovL3d3dy5xYjUudHcvYm9va18xMDg5ODkvNDA0NzMxMTcuaHRtbCJ9&quot;}\" src=\"https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-4554708189793180&amp;output=html&amp;h=280&amp;adk=2403905552&amp;adf=3897008944&amp;pi=t.aa~a.564632409~i.17~rp.1&amp;w=920&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1651317619&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=6577879424&amp;psa=1&amp;ad_type=text_image&amp;format=