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
3813-SSM毕业设计管理系统设计（源码+数据库+lun文）.zip （1143个子文件） 
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 BiyelunwenController.class 8KB LaoshidayiController.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 ZhongqibaogaoServiceImpl.class 4KB ZaixianxuantiServiceImpl.class 4KB XueshengtiwenServiceImpl.class 4KB WenjianmobanServiceImpl.class 4KB XueshengtitiServiceImpl.class 4KB LunwenjinduServiceImpl.class 4KB KaitibaogaoServiceImpl.class 4KB ZaixianxuantiEntity.class 4KB BiyelunwenServiceImpl.class 4KB LaoshidayiServiceImpl.class 4KB XueshengServiceImpl.class 4KB StoreupServiceImpl.class 4KB JiaoshiServiceImpl.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 KaitibaogaoModel.class 2KB LunwenjinduModel.class 2KB CommonServiceImpl.class 2KB XueshengtitiModel.class 2KB KaitibaogaoVO.class 2KB LunwenjinduVO.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 ZaixianxuantiService.class 2KB XueshengtiwenService.class 2KB ZhongqibaogaoService.class 2KB WenjianmobanService.class 2KB XueshengtitiService.class 2KB LunwenchazhongDao.class 2KB KaitibaogaoService.class 2KB LunwenjinduService.class 2KB ZaixianxuantiDao.class 2KB ZhongqibaogaoDao.class 2KB XueshengtiwenDao.class 2KB BiyelunwenService.class 2KB LaoshidayiService.class 2KB XueshengtitiDao.class 2KB WenjianmobanDao.class 2KB HttpClientUtils.class 2KB KaitibaogaoDao.class 2KB共 1143 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
Java旅途
- 粉丝: 1w+
- 资源: 3050
最新资源
- 2024网络攻防技术课程实验-基于python实现的域名信息收集工具源码+详细实验步骤.zip
- CodeChrono-1.0.4.zip
- (源码)基于Servlet和JSP的图书商城系统.zip
- (源码)基于SpringBoot和Vue的在线判题评测系统.zip
- C#ASP.NET带视频会议OA源码带手机端数据库 SQL2008源码类型 WebForm
- (源码)基于机器学习的手写数字识别系统.zip
- (源码)基于Java的数据库管理系统.zip
- es拼音分词插件7.5.0
- arctan单片机C语言多种方式代码实现对比 math库 查表法 泰勒连分式展开 分段多项式逼近
- (源码)基于SSM框架的宿舍管理系统.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
