【计算机毕业设计】幼儿资源互助共享平台

JAVA编码选手
已于 2024-08-25 12:54:59 修改
阅读量315
点赞数 12
分类专栏：计算机毕业设计实战案例文章标签：课程设计数据结构学习 java-ee maven java intellij-idea
于 2024-02-07 13:41:58 首次发布
本文链接：https://blog.csdn.net/m0_51029849/article/details/136068480
版权
计算机毕业设计实战案例专栏收录该内容
1518 篇文章 16 订阅
订阅专栏
在网络高速发展的时代，众多的软件被开发出来，给用户带来了很大的选择余地，而且人们越来越追求更个性的需求。在这种时代背景下，商家只能以用户为导向，以商品的持续创新作为商家最重要的事项。
在新发展的时代，人们对幼儿资源互助共享平台越来越重视，才能实现幼儿资源互助共享平台的有效发挥，本文将通过幼儿资源互助共享平台的信息，分析在日常生活中对幼儿资源互助共享平台存在哪些问题探讨出进一步提升效率，管理能力的对策。
系统采用了Java技术，将所有模块采用以浏览器交互的模式，选择MySQL作为系统的数据库，来进行系统的设计。基本实现了幼儿资源互助共享平台应有的主要功能模块，本系统有管理员：首页、个人中心、用户管理、卖家管理、咨询师管理、萌宝信息管理、幼儿知识管理、保姆推荐管理、音频资源管理、二手商品管理、商品分类管理、资源分类管理、交流论坛、系统管理，用户；首页、个人中心、萌宝信息管理、保姆推荐管理、音频资源管理，卖家；首页、个人中心、二手商品管理、订单管理，咨询师；首页、个人中心、幼儿知识管理，前台首页；首页、萌宝信息、幼儿知识、保姆推荐、音频资源、二手商品、交流论坛、个人中心、后台管理、购物车等功能。
对系统进行测试后，改善了程序逻辑和代码。同时确保系统中所有的程序都能正常运行，所有的功能都能操作，本系统的开发获取幼儿资源互助共享平台信息能够更加方便快捷，同时也使幼儿资源互助共享平台信息变的更加系统化、有序化。系统界面较友好，易于操作。
传统的幼儿资源互助共享平台方式是在线下实体进行的，用户需要到线下进行实际的了解传统信息，而随着信息不断的普及，越来越多的商家也开始出于各种各样的理由而热衷网上发展，传统的线下模式已经无法满足人们的需求了。
互联网的产生，带来了网络的再次高速发展，人们的生活得到了翻天覆地的变化。人们可以随时随地的享受互联网带来的方便快捷，在生活工作中的方方面面的需要都能在网络上实现，比如萌宝信息、幼儿知识、保姆推荐、音频资源、二手商品等信息。也就是说网络成了人们目前最直接、最方便、最轻松的接入口。
在当今世界，互联网快速发展的现在，如何利用互联网创造更简单高效的生活，这是我们首要讨论的。需要幼儿资源互助共享平台相关网站，一方面使得管理员可以对幼儿资源互助共享平台的信息进行及时更新和信息化的管理，可以较为容易的获取所需信息，系统的操作更加的准确，这是一种潜在趋势，或许可以有效加快幼儿资源互助共享平台的普及情况。
对于网站的设计，要保证主界面的整洁有序，能够抓住人的眼球，不会产生视觉疲劳，更重要的是，带给人容易操作的直观感受，这样才能留住用户去进行使用，增加三分热度的延续期。在系统的后台设计上，要采取非常简洁有效的技术，开发方便的同时，便于以后的维护。我们不但要确保所有的功能都能够满足用户的需求，用户还要能自己主动通过网站去实现想要的操作，而管理者的简单通过网站对用户的需求情况进行了解和管理。为达到这一目的，提出以下目标：
（1）实现管理系统信息关系的系统化、规范化和自动化；
（2）减少维护人员的工作量以及实现用户对信息的控制和管理。
（3）方便查询信息及管理信息等；
（4）通过网络操作，改善处理问题的效率，提高操作人员利用率；
（5）考虑到用户多样性特点，要求界面简单，操作简便。
在这里插入图片描述
/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - ssmkoam8
*********************************************************************
*/

/*!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*/`ssmkoam8` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `ssmkoam8`;

/*Table structure for table `address` */

DROP TABLE IF EXISTS `address`;

CREATE TABLE `address` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `address` varchar(200) NOT NULL COMMENT '地址',
  `name` varchar(200) NOT NULL COMMENT '收货人',
  `phone` varchar(200) NOT NULL COMMENT '电话',
  `isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1622641500533 DEFAULT CHARSET=utf8 COMMENT='地址';

/*Data for the table `address` */

insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (1,'2021-06-02 21:37:13',1,'宇宙银河系金星1号','金某','13823888881','是');
insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (2,'2021-06-02 21:37:13',2,'宇宙银河系木星1号','木某','13823888882','是');
insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (3,'2021-06-02 21:37:13',3,'宇宙银河系水星1号','水某','13823888883','是');
insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (4,'2021-06-02 21:37:13',4,'宇宙银河系火星1号','火某','13823888884','是');
insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (5,'2021-06-02 21:37:13',5,'宇宙银河系土星1号','土某','13823888885','是');
insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (6,'2021-06-02 21:37:13',6,'宇宙银河系月球1号','月某','13823888886','是');
insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (1622641500532,'2021-06-02 21:45:00',1622641174727,'广东省揭阳市榕城区东兴街道宝仁堂小儿推拿玉里苑','发得分高达','12312421232','是');

/*Table structure for table `baomutuijian` */

DROP TABLE IF EXISTS `baomutuijian`;

CREATE TABLE `baomutuijian` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `baomuxingming` varchar(200) DEFAULT NULL COMMENT '保姆姓名',
  `nianling` int(11) DEFAULT NULL COMMENT '年龄',
  `gongzuojingyan` varchar(200) DEFAULT NULL COMMENT '工作经验',
  `jiatingzhuzhi` varchar(200) DEFAULT NULL COMMENT '家庭住址',
  `pingjianeirong` longtext COMMENT '评价内容',
  `baomujianjie` longtext COMMENT '保姆简介',
  `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='保姆推荐';

