在线考试系统

  • w9_514100
    了解作者
  • 63.8KB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-06-15 06:44
    上传日期
asp.net做的 毕业设计 程序源码
Examinee.rar
内容介绍
--定义存储过程由考生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
评论
    相关推荐
    • asp.net
      asp.net做的,有参考价值!适合初学者.
    • asp.net
      asp.net初学者实用小实例
    • asp.net
      hello,this is a asp.net
    • asp.net
      oksssssssssssssssssss
    • Asp.Net
      Asp.Net
    • ASP.NET
      关于ASP.NET的一些说明
    • asp.net 课件
      asp.net课件,ASP.NET项目实训_电子教案ASP.NET项目实训_电子教案ASP.NET项目实训_电子教案ASP.NET项目实训_电子教案ASP.NET项目实训_电子教案
    • DotNet_ANSA:.NET ASP.NET 安全分析器 - 多个 ASP.NET OWASP 工具的整合
      点网_ANSA .NET ASP.NET 安全分析器 - 多个 ASP.NET OWASP 工具的整合 有关更多详细信息,请参阅此帖子
    • C# .NET asp.net课件
      C# .NET asp.net课件 C# .NET asp.net课件 C# .NET asp.net课件 C# .NET asp.net课件
    • ASP.NET验证码
      ASP.NET验证码 ASP.NET验证码ASP.NET验证码 ASP.NET验证码 ASP.NET验证码 ASP.NET验证码 ASP.NET验证码 ASP.NET验证码