基于微信小程序的备忘录英语学习资源交流平台SSM-JAVA【数据库设计、论文、毕设源码、开题报告】

最新推荐文章于 2024-06-13 21:12:59 发布

云码资源

最新推荐文章于 2024-06-13 21:12:59 发布

阅读量152

点赞数

分类专栏：微信小程序实战项目文章标签：数据库 mysql tomcat

本文链接：https://blog.csdn.net/itrjxxs_2/article/details/129136479

版权

微信小程序实战项目专栏收录该内容

100 篇文章 12 订阅

订阅专栏

功能介绍

管理员：个人中心、用户管理、每日打卡管理、备忘录管理、学习计划管理、学习资源管理、论坛交流、系统管理。

用户：个人中心、每日打卡、备忘录、学习计划、学习资源、论坛交流、我的收藏。

使用技术

使用框架：SSM
开发语言：Java、小程序，
前端技术：JavaScript、VUE.js（2.X）、css3
框架：ssm，JDK版本：JDK1.8 ，
服务器：tomcat9 ，
数据库：mysql 5.7，
数据库工具：Navicat11，
开发软件：eclipse/myeclipse/idea，
浏览器：谷歌浏览器，
小程序运行软件：微信开发者

项目截图

在这里插入图片描述

数据库脚本


/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - ssmx5rm4
*********************************************************************
*/


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

USE `ssmx5rm4`;

/*Table structure for table `beiwanglu` */

DROP TABLE IF EXISTS `beiwanglu`;

CREATE TABLE `beiwanglu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `yonghu` varchar(200) DEFAULT NULL COMMENT '用户',
  `biaoti` varchar(200) DEFAULT NULL COMMENT '标题',
  `peitu` varchar(200) DEFAULT NULL COMMENT '配图',
  `shixiang` longtext COMMENT '事项',
  `riqi` date DEFAULT NULL COMMENT '日期',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='备忘录';

/*Data for the table `beiwanglu` */

insert  into `beiwanglu`(`id`,`addtime`,`zhanghao`,`yonghu`,`biaoti`,`peitu`,`shixiang`,`riqi`,`userid`) values (31,'2022-04-21 20:26:21','账号1','用户1','标题1','http://localhost:8080/ssmx5rm4/upload/beiwanglu_peitu1.jpg','事项1','2022-04-21',1),(32,'2022-04-21 20:26:21','账号2','用户2','标题2','http://localhost:8080/ssmx5rm4/upload/beiwanglu_peitu2.jpg','事项2','2022-04-21',2),(33,'2022-04-21 20:26:21','账号3','用户3','标题3','http://localhost:8080/ssmx5rm4/upload/beiwanglu_peitu3.jpg','事项3','2022-04-21',3),(34,'2022-04-21 20:26:21','账号4','用户4','标题4','http://localhost:8080/ssmx5rm4/upload/beiwanglu_peitu4.jpg','事项4','2022-04-21',4),(35,'2022-04-21 20:26:21','账号5','用户5','标题5','http://localhost:8080/ssmx5rm4/upload/beiwanglu_peitu5.jpg','事项5','2022-04-21',5),(36,'2022-04-21 20:26:21','账号6','用户6','标题6','http://localhost:8080/ssmx5rm4/upload/beiwanglu_peitu6.jpg','事项6','2022-04-21',6);

/*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=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*Data for the table `config` */

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

/*Table structure for table `discussxuexiziyuan` */

DROP TABLE IF EXISTS `discussxuexiziyuan`;

CREATE TABLE `discussxuexiziyuan` (
  `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=97 DEFAULT CHARSET=utf8 COMMENT='学习资源评论表';

/*Data for the table `discussxuexiziyuan` */

insert  into `discussxuexiziyuan`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (91,'2022-04-21 20:26:21',1,1,'用户名1','评论内容1','回复内容1'),(92,'2022-04-21 20:26:21',2,2,'用户名2','评论内容2','回复内容2'),(93,'2022-04-21 20:26:21',3,3,'用户名3','评论内容3','回复内容3'),(94,'2022-04-21 20:26:21',4,4,'用户名4','评论内容4','回复内容4'),(95,'2022-04-21 20:26:21',5,5,'用户名5','评论内容5','回复内容5'),(96,'2022-04-21 20:26:21',6,6,'用户名6','评论内容6','回复内容6');

/*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=67 DEFAULT CHARSET=utf8 COMMENT='论坛交流';

/*Data for the table `forum` */

