部分数据库 CREATE TABLE t_course ( id int(11) NOT NULL AUTO_INCREMENT, courseName varchar(40) DEFAULT NULL, credit int(11) DEFAULT NULL, teacherId int(11) DEFAULT NULL, isxuan int(2) DEFAULT NULL, coursetime int(2) DEFAULT NULL, PRIMARY KEY (id), KEY FK_t_course (teacherId), CONSTRAINT FK_t_course FOREIGN KEY (teacherId) REFERENCES t_teacher (id) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
– Records of t_course
INSERT INTO t_course VALUES (‘1’, ‘数据结构和算法(周一上午8:00-9:30)’, ‘5’, ‘1’, ‘0’, ‘1’); INSERT INTO t_course VALUES (‘2’, ‘操作系统原理(周一上午10:00-12:00)’, ‘3’, ‘2’, ‘0’, ‘2’); INSERT INTO t_course VALUES (‘3’, ‘音乐鉴赏(周三下午3:00-4;00)’, ‘2’, ‘3’, ‘1’, ‘11’); INSERT INTO t_course VALUES (‘4’, ‘C语言基础(周三下午5:00-6:30)’, ‘4’, ‘2’, ‘0’, ‘12’); INSERT INTO t_course VALUES (‘5’, ‘编译原理(周五上午10:00-12:00)’, ‘5’, ‘5’, ‘0’, ‘18’); INSERT INTO t_course VALUES (‘6’, ‘计算机图形学(周五上午10:00-12:00)’, ‘2’, ‘5’, ‘1’, ‘18’); INSERT INTO t_course VALUES (‘7’, ‘离散数学(周二上午8:00-9:30)’, ‘4’, ‘2’, ‘0’, ‘3’); INSERT INTO t_course VALUES (‘8’, ‘大学英语(周二下午3:00-4:00)’, ‘4’, ‘6’, ‘0’, ‘4’); INSERT INTO t_course VALUES (‘9’, ‘体育(周四上午8:00-9:30)’, ‘1’, ‘4’, ‘0’, ‘7’); INSERT INTO t_course VALUES (‘10’, ‘Java程序设计(周二上午10:00-12:00)’, ‘3’, ‘2’, ‘0’, ‘6’); INSERT INTO t_course VALUES (‘11’, ‘编译原理(周五下午5:00-6:30)’, ‘4’, ‘1’, ‘0’, ‘20’);
– Table structure for t_manager
DROP TABLE IF EXISTS t_manager; CREATE TABLE t_manager ( id int(11) NOT NULL AUTO_INCREMENT, userName varchar(20) DEFAULT NULL, password varchar(20) DEFAULT NULL, trueName varchar(20) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
– Records of t_manager
INSERT INTO t_manager VALUES (‘1’, ‘admin’, ‘123’, ‘王大锤’);
– Table structure for t_student
DROP TABLE IF EXISTS t_student; CREATE TABLE t_student ( id int(11) NOT NULL AUTO_INCREMENT, userName varchar(20) DEFAULT NULL, password varchar(20) DEFAULT NULL, trueName varchar(20) DEFAULT NULL, stuNo varchar(20) DEFAULT NULL, professional varchar(30) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
– Records of t_student
INSERT INTO t_student VALUES (‘1’, ‘jack’, ‘123’, ‘张三’, ‘001’, ‘计算机’); INSERT INTO t_student VALUES (‘2’, ‘john’, ‘123’, ‘李四’, ‘002’, ‘计算机’); INSERT INTO t_student VALUES (‘5’, ‘dsfdf’, ‘123’, ‘rtre’, ‘004’, ‘reyrety’); INSERT INTO t_student VALUES (‘7’, ‘ejhk’, ‘123’, ‘iorqwyo’, ‘007’, ‘qwkjlrh k’);
管理员界面 教师界面 学生界面
