在线考试系统

--定义存储过程由考生ID和科目ID存储本次考生登录信息并返回登录ID create procedure Pr_AddLogin( @ExamineeID int,@SubjectID int,@LoginID int output) as insert into Login( ExamineeID,SubjectID,StartDate,EndDate ) values( @ExamineeID,@SubjectID,GETDATE(), dateadd(hour,2,getdate())) select @LoginID=ID from Login where ExamineeID=@ExamineeID and SubjectID=@SubjectID go --测试数据 --向考生表插入数据 insert into Examinee( Username,Password,Email,Role) values( 'admin','admin','admin@163.com',1 ) insert into Examinee( Username,Password,Email,Role) values( 'tom','tom','tom@163.com',0 ) insert into Examinee( Username,Password,Email,Role) values( 'sky','sky','sky@163.com',0 ) insert into Examinee( Username,Password,Email,Role) values( 'luck','luck','luck@163.com',0 ) go --插入考试科目 insert into Subject(Name)values( '计算机') insert into Subject(Name)values( '政治') insert into Subject(Name)values( '英语') go --插入考题 insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( 'ASP.NET是哪一个公司的产品？','MicroSoft' ,'IBM','SUN','ORACAL','A',10,1) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '以下控件并不是ASP.NET控件的是','DateGridView' ,'TextBox','GridView','Label','A',10,1) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '以下对象不是ASP.NET对象的是','Response' ,'Request','Session','State','D',10,1) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '.NET可以看成？','一个网站' ,'一个平台','一种语言','一种工具','B',10,1) go insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '唯物历史观认为，人类的第一个历史活动是','吃喝穿住' ,'物质生活资料的生产','人的自觉意识活动','结成社会关系','B',10,2) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '新民主主义革命的中心内容是','没收封建官僚垄断资本归新民主主义国家所有' ,'没收封建地主阶级的土地归新民主主义国家所有','没收封建地主阶级的土地归民所有','保护民族工商业','C',10,2) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '贯彻三个代表的重要思想，关键在','坚持党的先进性' ,'坚持执政为民','坚持党的阶级性','坚持与时俱进','D',10,2) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '2003年9月通过全民公决否决了加入欧元区议案的欧盟国家是','瑞典' ,'丹麦','英国','希腊','A',10,2) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '现代企业制度的典型形式是','股份制' ,'股份合作制','合伙制','公司制','D',10,2) go insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '“Thank you very much.”“ ____”','That’s right.' ,'Thank you.','Oh，yes，all right ','That’s all right.','D',10,3) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( 'David goes to school_____every day.','by a bike' ,'by his bike','on his bike','on bike','D',10,3) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( 'How many____are there in your school?','woman teacher' ,'women teacher','woman teachers','women teachers','B',10,3) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( 'There’s______“u” in the word “use”','a ' ,'an','the','X','A',10,3) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( '“_____your brother’s number?” “4”','What’s' ,'How many ','How ','How old','C',10,3) insert into Question(Name,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Score,SubjectID)values( 'That’s _____bus.','English' ,'his','Japanese','he','B',10,3) go