Source Server : shuai Source Server Version : 50037
Source Host : localhost:3306 Source Database : stu_score_ms
Target Server Type : MYSQL Target Server Version : 50037 File Encoding : 65001
Date: 2010-01-17 21:41:59 */
SET FOREIGN_KEY_CHECKS=0; -- ----------------------------
-- Table structure for `course` -- ----------------------------
DROP TABLE IF EXISTS `course`; CREATE TABLE `course` ( `cid` char(10) NOT NULL, `clnum` char(10) NOT NULL, `cname` char(10) NOT NULL, `credit` double(4,2) default NULL, `capacity` int(4) default NULL, `tid` char(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ---------------------------- -- Records of course -- ----------------------------
INSERT INTO `course` VALUES ('bb1', '1', 'java', '3.00', '120', null); INSERT INTO `course` VALUES ('bb2', '2', 'c++', '2.50', '150', null);
-- ----------------------------
-- Table structure for `manager` -- ----------------------------
DROP TABLE IF EXISTS `manager`; CREATE TABLE `manager` ( `id` char(10) NOT NULL,
`password` char(10) default NULL, PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of manager
Javaweb学生成绩管理系统
-- ----------------------------
INSERT INTO `manager` VALUES ('1', '1'); INSERT INTO `manager` VALUES ('2', '2');
-- ---------------------------- -- Table structure for `rank` -- ----------------------------
DROP TABLE IF EXISTS `rank`; CREATE TABLE `rank` ( `sid` char(4) NOT NULL,
`averagepoint` double(4,2) default NULL, `rank` int(4) default NULL, PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of rank
-- ----------------------------
INSERT INTO `rank` VALUES ('001', '3.88', null); INSERT INTO `rank` VALUES ('002', '3.70', null); INSERT INTO `rank` VALUES ('003', '2.53', null); INSERT INTO `rank` VALUES ('004', '3.41', null); INSERT INTO `rank` VALUES ('005', '3.13', null); INSERT INTO `rank` VALUES ('006', null, null); INSERT INTO `rank` VALUES ('007', null, null); INSERT INTO `rank` VALUES ('null', null, null);
-- ---------------------------- -- Table structure for `score` -- ----------------------------
DROP TABLE IF EXISTS `score`; CREATE TABLE `score` ( `cid` char(10) NOT NULL,
`cname` char(10) default NULL, `credit` double(4,1) default NULL, `sid` char(10) default NULL, `pscore` int(4) default NULL, `qscore` int(4) default NULL, `grade` int(4) default NULL, `jpa` double(4,2) default NULL, `rank` int(4) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of score -- ----------------------------
INSERT INTO `score` VALUES ('bb1', 'java', '3.5', '001', '98', '96', '97', '4.00', null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '001', '86', '88', '87', '3.70', null); INSERT INTO `score` VALUES ('bb1', 'java', '3.5', '002', '94', '82', '88', '3.70', null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', 'null', null, null, null, null, null); INSERT INTO `score` VALUES ('bb1', 'java', '3.5', 'null', null, null, null, null, null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '002', '96', '77', '86', '3.70', null); INSERT INTO `score` VALUES ('bb1', 'java', '3.5', '003', '88', '67', '77', '2.70', null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '003', '78', '67', '72', '2.30', null); INSERT INTO `score` VALUES ('bb1', 'java', '3.5', '004', '78', '98', '88', '3.70', null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '004', '84', '76', '80', '3.00', null); INSERT INTO `score` VALUES ('bb1', 'java', '3.5', '005', '84', '79', '81', '3.00', null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '005', '84', '84', '84', '3.30', null); INSERT INTO `score` VALUES ('bb1', 'java', '3.0', '006', null, null, null, null, null); INSERT INTO `score` VALUES ('bb1', 'java', '3.0', '006', null, null, null, null, null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '006', null, null, null, null, null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '006', null, null, null, null, null); INSERT INTO `score` VALUES ('bb1', 'java', '3.0', '007', null, null, null, null, null); INSERT INTO `score` VALUES ('bb2', 'c++', '2.5', '007', null, null, null, null, null);
-- ----------------------------
-- Table structure for `student` -- ----------------------------
DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` char(10) NOT NULL,
`sname` char(10) default NULL, `password` char(10) default NULL, `sclass` char(20) default NULL, `smajor` char(20) default NULL, PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of student -- ----------------------------
INSERT INTO `student` VALUES ('001', '孔帅', '1', '1', '计算机'); INSERT INTO `student` VALUES ('002', '李维银', '2', '2', '计算机'); INSERT INTO `student` VALUES ('003', '罗玉泽', '3', '3', '计算机'); INSERT INTO `student` VALUES ('004', '孙煜', '4', '4', '计算机'); INSERT INTO `student` VALUES ('005', '贾佑闯', '5', '5', '计算机'); INSERT INTO `student` VALUES ('006', '马富营', '6', '1', '计算机'); INSERT INTO `student` VALUES ('007', '王成龙', '7', '1', '计算机');
Javaweb学生成绩管理系统
-- ----------------------------
-- Table structure for `studentcourse` -- ----------------------------
DROP TABLE IF EXISTS `studentcourse`; CREATE TABLE `studentcourse` ( `sid` char(10) NOT NULL, `cid` char(10) NOT NULL,
`cname` char(10) default NULL, `credit` double(4,1) default NULL, `capacity` int(4) default NULL, `clnum` char(10) default NULL, `tid` char(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ---------------------------- -- Records of studentcourse -- ----------------------------
INSERT INTO `studentcourse` VALUES ('001', 'bb1', 'java', '3.5', '120', '1', null); INSERT INTO `studentcourse` VALUES ('001', 'bb2', 'c++', '2.5', '150', '2', null); INSERT INTO `studentcourse` VALUES ('002', 'bb1', 'java', '3.5', '120', '1', null); INSERT INTO `studentcourse` VALUES ('null', 'bb2', 'c++', '2.5', '150', '2', null); INSERT INTO `studentcourse` VALUES ('null', 'bb1', 'java', '3.5', '120', '1', null); INSERT INTO `studentcourse` VALUES ('002', 'bb2', 'c++', '2.5', '150', '2', null); INSERT INTO `studentcourse` VALUES ('003', 'bb1', 'java', '3.5', '120', '1', null); INSERT INTO `studentcourse` VALUES ('003', 'bb2', 'c++', '2.5', '150', '2', null); INSERT INTO `studentcourse` VALUES ('004', 'bb1', 'java', '3.5', '120', '1', null); INSERT INTO `studentcourse` VALUES ('004', 'bb2', 'c++', '2.5', '150', '2', null); INSERT INTO `studentcourse` VALUES ('005', 'bb1', 'java', '3.5', '120', '1', null); INSERT INTO `studentcourse` VALUES ('005', 'bb2', 'c++', '2.5', '150', '2', null); INSERT INTO `studentcourse` VALUES ('006', 'bb1', 'java', '3.0', '120', '1', null); INSERT INTO `studentcourse` VALUES ('006', 'bb2', 'c++', '2.5', '150', '2', null);
-- ----------------------------
-- Table structure for `teacher` -- ----------------------------
DROP TABLE IF EXISTS `teacher`; CREATE TABLE `teacher` ( `id` char(10) NOT NULL, `tname` char(10) NOT NULL, `password` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of teacher -- ----------------------------
INSERT INTO `teacher` VALUES ('1', '岳训', '1'); INSERT INTO `teacher` VALUES ('2', '张军本', '2');
代码测试：