CREATE TABLE Choose( vTxID varchar(4) NOT NULL, vNandu varchar(4) NOT NULL, vtID varchar(4) NOT NULL, vNeirong varchar(50) NOT NULL, vSelecA varchar(50) NOT NULL, vSelecB varchar(50) NOT NULL, vSelecC varchar(50) NOT NULL, vSelecD varchar(50) NOT NULL, vBanswer varchar(2) NOT NULL, vScore int NOT NULL )
填空题表
USE C考试系统
CREATE TABLE Fillblank( vTxID varchar(4) NOT NULL, vNandu varchar(4) NOT NULL, vtID varchar(4) NOT NULL, vNeirong varchar(50) NOT NULL, vBanswer varchar(50) NOT NULL, vScore int NOT NULL )
程序设计题表
USE C考试系统
CREATE TABLE Program( vTxID varchar(4) NOT NULL, vNandu varchar(4) NOT NULL, vtID varchar(4) NOT NULL, vNeirong varchar(100) NOT NULL, vBanswer varchar(100) NOT NULL, vScore int NOT NULL )
学生答案表
USE C考试系统
CREATE TABLE StuAnswer(
vID varchar(20) NOT NULL primary key, vName varchar(20) NOT NULL, vtID varchar(4) NOT NULL,
vAnswer varchar(100) NOT NULL )
判卷表
USE C考试系统
CREATE TABLE Ajusted(
vID varchar(20) NOT NULL primary key, vName varchar(20) NOT NULL, vtID varchar(4) NOT NULL, vBAnswer varchar(100) NOT NULL, vAnswer varchar(100) NOT NULL, iScore int NULL, iScoreSum int NULL )
表数据插入
管理员
use C考试系统
insert Admintor
values ('张朋','Zhangpeng')
教师
use C考试系统
insert Teacher
values ('张宏','Zhanghong'), ('李杰','Lijie'), ('姚明','Yaoming')
学生
use C考试系统
insert Student
values ('2010121001','lihong','李宏','男','网络工程','121','101'), ('2010121002','zhangjian','张建','男','网络工程','121','101'), ('2010121003','Chenpeng','程鹏','男','网络工程','121','101'), ('2010121004','zhanghong','张红','女','网络工程','121','101'), ('2010121005','liujian','刘建','男','网络工程','121','101'), ('2010121006','xiaqi','夏棋','男','网络工程','121','102'), ('2010121007','chentao','陈涛','男','网络工程','121','102'), ('2010121008','liyu','李宇','男','网络工程','121','102'),
('2010121009','mapeijian','马培建','男','网络工程','121','102'), ('2010121010','Shengxia','盛夏','女','网络工程','121','102'), ('2010121011','zhanghui','张辉','女','网络工程','121','102'), ('2010122012','Tangli','唐莉','女','信息安全','122','102'), ('2010122013','sangbo','桑博','男','信息安全','122','102'), ('2010122014','Chenglong','成龙','男','信息安全','122','103'), ('2010122015','zhangsan','张三','男','信息安全','122','103'), ('2010122016','lisi','李四','男','信息安全','122','103'), ('2010122017','wangwu','王五','男','信息安全','122','103'), ('2010122018','zhaoliu','赵六','男','信息安全','122','103'), ('2010122019','chenqi','陈奇','男','信息安全','122','103'), ('2010122020','linfeng','林枫','男','信息安全','122','103'), ('2010123021','liubei','刘备','男','信息对抗','123','103'), ('2010123022','zhangfei','张飞','男','信息对抗','123','104'), ('2010123023','lusu','鲁肃','男','信息对抗','123','104'), ('2010123024','diaochan','貂蝉','女','信息对抗','123','104'), ('2010123025','Daji','妲己','女','信息对抗','123','104'), ('2010123026','lvzhi','吕雉','女','信息对抗','123','104'), ('2010123027','lisheng','李胜','男','信息对抗','123','104'), ('2010123028','liubai','刘白','男','信息对抗','123','104'), ('2010123029','zhangqiang','张强','男','信息对抗','123','104'), ('2010123030','liuhong','刘宏','男','信息对抗','123','104'), ('2010123031','zhaolong','赵龙','男','信息对抗','123','104'), ('2010123032','sufeng','苏风','女','信息对抗','123','104'), ('2010123033','caocao','曹操','男','信息对抗','123','104'),
('2010123034','libinbin','李彬彬','男','信息对抗','123','104'), ('2010123035','Fanwei','范伟','男','信息对抗','123','101'), ('2010124036','zhoujie','周杰','男','计算机科学','124','101'), ('2010124037','longgen','龙根','男','计算机科学','124','101'), ('2010124038','lihao','李浩','男','计算机科学','124','102'), ('2010124039','chensa','陈飒','男','计算机科学','124','102'), ('2010124040','liwu','李武','男','计算机科学','124','103'), ('2010124041','qiansun','钱孙','男','计算机科学','124','103'), ('2010124042','zhenghe','郑和','女','计算机科学','124','103') 学生汇总 use C考试系统
insert Stud
values ('2010121001','李宏','男','网络工程','121','101','2011-07-09 09:00','78'),
('2010121002','张建','男','网络工程','121','101','2011-07-09 09:00','56'),
('2010121003','程鹏','男','网络工程','121','101','2011-07-09 09:00','89'),
('2010121004','张红','女','网络工程','121','101','2011-07-09 09:00','90'),
('2010121005','刘建','男','网络工程','121','101','2011-07-09 09:00','45'),
('2010121006','夏棋','男','网络工程','121','102','2011-07-09 09:00','65'),
('2010121007','陈涛','男','网络工程','121','102','2011-07-09 09:00','96'),
('2010121008','李宇','男','网络工程','121','102','2011-07-09 09:00','78'),
('2010121009','马培建','男','网络工程','121','102','2011-07-09 09:00','32'),
('2010121010','盛夏','女','网络工程','121','102','2011-07-09 09:00','43'),
('2010121011','张辉','女','网络工程','121','102','2011-07-09 09:00','64'),
('2010122012','唐莉','女','信息安全','122','102','2011-07-09 09:00','62'),
('2010122013','桑博','男','信息安全','122','102','2011-07-09 09:00','88'),
('2010122014','成龙','男','信息安全','122','103','2011-07-09 09:00','77'),
('2010122015','张三','男','信息安全','122','103','2011-07-09 09:00','66'),
('2010122016','李四','男','信息安全','122','103','2011-07-09 09:00','55'),
('2010122017','王五','男','信息安全','122','103','2011-07-09 09:00','44'),
('2010122018','赵六','男','信息安全','122','103','2011-07-09 09:00','58'),
('2010122019','陈奇','男','信息安全','122','103','2011-07-09 09:00','81'),
('2010122020','林枫','男','信息安全','122','103','2011-07-09 09:00','67'),
('2010123021','刘备','男','信息对抗','123','103','2011-07-09 09:00','64'),
('2010123022','张飞','男','信息对抗','123','104','2011-07-09 09:00','69'),
('2010123023','鲁肃','男','信息对抗','123','104','2011-07-09 09:00','70'),
('2010123024','貂蝉','女','信息对抗','123','104','2011-07-09 09:00','80'),
('2010123025','妲己','女','信息对抗','123','104','2011-07-09 09:00','90'),
('2010123026','吕雉','女','信息对抗','123','104','2011-07-09 09:00','100'),
('2010123027','李胜','男','信息对抗','123','104','2011-07-09 09:00','100'),
('2010123028','刘白','男','信息对抗','123','104','2011-07-09 09:00','100'),
('2010123029','张强','男','信息对抗','123','104','2011-07-09 09:00','56'),
('2010123030','刘宏','男','信息对抗','123','104','2011-07-09 09:00','75'),
('2010123031','赵龙','男','信息对抗','123','104','2011-07-09 09:00','74'),
('2010123032','苏风','女','信息对抗','123','104','2011-07-09 09:00','53'),
('2010123033','曹操','男','信息对抗','123','104','2011-07-09 09:00','52'),
('2010123034','李彬彬','男','信息对抗','123','104','2011-07-09 09:00','54'),
('2010123035','范伟','男','信息对抗','123','101','2011-07-09 09:00','67'),
('2010124036','周杰','男','计算机科学','124','101','2011-07-09 09:00','76'),
('2010124037','龙根','男','计算机科学','124','101','2011-07-09 09:00','78'),