/*Data for the table `baomutuijian` */

insert  into `baomutuijian`(`id`,`addtime`,`baomuxingming`,`nianling`,`gongzuojingyan`,`jiatingzhuzhi`,`pingjianeirong`,`baomujianjie`,`zhaopian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`,`clicktime`,`clicknum`) values (61,'2021-06-02 21:37:13','保姆姓名1',1,'工作经验1','家庭住址1','评价内容1','保姆简介1','http://localhost:8080/ssmkoam8/upload/baomutuijian_zhaopian1.jpg','账号1','姓名1',1,1,'2021-06-02 21:37:13',1);
insert  into `baomutuijian`(`id`,`addtime`,`baomuxingming`,`nianling`,`gongzuojingyan`,`jiatingzhuzhi`,`pingjianeirong`,`baomujianjie`,`zhaopian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`,`clicktime`,`clicknum`) values (62,'2021-06-02 21:37:13','保姆姓名2',2,'工作经验2','家庭住址2','评价内容2','保姆简介2','http://localhost:8080/ssmkoam8/upload/baomutuijian_zhaopian2.jpg','账号2','姓名2',2,2,'2021-06-02 21:37:13',2);
insert  into `baomutuijian`(`id`,`addtime`,`baomuxingming`,`nianling`,`gongzuojingyan`,`jiatingzhuzhi`,`pingjianeirong`,`baomujianjie`,`zhaopian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`,`clicktime`,`clicknum`) values (63,'2021-06-02 21:37:13','保姆姓名3',3,'工作经验3','家庭住址3','评价内容3','保姆简介3','http://localhost:8080/ssmkoam8/upload/baomutuijian_zhaopian3.jpg','账号3','姓名3',3,3,'2021-06-02 21:37:13',3);
insert  into `baomutuijian`(`id`,`addtime`,`baomuxingming`,`nianling`,`gongzuojingyan`,`jiatingzhuzhi`,`pingjianeirong`,`baomujianjie`,`zhaopian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`,`clicktime`,`clicknum`) values (64,'2021-06-02 21:37:13','保姆姓名4',4,'工作经验4','家庭住址4','评价内容4','保姆简介4','http://localhost:8080/ssmkoam8/upload/baomutuijian_zhaopian4.jpg','账号4','姓名4',4,4,'2021-06-02 21:37:13',4);
insert  into `baomutuijian`(`id`,`addtime`,`baomuxingming`,`nianling`,`gongzuojingyan`,`jiatingzhuzhi`,`pingjianeirong`,`baomujianjie`,`zhaopian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`,`clicktime`,`clicknum`) values (65,'2021-06-02 21:37:13','保姆姓名5',5,'工作经验5','家庭住址5','评价内容5','保姆简介5','http://localhost:8080/ssmkoam8/upload/baomutuijian_zhaopian5.jpg','账号5','姓名5',5,5,'2021-06-02 21:37:13',5);
insert  into `baomutuijian`(`id`,`addtime`,`baomuxingming`,`nianling`,`gongzuojingyan`,`jiatingzhuzhi`,`pingjianeirong`,`baomujianjie`,`zhaopian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`,`clicktime`,`clicknum`) values (66,'2021-06-02 21:37:13','保姆姓名6',6,'工作经验6','家庭住址6','评价内容6','保姆简介6','http://localhost:8080/ssmkoam8/upload/baomutuijian_zhaopian6.jpg','账号6','姓名6',6,6,'2021-06-02 21:37:13',6);

/*Table structure for table `cart` */

DROP TABLE IF EXISTS `cart`;

CREATE TABLE `cart` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `tablename` varchar(200) DEFAULT 'ershoushangpin' COMMENT '商品表名',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `goodid` bigint(20) NOT NULL COMMENT '商品id',
  `goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `picture` varchar(200) DEFAULT NULL COMMENT '图片',
  `buynumber` int(11) NOT NULL COMMENT '购买数量',
  `price` float DEFAULT NULL COMMENT '单价',
  `discountprice` float DEFAULT NULL COMMENT '会员价',
  `maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '商户名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1622641469564 DEFAULT CHARSET=utf8 COMMENT='购物车表';

/*Data for the table `cart` */

/*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`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*Data for the table `config` */

insert  into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/ssmkoam8/upload/picture1.jpg');
insert  into `config`(`id`,`name`,`value`) values (2,'picture2','http://localhost:8080/ssmkoam8/upload/picture2.jpg');
insert  into `config`(`id`,`name`,`value`) values (3,'picture3','http://localhost:8080/ssmkoam8/upload/picture3.jpg');

/*Table structure for table `discussbaomutuijian` */

DROP TABLE IF EXISTS `discussbaomutuijian`;

CREATE TABLE `discussbaomutuijian` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8 COMMENT='保姆推荐评论表';

/*Data for the table `discussbaomutuijian` */

insert  into `discussbaomutuijian`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (171,'2021-06-02 21:37:13',1,1,'用户名1','评论内容1','回复内容1');
insert  into `discussbaomutuijian`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (172,'2021-06-02 21:37:13',2,2,'用户名2','评论内容2','回复内容2');
insert  into `discussbaomutuijian`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (173,'2021-06-02 21:37:13',3,3,'用户名3','评论内容3','回复内容3');
insert  into `discussbaomutuijian`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (174,'2021-06-02 21:37:13',4,4,'用户名4','评论内容4','回复内容4');
insert  into `discussbaomutuijian`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (175,'2021-06-02 21:37:13',5,5,'用户名5','评论内容5','回复内容5');
insert  into `discussbaomutuijian`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (176,'2021-06-02 21:37:13',6,6,'用户名6','评论内容6','回复内容6');

