技术: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&#