代码拉取完成,页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : MySQL
Source Server Version : 50540
Source Host : localhost:3306
Source Database : studentinfomanagement
Target Server Type : MYSQL
Target Server Version : 50540
File Encoding : 65001
Date: 2020-12-20 16:04:51
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for class
-- ----------------------------
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
`Clno` char(12) NOT NULL DEFAULT '',
`Clname` char(12) DEFAULT NULL,
`Dno` char(12) DEFAULT NULL,
PRIMARY KEY (`Clno`),
KEY `FK_Class_Department` (`Dno`),
CONSTRAINT `class_ibfk_1` FOREIGN KEY (`Dno`) REFERENCES `department` (`Dno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of class
-- ----------------------------
INSERT INTO `class` VALUES ('20150103', '2015-3班', '201501');
INSERT INTO `class` VALUES ('20150104', '2015-4班', '201501');
INSERT INTO `class` VALUES ('20150201', '2015-1班', '201502');
INSERT INTO `class` VALUES ('20150202', '2015-2班', '201502');
INSERT INTO `class` VALUES ('20150301', '2015-1班', '201503');
INSERT INTO `class` VALUES ('20150302', '2015-2班', '201503');
-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`Cno` char(12) NOT NULL DEFAULT '',
`Cname` char(12) DEFAULT NULL,
`Cteacher` char(8) DEFAULT NULL,
`Ccredit` smallint(6) DEFAULT NULL,
PRIMARY KEY (`Cno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES ('1', '高等数学', '张三', '4');
INSERT INTO `course` VALUES ('2', '数据库原理设计', '李四', '3');
INSERT INTO `course` VALUES ('3', 'Java程序设计', '王五', '4');
-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
`Dno` char(12) NOT NULL DEFAULT '',
`Dname` char(12) DEFAULT NULL,
PRIMARY KEY (`Dno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('201501', '软件学院');
INSERT INTO `department` VALUES ('201502', '经管学院');
INSERT INTO `department` VALUES ('201503', '人文学院');
INSERT INTO `department` VALUES ('201504', '国际学院');
INSERT INTO `department` VALUES ('201505', '理学院');
-- ----------------------------
-- Table structure for sc
-- ----------------------------
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc` (
`Sno` char(12) NOT NULL DEFAULT '',
`Cno` char(12) NOT NULL DEFAULT '',
`Grade` smallint(6) DEFAULT NULL,
PRIMARY KEY (`Sno`,`Cno`),
KEY `FK_SC_Course` (`Cno`),
CONSTRAINT `sc_ibfk_1` FOREIGN KEY (`Sno`) REFERENCES `student` (`Sno`),
CONSTRAINT `sc_ibfk_2` FOREIGN KEY (`Cno`) REFERENCES `course` (`Cno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sc
-- ----------------------------
INSERT INTO `sc` VALUES ('2015010312', '1', '50');
INSERT INTO `sc` VALUES ('2015010312', '2', '80');
INSERT INTO `sc` VALUES ('2015010312', '3', '70');
INSERT INTO `sc` VALUES ('2015010313', '1', '90');
INSERT INTO `sc` VALUES ('2015010313', '2', '89');
INSERT INTO `sc` VALUES ('2015010313', '3', '59');
INSERT INTO `sc` VALUES ('2015010314', '1', '85');
INSERT INTO `sc` VALUES ('2015010314', '2', '75');
INSERT INTO `sc` VALUES ('2015010314', '3', '95');
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`Sno` char(12) NOT NULL DEFAULT '',
`Sname` char(8) DEFAULT NULL,
`Ssex` char(2) DEFAULT NULL,
`Sage` smallint(6) DEFAULT NULL,
`Clno` char(12) DEFAULT NULL,
PRIMARY KEY (`Sno`),
KEY `FK_Student_Class` (`Clno`),
CONSTRAINT `student_ibfk_1` FOREIGN KEY (`Clno`) REFERENCES `class` (`Clno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('2015010312', '张明', '男', '20', '20150103');
INSERT INTO `student` VALUES ('2015010313', '秦羽', '女', '19', '20150103');
INSERT INTO `student` VALUES ('2015010314', '刘翔', '男', '19', '20150103');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`username` char(12) NOT NULL DEFAULT '',
`password` char(12) NOT NULL,
`level` char(6) DEFAULT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('admin', '666', '管理员');
INSERT INTO `user` VALUES ('user', '123', '用户');
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。