/*Table structure for table `discussershoushangpin` */

DROP TABLE IF EXISTS `discussershoushangpin`;

CREATE TABLE `discussershoushangpin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COMMENT='二手商品评论表';

/*Data for the table `discussershoushangpin` */

insert  into `discussershoushangpin`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (181,'2021-06-02 21:37:13',1,1,'用户名1','评论内容1','回复内容1');
insert  into `discussershoushangpin`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (182,'2021-06-02 21:37:13',2,2,'用户名2','评论内容2','回复内容2');
insert  into `discussershoushangpin`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (183,'2021-06-02 21:37:13',3,3,'用户名3','评论内容3','回复内容3');
insert  into `discussershoushangpin`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (184,'2021-06-02 21:37:13',4,4,'用户名4','评论内容4','回复内容4');
insert  into `discussershoushangpin`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (185,'2021-06-02 21:37:13',5,5,'用户名5','评论内容5','回复内容5');
insert  into `discussershoushangpin`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (186,'2021-06-02 21:37:13',6,6,'用户名6','评论内容6','回复内容6');

/*Table structure for table `discussmengbaoxinxi` */

DROP TABLE IF EXISTS `discussmengbaoxinxi`;

CREATE TABLE `discussmengbaoxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 COMMENT='萌宝信息评论表';

/*Data for the table `discussmengbaoxinxi` */

insert  into `discussmengbaoxinxi`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (161,'2021-06-02 21:37:13',1,1,'用户名1','评论内容1','回复内容1');
insert  into `discussmengbaoxinxi`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (162,'2021-06-02 21:37:13',2,2,'用户名2','评论内容2','回复内容2');
insert  into `discussmengbaoxinxi`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (163,'2021-06-02 21:37:13',3,3,'用户名3','评论内容3','回复内容3');
insert  into `discussmengbaoxinxi`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (164,'2021-06-02 21:37:13',4,4,'用户名4','评论内容4','回复内容4');
insert  into `discussmengbaoxinxi`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (165,'2021-06-02 21:37:13',5,5,'用户名5','评论内容5','回复内容5');
insert  into `discussmengbaoxinxi`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (166,'2021-06-02 21:37:13',6,6,'用户名6','评论内容6','回复内容6');

/*Table structure for table `ershoushangpin` */

DROP TABLE IF EXISTS `ershoushangpin`;

CREATE TABLE `ershoushangpin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
  `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `shangpinleixing` varchar(200) DEFAULT NULL COMMENT '商品类型',
  `shangpinjieshao` longtext COMMENT '商品介绍',
  `guige` varchar(200) DEFAULT NULL COMMENT '规格',
  `chengse` varchar(200) DEFAULT NULL COMMENT '成色',
  `xiangqing` longtext COMMENT '详情',
  `shangpintupian` varchar(200) DEFAULT NULL COMMENT '商品图片',
  `maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
  `maijiaxingming` varchar(200) DEFAULT NULL COMMENT '卖家姓名',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  `price` float NOT NULL COMMENT '价格',
  `onelimittimes` int(11) DEFAULT '-1' COMMENT '单限',
  `alllimittimes` int(11) DEFAULT '-1' COMMENT '库存',
  PRIMARY KEY (`id`),
  UNIQUE KEY `shangpinbianhao` (`shangpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='二手商品';

/*Data for the table `ershoushangpin` */

insert  into `ershoushangpin`(`id`,`addtime`,`shangpinbianhao`,`shangpinmingcheng`,`shangpinleixing`,`shangpinjieshao`,`guige`,`chengse`,`xiangqing`,`shangpintupian`,`maijiazhanghao`,`maijiaxingming`,`thumbsupnum`,`crazilynum`,`price`,`onelimittimes`,`alllimittimes`) values (81,'2021-06-02 21:37:13','商品编号1','商品名称1','商品类型1','商品介绍1','规格1','成色1','详情1','http://localhost:8080/ssmkoam8/upload/ershoushangpin_shangpintupian1.jpg','卖家账号1','卖家姓名1',1,1,99.9,1,99);
insert  into `ershoushangpin`(`id`,`addtime`,`shangpinbianhao`,`shangpinmingcheng`,`shangpinleixing`,`shangpinjieshao`,`guige`,`chengse`,`xiangqing`,`shangpintupian`,`maijiazhanghao`,`maijiaxingming`,`thumbsupnum`,`crazilynum`,`price`,`onelimittimes`,`alllimittimes`) values (82,'2021-06-02 21:37:13','商品编号2','商品名称2','商品类型2','商品介绍2','规格2','成色2','详情2','http://localhost:8080/ssmkoam8/upload/ershoushangpin_shangpintupian2.jpg','卖家账号2','卖家姓名2',2,2,99.9,2,97);
insert  into `ershoushangpin`(`id`,`addtime`,`shangpinbianhao`,`shangpinmingcheng`,`shangpinleixing`,`shangpinjieshao`,`guige`,`chengse`,`xiangqing`,`shangpintupian`,`maijiazhanghao`,`maijiaxingming`,`thumbsupnum`,`crazilynum`,`price`,`onelimittimes`,`alllimittimes`) values (83,'2021-06-02 21:37:13','商品编号3','商品名称3','商品类型3','商品介绍3','规格3','成色3','详情3','http://localhost:8080/ssmkoam8/upload/ershoushangpin_shangpintupian3.jpg','卖家账号3','卖家姓名3',3,3,99.9,3,99);
insert  into `ershoushangpin`(`id`,`addtime`,`shangpinbianhao`,`shangpinmingcheng`,`shangpinleixing`,`shangpinjieshao`,`guige`,`chengse`,`xiangqing`,`shangpintupian`,`maijiazhanghao`,`maijiaxingming`,`thumbsupnum`,`crazilynum`,`price`,`onelimittimes`,`alllimittimes`) values (84,'2021-06-02 21:37:13','商品编号4','商品名称4','商品类型4','商品介绍4','规格4','成色4','详情4','http://localhost:8080/ssmkoam8/upload/ershoushangpin_shangpintupian4.jpg','卖家账号4','卖家姓名4',4,4,99.9,4,99);
insert  into `ershoushangpin`(`id`,`addtime`,`shangpinbianhao`,`shangpinmingcheng`,`shangpinleixing`,`shangpinjieshao`,`guige`,`chengse`,`xiangqing`,`shangpintupian`,`maijiazhanghao`,`maijiaxingming`,`thumbsupnum`,`crazilynum`,`price`,`onelimittimes`,`alllimittimes`) values (85,'2021-06-02 21:37:13','商品编号5','商品名称5','商品类型5','商品介绍5','规格5','成色5','详情5','http://localhost:8080/ssmkoam8/upload/ershoushangpin_shangpintupian5.jpg','卖家账号5','卖家姓名5',5,5,99.9,5,99);
insert  into `ershoushangpin`(`id`,`addtime`,`shangpinbianhao`,`shangpinmingcheng`,`shangpinleixing`,`shangpinjieshao`,`guige`,`chengse`,`xiangqing`,`shangpintupian`,`maijiazhanghao`,`maijiaxingming`,`thumbsupnum`,`crazilynum`,`price`,`onelimittimes`,`alllimittimes`) values (86,'2021-06-02 21:37:13','商品编号6','商品名称6','商品类型6','商品介绍6','规格6','成色6','详情6','http://localhost:8080/ssmkoam8/upload/ershoushangpin_shangpintupian6.jpg','卖家账号6','卖家姓名6',6,6,99.9,6,99);

