ASP.NET调试在线考试系统的实现-报告.doc

ASP.NET调试在线考试系统的实现-报告ASP.NET调试在线考试系统的实现|上机实验实习报告|计算机上机实习报告|习题10-6需求一和需求二任选一一 实验目的：。二、实验要求：1：自学第十章2：调试在线考试系统的实现3：改进该系统，既习题10-6需求一和需求二任选一，画流程图、编程、调试、运行结果截图三、实验步骤：程序设计：流程图：void Page_Load(Object Src, EventArgs E) string No = ; string Name = ; string Lesson = ; string Msg = ; if (IsPostBack) /页面被提交的时候执行 No = RequesttxtNo; Name = RequesttxtName; Lesson = RequestLesson; string SQL = Select * From 成绩单 ; SQL = SQL + Where 学号= + + No + + And 姓名= + Name + ; OleDbConnection Conn; Conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;+ Data Source=+Server.MapPath(test.mdb); Conn.Open(); /Response.Write(SQL); OleDbCommand Comm=new OleDbCommand(SQL,Conn); OleDbDataReader dr=Comm.ExecuteReader(); if (dr.Read() if (drLesson.ToString() != -1) Msg = 你已经考过本科目了!; else Conn.Close(); Response.Redirect(TEST.ASPX?Lesson=+Lesson+&Name=+Name+&No=+No); else Msg = 你不是合法考生!; Message.Text = Msg; Conn.Close(); 在线考试系统 ASP XML 姓名： 学号： string Lesson;string No;string Name;OleDbDataReader dr;void Page_Load(Object Src, EventArgs E) Lesson = RequestLesson; No = RequestNo; Name = RequestName; string SQL = Select * From + Lesson + Order By 题号; OleDbConnection Conn; Conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;+ Data Source=+Server.MapPath(test.mdb); Conn.Open(); /Response.Write(SQL); OleDbCommand Comm = new OleDbCommand(SQL,Conn); dr = Comm.ExecuteReader(); 在线考试系统 考试科目 - INPUT Type=Hidden Name=Lesson Value= INPUT Type=Hidden Name=No Value= INPUT Type=Hidden Name=Name Value=%string TestType = ;while (dr.Read() Response.Write( + dr题号.ToString() + . + Server.HtmlEncode(dr题目.ToString() + dr类型.ToString() + : + dr分数.ToString() + 分); Response.Write(); for (int i=1; i5; i+) if (dr类型.ToString() = 单选) TestType = Radio; else TestType = CheckBox; Response.Write( + Server.HtmlEncode(dr选项 + i.ToString() + ); Response.Write();% string Lesson;string No;string Name;OleDbDataReader dr;string SQL;OleDbConnection Conn;OleDbCommand Comm;void Page_Load(Object Src, EventArgs E) Lesson = RequestLesson; No = RequestNo; Name = RequestName; Conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;+ Data Source=+Server.MapPath(test.mdb); Conn.Open(); SQL = Select * from + Lesson; /Response.Write(SQL); Comm = new OleDbCommand(SQL,Conn); dr = Comm.ExecuteReader();/如果60分，显示为红色string TestResult(string inputScore) int Score = Convert.ToInt32(inputScore); if (-1 = Score) return 你还没有考试; else if(Score 60) return + Score + ; else return Score.ToString(); 成绩单% int Score = 0; while (dr.Read() if (RequestNo + dr题号.ToString() != null) string Sel = RequestNo + dr题号.ToString(); string Ans = dr解答.ToString(); /Response.Write(Sel + Ans + ); if (Ans = Sel) Score = Score + Convert.ToInt32(dr分数.ToString(); /Response.Write( OK + Score); /重新建立DataReader对象，需要重新打开Connection对象 Conn.Close(); Conn.Open(); SQL = Select * From 成绩单 ; SQL = SQL + Where 学号= + + No + + And 姓名= + Name + ; Comm = new OleDbCommand(SQL,Conn); OleDbDataReader drScore = Comm.ExecuteReader(); if(drScore.Read() if (drScoreLesson.ToString() = -1) SQL = update 成绩单 set + Lesson + = + Score.ToString() + where 学号= + + No + + And 姓名= + Name + ; Conn.Close(); Conn.Open(); Comm = new OleDbComm