insert  into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (61,'2022-04-21 20:26:21','帖子标题1','帖子内容1',1,1,'用户名1','开放'),(62,'2022-04-21 20:26:21','帖子标题2','帖子内容2',2,2,'用户名2','开放'),(63,'2022-04-21 20:26:21','帖子标题3','帖子内容3',3,3,'用户名3','开放'),(64,'2022-04-21 20:26:21','帖子标题4','帖子内容4',4,4,'用户名4','开放'),(65,'2022-04-21 20:26:21','帖子标题5','帖子内容5',5,5,'用户名5','开放'),(66,'2022-04-21 20:26:21','帖子标题6','帖子内容6',6,6,'用户名6','开放');

/*Table structure for table `meiridaka` */

DROP TABLE IF EXISTS `meiridaka`;

CREATE TABLE `meiridaka` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `yonghu` varchar(200) DEFAULT NULL COMMENT '用户',
  `daka` varchar(200) DEFAULT NULL COMMENT '打卡',
  `dongtai` longtext COMMENT '动态',
  `peitu` varchar(200) DEFAULT NULL COMMENT '配图',
  `shijian` datetime DEFAULT NULL COMMENT '时间',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='每日打卡';

/*Data for the table `meiridaka` */

insert  into `meiridaka`(`id`,`addtime`,`zhanghao`,`yonghu`,`daka`,`dongtai`,`peitu`,`shijian`,`userid`) values (21,'2022-04-21 20:26:21','账号1','用户1','签到','动态1','http://localhost:8080/ssmx5rm4/upload/meiridaka_peitu1.jpg','2022-04-21 20:26:21',1),(22,'2022-04-21 20:26:21','账号2','用户2','签到','动态2','http://localhost:8080/ssmx5rm4/upload/meiridaka_peitu2.jpg','2022-04-21 20:26:21',2),(23,'2022-04-21 20:26:21','账号3','用户3','签到','动态3','http://localhost:8080/ssmx5rm4/upload/meiridaka_peitu3.jpg','2022-04-21 20:26:21',3),(24,'2022-04-21 20:26:21','账号4','用户4','签到','动态4','http://localhost:8080/ssmx5rm4/upload/meiridaka_peitu4.jpg','2022-04-21 20:26:21',4),(25,'2022-04-21 20:26:21','账号5','用户5','签到','动态5','http://localhost:8080/ssmx5rm4/upload/meiridaka_peitu5.jpg','2022-04-21 20:26:21',5),(26,'2022-04-21 20:26:21','账号6','用户6','签到','动态6','http://localhost:8080/ssmx5rm4/upload/meiridaka_peitu6.jpg','2022-04-21 20:26:21',6);

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `introduction` longtext COMMENT '简介',
  `picture` varchar(200) NOT NULL COMMENT '图片',
  `content` longtext NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='网站资讯';

/*Data for the table `news` */