/*Table structure for table `forum` */

DROP TABLE IF EXISTS `forum`;

CREATE TABLE `forum` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
  `content` longtext NOT NULL COMMENT '帖子内容',
  `parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(200) DEFAULT NULL COMMENT '用户名',
  `isdone` varchar(200) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='交流论坛';

/*Data for the table `forum` */

insert  into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (111,'2021-06-02 21:37:13','帖子标题1','帖子内容1',1,1,'用户名1','开放');
insert  into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (112,'2021-06-02 21:37:13','帖子标题2','帖子内容2',2,2,'用户名2','开放');
insert  into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (113,'2021-06-02 21:37:13','帖子标题3','帖子内容3',3,3,'用户名3','开放');
insert  into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (114,'2021-06-02 21:37:13','帖子标题4','帖子内容4',4,4,'用户名4','开放');
insert  into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (115,'2021-06-02 21:37:13','帖子标题5','帖子内容5',5,5,'用户名5','开放');
insert  into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (116,'2021-06-02 21:37:13','帖子标题6','帖子内容6',6,6,'用户名6','开放');

/*Table structure for table `maijia` */

DROP TABLE IF EXISTS `maijia`;

CREATE TABLE `maijia` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `maijiazhanghao` varchar(200) NOT NULL COMMENT '卖家账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `maijiaxingming` varchar(200) NOT NULL COMMENT '卖家姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
  `zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址',
  `money` float DEFAULT '0' COMMENT '余额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `maijiazhanghao` (`maijiazhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1622641174728 DEFAULT CHARSET=utf8 COMMENT='卖家';

/*Data for the table `maijia` */

insert  into `maijia`(`id`,`addtime`,`maijiazhanghao`,`mima`,`maijiaxingming`,`xingbie`,`lianxidianhua`,`shenfenzheng`,`zhuzhi`,`money`) values (21,'2021-06-02 21:37:13','卖家1','123456','卖家姓名1','男','13823888881','440300199101010001','住址1',100);
insert  into `maijia`(`id`,`addtime`,`maijiazhanghao`,`mima`,`maijiaxingming`,`xingbie`,`lianxidianhua`,`shenfenzheng`,`zhuzhi`,`money`) values (22,'2021-06-02 21:37:13','卖家2','123456','卖家姓名2','男','13823888882','440300199202020002','住址2',100);
insert  into `maijia`(`id`,`addtime`,`maijiazhanghao`,`mima`,`maijiaxingming`,`xingbie`,`lianxidianhua`,`shenfenzheng`,`zhuzhi`,`money`) values (23,'2021-06-02 21:37:13','卖家3','123456','卖家姓名3','男','13823888883','440300199303030003','住址3',100);
insert  into `maijia`(`id`,`addtime`,`maijiazhanghao`,`mima`,`maijiaxingming`,`xingbie`,`lianxidianhua`,`shenfenzheng`,`zhuzhi`,`money`) values (24,'2021-06-02 21:37:13','卖家4','123456','卖家姓名4','男','13823888884','440300199404040004','住址4',100);
insert  into `maijia`(`id`,`addtime`,`maijiazhanghao`,`mima`,`maijiaxingming`,`xingbie`,`lianxidianhua`,`shenfenzheng`,`zhuzhi`,`money`) values (25,'2021-06-02 21:37:13','卖家5','123456','卖家姓名5','男','13823888885','440300199505050005','住址5',100);
insert  into `maijia`(`id`,`addtime`,`maijiazhanghao`,`mima`,`maijiaxingming`,`xingbie`,`lianxidianhua`,`shenfenzheng`,`zhuzhi`,`money`) values (26,'2021-06-02 21:37:13','卖家6','123456','卖家姓名6','男','13823888886','440300199606060006','住址6',100);
insert  into `maijia`(`id`,`addtime`,`maijiazhanghao`,`mima`,`maijiaxingming`,`xingbie`,`lianxidianhua`,`shenfenzheng`,`zhuzhi`,`money`) values (1622641174727,'2021-06-02 21:39:34','2','2','2',NULL,'','','',1900.2);

