第四套JavaWeb在线考试系统（源码+数据库）无论文
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
– Table structure for announcement
DROP TABLE IF EXISTS announcement;
CREATE TABLE announcement (A_ID bigint(10) NOT NULL AUTO_INCREMENT COMMENT ‘公告id’,A_Title varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘标题’,A_Content varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘内容’,A_Author char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘作者id’,A_StartTime date NOT NULL COMMENT ‘有效开始时间’,A_EndTime date NULL DEFAULT NULL COMMENT ‘有效结束时间’,A_CreateDate datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,A_AuthorName varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘作者名’,
PRIMARY KEY (A_ID, A_Content) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Table structure for classes
DROP TABLE IF EXISTS classes;
CREATE TABLE classes (CLS_ID char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘班级id’,CLS_Name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘班级名’,COLL_ID char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学院id’,
PRIMARY KEY (CLS_ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Records of classes
INSERT INTO classes VALUES (‘2013001’, ‘信息管理1班’, ‘20130’);
INSERT INTO classes VALUES (‘2013002’, ‘软件工程1班’, ‘20130’);
INSERT INTO classes VALUES (‘2013101’, ‘电气班’, ‘20131’);
INSERT INTO classes VALUES (‘2013201’, ‘英语1班’, ‘20132’);
– Table structure for college
DROP TABLE IF EXISTS college;
CREATE TABLE college (COLL_ID char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学院id’,COLL_Name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学院名称’,
PRIMARY KEY (COLL_ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Records of college
INSERT INTO college VALUES (‘20130’, ‘信息科学与工程学院’);
INSERT INTO college VALUES (‘20131’, ‘物理与电子工程学院’);
INSERT INTO college VALUES (‘20132’, ‘外语学院’);