成绩管理系统web_android端

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50712 Source Host : localhost:3306 Source Database : ssh1 Target Server Type : MYSQL Target Server Version : 50712 File Encoding : 65001 Date: 2017-10-11 15:43:10 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for class_teacher -- ---------------------------- DROP TABLE IF EXISTS `class_teacher`; CREATE TABLE `class_teacher` ( `id` int(4) unsigned NOT NULL AUTO_INCREMENT, `teacher` varchar(20) NOT NULL, `department` varchar(50) NOT NULL, `major` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `teacher` (`teacher`), CONSTRAINT `class_teacher_ibfk_1` FOREIGN KEY (`teacher`) REFERENCES `teacher` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of class_teacher -- ---------------------------- INSERT INTO `class_teacher` VALUES ('1', 'A001', '大数据学院', '网络工程'); -- ---------------------------- -- Table structure for course -- ---------------------------- DROP TABLE IF EXISTS `course`; CREATE TABLE `course` ( `id` varchar(20) NOT NULL, `name` varchar(50) NOT NULL, `credit` float(4,1) NOT NULL, `teacher` varchar(20) NOT NULL, `time` varchar(50) NOT NULL, `type` varchar(50) NOT NULL, `term` varchar(50) NOT NULL, KEY `FKAF42E01BD0D9283F` (`teacher`), KEY `id` (`id`), CONSTRAINT `course_ibfk_1` FOREIGN KEY (`teacher`) REFERENCES `teacher` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of course -- ---------------------------- INSERT INTO `course` VALUES ('T001', '数据结构', '0.5', 'A001', '周五第二大节', '专业必修课', '第一学年（秋季）'); INSERT INTO `course` VALUES ('T002', '数据库', '4.0', 'A001', '周五第二大节', '专业必修课', '第一学年（春季）'); INSERT INTO `course` VALUES ('T003', '线性代数', '0.5', 'A001', '周五第一大节', '专业必修课', '第一学年（秋季）'); INSERT INTO `course` VALUES ('T100', 'C语言程序设计', '4.0', 'A001', '周一第一大节', '专业必修课', '第二学年（春季）'); -- ---------------------------- -- Table structure for grade -- ---------------------------- DROP TABLE IF EXISTS `grade`; CREATE TABLE `grade` ( `id` int(4) NOT NULL AUTO_INCREMENT, `sno` varchar(20) NOT NULL, `cno` varchar(20) NOT NULL, `grade` float(4,1) NOT NULL, PRIMARY KEY (`id`), KEY `FK5E0BFD792398C32` (`sno`), KEY `FK5E0BFD77F4D99AC` (`cno`), KEY `FK5E0BFD7C75D02A` (`sno`), KEY `FK5E0BFD747ED55A4` (`cno`), CONSTRAINT `FK5E0BFD747ED55A4` FOREIGN KEY (`cno`) REFERENCES `course` (`id`), CONSTRAINT `FK5E0BFD77F4D99AC` FOREIGN KEY (`cno`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK5E0BFD792398C32` FOREIGN KEY (`sno`) REFERENCES `student` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK5E0BFD7C75D02A` FOREIGN KEY (`sno`) REFERENCES `student` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of grade -- ---------------------------- INSERT INTO `grade` VALUES ('1', '1407084131', 'T001', '96.0'); INSERT INTO `grade` VALUES ('2', '1407084133', 'T001', '59.0'); INSERT INTO `grade` VALUES ('3', '1407084137', 'T001', '95.0'); INSERT INTO `grade` VALUES ('4', '1407084137', 'T002', '86.0'); INSERT INTO `grade` VALUES ('5', '1407084133', 'T002', '88.0'); INSERT INTO `grade` VALUES ('6', '1407084131', 'T002', '85.0'); INSERT INTO `grade` VALUES ('7', '1407084131', 'T003', '65.0'); INSERT INTO `grade` VALUES ('8', '1407084133', 'T003', '70.0'); INSERT INTO `grade` VALUES ('9', '1407084137', 'T003', '89.0'); -- ---------------------------- -- Table structure for sc -- ---------------------------- DROP TABLE IF EXISTS `sc`; CREATE TABLE `sc` ( `id` int(4) unsigned NOT NULL AUTO_INCREMENT, `sno` varchar(20) NOT NULL, `cno` varchar(20) NOT NULL, PRIMARY KEY (`id`), KEY `sno` (`sno`), KEY `cno` (`cno`), CONSTRAINT `sc_ibfk_1` FOREIGN KEY (`sno`) REFERENCES `student` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `sc_ibfk_2` FOREIGN KEY (`cno`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of sc -- ---------------------------- INSERT INTO `sc` VALUES ('2', '1407084137', 'T002'); INSERT INTO `sc` VALUES ('4', '1407084133', 'T002'); INSERT INTO `sc` VALUES ('5', '1407084131', 'T001'); INSERT INTO `sc` VALUES ('6', '1407084133', 'T001'); INSERT INTO `sc` VALUES ('7', '1407084137', 'T001'); INSERT INTO `sc` VALUES ('8', '1407084131', 'T002'); INSERT INTO `sc` VALUES ('9', '1407084131', 'T003'); INSERT INTO `sc` VALUES ('10', '1407084133', 'T003'); INSERT INTO `sc` VALUES ('11', '1407084137', 'T003'); -- ---------------------------- -- Table structure for student -- ---------------------------- DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` varchar(20) NOT NULL, `name` varchar(20) NOT NULL, `age` int(4) NOT NULL, `sex` varchar(2) NOT NULL, `department` varchar(50) NOT NULL, `major` varchar(50) NOT NULL, `inTime` varchar(50) NOT NULL, `outTime` varchar(50) NOT NULL, `password` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of student -- ---------------------------- INSERT INTO `student` VALUES ('1407084131', '程文翔', '21', '男', '大数据学院', '网络工程', '2014-09-01', '2018-07-01', '1407084131'); INSERT INTO `student` VALUES ('1407084133', '李祖意', '21', '男', '大数据学院', '网络工程', '2014-09-01', '2018-07-01', '1407084133'); INSERT INTO `student` VALUES ('1407084137', '陈雨亮', '20', '男', '大数据学院', '网络工程', '2014-09-01', '2018-07-01', '1407084137'); -- ---------------------------- -- Table structure for teacher -- ---------------------------- DROP TABLE IF EXISTS `teacher`; CREATE TABLE `teacher` ( `id` varchar(20) NOT NULL, `name` varchar(20) NOT NULL, `age` int(4) NOT NULL, `sex` varchar(2) NOT NULL, `post` varchar(20) NOT NULL, `department` varchar(50) NOT NULL, `password` varchar(20) NOT NULL, `major` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of teacher -- ---------------------------- INSERT INTO `teacher` VALUES ('A001', '韩立新', '30', '女', '讲师', '大数据学院', '123', '网络工程'); INSERT INTO `teacher` VALUES ('A002', 'John', '35', '男', '教授', '理学院', 'A002', '统计学专业');