/*Table structure for table `mengbaoxinxi` */

DROP TABLE IF EXISTS `mengbaoxinxi`;

CREATE TABLE `mengbaoxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `mengbaoxingming` varchar(200) DEFAULT NULL COMMENT '萌宝姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `chushengriqi` date DEFAULT NULL COMMENT '出生日期',
  `tizhong` varchar(200) DEFAULT NULL COMMENT '体重',
  `shenghuoxiguan` varchar(200) DEFAULT NULL COMMENT '生活习惯',
  `xingquaihao` varchar(200) DEFAULT NULL COMMENT '兴趣爱好',
  `mengbaojianjie` longtext COMMENT '萌宝简介',
  `mengbaotupian` varchar(200) DEFAULT NULL COMMENT '萌宝图片',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='萌宝信息';

/*Data for the table `mengbaoxinxi` */

insert  into `mengbaoxinxi`(`id`,`addtime`,`mengbaoxingming`,`xingbie`,`chushengriqi`,`tizhong`,`shenghuoxiguan`,`xingquaihao`,`mengbaojianjie`,`mengbaotupian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`) values (41,'2021-06-02 21:37:13','萌宝姓名1','男','2021-06-02','体重1','生活习惯1','兴趣爱好1','萌宝简介1','http://localhost:8080/ssmkoam8/upload/mengbaoxinxi_mengbaotupian1.jpg','账号1','姓名1',1,1);
insert  into `mengbaoxinxi`(`id`,`addtime`,`mengbaoxingming`,`xingbie`,`chushengriqi`,`tizhong`,`shenghuoxiguan`,`xingquaihao`,`mengbaojianjie`,`mengbaotupian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`) values (42,'2021-06-02 21:37:13','萌宝姓名2','男','2021-06-02','体重2','生活习惯2','兴趣爱好2','萌宝简介2','http://localhost:8080/ssmkoam8/upload/mengbaoxinxi_mengbaotupian2.jpg','账号2','姓名2',2,2);
insert  into `mengbaoxinxi`(`id`,`addtime`,`mengbaoxingming`,`xingbie`,`chushengriqi`,`tizhong`,`shenghuoxiguan`,`xingquaihao`,`mengbaojianjie`,`mengbaotupian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`) values (43,'2021-06-02 21:37:13','萌宝姓名3','男','2021-06-02','体重3','生活习惯3','兴趣爱好3','萌宝简介3','http://localhost:8080/ssmkoam8/upload/mengbaoxinxi_mengbaotupian3.jpg','账号3','姓名3',3,3);
insert  into `mengbaoxinxi`(`id`,`addtime`,`mengbaoxingming`,`xingbie`,`chushengriqi`,`tizhong`,`shenghuoxiguan`,`xingquaihao`,`mengbaojianjie`,`mengbaotupian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`) values (44,'2021-06-02 21:37:13','萌宝姓名4','男','2021-06-02','体重4','生活习惯4','兴趣爱好4','萌宝简介4','http://localhost:8080/ssmkoam8/upload/mengbaoxinxi_mengbaotupian4.jpg','账号4','姓名4',4,4);
insert  into `mengbaoxinxi`(`id`,`addtime`,`mengbaoxingming`,`xingbie`,`chushengriqi`,`tizhong`,`shenghuoxiguan`,`xingquaihao`,`mengbaojianjie`,`mengbaotupian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`) values (45,'2021-06-02 21:37:13','萌宝姓名5','男','2021-06-02','体重5','生活习惯5','兴趣爱好5','萌宝简介5','http://localhost:8080/ssmkoam8/upload/mengbaoxinxi_mengbaotupian5.jpg','账号5','姓名5',5,5);
insert  into `mengbaoxinxi`(`id`,`addtime`,`mengbaoxingming`,`xingbie`,`chushengriqi`,`tizhong`,`shenghuoxiguan`,`xingquaihao`,`mengbaojianjie`,`mengbaotupian`,`zhanghao`,`xingming`,`thumbsupnum`,`crazilynum`) values (46,'2021-06-02 21:37:13','萌宝姓名6','男','2021-06-02','体重6','生活习惯6','兴趣爱好6','萌宝简介6','http://localhost:8080/ssmkoam8/upload/mengbaoxinxi_mengbaotupian6.jpg','账号6','姓名6',6,6);

/*Table structure for table `orders` */

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `orderid` varchar(200) NOT NULL COMMENT '订单编号',
  `tablename` varchar(200) DEFAULT 'ershoushangpin' COMMENT '商品表名',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `goodid` bigint(20) NOT NULL COMMENT '商品id',
  `goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `picture` varchar(200) DEFAULT NULL COMMENT '商品图片',
  `buynumber` int(11) NOT NULL COMMENT '购买数量',
  `price` float NOT NULL DEFAULT '0' COMMENT '价格/积分',
  `discountprice` float DEFAULT '0' COMMENT '折扣价格',
  `total` float NOT NULL DEFAULT '0' COMMENT '总价格/总积分',
  `discounttotal` float DEFAULT '0' COMMENT '折扣总价格',
  `type` int(11) DEFAULT '1' COMMENT '支付类型',
  `status` varchar(200) DEFAULT NULL COMMENT '状态',
  `address` varchar(200) DEFAULT NULL COMMENT '地址',
  `tel` varchar(200) DEFAULT NULL COMMENT '电话',
  `consignee` varchar(200) DEFAULT NULL COMMENT '收货人',
  `maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '商户名称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `orderid` (`orderid`)
) ENGINE=InnoDB AUTO_INCREMENT=1622641538867 DEFAULT CHARSET=utf8 COMMENT='订单';

/*Data for the table `orders` */

insert  into `orders`(`id`,`addtime`,`orderid`,`tablename`,`userid`,`goodid`,`goodname`,`picture`,`buynumber`,`price`,`discountprice`,`total`,`discounttotal`,`type`,`status`,`address`,`tel`,`consignee`,`maijiazhanghao`) values (1622641538866,'2021-06-02 21:45:38','20216221453938833477','ershoushangpin',1622641174727,82,'商品名称2','http://localhost:8080/ssmkoam8/upload/ershoushangpin_shangpintupian2.jpg',2,99.9,99.9,199.8,199.8,1,'已支付','广东省揭阳市榕城区东兴街道宝仁堂小儿推拿玉里苑','12312421232','发得分高达','卖家账号2');

/*Table structure for table `shangpinfenlei` */

DROP TABLE IF EXISTS `shangpinfenlei`;

CREATE TABLE `shangpinfenlei` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `leixing` varchar(200) DEFAULT NULL COMMENT '类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='商品分类';

/*Data for the table `shangpinfenlei` */

insert  into `shangpinfenlei`(`id`,`addtime`,`leixing`) values (91,'2021-06-02 21:37:13','类型1');
insert  into `shangpinfenlei`(`id`,`addtime`,`leixing`) values (92,'2021-06-02 21:37:13','类型2');
insert  into `shangpinfenlei`(`id`,`addtime`,`leixing`) values (93,'2021-06-02 21:37:13','类型3');
insert  into `shangpinfenlei`(`id`,`addtime`,`leixing`) values (94,'2021-06-02 21:37:13','类型4');
insert  into `shangpinfenlei`(`id`,`addtime`,`leixing`) values (95,'2021-06-02 21:37:13','类型5');
insert  into `shangpinfenlei`(`id`,`addtime`,`leixing`) values (96,'2021-06-02 21:37:13','类型6');

/*Table structure for table `storeup` */

DROP TABLE IF EXISTS `storeup`;

CREATE TABLE `storeup` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
  `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
  `name` varchar(200) NOT NULL COMMENT '收藏名称',
  `picture` varchar(200) NOT NULL COMMENT '收藏图片',
  `type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';

/*Data for the table `storeup` */

/*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`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';

