《在线考试系统代码》PPT课件.ppt

《《在线考试系统代码》PPT课件.ppt》由会员分享，可在线阅读，更多相关《《在线考试系统代码》PPT课件.ppt（10页珍藏版）》请在装配图网上搜索。

一个在线考试系统的代码设计,www.kasong-，，，，www.youlvjing-，，，，，，，，www.a-，www.a-，,（1）登陆页面,,,protectedvoidbtnlogin_Click(objectsender,EventArgse){if(txtCode.Text.Trim()!=Session["verify"].ToString()){Response.Write("alert(验证码错误);location=Login.aspx");}else{if(this.ddlstatus.SelectedValue=="学生"){if(BaseClass.CheckStudent(txtNum.Text.Trim(),txtPwd.Text.Trim())){Session["ID"]=txtNum.Text.Trim();Response.Redirect("student/studentexam.aspx");}else{Response.Write("alert(您不是学生或者用户名和密码错误);location=Login.aspx");}}if(this.ddlstatus.SelectedValue=="教师"){if(BaseClass.CheckTeacher(txtNum.Text.Trim(),txtPwd.Text.Trim())){Session["teacher"]=txtNum.Text;Response.Redirect("teacher/TeacherManage.aspx");}else{Response.Write("alert(您不是教师或者用户名和密码错误);location=Login.aspx");}}if(this.ddlstatus.SelectedValue=="管理员"){if(BaseClass.CheckAdmin(txtNum.Text.Trim(),txtPwd.Text.Trim())){Session["admin"]=txtNum.Text;Response.Redirect("admin/AdminManage.aspx");}else{Response.Write("alert(您不是管理员或者用户名和密码错误);location=Login.aspx");}}}}protectedvoidbtnconcel_Click(objectsender,EventArgse){RegisterStartupScript("提示","window.close();");},,,,（2）添加信息学生代码,protectedvoidPage_Load(objectsender,EventArgse){if(Session["admin"]==null){Response.Redirect("../Login.aspx");}}protectedvoidbtnSubmit_Click(objectsender,EventArgse){if(txtName.Text==""||txtNum.Text==""||txtPwd.Text==""){MessageBox.Show("请将信息填写完整");return;}else{SqlConnectionconn=BaseClass.DBCon();conn.Open();SqlCommandcmd=newSqlCommand("selectcount(*)fromtb_StudentwhereStudentNum="+txtNum.Text+"",conn);inti=Convert.ToInt32(cmd.ExecuteScalar());if(i>0){MessageBox.Show("此学号已经存在");return;}else{cmd=newSqlCommand("insertintotb_Student(StudentNum,StudentName,StudentSex,StudentPwd)values("+txtNum.Text.Trim()+","+txtName.Text.Trim()+","+rblSex.SelectedValue.ToString()+","+txtPwd.Text.Trim()+")",conn);cmd.ExecuteNonQuery();conn.Close();MessageBox.Show("添加成功");btnConcel_Click(sender,e);}}}protectedvoidbtnConcel_Click(objectsender,EventArgse){txtName.Text="";txtNum.Text="";txtPwd.Text="";},,publicpartialclassadmin_ChangeStudentInfo:System.Web.UI.Page{privatestaticintid;protectedvoidPage_Load(objectsender,EventArgse){if(Session["admin"]==null){Response.Redirect("../Login.aspx");}if(!IsPostBack){id=Convert.ToInt32(Request.QueryString["stuid"]);SqlConnectionconn=BaseClass.DBCon();conn.Open();SqlCommandcmd=newSqlCommand("select*fromtb_StudentwhereID="+id,conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();txtStuName.Text=sdr["StudentName"].ToString();txtStuNum.Text=sdr["StudentNum"].ToString();txtStuPwd.Text=sdr["StudentPwd"].ToString();rblSex.SelectedValue=sdr["StudentSex"].ToString();sdr.Close();conn.Close();}}protectedvoidbtnSava_Click(objectsender,EventArgse){if(txtStuName.Text.Trim()==""||txtStuPwd.Text.Trim()==""){MessageBox.Show("请将信息填写完整");return;}else{stringstr="updatetb_StudentsetStudentName="+txtStuName.Text.Trim()+",StudentPwd="+txtStuPwd.Text.Trim()+",StudentSex="+rblSex.SelectedItem.Text+"whereID="+id;BaseClass.OperateData(str);Response.Redirect("StudentInfo.aspx");}}protectedvoidbtnConcel_Click(objectsender,EventArgse){Response.Redirect("StudentInfo.aspx");}},（3）修改学生信息,（4）添加试题,,,添加试题信息代码如下：protectedvoidPage_Load(objectsender,EventArgse){if(Session["admin"]==null){Response.Redirect("../Login.aspx");}if(!IsPostBack){SqlConnectionconn=BaseClass.DBCon();conn.Open();SqlCommandcmd=newSqlCommand("select*fromtb_Lesson",conn);SqlDataReadersdr=cmd.ExecuteReader();this.ddlkm.DataSource=sdr;this.ddlkm.DataTextField="LessonName";this.ddlkm.DataValueField="ID";this.ddlkm.DataBind();this.ddlkm.SelectedIndex=0;conn.Close();}}protectedvoidbtnconfirm_Click(objectsender,EventArgse){if(txtsubject.Text==""||txtAnsA.Text==""||txtAnsB.Text==""||txtAnsC.Text==""||txtAnsD.Text==""){MessageBox.Show("请将信息填写完整");return;}else{stringisfb="";if(cbFB.Checked==true)isfb="1";elseisfb="0";stringstr="insertintotb_test(testContent,testAns1,testAns2,testAns3,testAns4,rightAns,pub,testCourse)values("+txtsubject.Text.Trim()+","+txtAnsA.Text.Trim()+","+txtAnsB.Text.Trim()+","+txtAnsC.Text.Trim()+","+txtAnsD.Text.Trim()+","+rblRightAns.SelectedValue.ToString()+","+isfb+","+ddlkm.SelectedItem.Text+")";BaseClass.OperateData(str);btnconcel_Click(sender,e);}}protectedvoidbtnconcel_Click(objectsender,EventArgse){txtsubject.Text="";txtAnsD.Text="";txtAnsC.Text="";txtAnsB.Text="";txtAnsA.Text="";},,,（4）数据库连接代码,addname="connstring"connectionString="DataSource=.;initialcatalog=Exam;UserID=sa;Password=123456",www.kasong-，，，，www.youlvjing-，，，，，，，，www.a-，www.a-，,ThankYou!,