随着信息技术在管理上越来越深入而广泛的应用,管理信息系统的实施在技术上已逐步成熟。本文介绍了微信小程序学生知识成果展示与交流的开发全过程。通过分析微信小程序学生知识成果展示与交流管理的不足,创建了一个计算机管理微信小程序学生知识成果展示与交流的方案。文章介绍了微信小程序学生知识成果展示与交流的系统分析部分,包括可行性分析等,系统设计部分主要介绍了系统功能设计和数据库设计。
本微信小程序学生知识成果展示与交流管理员功能有个人中心,学生管理,教师管理,课程信息管理,重点解析管理,科目类型管理,校园资讯管理,试卷管理,试题管理,学习交流,系统管理,考试管理等。因而具有一定的实用性。
本站后台采用Java的SSM框架进行后台管理开发,可以在浏览器上登录进行后台数据方面的管理,MySQL作为本地数据库,微信小程序用到了微信开发者工具,充分保证系统的稳定性。系统具有界面清晰、操作简单,功能齐全的特点,使得微信小程序学生知识成果展示与交流管理工作系统化、规范化。
如今互联网高速发展,网络遍布全球,国内移动信息领域独树一帜,通过微信发布的消息能快而方便的传播到世界每个角落,并且互联网上能传播的信息也很广,比如文字、图片、声音、视频等。从而,这种种好处使得互联网成了信息传播的主要途径,社会上各种各样的信息都想尽办法通过互联网进行传播,互联网对社会产生的影响越来越大。
因此,开发合适的微信小程序学生知识成果展示与交流,可以方便管理人员对微信小程序学生知识成果展示与交流的管理,提高信息管理工作效率及查询效率,用户可以在手机上通过微信小程序来订餐,更加的方便,有利于更好的为人们服务。
*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - ssmw52wu
*********************************************************************
*/
/*!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*/`ssmw52wu` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ssmw52wu`;
/*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/ssmw52wu/upload/picture1.jpg');
insert into `config`(`id`,`name`,`value`) values (2,'picture2','http://localhost:8080/ssmw52wu/upload/picture2.jpg');
insert into `config`(`id`,`name`,`value`) values (3,'picture3','http://localhost:8080/ssmw52wu/upload/picture3.jpg');
insert into `config`(`id`,`name`,`value`) values (6,'homepage',NULL);
/*Table structure for table `exampaper` */
DROP TABLE IF EXISTS `exampaper`;
CREATE TABLE `exampaper` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`name` varchar(200) NOT NULL COMMENT '试卷名称',
`time` int(11) NOT NULL COMMENT '考试时长(分钟)',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '试卷状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1619847514578 DEFAULT CHARSET=utf8 COMMENT='试卷表';
/*Data for the table `exampaper` */
insert into `exampaper`(`id`,`addtime`,`name`,`time`,`status`) values (1619847260385,'2021-05-01 13:34:20','sdsascS',60,1);
insert into `exampaper`(`id`,`addtime`,`name`,`time`,`status`) values (1619847514577,'2021-05-01 13:38:33','地方撒发送到',30,1);
/*Table structure for table `examquestion` */
DROP TABLE IF EXISTS `examquestion`;
CREATE TABLE `examquestion` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`paperid` bigint(20) NOT NULL COMMENT '所属试卷id(外键)',
`papername` varchar(200) NOT NULL COMMENT '试卷名称',
`questionname` varchar(200) NOT NULL COMMENT '试题名称',
`options` longtext COMMENT '选项,json字符串',
`score` bigint(20) DEFAULT '0' COMMENT '分值',
`answer` varchar(200) DEFAULT NULL COMMENT '正确答案',
`analysis` longtext COMMENT '答案解析',
`type` bigint(20) DEFAULT '0' COMMENT '试题类型,0:单选题 1:多选题 2:判断题 3:填空题(暂不考虑多项填空)',
`sequence` bigint(20) DEFAULT '100' COMMENT '试题排序,值越大排越前面',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1619847581593 DEFAULT CHARSET=utf8 COMMENT='试题表';
/*Data for the table `examquestion` */
insert into `examquestion`(`id`,`addtime`,`paperid`,`papername`,`questionname`,`options`,`score`,`answer`,`analysis`,`type`,`sequence`) values (1619847292361,'2021-05-01 13:34:52',1619847260385,'sdsascS','SADADSADSADA','[{\"text\":\"A.ASDAS\",\"code\":\"A\"},{\"text\":\"B.DSAD \",\"code\":\"B\"},{\"text\":\"C.SADAASD\",\"code\":\"C\"}]',10,'A','ASDAD',0,1);
insert into `examquestion`(`id`,`addtime`,`paperid`,`papername`,`questionname`,`options`,`score`,`answer`,`analysis`,`type`,`sequence`) values (1619847312112,'2021-05-01 13:35:11',1619847260385,'sdsascS','SADSADAS','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',5,'A','SADSAAS',2,2);
insert into `examquestion`(`id`,`addtime`,`paperid`,`papername`,`questionname`,`options`,`score`,`answer`,`analysis`,`type`,`sequence`) values (1619847324397,'2021-05-01 13:35:23',1619847260385,'sdsascS','ASDSA','[]',10,'SDADAS','SADAS',3,3);
insert into `examquestion`(`id`,`addtime`,`paperid`,`papername`,`questionname`,`options`,`score`,`answer`,`analysis`,`type`,`sequence`) values (1619847547237,'2021-05-01 13:39:06',1619847514577,'地方撒发送到','ASDA ','[{\"text\":\"A.ASDAS\",\"code\":\"A\"},{\"text\":\"B.ADAD\",\"code\":\"B\"}]',5,'A','SADSADA',1,1);
insert into `examquestion`(`id`,`addtime`,`paperid`,`papername`,`questionname`,`options`,`score`,`answer`,`analysis`,`type`,`sequence`) values (1619847565663,'2021-05-01 13:39:24',1619847514577,'地方撒发送到','DSAAS','[]',10,'ASDSAD','ASDAD',3,2);
insert into `examquestion`(`id`,`addtime`,`paperid`,`papername`,`questionname`,`options`,`score`,`answer`,`analysis`,`type`,`sequence`) values (1619847581592,'2021-05-01 13:39:41',1619847514577,'地方撒发送到','ASDAS','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',10,'A','DSADSAD',2,3);
/*Table structure for table `examrecord` */
DROP TABLE IF EXISTS `examrecord`;
CREATE TABLE `examrecord` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`paperid` bigint(20) NOT NULL COMMENT '试卷id(外键)',
`papername` varchar(200) NOT NULL COMMENT '试卷名称',
`questionid` bigint(20) NOT NULL COMMENT '试题id(外键)',
`questionname` varchar(200) NOT NULL COMMENT '试题名称',
`options` longtext COMMENT '选项,json字符串',
`score` bigint(20) DEFAULT '0' COMMENT '分值',
`answer` varchar(200) DEFAULT NULL COMMENT '正确答案',
`analysis` longtext COMMENT '答案解析',
`myscore` bigint(20) NOT NULL DEFAULT '0' COMMENT '试题得分',
`myanswer` varchar(200) DEFAULT NULL COMMENT '考生答案',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1619847355568 DEFAULT CHARSET=utf8 COMMENT='考试记录表';
/*Data for the table `examrecord` */
insert into `examrecord`(`id`,`addtime`,`userid`,`username`,`paperid`,`papername`,`questionid`,`questionname`,`options`,`score`,`answer`,`analysis`,`myscore`,`myanswer`) values (1619847346203,'2021-05-01 13:35:45',1619846885772,NULL,1619847260385,'sdsascS',1619847292361,'SADADSADSADA','[{\"text\":\"A.ASDAS\",\"code\":\"A\",\"checked\":true},{\"text\":\"B.DSAD \",\"code\":\"B\",\"checked\":false},{\"text\":\"C.SADAASD\",\"code\":\"C\",\"checked\":false}]',10,'A','ASDAD',10,'A');
insert into `examrecord`(`id`,`addtime`,`userid`,`username`,`paperid`,`papername`,`questionid`,`questionname`,`options`,`score`,`answer`,`analysis`,`myscore`,`myanswer`) values (1619847352310,'2021-05-01 13:35:51',1619846885772,NULL,1619847260385,'sdsascS',1619847312112,'SADSADAS','[{\"text\":\"A.对\",\"code\":\"A\",\"checked\":true},{\"text\":\"B.错\",\"code\":\"B\",\"checked\":false}]',5,'A','SADSAAS',5,'A');
insert into `examrecord`(`id`,`addtime`,`userid`,`username`,`paperid`,`papername`,`questionid`,`questionname`,`options`,`score`,`answer`,`analysis`,`myscore`,`myanswer`) values (1619847355567,'2021-05-01 13:35:55',1619846885772,NULL,1619847260385,'sdsascS',1619847324397,'ASDSA','[]',10,'SDADAS','SADAS',0,'QASADA');
/*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=1619847190696 DEFAULT CHARSET=utf8 COMMENT='学习交流';
/*Data for the table `forum` */
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (91,'2021-05-01 13:25:48','帖子标题1','帖子内容1',1,1,'用户名1','开放');
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (92,'2021-05-01 13:25:48','帖子标题2','帖子内容2',2,2,'用户名2','开放');
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (93,'2021-05-01 13:25:48','帖子标题3','帖子内容3',3,3,'用户名3','开放');
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (94,'2021-05-01 13:25:48','帖子标题4','帖子内容4',4,4,'用户名4','开放');
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (95,'2021-05-01 13:25:48','帖子标题5','帖子内容5',5,5,'用户名5','开放');
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (96,'2021-05-01 13:25:48','帖子标题6','帖子内容6',6,6,'用户名6','开放');
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (1619847103895,'2021-05-01 13:31:43','DGAFS','SSA',0,1619846891187,'2','开放');
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (1619847111761,'2021-05-01 13:31:51',NULL,'都是',1619847103895,1619846891187,'2',NULL);
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (1619847153942,'2021-05-01 13:32:33',NULL,'啊',1619847103895,1619846885772,'1',NULL);
insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (1619847190695,'2021-05-01 13:33:10','ASDa','DSADNA',0,1619846885772,'1','开放');
/*Table structure for table `jiaoshi` */
DROP TABLE IF EXISTS `jiaoshi`;
CREATE TABLE `jiaoshi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) NOT NULL COMMENT '工号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
PRIMARY KEY (`id`),
UNIQUE KEY `gonghao` (`gonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1619846891188 DEFAULT CHARSET=utf8 COMMENT='教师';
/*Data for the table `jiaoshi` */
insert into `jiaoshi`(`id`,`addtime`,`gonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhicheng`,`shouji`,`youxiang`,`tupian`) values (21,'2021-05-01 13:25:48','教师1','123456','教师姓名1','男','职称1','13823888881','773890001@qq.com','http://localhost:8080/ssmw52wu/upload/jiaoshi_tupian1.jpg');
insert into `jiaoshi`(`id`,`addtime`,`gonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhicheng`,`shouji`,`youxiang`,`tupian`) values (22,'2021-05-01 13:25:48','教师2','123456','教师姓名2','男','职称2','13823888882','773890002@qq.com','http://localhost:8080/ssmw52wu/upload/jiaoshi_tupian2.jpg');
insert into `jiaoshi`(`id`,`addtime`,`gonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhicheng`,`shouji`,`youxiang`,`tupian`) values (23,'2021-05-01 13:25:48','教师3','123456','教师姓名3','男','职称3','13823888883','773890003@qq.com','http://localhost:8080/ssmw52wu/upload/jiaoshi_tupian3.jpg');
insert into `jiaoshi`(`id`,`addtime`,`gonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhicheng`,`shouji`,`youxiang`,`tupian`) values (24,'2021-05-01 13:25:48','教师4','123456','教师姓名4','男','职称4','13823888884','773890004@qq.com','http://localhost:8080/ssmw52wu/upload/jiaoshi_tupian4.jpg');
insert into `jiaoshi`(`id`,`addtime`,`gonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhicheng`,`shouji`,`youxiang`,`tupian`) values (25,'2021-05-01 13:25:48','教师5','123456','教师姓名5','男','职称5','13823888885','773890005@qq.com','http://localhost:8080/ssmw52wu/upload/jiaoshi_tupian5.jpg');
insert into `jiaoshi`(`id`,`addtime`,`gonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhicheng`,`shouji`,`youxiang`,`tupian`) values (26,'2021-05-01 13:25:48','教师6','123456','教师姓名6','男','职称6','13823888886','773890006@qq.com','http://localhost:8080/ssmw52wu/upload/jiaoshi_tupian6.jpg');
insert into `jiaoshi`(`id`,`addtime`,`gonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhicheng`,`shouji`,`youxiang`,`tupian`) values (1619846891187,'2021-05-01 13:28:11','2','2','2','女',NULL,NULL,NULL,NULL);
/*Table structure for table `kechengjieda` */
DROP TABLE IF EXISTS `kechengjieda`;
CREATE TABLE `kechengjieda` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
`kechengmingcheng` varchar(200) DEFAULT NULL COMMENT '课程名称',
`kemu` varchar(200) DEFAULT NULL COMMENT '科目',
`jiedaneirong` longtext COMMENT '解答内容',
`jiedariqi` date DEFAULT NULL COMMENT '解答日期',
`kechengtupian` varchar(200) DEFAULT NULL COMMENT '课程图片',
`gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1619847211449 DEFAULT CHARSET=utf8 COMMENT='课程解答';
/*Data for the table `kechengjieda` */
insert into `kechengjieda`(`id`,`addtime`,`xuehao`,`xueshengxingming`,`kechengmingcheng`,`kemu`,`jiedaneirong`,`jiedariqi`,`kechengtupian`,`gonghao`,`jiaoshixingming`,`userid`) values (61,'2021-05-01 13:25:48','学号1','学生姓名1','课程名称1','科目1','解答内容1','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengjieda_kechengtupian1.jpg','工号1','教师姓名1',1);
insert into `kechengjieda`(`id`,`addtime`,`xuehao`,`xueshengxingming`,`kechengmingcheng`,`kemu`,`jiedaneirong`,`jiedariqi`,`kechengtupian`,`gonghao`,`jiaoshixingming`,`userid`) values (62,'2021-05-01 13:25:48','学号2','学生姓名2','课程名称2','科目2','解答内容2','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengjieda_kechengtupian2.jpg','工号2','教师姓名2',2);
insert into `kechengjieda`(`id`,`addtime`,`xuehao`,`xueshengxingming`,`kechengmingcheng`,`kemu`,`jiedaneirong`,`jiedariqi`,`kechengtupian`,`gonghao`,`jiaoshixingming`,`userid`) values (63,'2021-05-01 13:25:48','学号3','学生姓名3','课程名称3','科目3','解答内容3','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengjieda_kechengtupian3.jpg','工号3','教师姓名3',3);
insert into `kechengjieda`(`id`,`addtime`,`xuehao`,`xueshengxingming`,`kechengmingcheng`,`kemu`,`jiedaneirong`,`jiedariqi`,`kechengtupian`,`gonghao`,`jiaoshixingming`,`userid`) values (64,'2021-05-01 13:25:48','学号4','学生姓名4','课程名称4','科目4','解答内容4','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengjieda_kechengtupian4.jpg','工号4','教师姓名4',4);
insert into `kechengjieda`(`id`,`addtime`,`xuehao`,`xueshengxingming`,`kechengmingcheng`,`kemu`,`jiedaneirong`,`jiedariqi`,`kechengtupian`,`gonghao`,`jiaoshixingming`,`userid`) values (65,'2021-05-01 13:25:48','学号5','学生姓名5','课程名称5','科目5','解答内容5','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengjieda_kechengtupian5.jpg','工号5','教师姓名5',5);
insert into `kechengjieda`(`id`,`addtime`,`xuehao`,`xueshengxingming`,`kechengmingcheng`,`kemu`,`jiedaneirong`,`jiedariqi`,`kechengtupian`,`gonghao`,`jiaoshixingming`,`userid`) values (66,'2021-05-01 13:25:48','学号6','学生姓名6','课程名称6','科目6','解答内容6','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengjieda_kechengtupian6.jpg','工号6','教师姓名6',6);
insert into `kechengjieda`(`id`,`addtime`,`xuehao`,`xueshengxingming`,`kechengmingcheng`,`kemu`,`jiedaneirong`,`jiedariqi`,`kechengtupian`,`gonghao`,`jiaoshixingming`,`userid`) values (1619847211448,'2021-05-01 13:33:31','1','1','第三方付多少','类型1','地方撒旦','2021-05-01','http://localhost:8080/ssmw52wu/upload/1619847046024.jpg','2','2',1619846891187);
/*Table structure for table `kechengtiwen` */
DROP TABLE IF EXISTS `kechengtiwen`;
CREATE TABLE `kechengtiwen` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`kechengmingcheng` varchar(200) DEFAULT NULL COMMENT '课程名称',
`kemu` varchar(200) DEFAULT NULL COMMENT '科目',
`tiwenneirong` longtext COMMENT '提问内容',
`tiwenriqi` date DEFAULT NULL COMMENT '提问日期',
`kechengtupian` varchar(200) DEFAULT NULL COMMENT '课程图片',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1619847137799 DEFAULT CHARSET=utf8 COMMENT='课程提问';
/*Data for the table `kechengtiwen` */
insert into `kechengtiwen`(`id`,`addtime`,`gonghao`,`jiaoshixingming`,`kechengmingcheng`,`kemu`,`tiwenneirong`,`tiwenriqi`,`kechengtupian`,`xuehao`,`xueshengxingming`,`userid`) values (51,'2021-05-01 13:25:48','工号1','教师姓名1','课程名称1','科目1','提问内容1','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengtiwen_kechengtupian1.jpg','学号1','学生姓名1',1);
insert into `kechengtiwen`(`id`,`addtime`,`gonghao`,`jiaoshixingming`,`kechengmingcheng`,`kemu`,`tiwenneirong`,`tiwenriqi`,`kechengtupian`,`xuehao`,`xueshengxingming`,`userid`) values (52,'2021-05-01 13:25:48','工号2','教师姓名2','课程名称2','科目2','提问内容2','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengtiwen_kechengtupian2.jpg','学号2','学生姓名2',2);
insert into `kechengtiwen`(`id`,`addtime`,`gonghao`,`jiaoshixingming`,`kechengmingcheng`,`kemu`,`tiwenneirong`,`tiwenriqi`,`kechengtupian`,`xuehao`,`xueshengxingming`,`userid`) values (53,'2021-05-01 13:25:48','工号3','教师姓名3','课程名称3','科目3','提问内容3','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengtiwen_kechengtupian3.jpg','学号3','学生姓名3',3);
insert into `kechengtiwen`(`id`,`addtime`,`gonghao`,`jiaoshixingming`,`kechengmingcheng`,`kemu`,`tiwenneirong`,`tiwenriqi`,`kechengtupian`,`xuehao`,`xueshengxingming`,`userid`) values (54,'2021-05-01 13:25:48','工号4','教师姓名4','课程名称4','科目4','提问内容4','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengtiwen_kechengtupian4.jpg','学号4','学生姓名4',4);
insert into `kechengtiwen`(`id`,`addtime`,`gonghao`,`jiaoshixingming`,`kechengmingcheng`,`kemu`,`tiwenneirong`,`tiwenriqi`,`kechengtupian`,`xuehao`,`xueshengxingming`,`userid`) values (55,'2021-05-01 13:25:48','工号5','教师姓名5','课程名称5','科目5','提问内容5','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengtiwen_kechengtupian5.jpg','学号5','学生姓名5',5);
insert into `kechengtiwen`(`id`,`addtime`,`gonghao`,`jiaoshixingming`,`kechengmingcheng`,`kemu`,`tiwenneirong`,`tiwenriqi`,`kechengtupian`,`xuehao`,`xueshengxingming`,`userid`) values (56,'2021-05-01 13:25:48','工号6','教师姓名6','课程名称6','科目6','提问内容6','2021-05-01','http://localhost:8080/ssmw52wu/upload/kechengtiwen_kechengtupian6.jpg','学号6','学生姓名6',6);
insert into `kechengtiwen`(`id`,`addtime`,`gonghao`,`jiaoshixingming`,`kechengmingcheng`,`kemu`,`tiwenneirong`,`tiwenriqi`,`kechengtupian`,`xuehao`,`xueshengxingming`,`userid`) values (1619847137798,'2021-05-01 13:32:17','2','2','第三方付多少','类型1','萨达','2021-05-02','http://localhost:8080/ssmw52wu/upload/1619847046024.jpg','1','1',1619846885772);