insert  into `news`(`id`,`addtime`,`title`,`introduction`,`picture`,`content`) values (81,'2022-04-21 20:26:21','标题1','简介1','http://localhost:8080/ssmx5rm4/upload/news_picture1.jpg','内容1'),(82,'2022-04-21 20:26:21','标题2','简介2','http://localhost:8080/ssmx5rm4/upload/news_picture2.jpg','内容2'),(83,'2022-04-21 20:26:21','标题3','简介3','http://localhost:8080/ssmx5rm4/upload/news_picture3.jpg','内容3'),(84,'2022-04-21 20:26:21','标题4','简介4','http://localhost:8080/ssmx5rm4/upload/news_picture4.jpg','内容4'),(85,'2022-04-21 20:26:21','标题5','简介5','http://localhost:8080/ssmx5rm4/upload/news_picture5.jpg','内容5'),(86,'2022-04-21 20:26:21','标题6','简介6','http://localhost:8080/ssmx5rm4/upload/news_picture6.jpg','内容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 '收藏图片',
  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 DEFAULT CHARSET=utf8 COMMENT='token表';

/*Data for the table `token` */

/*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','管理员','2022-04-21 20:26:21');

/*Table structure for table `xuexijihua` */

DROP TABLE IF EXISTS `xuexijihua`;

CREATE TABLE `xuexijihua` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `yonghu` varchar(200) DEFAULT NULL COMMENT '用户',
  `xueximubiao` varchar(200) DEFAULT NULL COMMENT '学习目标',
  `xuexineirong` longtext COMMENT '学习内容',
  `xuexibiao` varchar(200) DEFAULT NULL COMMENT '学习表',
  `qishiriqi` date DEFAULT NULL COMMENT '起始日期',
  `jieshuriqi` date DEFAULT NULL COMMENT '结束日期',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='学习计划';

/*Data for the table `xuexijihua` */

insert  into `xuexijihua`(`id`,`addtime`,`zhanghao`,`yonghu`,`xueximubiao`,`xuexineirong`,`xuexibiao`,`qishiriqi`,`jieshuriqi`,`userid`) values (41,'2022-04-21 20:26:21','账号1','用户1','学习目标1','学习内容1','http://localhost:8080/ssmx5rm4/upload/xuexijihua_xuexibiao1.jpg','2022-04-21','2022-04-21',1),(42,'2022-04-21 20:26:21','账号2','用户2','学习目标2','学习内容2','http://localhost:8080/ssmx5rm4/upload/xuexijihua_xuexibiao2.jpg','2022-04-21','2022-04-21',2),(43,'2022-04-21 20:26:21','账号3','用户3','学习目标3','学习内容3','http://localhost:8080/ssmx5rm4/upload/xuexijihua_xuexibiao3.jpg','2022-04-21','2022-04-21',3),(44,'2022-04-21 20:26:21','账号4','用户4','学习目标4','学习内容4','http://localhost:8080/ssmx5rm4/upload/xuexijihua_xuexibiao4.jpg','2022-04-21','2022-04-21',4),(45,'2022-04-21 20:26:21','账号5','用户5','学习目标5','学习内容5','http://localhost:8080/ssmx5rm4/upload/xuexijihua_xuexibiao5.jpg','2022-04-21','2022-04-21',5),(46,'2022-04-21 20:26:21','账号6','用户6','学习目标6','学习内容6','http://localhost:8080/ssmx5rm4/upload/xuexijihua_xuexibiao6.jpg','2022-04-21','2022-04-21',6);

/*Table structure for table `xuexiziyuan` */

DROP TABLE IF EXISTS `xuexiziyuan`;

CREATE TABLE `xuexiziyuan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `biaoti` varchar(200) DEFAULT NULL COMMENT '标题',
  `jianjie` longtext COMMENT '简介',
  `peitu` varchar(200) DEFAULT NULL COMMENT '配图',
  `shipinxuexi` varchar(200) DEFAULT NULL COMMENT '视频学习',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='学习资源';

/*Data for the table `xuexiziyuan` */

insert  into `xuexiziyuan`(`id`,`addtime`,`biaoti`,`jianjie`,`peitu`,`shipinxuexi`,`thumbsupnum`,`crazilynum`,`userid`) values (51,'2022-04-21 20:26:21','标题1','简介1','http://localhost:8080/ssmx5rm4/upload/xuexiziyuan_peitu1.jpg','',1,1,1),(52,'2022-04-21 20:26:21','标题2','简介2','http://localhost:8080/ssmx5rm4/upload/xuexiziyuan_peitu2.jpg','',2,2,2),(53,'2022-04-21 20:26:21','标题3','简介3','http://localhost:8080/ssmx5rm4/upload/xuexiziyuan_peitu3.jpg','',3,3,3),(54,'2022-04-21 20:26:21','标题4','简介4','http://localhost:8080/ssmx5rm4/upload/xuexiziyuan_peitu4.jpg','',4,4,4),(55,'2022-04-21 20:26:21','标题5','简介5','http://localhost:8080/ssmx5rm4/upload/xuexiziyuan_peitu5.jpg','',5,5,5),(56,'2022-04-21 20:26:21','标题6','简介6','http://localhost:8080/ssmx5rm4/upload/xuexiziyuan_peitu6.jpg','',6,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 '密码',
  `yonghu` varchar(200) NOT NULL COMMENT '用户',
  `nianling` int(11) DEFAULT NULL COMMENT '年龄',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='用户';

/*Data for the table `yonghu` */

insert  into `yonghu`(`id`,`addtime`,`zhanghao`,`mima`,`yonghu`,`nianling`,`xingbie`,`shouji`,`youxiang`,`touxiang`) values (11,'2022-04-21 20:26:21','用户1','123456','用户1',1,'男','13823888881','773890001@qq.com','http://localhost:8080/ssmx5rm4/upload/yonghu_touxiang1.jpg'),(12,'2022-04-21 20:26:21','用户2','123456','用户2',2,'男','13823888882','773890002@qq.com','http://localhost:8080/ssmx5rm4/upload/yonghu_touxiang2.jpg'),(13,'2022-04-21 20:26:21','用户3','123456','用户3',3,'男','13823888883','773890003@qq.com','http://localhost:8080/ssmx5rm4/upload/yonghu_touxiang3.jpg'),(14,'2022-04-21 20:26:21','用户4','123456','用户4',4,'男','13823888884','773890004@qq.com','http://localhost:8080/ssmx5rm4/upload/yonghu_touxiang4.jpg'),(15,'2022-04-21 20:26:21','用户5','123456','用户5',5,'男','13823888885','773890005@qq.com','http://localhost:8080/ssmx5rm4/upload/yonghu_touxiang5.jpg'),(16,'2022-04-21 20:26:21','用户6','123456','用户6',6,'男','13823888886','773890006@qq.com','http://localhost:8080/ssmx5rm4/upload/yonghu_touxiang6.jpg');

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