/*Data for the table `token` */

insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,1622641113260,'1','yonghu','用户','2vxd4fe3n3zjydxrinb0la7vop2kl0s0','2021-06-02 21:38:37','2021-06-02 22:38:37');
insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (2,1,'abo','users','管理员','bslkrp0ee2snpy4zadyzkrhjm2bjvflj','2021-06-02 21:39:01','2021-06-02 22:39:01');
insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (3,1622641174727,'2','maijia','卖家','ns76ithsfgclqcj3d4068c88gujyul11','2021-06-02 21:39:38','2021-06-02 22:39:39');

/*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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

/*Data for the table `users` */

insert  into `users`(`id`,`username`,`password`,`role`,`addtime`) values (1,'abo','abo','管理员','2021-06-02 21:37:13');

/*Table structure for table `yinpinziyuan` */

DROP TABLE IF EXISTS `yinpinziyuan`;

CREATE TABLE `yinpinziyuan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ziyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '资源名称',
  `ziyuanleixing` varchar(200) DEFAULT NULL COMMENT '资源类型',
  `ziyuanjianjie` longtext COMMENT '资源简介',
  `shipinwenjian` varchar(200) DEFAULT NULL COMMENT '视频文件',
  `shangchuanriqi` date DEFAULT NULL COMMENT '上传日期',
  `xiangqing` longtext COMMENT '详情',
  `ziyuantupian` varchar(200) DEFAULT NULL COMMENT '资源图片',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='音频资源';

/*Data for the table `yinpinziyuan` */

insert  into `yinpinziyuan`(`id`,`addtime`,`ziyuanmingcheng`,`ziyuanleixing`,`ziyuanjianjie`,`shipinwenjian`,`shangchuanriqi`,`xiangqing`,`ziyuantupian`,`zhanghao`,`xingming`) values (71,'2021-06-02 21:37:13','资源名称1','资源类型1','资源简介1','','2021-06-02','详情1','http://localhost:8080/ssmkoam8/upload/yinpinziyuan_ziyuantupian1.jpg','账号1','姓名1');
insert  into `yinpinziyuan`(`id`,`addtime`,`ziyuanmingcheng`,`ziyuanleixing`,`ziyuanjianjie`,`shipinwenjian`,`shangchuanriqi`,`xiangqing`,`ziyuantupian`,`zhanghao`,`xingming`) values (72,'2021-06-02 21:37:13','资源名称2','资源类型2','资源简介2','','2021-06-02','详情2','http://localhost:8080/ssmkoam8/upload/yinpinziyuan_ziyuantupian2.jpg','账号2','姓名2');
insert  into `yinpinziyuan`(`id`,`addtime`,`ziyuanmingcheng`,`ziyuanleixing`,`ziyuanjianjie`,`shipinwenjian`,`shangchuanriqi`,`xiangqing`,`ziyuantupian`,`zhanghao`,`xingming`) values (73,'2021-06-02 21:37:13','资源名称3','资源类型3','资源简介3','','2021-06-02','详情3','http://localhost:8080/ssmkoam8/upload/yinpinziyuan_ziyuantupian3.jpg','账号3','姓名3');
insert  into `yinpinziyuan`(`id`,`addtime`,`ziyuanmingcheng`,`ziyuanleixing`,`ziyuanjianjie`,`shipinwenjian`,`shangchuanriqi`,`xiangqing`,`ziyuantupian`,`zhanghao`,`xingming`) values (74,'2021-06-02 21:37:13','资源名称4','资源类型4','资源简介4','','2021-06-02','详情4','http://localhost:8080/ssmkoam8/upload/yinpinziyuan_ziyuantupian4.jpg','账号4','姓名4');
insert  into `yinpinziyuan`(`id`,`addtime`,`ziyuanmingcheng`,`ziyuanleixing`,`ziyuanjianjie`,`shipinwenjian`,`shangchuanriqi`,`xiangqing`,`ziyuantupian`,`zhanghao`,`xingming`) values (75,'2021-06-02 21:37:13','资源名称5','资源类型5','资源简介5','','2021-06-02','详情5','http://localhost:8080/ssmkoam8/upload/yinpinziyuan_ziyuantupian5.jpg','账号5','姓名5');
insert  into `yinpinziyuan`(`id`,`addtime`,`ziyuanmingcheng`,`ziyuanleixing`,`ziyuanjianjie`,`shipinwenjian`,`shangchuanriqi`,`xiangqing`,`ziyuantupian`,`zhanghao`,`xingming`) values (76,'2021-06-02 21:37:13','资源名称6','资源类型6','资源简介6','','2021-06-02','详情6','http://localhost:8080/ssmkoam8/upload/yinpinziyuan_ziyuantupian6.jpg','账号6','姓名6');

/*Table structure for table `yonghu` */

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhanghao` varchar(200) NOT NULL COMMENT '账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xingming` varchar(200) NOT NULL COMMENT '姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
  `zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址',
  `money` float DEFAULT '0' COMMENT '余额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1622641113261 DEFAULT CHARSET=utf8 COMMENT='用户';

/*Data for the table `yonghu` */

insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`xingming`,`xingbie`,`shouji`,`shenfenzheng`,`zhuzhi`,`money`) values (11,'2021-06-02 21:37:13','用户1','123456','姓名1','男','13823888881','440300199101010001','住址1',100);
insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`xingming`,`xingbie`,`shouji`,`shenfenzheng`,`zhuzhi`,`money`) values (12,'2021-06-02 21:37:13','用户2','123456','姓名2','男','13823888882','440300199202020002','住址2',100);
insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`xingming`,`xingbie`,`shouji`,`shenfenzheng`,`zhuzhi`,`money`) values (13,'2021-06-02 21:37:13','用户3','123456','姓名3','男','13823888883','440300199303030003','住址3',100);
insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`xingming`,`xingbie`,`shouji`,`shenfenzheng`,`zhuzhi`,`money`) values (14,'2021-06-02 21:37:13','用户4','123456','姓名4','男','13823888884','440300199404040004','住址4',100);
insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`xingming`,`xingbie`,`shouji`,`shenfenzheng`,`zhuzhi`,`money`) values (15,'2021-06-02 21:37:13','用户5','123456','姓名5','男','13823888885','440300199505050005','住址5',100);
insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`xingming`,`xingbie`,`shouji`,`shenfenzheng`,`zhuzhi`,`money`) values (16,'2021-06-02 21:37:13','用户6','123456','姓名6','男','13823888886','440300199606060006','住址6',100);
insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`xingming`,`xingbie`,`shouji`,`shenfenzheng`,`zhuzhi`,`money`) values (1622641113260,'2021-06-02 21:38:33','1','1','1',NULL,'','','',0);

/*Table structure for table `youerzhishi` */

DROP TABLE IF EXISTS `youerzhishi`;

CREATE TABLE `youerzhishi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhishimingcheng` varchar(200) DEFAULT NULL COMMENT '知识名称',
  `zhishileixing` varchar(200) DEFAULT NULL COMMENT '知识类型',
  `zhishijianjie` longtext COMMENT '知识简介',
  `xiangguanwenjian` varchar(200) DEFAULT NULL COMMENT '相关文件',
  `shangchuanshijian` date DEFAULT NULL COMMENT '上传时间',
  `fengmiantupian` varchar(200) DEFAULT NULL COMMENT '封面图片',
  `zixunshizhanghao` varchar(200) DEFAULT NULL COMMENT '咨询师账号',
  `zixunshixingming` varchar(200) DEFAULT NULL COMMENT '咨询师姓名',
  `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='幼儿知识';

