stuinfo table.txt

jsp网络考试系统,网上学生考试系统(cs版) 这是毕业设计程序,当时做的时候付出了很大的努力, 也学到很多的东西,算是对所学JAVA知识的一个综合应用吧, 做的过程中在网上找到了很多有用的东西

create table stuinfo(
sno number(4),
sname char(8) not null,
spass char(6) not null,
sex   char(2),
sclass char(20),
mscore number(4),
escore number(4),
constraint pk_stuinfo primary key(sno)
);
insert into stuinfo values(1001,'褚廷军','ctj','男','计算七班',null,null);
insert into stuinfo values(1002,'张三','002','男','计算七班',null,null);

//


create table exam(
eid char(4) not null,
tcontent varchar(100)not null,
toption  varchar(100),
type    varchar(10),
tkey    char(3),
constraint pk_exam primary key(tcontent)
);

insert into exam values('e','(1).Take an umbrella with you in case_____.','A) it will rain B) it rains C) it raining D) it rained','b');

insert into exam values('e','(2).He is no longer the honest man___he was.','A) who B) whom C) which D) that','b');
insert into exam values('e','(3).During the recession,thousands of workers were____.','A) laid on B) laid down C) laid out D) lain off','c');
insert into exam values('m','(1).25+2*_____=75 ?','A) 10 B) 20 C) 15 D) 25','d');
insert into exam values('m','(2).2+2*_____=12 ?','A) 10 B) 13 C) 15 D) 12','d');