DROP DATABASE IF EXISTS ssmJenZ0;
CREATE DATABASE ssmJenZ0 default character set utf8mb4 collate utf8mb4_general_ci;
USE ssmJenZ0;
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`xueshengxuehao` varchar(200) UNIQUE COMMENT '学生学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`mima` varchar(200) COMMENT '密码',
`xingbie` varchar(200) COMMENT '性别',
`nianji` varchar(200) COMMENT '年级',
`banji` varchar(200) COMMENT '班级',
`shenfenzheng` varchar(200) COMMENT '身份证',
`lianxidianhua` varchar(200) COMMENT '联系电话',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学生';
INSERT INTO xuesheng(xueshengxuehao,xueshengxingming,mima,xingbie,nianji,banji,shenfenzheng,lianxidianhua) VALUES('学生1','学生姓名1','123456','男','年级1','班级1','440300199101010001','020-89819991');
INSERT INTO xuesheng(xueshengxuehao,xueshengxingming,mima,xingbie,nianji,banji,shenfenzheng,lianxidianhua) VALUES('学生2','学生姓名2','123456','男','年级2','班级2','440300199202020002','020-89819992');
INSERT INTO xuesheng(xueshengxuehao,xueshengxingming,mima,xingbie,nianji,banji,shenfenzheng,lianxidianhua) VALUES('学生3','学生姓名3','123456','男','年级3','班级3','440300199303030003','020-89819993');
DROP TABLE IF EXISTS `jiaoshi`;
CREATE TABLE `jiaoshi` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`jiaoshigonghao` varchar(200) UNIQUE COMMENT '教师工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`mima` varchar(200) COMMENT '密码',
`zhicheng` varchar(200) COMMENT '职称',
`lianxidianhua` varchar(200) COMMENT '联系电话',
`shenfenzheng` varchar(200) COMMENT '身份证',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='教师';
INSERT INTO jiaoshi(jiaoshigonghao,jiaoshixingming,mima,zhicheng,lianxidianhua,shenfenzheng) VALUES('教师1','教师姓名1','123456','职称1','020-89819991','440300199101010001');
INSERT INTO jiaoshi(jiaoshigonghao,jiaoshixingming,mima,zhicheng,lianxidianhua,shenfenzheng) VALUES('教师2','教师姓名2','123456','职称2','020-89819992','440300199202020002');
INSERT INTO jiaoshi(jiaoshigonghao,jiaoshixingming,mima,zhicheng,lianxidianhua,shenfenzheng) VALUES('教师3','教师姓名3','123456','职称3','020-89819993','440300199303030003');
DROP TABLE IF EXISTS `zaixianxuanti`;
CREATE TABLE `zaixianxuanti` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ketitimu` varchar(200) COMMENT '课题题目',
`tupian` varchar(200) COMMENT '图片',
`jianjie` longtext COMMENT '简介',
`jiaoshigonghao` varchar(200) COMMENT '教师工号',
`fabushijian` date COMMENT '发布时间',
`sfsh` varchar(200) default '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='在线选题';
INSERT INTO zaixianxuanti(ketitimu,tupian,jianjie,jiaoshigonghao,fabushijian,sfsh,shhf) VALUES('课题题目1','zaixianxuanti_tupian1','简介1','教师工号1',CURRENT_TIMESTAMP,'否','');
INSERT INTO zaixianxuanti(ketitimu,tupian,jianjie,jiaoshigonghao,fabushijian,sfsh,shhf) VALUES('课题题目2','zaixianxuanti_tupian2','简介2','教师工号2',CURRENT_TIMESTAMP,'否','');
INSERT INTO zaixianxuanti(ketitimu,tupian,jianjie,jiaoshigonghao,fabushijian,sfsh,shhf) VALUES('课题题目3','zaixianxuanti_tupian3','简介3','教师工号3',CURRENT_TIMESTAMP,'否','');
DROP TABLE IF EXISTS `wenjianmoban`;
CREATE TABLE `wenjianmoban` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`biaoti` varchar(200) COMMENT '标题',
`wenjian` varchar(200) COMMENT '文件',
`tupian` varchar(200) COMMENT '图片',
`xiangqing` longtext COMMENT '详情',
`fabushijian` datetime COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件模板';
INSERT INTO wenjianmoban(biaoti,wenjian,tupian,xiangqing,fabushijian) VALUES('标题1','文件1','wenjianmoban_tupian1','详情1',CURRENT_TIMESTAMP);
INSERT INTO wenjianmoban(biaoti,wenjian,tupian,xiangqing,fabushijian) VALUES('标题2','文件2','wenjianmoban_tupian2','详情2',CURRENT_TIMESTAMP);
INSERT INTO wenjianmoban(biaoti,wenjian,tupian,xiangqing,fabushijian) VALUES('标题3','文件3','wenjianmoban_tupian3','详情3',CURRENT_TIMESTAMP);
DROP TABLE IF EXISTS `xueshengtiwen`;
CREATE TABLE `xueshengtiwen` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`woyaotiwen` longtext COMMENT '我要提问',
`xueshengxuehao` varchar(200) COMMENT '学生学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`jiaoshigonghao` varchar(200) COMMENT '教师工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`tiwenshijian` datetime COMMENT '提问时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学生提问';
INSERT INTO xueshengtiwen(woyaotiwen,xueshengxuehao,xueshengxingming,jiaoshigonghao,jiaoshixingming,tiwenshijian) VALUES('我要提问1','学生学号1','学生姓名1','教师工号1','教师姓名1',CURRENT_TIMESTAMP);
INSERT INTO xueshengtiwen(woyaotiwen,xueshengxuehao,xueshengxingming,jiaoshigonghao,jiaoshixingming,tiwenshijian) VALUES('我要提问2','学生学号2','学生姓名2','教师工号2','教师姓名2',CURRENT_TIMESTAMP);
INSERT INTO xueshengtiwen(woyaotiwen,xueshengxuehao,xueshengxingming,jiaoshigonghao,jiaoshixingming,tiwenshijian) VALUES('我要提问3','学生学号3','学生姓名3','教师工号3','教师姓名3',CURRENT_TIMESTAMP);
DROP TABLE IF EXISTS `laoshidayi`;
CREATE TABLE `laoshidayi` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`laoshidayi` longtext COMMENT '老师答疑',
`xueshengxuehao` varchar(200) COMMENT '学生学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`jiaoshigonghao` varchar(200) COMMENT '教师工号',
`jiaoshixingming` varchar(200) COMMENT '教师姓名',
`dayishijian` datetime COMMENT '答疑时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='老师答疑';
INSERT INTO laoshidayi(laoshidayi,xueshengxuehao,xueshengxingming,jiaoshigonghao,jiaoshixingming,dayishijian) VALUES('老师答疑1','学生学号1','学生姓名1','教师工号1','教师姓名1',CURRENT_TIMESTAMP);
INSERT INTO laoshidayi(laoshidayi,xueshengxuehao,xueshengxingming,jiaoshigonghao,jiaoshixingming,dayishijian) VALUES('老师答疑2','学生学号2','学生姓名2','教师工号2','教师姓名2',CURRENT_TIMESTAMP);
INSERT INTO laoshidayi(laoshidayi,xueshengxuehao,xueshengxingming,jiaoshigonghao,jiaoshixingming,dayishijian) VALUES('老师答疑3','学生学号3','学生姓名3','教师工号3','教师姓名3',CURRENT_TIMESTAMP);
DROP TABLE IF EXISTS `kaitibaogao`;
CREATE TABLE `kaitibaogao` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ketitimu` varchar(200) COMMENT '课题题目',
`kaitibaogao` longtext COMMENT '开题报告',
`xueshengxuehao` varchar(200) COMMENT '学生学号',
`xueshengxingming` varchar(200) COMMENT '学生姓名',
`jiaoshigonghao` varchar(200) COMMENT '教师工号',
`tijiaoshijian` datetime COMMENT '提交时间',
`sfsh` varchar(200) default '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='开题报告';
INSERT INTO kaitibaogao(ketitimu,kaitibaogao,xueshengxuehao,xueshengxingming,jiaoshigonghao,tijia
【计算机毕业设计】213毕业设计管理系统设计
版权申诉
72 浏览量
2023-08-08
10:35:06
上传
评论 1
收藏 32.54MB RAR 举报
【计算机毕业设计】213毕业设计管理系统设计 （1142个子文件） 
2-run.bat 14B 1-install.bat 12B XueshengController.class 10KB JiaoshiController.class 10KB CommonController.class 10KB ForumController.class 9KB ZhongqibaogaoController.class 8KB XueshengtiwenController.class 8KB XueshengtitiController.class 8KB KaitibaogaoController.class 8KB LaoshidayiController.class 8KB BiyelunwenController.class 8KB ZaixianxuantiController.class 8KB LunwenjinduController.class 8KB StoreupController.class 8KB LunwenchazhongController.class 8KB WenjianmobanController.class 8KB NewsController.class 7KB MPUtil.class 7KB UserController.class 6KB ZhongqibaogaoEntity.class 5KB BiyelunwenEntity.class 5KB TokenServiceImpl.class 4KB FileController.class 4KB BaiduUtil.class 4KB XueshengtitiEntity.class 4KB KaitibaogaoEntity.class 4KB LunwenjinduEntity.class 4KB ForumEntity.class 4KB XueshengEntity.class 4KB LunwenchazhongServiceImpl.class 4KB XueshengtiwenServiceImpl.class 4KB ZaixianxuantiServiceImpl.class 4KB ZhongqibaogaoServiceImpl.class 4KB XueshengtitiServiceImpl.class 4KB WenjianmobanServiceImpl.class 4KB LunwenjinduServiceImpl.class 4KB KaitibaogaoServiceImpl.class 4KB ZaixianxuantiEntity.class 4KB BiyelunwenServiceImpl.class 4KB LaoshidayiServiceImpl.class 4KB XueshengServiceImpl.class 4KB JiaoshiServiceImpl.class 4KB StoreupServiceImpl.class 4KB ForumServiceImpl.class 4KB ConfigController.class 4KB XueshengtiwenEntity.class 4KB NewsServiceImpl.class 4KB LaoshidayiEntity.class 4KB JiaoshiEntity.class 3KB AuthorizationInterceptor.class 3KB WenjianmobanEntity.class 3KB StoreupEntity.class 3KB Query.class 3KB LunwenchazhongEntity.class 3KB NewsEntity.class 3KB UserServiceImpl.class 3KB PageUtils.class 3KB ZhongqibaogaoModel.class 3KB ZhongqibaogaoVO.class 3KB BiyelunwenModel.class 3KB BiyelunwenVO.class 3KB TokenEntity.class 3KB LunwenjinduModel.class 2KB KaitibaogaoModel.class 2KB CommonServiceImpl.class 2KB XueshengtitiModel.class 2KB LunwenjinduVO.class 2KB KaitibaogaoVO.class 2KB XueshengtitiVO.class 2KB ZaixianxuantiModel.class 2KB ZaixianxuantiVO.class 2KB XueshengModel.class 2KB XueshengtiwenModel.class 2KB XueshengVO.class 2KB LaoshidayiModel.class 2KB XueshengtiwenVO.class 2KB LaoshidayiVO.class 2KB R.class 2KB UserEntity.class 2KB ValidatorUtils.class 2KB SpringContextUtils.class 2KB LunwenchazhongService.class 2KB XueshengtiwenService.class 2KB ZaixianxuantiService.class 2KB ZhongqibaogaoService.class 2KB WenjianmobanService.class 2KB XueshengtitiService.class 2KB LunwenchazhongDao.class 2KB KaitibaogaoService.class 2KB LunwenjinduService.class 2KB ZhongqibaogaoDao.class 2KB ZaixianxuantiDao.class 2KB XueshengtiwenDao.class 2KB BiyelunwenService.class 2KB LaoshidayiService.class 2KB WenjianmobanDao.class 2KB XueshengtitiDao.class 2KB HttpClientUtils.class 2KB KaitibaogaoDao.class 2KB共 1142 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
卓怡学长
- 粉丝: 1w+
- 资源: 121
最新资源
- 下载安装这个软件.apk
- 【数据集详细解释及案例分析】数据集详细解释及案例分析
- 基于SHT71温湿度传感器、STM32F103C8T6、LCD1602温湿度采集显示系统proteus仿真设计
- 基于TH02温湿度传感器、STM32F103C8T6、LCD1602、FREERTOS的温湿度采集系统proteus仿真设计
- 【TCP-IP协议详细解释及案例分析】TCP-IP协议详细解释及案例分析
- 一文搞懂 LSTM（长短期记忆网络）.rar
- 【autosar简介及基本案例解析】autosar简介及基本案例解析
- java模拟斗地主洗牌发牌
- springboot+vue登录系统 vue部分
- 常用常见 SQL语句语法
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