/*Data for the table `youerzhishi` */

insert  into `youerzhishi`(`id`,`addtime`,`zhishimingcheng`,`zhishileixing`,`zhishijianjie`,`xiangguanwenjian`,`shangchuanshijian`,`fengmiantupian`,`zixunshizhanghao`,`zixunshixingming`,`clicktime`,`clicknum`) values (51,'2021-06-02 21:37:13','知识名称1','知识类型1','知识简介1','','2021-06-02','http://localhost:8080/ssmkoam8/upload/youerzhishi_fengmiantupian1.jpg','咨询师账号1','咨询师姓名1','2021-06-02 21:37:13',1);
insert  into `youerzhishi`(`id`,`addtime`,`zhishimingcheng`,`zhishileixing`,`zhishijianjie`,`xiangguanwenjian`,`shangchuanshijian`,`fengmiantupian`,`zixunshizhanghao`,`zixunshixingming`,`clicktime`,`clicknum`) values (52,'2021-06-02 21:37:13','知识名称2','知识类型2','知识简介2','','2021-06-02','http://localhost:8080/ssmkoam8/upload/youerzhishi_fengmiantupian2.jpg','咨询师账号2','咨询师姓名2','2021-06-02 21:37:13',2);
insert  into `youerzhishi`(`id`,`addtime`,`zhishimingcheng`,`zhishileixing`,`zhishijianjie`,`xiangguanwenjian`,`shangchuanshijian`,`fengmiantupian`,`zixunshizhanghao`,`zixunshixingming`,`clicktime`,`clicknum`) values (53,'2021-06-02 21:37:13','知识名称3','知识类型3','知识简介3','','2021-06-02','http://localhost:8080/ssmkoam8/upload/youerzhishi_fengmiantupian3.jpg','咨询师账号3','咨询师姓名3','2021-06-02 21:37:13',3);
insert  into `youerzhishi`(`id`,`addtime`,`zhishimingcheng`,`zhishileixing`,`zhishijianjie`,`xiangguanwenjian`,`shangchuanshijian`,`fengmiantupian`,`zixunshizhanghao`,`zixunshixingming`,`clicktime`,`clicknum`) values (54,'2021-06-02 21:37:13','知识名称4','知识类型4','知识简介4','','2021-06-02','http://localhost:8080/ssmkoam8/upload/youerzhishi_fengmiantupian4.jpg','咨询师账号4','咨询师姓名4','2021-06-02 21:37:13',4);
insert  into `youerzhishi`(`id`,`addtime`,`zhishimingcheng`,`zhishileixing`,`zhishijianjie`,`xiangguanwenjian`,`shangchuanshijian`,`fengmiantupian`,`zixunshizhanghao`,`zixunshixingming`,`clicktime`,`clicknum`) values (55,'2021-06-02 21:37:13','知识名称5','知识类型5','知识简介5','','2021-06-02','http://localhost:8080/ssmkoam8/upload/youerzhishi_fengmiantupian5.jpg','咨询师账号5','咨询师姓名5','2021-06-02 21:37:13',5);
insert  into `youerzhishi`(`id`,`addtime`,`zhishimingcheng`,`zhishileixing`,`zhishijianjie`,`xiangguanwenjian`,`shangchuanshijian`,`fengmiantupian`,`zixunshizhanghao`,`zixunshixingming`,`clicktime`,`clicknum`) values (56,'2021-06-02 21:37:13','知识名称6','知识类型6','知识简介6','','2021-06-02','http://localhost:8080/ssmkoam8/upload/youerzhishi_fengmiantupian6.jpg','咨询师账号6','咨询师姓名6','2021-06-02 21:37:13',6);

