Java项目-基于SSM+JSP的教学质量评价系统的设计与实现（源码+万字LW+部署视频+代码讲解视频+全套软件）

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspm0afw5 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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='配置文件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (1,'picture1','http://localhost:8080/jspm0afw5/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/jspm0afw5/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/jspm0afw5/upload/picture3.jpg'),(6,'homepage',NULL); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dudao` -- DROP TABLE IF EXISTS `dudao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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='督导'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dudao` -- LOCK TABLES `dudao` WRITE; /*!40000 ALTER TABLE `dudao` DISABLE KEYS */; INSERT INTO `dudao` VALUES (51,'2021-02-27 08:45:45','督导1','123456','督导姓名1','男','http://localhost:8080/jspm0afw5/upload/dudao_touxiang1.jpg','学院1','13823888881'),(52,'2021-02-27 08:45:45','督导2','123456','督导姓名2','男','http://localhost:8080/jspm0afw5/upload/dudao_touxiang2.jpg','学院2','13823888882'),(53,'2021-02-27 08:45:45','督导3','123456','督导姓名3','男','http://localhost:8080/jspm0afw5/upload/dudao_touxiang3.jpg','学院3','13823888883'),(54,'2021-02-27 08:45:45','督导4','123456','督导姓名4','男','http://localhost:8080/jspm0afw5/upload/dudao_touxiang4.jpg','学院4','13823888884'),(55,'2021-02-27 08:45:45','督导5','123456','督导姓名5','男','http://localhost:8080/jspm0afw5/upload/dudao_touxiang5.jpg','学院5','13823888885'),(56,'2021-02-27 08:45:45','督导6','123456','督导姓名6','男','http://localhost:8080/jspm0afw5/upload/dudao_touxiang6.jpg','学院6','13823888886'),(1614415891334,'2021-02-27 08:51:31','2','2','张悦','女','http://localhost:8080/jspm0afw5/upload/1614415885266.jpg','计算机学院','12345645645'); /*!40000 ALTER TABLE `dudao` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dudaopingjiao` -- DROP TABLE IF EXISTS `dudaopingjiao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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='督导评教'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dudaopingjiao` -- LOCK TABLES `dudaopingjiao` WRITE; /*!40000 ALTER TABLE `dudaopingjiao` DISABLE KEYS */; INSERT INTO `dudaopingjiao` VALUES (81,'2021-02-27 08:45:45','教师工号1','教师姓名1','学院1','职称1','任教科目1','1','评价内容1','2021-02-27','督导账号1','督导姓名1'),(82,'2021-02-27 08:45:45','教师工号2','教师姓名2','学院2','职称2','任教科目2','1','评价内容2','2021-02-27','督导账号2','督导姓名2'),(83,'2021-02-27 08:45:45','教师工号3','教师姓名3','学院3','职称3','任教科目3','1','评价内容3','2021-02-27','督导账号3','督导姓名3'),(84,'2021-02-27 08:45:45','教师工号4','教师姓名4','学院4','职称4','任教科目4','1','评价内容4','2021-02-27','督导账号4','督导姓名4'),(85,'2021-02-27 08:45:45','教师工号5','教师姓名5','学院5','职称5','任教科目5','1','评价内容5','2021-02-27','督导账号5','督导姓名5'),(86,'2021-02-27 08:45:45','教师工号6','教师姓名6','学院6','职称6','任教科目6','1','评价内容6','2021-02-27','督导账号6','督导姓名6'),(1614416084896,'2021-02-27 08:54:44','1','陈一','计算机学院','中级教师','','9','是一位优秀的教师，深得学生的喜爱','2021-02-27','2','张悦'); /*!40000 ALTER TABLE `dudaopingjiao` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gonggaoxinxi` -- DROP TABLE IF EXISTS `gonggaoxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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='公告信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gonggaoxinxi` -- LOCK TABLES `gonggaoxinxi` WRITE; /*!40000 ALTER TABLE `gonggaoxinxi` DISABLE KEYS */; INSERT INTO `gonggaoxinxi` VALUES (11,'2021-02-27 08:45:45','公告标题1','http://localhost:8080/jspm0afw5/upload/1614415660865.jpg','内容1\r\n','2021-02-27'),(12,'2021-02-27 08:45:45','公告标题2','http://localhost:8080/jspm0afw5/upload/1614415667351.jpg','内容2\r\n','2021-02-27'),(13,'2021-02-27 08:45:45','公告标题3','http://localhost:8080/jspm0afw5/upload/1614415675388.jpg','内容3\r\n','2021-02-27'),(14,'2021-02-27 08:45:45','公告标题4','http://localhost:8080/jspm0afw5/upload/1614415681627.jpg','内容4\r\n','2021-02-27'),(15,'2021-02-27 08:45:45','