/*
Navicat MySQL Data Transfer
Source Server : myconnector
Source Server Version : 50640
Source Host : localhost:3306
Source Database : studb
Target Server Type : MYSQL
Target Server Version : 50640
File Encoding : 65001
Date: 2018-07-18 21:45:26
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for courseinfo
-- ----------------------------
DROP TABLE IF EXISTS `courseinfo`;
CREATE TABLE `courseinfo` (
`course_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '课程编号',
`course_name` varchar(20) NOT NULL COMMENT '课程名',
`course_teacher` varchar(30) NOT NULL COMMENT '任课教师',
`course_credit` int(11) NOT NULL COMMENT '学分',
PRIMARY KEY (`course_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of courseinfo
-- ----------------------------
INSERT INTO `courseinfo` VALUES ('7', '计算机网络', '王华', '2');
-- ----------------------------
-- Table structure for studentinfo
-- ----------------------------
DROP TABLE IF EXISTS `studentinfo`;
CREATE TABLE `studentinfo` (
`stu_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`stu_num` varchar(20) NOT NULL COMMENT '账号',
`stu_name` varchar(20) NOT NULL COMMENT '姓名',
`stu_sex` varchar(10) NOT NULL COMMENT '性别',
`stu_age` int(11) NOT NULL COMMENT '年龄',
`stu_class` varchar(20) NOT NULL COMMENT '班级',
`major` varchar(20) NOT NULL COMMENT '专业',
`department` varchar(20) NOT NULL COMMENT '院系',
PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of studentinfo
-- ----------------------------
INSERT INTO `studentinfo` VALUES ('9', '17001', '王五', '男', '22', '软件1701', '软件工程', '计算机学院');
INSERT INTO `studentinfo` VALUES ('10', '17002', '张三', '男', '21', '软件1702', '软件工程', '计算机学院');
INSERT INTO `studentinfo` VALUES ('11', '17003', '李四', '男', '22', '软件1701', '软件工程', '计算机学院');
INSERT INTO `studentinfo` VALUES ('12', '17004', '李明', '男', '22', '软件1701', '软件工程', '计算机学院');
INSERT INTO `studentinfo` VALUES ('13', '17005', '王华', '女', '20', '软件1703', '软件工程', '计算机学院');
INSERT INTO `studentinfo` VALUES ('14', '17006', '陈东', '男', '22', '软件1702', '软件工程', '计算机学院');
INSERT INTO `studentinfo` VALUES ('15', '17007', '陈红', '女', '21', '软件1703', '软件工程', '计算机学院');
INSERT INTO `studentinfo` VALUES ('16', '17008', '吴花', '女', '23', '软件1701', '软件工程', '计算机学院');
-- ----------------------------
-- Table structure for studentscore
-- ----------------------------
DROP TABLE IF EXISTS `studentscore`;
CREATE TABLE `studentscore` (
`score_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '成绩编号',
`stu_num` varchar(20) NOT NULL COMMENT '学号',
`course_name` varchar(20) NOT NULL COMMENT '科目',
`score_grade` double(5,2) NOT NULL COMMENT '成绩',
PRIMARY KEY (`score_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of studentscore
-- ----------------------------
INSERT INTO `studentscore` VALUES ('16', '17001', '计算机网络', '86.00');
INSERT INTO `studentscore` VALUES ('20', '17002', '计算机网络', '76.00');
INSERT INTO `studentscore` VALUES ('21', '17003', '计算机网络', '85.00');
INSERT INTO `studentscore` VALUES ('22', '17004', '计算机网络', '66.00');
INSERT INTO `studentscore` VALUES ('23', '17005', '计算机网络', '69.00');
INSERT INTO `studentscore` VALUES ('24', '17006', '计算机网络', '96.00');
INSERT INTO `studentscore` VALUES ('25', '17007', '计算机网络', '90.00');
INSERT INTO `studentscore` VALUES ('26', '17008', '计算机网络', '58.00');
-- ----------------------------
-- Table structure for teacherinfo
-- ----------------------------
DROP TABLE IF EXISTS `teacherinfo`;
CREATE TABLE `teacherinfo` (
`tea_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`tea_num` varchar(20) NOT NULL COMMENT '工号',
`tea_name` varchar(30) NOT NULL COMMENT '姓名',
`tea_sex` varchar(10) NOT NULL COMMENT '性别',
`tea_age` int(11) NOT NULL COMMENT '年龄',
`tea_course` varchar(20) NOT NULL COMMENT '所任课程',
`department` varchar(20) NOT NULL COMMENT '院系',
PRIMARY KEY (`tea_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of teacherinfo
-- ----------------------------
INSERT INTO `teacherinfo` VALUES ('5', '9001', '王华', '男', '40', '计算机网络', '计算机学院');
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
`user_num` varchar(20) NOT NULL COMMENT '用户账号',
`password` varchar(20) NOT NULL COMMENT '密码',
`role_id` int(11) NOT NULL COMMENT '角色编号(外键)',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('17', '17001', '111111', '0');
INSERT INTO `users` VALUES ('18', '9001', '111111', '1');
INSERT INTO `users` VALUES ('19', '17002', '111111', '0');
INSERT INTO `users` VALUES ('20', '17003', '111111', '0');
INSERT INTO `users` VALUES ('21', '17004', '111111', '0');
INSERT INTO `users` VALUES ('22', '17005', '111111', '0');
INSERT INTO `users` VALUES ('23', '17006', '111111', '0');
INSERT INTO `users` VALUES ('24', '17007', '111111', '0');
INSERT INTO `users` VALUES ('25', '17008', '111111', '0');
INSERT INTO `users` VALUES ('26', 'admin', 'admin', '2');