开发语言:Java 框架:springboot JDK版本:JDK1.8 服务器:tomcat7 数据库:mysql 5.7(一定要5.7版本) 数据库工具:Navicat11 开发软件:eclipse/myeclipse/idea Maven包:Maven3.3.9 浏览器:谷歌浏览器
数据库部分表:
DROP TABLE IF EXISTS bisheketi
;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE bisheketi
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
xuantimingcheng
varchar(200) NOT NULL COMMENT '选题名称',
xuantileixing
varchar(200) NOT NULL COMMENT '选题类型',
xuantiyaoqiu
varchar(200) DEFAULT NULL COMMENT '选题要求',
shiyongzhuanye
varchar(200) DEFAULT NULL COMMENT '适用专业',
faburiqi
date DEFAULT NULL COMMENT '发布日期',
jiaoshigonghao
varchar(200) DEFAULT NULL COMMENT '教师工号',
jiaoshixingming
varchar(200) DEFAULT NULL COMMENT '教师姓名',
jiaoshidianhua
varchar(200) DEFAULT NULL COMMENT '教师电话',
sfsh
varchar(200) DEFAULT '待审核' COMMENT '是否审核',
shhf
longtext COMMENT '审核回复',
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='毕设课题';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table bisheketi
--
LOCK TABLES bisheketi
WRITE;
/*!40000 ALTER TABLE bisheketi
DISABLE KEYS /;
INSERT INTO bisheketi
VALUES (41,'2023-03-21 02:35:14','选题名称1','选题类型1','选题要求1','适用专业1','2023-03-21','教师工号1','教师姓名1','13823888881','是',''),(42,'2023-03-21 02:35:14','选题名称2','选题类型2','选题要求2','适用专业2','2023-03-21','教师工号2','教师姓名2','13823888882','是',''),(43,'2023-03-21 02:35:14','选题名称3','选题类型3','选题要求3','适用专业3','2023-03-21','教师工号3','教师姓名3','13823888883','是',''),(44,'2023-03-21 02:35:14','选题名称4','选题类型4','选题要求4','适用专业4','2023-03-21','教师工号4','教师姓名4','13823888884','是',''),(45,'2023-03-21 02:35:14','选题名称5','选题类型5','选题要求5','适用专业5','2023-03-21','教师工号5','教师姓名5','13823888885','是',''),(46,'2023-03-21 02:35:14','选题名称6','选题类型6','选题要求6','适用专业6','2023-03-21','教师工号6','教师姓名6','13823888886','是',''),(47,'2023-03-21 02:35:14','选题名称7','选题类型7','选题要求7','适用专业7','2023-03-21','教师工号7','教师姓名7','13823888887','是',''),(48,'2023-03-21 02:35:14','选题名称8','选题类型8','选题要求8','适用专业8','2023-03-21','教师工号8','教师姓名8','13823888888','是','');
/!40000 ALTER TABLE bisheketi
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table bisherenwushu
--
DROP TABLE IF EXISTS bisherenwushu
;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE bisherenwushu
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
xuantimingcheng
varchar(200) DEFAULT NULL COMMENT '选题名称',
xuantileixing
varchar(200) DEFAULT NULL COMMENT '选题类型',
renwushu
longtext COMMENT '任务书',
jiaoshigonghao
varchar(200) DEFAULT NULL COMMENT '教师工号',
jiaoshixingming
varchar(200) DEFAULT NULL COMMENT '教师姓名',
renwushuxiangqing
longtext COMMENT '任务书详情',
tijiaoriqi
date DEFAULT NULL COMMENT '提交日期',
xuehao
varchar(200) DEFAULT NULL COMMENT '学号',
xueshengxingming
varchar(200) DEFAULT NULL COMMENT '学生姓名',
zhuanyebanji
varchar(200) DEFAULT NULL COMMENT '专业班级',
xueshengshouji
varchar(200) DEFAULT NULL COMMENT '学生手机',
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='毕设任务书';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table bisherenwushu
--
LOCK TABLES bisherenwushu
WRITE;
/*!40000 ALTER TABLE bisherenwushu
DISABLE KEYS /;
INSERT INTO bisherenwushu
VALUES (71,'2023-03-21 02:35:14','选题名称1','选题类型1','','教师工号1','教师姓名1','任务书详情1','2023-03-21','学号1','学生姓名1','专业班级1','学生手机1'),(72,'2023-03-21 02:35:14','选题名称2','选题类型2','','教师工号2','教师姓名2','任务书详情2','2023-03-21','学号2','学生姓名2','专业班级2','学生手机2'),(73,'2023-03-21 02:35:14','选题名称3','选题类型3','','教师工号3','教师姓名3','任务书详情3','2023-03-21','学号3','学生姓名3','专业班级3','学生手机3'),(74,'2023-03-21 02:35:14','选题名称4','选题类型4','','教师工号4','教师姓名4','任务书详情4','2023-03-21','学号4','学生姓名4','专业班级4','学生手机4'),(75,'2023-03-21 02:35:14','选题名称5','选题类型5','','教师工号5','教师姓名5','任务书详情5','2023-03-21','学号5','学生姓名5','专业班级5','学生手机5'),(76,'2023-03-21 02:35:14','选题名称6','选题类型6','','教师工号6','教师姓名6','任务书详情6','2023-03-21','学号6','学生姓名6','专业班级6','学生手机6'),(77,'2023-03-21 02:35:14','选题名称7','选题类型7','','教师工号7','教师姓名7','任务书详情7','2023-03-21','学号7','学生姓名7','专业班级7','学生手机7'),(78,'2023-03-21 02:35:14','选题名称8','选题类型8','','教师工号8','教师姓名8','任务书详情8','2023-03-21','学号8','学生姓名8','专业班级8','学生手机8');
/!40000 ALTER TABLE bisherenwushu
ENABLE KEYS */;
UNLOCK TABLES;