【计算机程序设计项目源码】_java项目_ssm教学质量评价系统_java毕业设计.zip

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50730 Source Host : localhost:3306 Source Database : jspm0afw5 Target Server Type : MYSQL Target Server Version : 50730 File Encoding : 65001 Date: 2022-09-04 11:02:17 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for 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='配置文件'; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES ('1', 'picture1', 'http://localhost:8080/jspm0afw5/upload/picture1.jpg'); INSERT INTO `config` VALUES ('2', 'picture2', 'http://localhost:8080/jspm0afw5/upload/picture2.jpg'); INSERT INTO `config` VALUES ('3', 'picture3', 'http://localhost:8080/jspm0afw5/upload/picture3.jpg'); INSERT INTO `config` VALUES ('6', 'homepage', null); -- ---------------------------- -- Table structure for dudao -- ---------------------------- DROP TABLE IF EXISTS `dudao`; CREATE TABLE `dudao` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `dudaozhanghao` varchar(200) NOT NULL COMMENT '督导账号', `mima` varchar(200) NOT NULL COMMENT '密码', `dudaoxingming` varchar(200) NOT NULL COMMENT '督导姓名', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `touxiang` varchar(200) DEFAULT NULL COMMENT '头像', `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院', `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式', PRIMARY KEY (`id`), UNIQUE KEY `dudaozhanghao` (`dudaozhanghao`) ) ENGINE=InnoDB AUTO_INCREMENT=1614415891335 DEFAULT CHARSET=utf8 COMMENT='督导'; -- ---------------------------- -- Records of dudao -- ---------------------------- INSERT INTO `dudao` VALUES ('51', '2021-02-27 16:45:45', '督导1', '123456', '督导姓名1', '男', 'http://localhost:8080/jspm0afw5/upload/dudao_touxiang1.jpg', '学院1', '13823888881'); INSERT INTO `dudao` VALUES ('52', '2021-02-27 16:45:45', '督导2', '123456', '督导姓名2', '男', 'http://localhost:8080/jspm0afw5/upload/dudao_touxiang2.jpg', '学院2', '13823888882'); INSERT INTO `dudao` VALUES ('53', '2021-02-27 16:45:45', '督导3', '123456', '督导姓名3', '男', 'http://localhost:8080/jspm0afw5/upload/dudao_touxiang3.jpg', '学院3', '13823888883'); INSERT INTO `dudao` VALUES ('54', '2021-02-27 16:45:45', '督导4', '123456', '督导姓名4', '男', 'http://localhost:8080/jspm0afw5/upload/dudao_touxiang4.jpg', '学院4', '13823888884'); INSERT INTO `dudao` VALUES ('55', '2021-02-27 16:45:45', '督导5', '123456', '督导姓名5', '男', 'http://localhost:8080/jspm0afw5/upload/dudao_touxiang5.jpg', '学院5', '13823888885'); INSERT INTO `dudao` VALUES ('56', '2021-02-27 16:45:45', '督导6', '123456', '督导姓名6', '男', 'http://localhost:8080/jspm0afw5/upload/dudao_touxiang6.jpg', '学院6', '13823888886'); INSERT INTO `dudao` VALUES ('1614415891334', '2021-02-27 16:51:31', '2', '2', '张悦', '女', 'http://localhost:8080/jspm0afw5/upload/1614415885266.jpg', '计算机学院', '12345645645'); -- ---------------------------- -- Table structure for dudaopingjiao -- ---------------------------- DROP TABLE IF EXISTS `dudaopingjiao`; CREATE TABLE `dudaopingjiao` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号', `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名', `xueyuan` varchar(200) DEFAULT NULL COMMENT '学院', `zhicheng` varchar(200) DEFAULT NULL COMMENT '职称', `renjiaokemu` varchar(200) DEFAULT NULL COMMENT '任教科目', `pingfen` varchar(200) DEFAULT NULL COMMENT '评分', `pingjianeirong` longtext COMMENT '评价内容', `pingjiariqi` date DEFAULT NULL COMMENT '评价日期', `dudaozhanghao` varchar(200) DEFAULT NULL COMMENT '督导账号', `dudaoxingming` varchar(200) DEFAULT NULL COMMENT '督导姓名', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1614416084897 DEFAULT CHARSET=utf8 COMMENT='督导评教'; -- ---------------------------- -- Records of dudaopingjiao -- ---------------------------- INSERT INTO `dudaopingjiao` VALUES ('81', '2021-02-27 16:45:45', '教师工号1', '教师姓名1', '学院1', '职称1', '任教科目1', '1', '评价内容1', '2021-02-27', '督导账号1', '督导姓名1'); INSERT INTO `dudaopingjiao` VALUES ('82', '2021-02-27 16:45:45', '教师工号2', '教师姓名2', '学院2', '职称2', '任教科目2', '1', '评价内容2', '2021-02-27', '督导账号2', '督导姓名2'); INSERT INTO `dudaopingjiao` VALUES ('83', '2021-02-27 16:45:45', '教师工号3', '教师姓名3', '学院3', '职称3', '任教科目3', '1', '评价内容3', '2021-02-27', '督导账号3', '督导姓名3'); INSERT INTO `dudaopingjiao` VALUES ('84', '2021-02-27 16:45:45', '教师工号4', '教师姓名4', '学院4', '职称4', '任教科目4', '1', '评价内容4', '2021-02-27', '督导账号4', '督导姓名4'); INSERT INTO `dudaopingjiao` VALUES ('85', '2021-02-27 16:45:45', '教师工号5', '教师姓名5', '学院5', '职称5', '任教科目5', '1', '评价内容5', '2021-02-27', '督导账号5', '督导姓名5'); INSERT INTO `dudaopingjiao` VALUES ('86', '2021-02-27 16:45:45', '教师工号6', '教师姓名6', '学院6', '职称6', '任教科目6', '1', '评价内容6', '2021-02-27', '督导账号6', '督导姓名6'); INSERT INTO `dudaopingjiao` VALUES ('1614416084896', '2021-02-27 16:54:44', '1', '陈一', '计算机学院', '中级教师', '', '9', '是一位优秀的教师，深得学生的喜爱', '2021-02-27', '2', '张悦'); -- ---------------------------- -- Table structure for gonggaoxinxi -- ---------------------------- DROP TABLE IF EXISTS `gonggaoxinxi`; CREATE TABLE `gonggaoxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `gonggaobiaoti` varchar(200) NOT NULL COMMENT '公告标题', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `neirong` longtext COMMENT '内容', `faburiqi` date DEFAULT NULL COMMENT '发布日期', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1614415817113 DEFAULT CHARSET=utf8 COMMENT='公告信息'; -- ---------------------------- -- Records of gonggaoxinxi -- ---------------------------- INSERT INTO `gonggaoxinxi` VALUES ('11', '2021-02-27 16:45:45', '公告标题1', 'http://localhost:8080/jspm0afw5/upload/1614415660865.jpg', '内容1\r\n', '2021-02-27'); INSERT INTO `gonggaoxinxi` VALUES ('12', '2021-02-27 16:45:45', '公告标题2', 'http://localhost:8080/jspm0afw5/upload/1614415667351.jpg', '内容2\r\n', '2021-02-27'); INSERT INTO `gonggaoxinxi` VALUES ('13', '2021-02-27 16:45:45', '公告标题3', 'http://localhost:8080/jspm0afw5/upload/1614415675388.jpg', '内容3\r\n', '2021-02-27'); INSERT INTO `gonggaoxinxi` VALUES ('14', '2021-02-27 16:45:45', '公告标题4', 'http://localhost:8080/jspm0afw5/upload/1614415681627.jpg', '内容4\r\n', '2021-02-27'); INSERT INTO `gonggaoxinxi` VALUES ('15', '2021-02-27 16:45:45', '公告标题5', 'http://localhost:8080/jspm0afw5/upload/1614415689429.jpg', '内容5\r\n', '2021-02-27'); INSERT INTO `gonggaoxinxi` VALUES ('16', '2021-02-27 16:45:45', '公告标题6', 'http://localhost:8080/jspm0afw5/upload/1614415705299.png', '内容6\r\n', '2021-02-27'); INSERT INTO `gonggaoxinxi` VALUES ('1614415817112', '