db/mysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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='在线选题';