技术：spring springmvc mybatis java mysql
数据库表
数据库表：
CREATE TABLE course (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) DEFAULT NULL,
teacher varchar(255) DEFAULT NULL,
period varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
– Records of course
INSERT INTO course VALUES (‘1’, ‘计算机科学与技术’, ‘张凤兰’, ‘20’);
INSERT INTO course VALUES (‘2’, ‘概率论’, ‘马飞’, ‘15’);
INSERT INTO course VALUES (‘3’, ‘高等数学’, ‘刘峰’, ‘30’);
INSERT INTO course VALUES (‘4’, ‘数字电路’, ‘韩丽’, ‘25’);
INSERT INTO course VALUES (‘5’, ‘JAVA基础’, ‘宋翔’, ‘26’);
– Table structure for report
DROP TABLE IF EXISTS report;
CREATE TABLE report (
id int(11) NOT NULL AUTO_INCREMENT,
stuno varchar(255) DEFAULT NULL,
coursename varchar(255) DEFAULT NULL,
score varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
– Records of report
INSERT INTO report VALUES (‘2’, ‘stu001’, ‘计算机科学与技术’, ‘85’);
INSERT INTO report VALUES (‘3’, ‘stu001’, ‘概率论’, ‘95’);
INSERT INTO report VALUES (‘4’, ‘stu001’, ‘数字电路’, ‘75’);
INSERT INTO report VALUES (‘5’, ‘stu002’, ‘计算机科学与技术’, ‘65’);
– Table structure for stu
DROP TABLE IF EXISTS stu;
CREATE TABLE stu (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(255) DEFAULT NULL,
pwd varchar(255) DEFAULT NULL,
sex varchar(255) DEFAULT NULL,
age varchar(255) DEFAULT NULL,
stuno varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
