【计算机毕业设计】数学竞赛网站

yh1340327157

已于 2024-08-26 15:37:11 修改

阅读量138

点赞数 1

分类专栏：计算机毕业设计实战案例文章标签：课程设计 java-ee 数据库 java maven eclipse intellij-idea

于 2024-07-14 12:04:27 首次发布

本文链接：https://blog.csdn.net/yh1340327157/article/details/140414883

版权

计算机毕业设计实战案例专栏收录该内容

655 篇文章 0 订阅

订阅专栏

传统办法管理信息首先需要花费的时间比较多，其次数据出错率比较高，而且对错误的数据进行更改也比较困难，最后，检索数据费事费力。因此，在计算机上安装数学竞赛网站软件来发挥其高效地信息处理的作用，可以规范信息管理流程，让管理工作可以系统化和程序化，同时，数学竞赛网站的有效运用可以帮助管理人员准确快速地处理信息。
数学竞赛网站在对开发工具的选择上也很慎重，为了便于开发实现，选择的开发工具为Eclipse，选择的数据库工具为Mysql。以此搭建开发环境实现数学竞赛网站的功能。其中管理员管理用户，新闻公告。
数学竞赛网站是一款运用软件开发技术设计实现的应用系统，在信息处理上可以达到快速的目的，不管是针对数据添加，数据维护和统计，以及数据查询等处理要求，数学竞赛网站都可以轻松应对。
当前的网络技术，软件技术等都具备成熟的理论基础，市场上也出现各种技术开发的软件，这些软件都被用于各个领域，包括生活和工作的领域。随着电脑和笔记本的广泛运用，以及各种计算机硬件的完善和升级，市面上的电脑和笔记本的性能都得到提升，可以支持的软件也逐渐增多，因此，在计算机上安装软件来发挥其高效地信息处理的作用，则很受人们的青睐。对于公交信息来讲，通过手工形式处理，在面对庞大的信息数量时，就显得不适宜了，首先需要花费的时间比较多，其次数据出错率比较高，而且对错误的数据进行更改也比较困难，最后，检索数据费事费力。因此，为了解决上述问题，有必要建立数学竞赛网站，来规范公交信息管理流程，让管理工作可以系统化和程序化，同时，数学竞赛网站的有效运用可以帮助管理人员准确快速地处理信息。
在这里插入图片描述

/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.26 : Database - shuxuejingsuwangzhan
*********************************************************************
*/

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

USE `shuxuejingsuwangzhan`;

/*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,'轮播图1','http://localhost:8080/shuxuejingsuwangzhan/upload/config1.jpg'),(2,'轮播图2','http://localhost:8080/shuxuejingsuwangzhan/upload/config2.jpg'),(3,'轮播图3','http://localhost:8080/shuxuejingsuwangzhan/upload/config3.jpg');

/*Table structure for table `dictionary` */

DROP TABLE IF EXISTS `dictionary`;

