test.sql

java socket 网上在线考试系统

create database web158_com
go
use web158_com
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[stu_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[stu_list]
GO

CREATE TABLE [dbo].[stu_list] (
	[stuname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[stuid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[stuscore] [int] NULL ,
	[stuoperate] [int] NULL ,
	[examed] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[submited] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[stu_question_choose]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[stu_question_choose]
GO

CREATE TABLE [dbo].[stu_question_choose] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[question] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[a] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[b] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[c] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[d] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[stu_question_operation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[stu_question_operation]
GO

CREATE TABLE [dbo].[stu_question_operation] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[question] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

















delete from stu_list 
insert into stu_list values ('李建东',2005010720,'','','false','false')
insert into stu_list values ('李伟龙',2005010721,'','','false','false')
insert into stu_list values ('李新',2005010723,'','','false','false')
insert into stu_list values ('王伟',2005010724,'','','false','false')
delete from stu_question_choose
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第一个选择题','选择题的A项','选择题的B项','选择题的C项','选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第二个选择题','二选择题的A项','二选择题的B项','二选择题的C项','二选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第三个选择题','三选择题的A项','三选择题的B项','选三择题的C项','三选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第四个选择题','四选择题的A项','四选择题的B项','四选择题的C项','四选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第五个选择题','五选择题的A项','五选择题的B项','五选择题的C项','五选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第六个选择题','六选择题的A项','六选择题的B项','六选择题的C项','六选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第七个选择题','七选择题的A项','七选择题的B项','七选择题的C项','七选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第八个选择题','八选择题的A项','八选择题的B项','八选择题的C项','八选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第九个选择题','九选择题的A项','九选择题的B项','九选择题的C项','九选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第十个选择题','十选择题的A项','十选择题的B项','十选择题的C项','十选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第十一个选择题','十一选择题的A项','十一选择题的B项','十一选择题的C项','十一选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第十二个选择题','十二选择题的A项','十二选择题的B项','十二选择题的C项','十二选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第十三个选择题','十三个选择题的A项','十三个选择题的B项','十三个选择题的C项','十三个选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第十四个选择题','十四选择题的A项','十四选择题的B项','十四选择题的C项','十四选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第十五个选择题','十五个选择题的A项','十五个选择题的B项','十五个选择题的C项','十五个选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第工上二魂牵梦萦个选择题',' 非机动车选择题的A项','我工选择题的B项','以枯个选择题的C项','十五个选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第十有以个选择题','十五个选择题的A项','十五个选择题的B项','十五个选择题的C项','十五个选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第工上个选择题','十五个选择题的A项','十五个选择题的B项','十五个选择题的C项','十五个选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第采人个选择题','中上个选择题的A项','和人个选择题的B项','发展个选择题的C项','在人个选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第sdfsdf选择题','可耕地个选择题的A项','十地选择题的B项','可耕地择题的C项','十五个选择题的D项','A')
insert into stu_question_choose (question,a,b,c,d,answer) 
values('这是第二十个选择题','二十个选择题的A项','十五个选择题的B项','十五个选择题的C项','十五个选择题的D项','A')

delete from stu_question_operation
insert into stu_question_operation (question) values('操作题目一:请新建一个文件夹,然后在里面新新一个ACCESS数据库,把数据库里建两个表')
insert into stu_question_operation (question) values('新建一张网页,要求全部用CSS+DIV部局')
insert into stu_question_operation (question) values('新建EXCEL表格,里面添加20条学生记录,和学生成绩')