41-java学生成绩管理系统.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssmp3s4y -- ------------------------------------------------------ -- 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 `banjichengji` -- DROP TABLE IF EXISTS `banjichengji`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `banjichengji` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `biaoti` varchar(200) DEFAULT NULL COMMENT '标题', `nianji` varchar(200) DEFAULT NULL COMMENT '年级', `banji` varchar(200) DEFAULT NULL COMMENT '班级', `kemu` varchar(200) DEFAULT NULL COMMENT '科目', `zongchengji` varchar(200) DEFAULT NULL COMMENT '总成绩', `pingjunfen` varchar(200) DEFAULT NULL COMMENT '平均分', `chengjibiao` longtext COMMENT '成绩表', `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号', `dengjishijian` date 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 `banjichengji` -- LOCK TABLES `banjichengji` WRITE; /*!40000 ALTER TABLE `banjichengji` DISABLE KEYS */; INSERT INTO `banjichengji` VALUES (1,'2020-12-17 05:03:35','标题1','一年级','一班','英语','总成绩1','平均分1','成绩表1','教师工号1','2020-12-17'),(2,'2020-12-17 05:03:35','标题2','一年级','一班','英语','总成绩2','平均分2','成绩表2','教师工号2','2020-12-17'),(3,'2020-12-17 05:03:35','标题3','一年级','一班','英语','总成绩3','平均分3','成绩表3','教师工号3','2020-12-17'),(4,'2020-12-17 05:03:35','标题4','一年级','一班','英语','总成绩4','平均分4','成绩表4','教师工号4','2020-12-17'),(5,'2020-12-17 05:03:35','标题5','一年级','一班','英语','总成绩5','平均分5','成绩表5','教师工号5','2020-12-17'),(6,'2020-12-17 05:03:35','标题6','一年级','一班','英语','总成绩6','平均分6','成绩表6','教师工号6','2020-12-17'); /*!40000 ALTER TABLE `banjichengji` ENABLE KEYS */; UNLOCK TABLES; -- -- 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/ssmp3s4y/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssmp3s4y/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssmp3s4y/upload/picture3.jpg'),(4,'picture4','http://localhost:8080/ssmp3s4y/upload/picture4.jpg'),(5,'picture5','http://localhost:8080/ssmp3s4y/upload/picture5.jpg'),(6,'homepage',NULL); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exampaper` -- DROP TABLE IF EXISTS `exampaper`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 DEFAULT CHARSET=utf8 COMMENT='试卷表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exampaper` -- LOCK TABLES `exampaper` WRITE; /*!40000 ALTER TABLE `exampaper` DISABLE KEYS */; /*!40000 ALTER TABLE `exampaper` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `examquestion` -- DROP TABLE IF EXISTS `examquestion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 DEFAULT CHARSET=utf8 COMMENT='试题表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `examquestion` -- LOCK TABLES `examquestion` WRITE; /*!40000 ALTER TABLE `examquestion` DISABLE KEYS */; /*!40000 ALTER TABLE `examquestion` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `examrecord` -- DROP TABLE IF EXISTS `examrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 DEFAULT CHARSET=utf8 COMMENT='考试记录表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `examrecord` -- LOCK TABLES `examrecord` WRITE; /*!40000 ALTER TABLE `examrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `examrecord` 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 '创建时间', `biaoti` varchar(200) DEFAULT NULL COMM