CREATE TABLE `dictionary` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dic_code` varchar(200) DEFAULT NULL COMMENT '字段',
  `dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',
  `code_index` int(11) DEFAULT NULL COMMENT '编码',
  `index_name` varchar(200) DEFAULT NULL COMMENT '编码名字  Search111 ',
  `super_id` int(11) DEFAULT NULL COMMENT '父字段id',
  `beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='字典表';

/*Data for the table `dictionary` */

insert  into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (1,'exampaper_types','试卷状态',1,'启用',NULL,NULL,'2022-02-23 17:04:13'),(2,'exampaper_types','试卷状态',2,'禁用',NULL,NULL,'2022-02-23 17:04:13'),(3,'examquestion_types','试题类型',1,'单选题',NULL,NULL,'2022-02-23 17:04:13'),(4,'examquestion_types','试题类型',2,'多选题',NULL,NULL,'2022-02-23 17:04:13'),(5,'examquestion_types','试题类型',3,'判断题',NULL,NULL,'2022-02-23 17:04:13'),(6,'examquestion_types','试题类型',4,'填空题',NULL,NULL,'2022-02-23 17:04:13'),(7,'examredetails_types','审核结果',1,'正确',NULL,NULL,'2022-02-23 17:04:13'),(8,'examredetails_types','审核结果',2,'错误',NULL,NULL,'2022-02-23 17:04:13'),(9,'sex_types','性别',1,'男',NULL,NULL,'2022-02-23 17:04:13'),(10,'sex_types','性别',2,'女',NULL,NULL,'2022-02-23 17:04:13'),(11,'news_types','公告信息类型',1,'公告信息类型1',NULL,NULL,'2022-02-23 17:04:13'),(12,'news_types','公告信息类型',2,'公告信息类型2',NULL,NULL,'2022-02-23 17:04:13'),(13,'news_types','公告信息类型',3,'公告信息类型3',NULL,NULL,'2022-02-23 17:04:13'),(14,'forum_state_types','帖子状态',1,'发帖',NULL,NULL,'2022-02-23 17:04:14'),(15,'forum_state_types','帖子状态',2,'回帖',NULL,NULL,'2022-02-23 17:04:14');

/*Table structure for table `exampaper` */

DROP TABLE IF EXISTS `exampaper`;

CREATE TABLE `exampaper` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `exampaper_name` varchar(200) NOT NULL COMMENT '试卷名称 Search111',
  `exampaper_date` int(11) NOT NULL COMMENT '考试时长(分钟)',
  `exampaper_myscore` int(11) NOT NULL COMMENT '试卷总分',
  `exampaper_types` int(11) NOT NULL DEFAULT '0' COMMENT '试卷状态 Search111',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='试卷表';

/*Data for the table `exampaper` */

insert  into `exampaper`(`id`,`exampaper_name`,`exampaper_date`,`exampaper_myscore`,`exampaper_types`,`create_time`) values (1,'数学竞赛初赛',120,100,1,'2022-02-23 17:28:10');

/*Table structure for table `examquestion` */

DROP TABLE IF EXISTS `examquestion`;

CREATE TABLE `examquestion` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `exampaper_id` int(20) NOT NULL COMMENT '所属试卷id（外键）',
  `examquestion_name` varchar(200) NOT NULL COMMENT '试题名称 Search111',
  `examquestion_options` longtext COMMENT '选项',
  `examquestion_score` int(20) DEFAULT '0' COMMENT '分值 Search111',
  `examquestion_types` int(20) DEFAULT '0' COMMENT '试题类型',
  `examquestion_sequence` int(20) DEFAULT '100' COMMENT '试题排序，值越大排越前面',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='试题表';

/*Data for the table `examquestion` */

insert  into `examquestion`(`id`,`exampaper_id`,`examquestion_name`,`examquestion_options`,`examquestion_score`,`examquestion_types`,`examquestion_sequence`,`create_time`) values (1,1,'1+1=？','[{\"text\":\"1\",\"code\":\"A\"},{\"text\":\"2\",\"code\":\"B\"},{\"text\":\"3\",\"code\":\"C\"},{\"text\":\"4\",\"code\":\"D\"}]',20,1,15,'2022-02-23 17:28:50'),(2,1,'2+2=？','[{\"text\":\"1+1-1+2\",\"code\":\"A\"},{\"text\":\"1+1+2\",\"code\":\"B\"},{\"text\":\"3\",\"code\":\"C\"},{\"text\":\"4\",\"code\":\"D\"}]',20,2,14,'2022-02-23 17:29:59'),(3,1,'3+3=？','[{\"text\":\"对\",\"code\":\"A\"},{\"text\":\"错\",\"code\":\"B\"}]',20,3,13,'2022-02-23 17:31:24'),(4,1,'4+4=？','[]',20,4,12,'2022-02-23 17:31:48'),(5,1,'5+5=？','[]',20,4,11,'2022-02-23 17:32:03');

/*Table structure for table `examrecord` */

DROP TABLE IF EXISTS `examrecord`;

CREATE TABLE `examrecord` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `examrecord_uuid_number` varchar(200) DEFAULT NULL COMMENT '考试编号',
  `yonghu_id` int(20) NOT NULL COMMENT '考试用户',
  `exampaper_id` int(20) NOT NULL COMMENT '所属试卷id（外键）',
  `total_score` int(200) DEFAULT NULL COMMENT '所得总分',
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '考试时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='考试记录表';

/*Data for the table `examrecord` */

insert  into `examrecord`(`id`,`examrecord_uuid_number`,`yonghu_id`,`exampaper_id`,`total_score`,`insert_time`,`create_time`) values (3,'1645614622033',1,1,82,'2022-02-23 19:10:22','2022-02-23 19:10:22');

/*Table structure for table `examredetails` */

DROP TABLE IF EXISTS `examredetails`;

CREATE TABLE `examredetails` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `examredetails_uuid_number` varchar(200) DEFAULT NULL COMMENT '试卷编号',
  `yonghu_id` int(20) NOT NULL COMMENT '用户id',
  `examquestion_id` int(20) NOT NULL COMMENT '试题id（外键）',
  `examredetails_myanswer` varchar(200) DEFAULT NULL COMMENT '考生答案',
  `examredetails_myscore` int(20) DEFAULT NULL COMMENT '试题得分',
  `examination_name` varchar(200) DEFAULT NULL COMMENT '审核教师',
  `examredetails_types` int(20) DEFAULT NULL COMMENT '审核结果',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='答题详情表';

/*Data for the table `examredetails` */

insert  into `examredetails`(`id`,`examredetails_uuid_number`,`yonghu_id`,`examquestion_id`,`examredetails_myanswer`,`examredetails_myscore`,`examination_name`,`examredetails_types`,`create_time`) values (6,'1645614622033',1,1,'A',20,'a2',1,'2022-02-23 19:10:25'),(7,'1645614622033',1,2,'B',20,'a2',1,'2022-02-23 19:10:26'),(8,'1645614622033',1,3,'B',10,'a2',2,'2022-02-23 19:10:28'),(9,'1645614622033',1,4,'12',20,'a2',1,'2022-02-23 19:10:30'),(10,'1645614622033',1,5,'33',12,'a2',2,'2022-02-23 19:10:32');

/*Table structure for table `examrewrongquestion` */

DROP TABLE IF EXISTS `examrewrongquestion`;

CREATE TABLE `examrewrongquestion` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `yonghu_id` int(20) NOT NULL COMMENT '用户id',
  `exampaper_id` int(20) NOT NULL COMMENT '试卷（外键）',
  `examquestion_id` int(20) NOT NULL COMMENT '试题id（外键）',
  `examredetails_myanswer` varchar(200) DEFAULT NULL COMMENT '考生作答',
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='错题表';

/*Data for the table `examrewrongquestion` */

insert  into `examrewrongquestion`(`id`,`yonghu_id`,`exampaper_id`,`examquestion_id`,`examredetails_myanswer`,`insert_time`,`create_time`) values (1,1,1,5,'33','2022-02-23 19:11:28','2022-02-23 19:11:28'),(2,1,1,3,'B','2022-02-23 19:12:15','2022-02-23 19:12:15');

/*Table structure for table `forum` */

DROP TABLE IF EXISTS `forum`;

CREATE TABLE `forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `forum_name` varchar(200) DEFAULT NULL COMMENT '帖子标题  Search111 ',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `jiaoshi_id` int(11) DEFAULT NULL COMMENT '教师',
  `users_id` int(11) DEFAULT NULL COMMENT '管理员',
  `forum_content` text COMMENT '发布内容',
  `super_ids` int(11) DEFAULT NULL COMMENT '父id',
  `forum_state_types` int(11) DEFAULT NULL COMMENT '帖子状态',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '发帖时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='论坛';