/*Table structure for table `zixunshi` */

DROP TABLE IF EXISTS `zixunshi`;

CREATE TABLE `zixunshi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zixunshizhanghao` varchar(200) NOT NULL COMMENT '咨询师账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `zixunshixingming` varchar(200) NOT NULL COMMENT '咨询师姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `yiling` int(11) DEFAULT NULL COMMENT '医龄',
  `zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',
  `gerenjianjie` longtext COMMENT '个人简介',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `money` float DEFAULT '0' COMMENT '余额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zixunshizhanghao` (`zixunshizhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='咨询师';

/*Data for the table `zixunshi` */

insert  into `zixunshi`(`id`,`addtime`,`zixunshizhanghao`,`mima`,`zixunshixingming`,`xingbie`,`yiling`,`zhicheng`,`gerenjianjie`,`lianxidianhua`,`money`) values (31,'2021-06-02 21:37:13','咨询师1','123456','咨询师姓名1','男',1,'职称1','个人简介1','13823888881',100);
insert  into `zixunshi`(`id`,`addtime`,`zixunshizhanghao`,`mima`,`zixunshixingming`,`xingbie`,`yiling`,`zhicheng`,`gerenjianjie`,`lianxidianhua`,`money`) values (32,'2021-06-02 21:37:13','咨询师2','123456','咨询师姓名2','男',2,'职称2','个人简介2','13823888882',100);
insert  into `zixunshi`(`id`,`addtime`,`zixunshizhanghao`,`mima`,`zixunshixingming`,`xingbie`,`yiling`,`zhicheng`,`gerenjianjie`,`lianxidianhua`,`money`) values (33,'2021-06-02 21:37:13','咨询师3','123456','咨询师姓名3','男',3,'职称3','个人简介3','13823888883',100);
insert  into `zixunshi`(`id`,`addtime`,`zixunshizhanghao`,`mima`,`zixunshixingming`,`xingbie`,`yiling`,`zhicheng`,`gerenjianjie`,`lianxidianhua`,`money`) values (34,'2021-06-02 21:37:13','咨询师4','123456','咨询师姓名4','男',4,'职称4','个人简介4','13823888884',100);
insert  into `zixunshi`(`id`,`addtime`,`zixunshizhanghao`,`mima`,`zixunshixingming`,`xingbie`,`yiling`,`zhicheng`,`gerenjianjie`,`lianxidianhua`,`money`) values (35,'2021-06-02 21:37:13','咨询师5','123456','咨询师姓名5','男',5,'职称5','个人简介5','13823888885',100);
insert  into `zixunshi`(`id`,`addtime`,`zixunshizhanghao`,`mima`,`zixunshixingming`,`xingbie`,`yiling`,`zhicheng`,`gerenjianjie`,`lianxidianhua`,`money`) values (36,'2021-06-02 21:37:13','咨询师6','123456','咨询师姓名6','男',6,'职称6','个人简介6','13823888886',100);

/*Table structure for table `ziyuanfenlei` */

DROP TABLE IF EXISTS `ziyuanfenlei`;

CREATE TABLE `ziyuanfenlei` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `leixing` varchar(200) DEFAULT NULL COMMENT '类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='资源分类';

/*Data for the table `ziyuanfenlei` */

insert  into `ziyuanfenlei`(`id`,`addtime`,`leixing`) values (101,'2021-06-02 21:37:13','类型1');
insert  into `ziyuanfenlei`(`id`,`addtime`,`leixing`) values (102,'2021-06-02 21:37:13','类型2');
insert  into `ziyuanfenlei`(`id`,`addtime`,`leixing`) values (103,'2021-06-02 21:37:13','类型3');
insert  into `ziyuanfenlei`(`id`,`addtime`,`leixing`) values (104,'2021-06-02 21:37:13','类型4');
insert  into `ziyuanfenlei`(`id`,`addtime`,`leixing`) values (105,'2021-06-02 21:37:13','类型5');
insert  into `ziyuanfenlei`(`id`,`addtime`,`leixing`) values (106,'2021-06-02 21:37:13','类型6');

/*!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 */;