/*Data for the table `forum` */

insert  into `forum`(`id`,`forum_name`,`yonghu_id`,`jiaoshi_id`,`users_id`,`forum_content`,`super_ids`,`forum_state_types`,`insert_time`,`update_time`,`create_time`) values (1,'帖子标题1',2,NULL,NULL,'发布内容1',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(2,'帖子标题2',3,NULL,NULL,'发布内容2',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(3,'帖子标题3',3,NULL,NULL,'发布内容3',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(4,'帖子标题4',1,NULL,NULL,'发布内容4',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(5,'帖子标题5',2,NULL,NULL,'发布内容5',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(6,'帖子标题6',3,NULL,NULL,'发布内容6',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(7,'帖子标题7',1,NULL,NULL,'发布内容7',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(8,'帖子标题8',2,NULL,NULL,'发布内容8',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(9,'帖子标题9',3,NULL,NULL,'发布内容9',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(10,'帖子标题10',3,NULL,NULL,'发布内容10',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(11,'帖子标题11',3,NULL,NULL,'发布内容11',NULL,1,'2022-02-23 17:04:27','2022-02-23 17:04:27','2022-02-23 17:04:27'),(12,NULL,1,NULL,NULL,'用户评论',11,2,'2022-02-23 19:10:18',NULL,'2022-02-23 19:10:18'),(13,NULL,NULL,NULL,1,'管理回复',11,2,'2022-02-23 19:15:34',NULL,'2022-02-23 19:15:34');

/*Table structure for table `jiaoshi` */

DROP TABLE IF EXISTS `jiaoshi`;

CREATE TABLE `jiaoshi` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `jiaoshi_name` varchar(200) DEFAULT NULL COMMENT '教师姓名 Search111 ',
  `jiaoshi_photo` varchar(255) DEFAULT NULL COMMENT '头像',
  `jiaoshi_phone` varchar(200) DEFAULT NULL COMMENT '教师手机号',
  `jiaoshi_id_number` varchar(200) DEFAULT NULL COMMENT '教师身份证号 ',
  `jiaoshi_email` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111 ',
  `jiaoshi_delete` int(11) DEFAULT '1' COMMENT '假删',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='教师';

/*Data for the table `jiaoshi` */

insert  into `jiaoshi`(`id`,`username`,`password`,`jiaoshi_name`,`jiaoshi_photo`,`jiaoshi_phone`,`jiaoshi_id_number`,`jiaoshi_email`,`sex_types`,`jiaoshi_delete`,`create_time`) values (1,'a1','123456','教师姓名1','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi1.jpg','17703786901','410224199610232001','1@qq.com',2,1,'2022-02-23 17:04:27'),(2,'a2','123456','教师姓名2','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi2.jpg','17703786902','410224199610232002','2@qq.com',1,1,'2022-02-23 17:04:27'),(3,'a3','123456','教师姓名3','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi3.jpg','17703786903','410224199610232003','3@qq.com',1,1,'2022-02-23 17:04:27'),(4,'a4','123456','教师姓名4','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi4.jpg','17703786904','410224199610232004','4@qq.com',1,1,'2022-02-23 17:04:27'),(5,'a5','123456','教师姓名5','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi5.jpg','17703786905','410224199610232005','5@qq.com',1,1,'2022-02-23 17:04:27'),(6,'a6','123456','教师姓名6','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi6.jpg','17703786906','410224199610232006','6@qq.com',1,1,'2022-02-23 17:04:27'),(7,'a7','123456','教师姓名7','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi7.jpg','17703786907','410224199610232007','7@qq.com',1,1,'2022-02-23 17:04:27'),(8,'a8','123456','教师姓名8','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi8.jpg','17703786908','410224199610232008','8@qq.com',2,1,'2022-02-23 17:04:27'),(9,'a9','123456','教师姓名9','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi9.jpg','17703786909','410224199610232009','9@qq.com',2,1,'2022-02-23 17:04:27'),(10,'a10','123456','教师姓名10','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi10.jpg','17703786910','410224199610232010','10@qq.com',1,1,'2022-02-23 17:04:27'),(11,'a11','123456','教师姓名11','http://localhost:8080/shuxuejingsuwangzhan/upload/jiaoshi11.jpg','17703786911','410224199610232011','11@qq.com',2,1,'2022-02-23 17:04:27');

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `news_name` varchar(200) DEFAULT NULL COMMENT '公告信息标题  Search111 ',
  `news_types` int(11) DEFAULT NULL COMMENT '公告信息类型  Search111 ',
  `news_photo` varchar(200) DEFAULT NULL COMMENT '公告信息图片',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '公告信息时间',
  `news_content` text COMMENT '公告信息详情',
  `news_delete` int(11) DEFAULT '1' COMMENT '假删',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='公告信息';

/*Data for the table `news` */

insert  into `news`(`id`,`news_name`,`news_types`,`news_photo`,`insert_time`,`news_content`,`news_delete`,`create_time`) values (1,'公告信息标题1',1,'http://localhost:8080/shuxuejingsuwangzhan/upload/news1.jpg','2022-02-23 17:04:27','公告信息详情1',1,'2022-02-23 17:04:27'),(2,'公告信息标题2',1,'http://localhost:8080/shuxuejingsuwangzhan/upload/news2.jpg','2022-02-23 17:04:27','公告信息详情2',1,'2022-02-23 17:04:27'),(3,'公告信息标题3',2,'http://localhost:8080/shuxuejingsuwangzhan/upload/news3.jpg','2022-02-23 17:04:27','公告信息详情3',1,'2022-02-23 17:04:27'),(4,'公告信息标题4',3,'http://localhost:8080/shuxuejingsuwangzhan/upload/news4.jpg','2022-02-23 17:04:27','公告信息详情4',1,'2022-02-23 17:04:27'),(5,'公告信息标题5',2,'http://localhost:8080/shuxuejingsuwangzhan/upload/news5.jpg','2022-02-23 17:04:27','公告信息详情5',1,'2022-02-23 17:04:27'),(6,'公告信息标题6',1,'http://localhost:8080/shuxuejingsuwangzhan/upload/news6.jpg','2022-02-23 17:04:27','公告信息详情6',1,'2022-02-23 17:04:27'),(7,'公告信息标题7',3,'http://localhost:8080/shuxuejingsuwangzhan/upload/news7.jpg','2022-02-23 17:04:27','公告信息详情7',1,'2022-02-23 17:04:27'),(8,'公告信息标题8',3,'http://localhost:8080/shuxuejingsuwangzhan/upload/news8.jpg','2022-02-23 17:04:27','公告信息详情8',1,'2022-02-23 17:04:27'),(9,'公告信息标题9',1,'http://localhost:8080/shuxuejingsuwangzhan/upload/news9.jpg','2022-02-23 17:04:27','公告信息详情9',1,'2022-02-23 17:04:27'),(10,'公告信息标题10',2,'http://localhost:8080/shuxuejingsuwangzhan/upload/news10.jpg','2022-02-23 17:04:27','公告信息详情10',1,'2022-02-23 17:04:27'),(11,'公告信息标题11',1,'http://localhost:8080/shuxuejingsuwangzhan/upload/news11.jpg','2022-02-23 17:04:27','公告信息详情11',1,'2022-02-23 17:04:27');

/*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,1,'admin','users','管理员','5eqgj55jknhtv7905879oi60c3cfjca5','2022-02-23 17:16:03','2022-02-23 20:18:29'),(2,1,'a1','yonghu','用户','kugryrxuf5nl8unx4d5ahsx8incuvmb2','2022-02-23 17:32:30','2022-02-23 20:19:02'),(3,2,'a2','jiaoshi','教师','nio8geroxunn3qut95jtn61grlngosoj','2022-02-23 19:11:03','2022-02-23 20:11:04');

/*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,'admin','admin','管理员','2021-02-25 15:59:12');

/*Table structure for table `yonghu` */

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户姓名 Search111 ',
  `yonghu_photo` varchar(255) DEFAULT NULL COMMENT '头像',
  `yonghu_phone` varchar(200) DEFAULT NULL COMMENT '用户手机号',
  `yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '用户身份证号 ',
  `yonghu_email` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111 ',
  `yonghu_delete` int(11) DEFAULT '1' COMMENT '假删',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户';

/*Data for the table `yonghu` */

insert  into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`yonghu_photo`,`yonghu_phone`,`yonghu_id_number`,`yonghu_email`,`sex_types`,`yonghu_delete`,`create_time`) values (1,'a1','123456','用户姓名1','http://localhost:8080/shuxuejingsuwangzhan/upload/yonghu1.jpg','17703786901','410224199610232001','1@qq.com',1,1,'2022-02-23 17:04:27'),(2,'a2','123456','用户姓名2','http://localhost:8080/shuxuejingsuwangzhan/upload/yonghu2.jpg','17703786902','410224199610232002','2@qq.com',1,1,'2022-02-23 17:04:27'),(3,'a3','123456','用户姓名3','http://localhost:8080/shuxuejingsuwangzhan/upload/yonghu3.jpg','17703786903','410224199610232003','3@qq.com',1,1,'2022-02-23 17:04:27');

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