《在線考試系統(tǒng)代碼》PPT課件.ppt

《《在線考試系統(tǒng)代碼》PPT課件.ppt》由會(huì)員分享，可在線閱讀，更多相關(guān)《《在線考試系統(tǒng)代碼》PPT課件.ppt（10頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

一個(gè)在線考試系統(tǒng)的代碼設(shè)計(jì),www.kasong-，，，，www.youlvjing-，，，，，，，，www.a-，www.a-，,（1）登陸頁(yè)面,,,protectedvoidbtnlogin_Click(objectsender,EventArgse){if(txtCode.Text.Trim()!=Session["verify"].ToString()){Response.Write("alert(驗(yàn)證碼錯(cuò)誤);location=Login.aspx");}else{if(this.ddlstatus.SelectedValue=="學(xué)生"){if(BaseClass.CheckStudent(txtNum.Text.Trim(),txtPwd.Text.Trim())){Session["ID"]=txtNum.Text.Trim();Response.Redirect("student/studentexam.aspx");}else{Response.Write("alert(您不是學(xué)生或者用戶名和密碼錯(cuò)誤);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(您不是教師或者用戶名和密碼錯(cuò)誤);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(您不是管理員或者用戶名和密碼錯(cuò)誤);location=Login.aspx");}}}}protectedvoidbtnconcel_Click(objectsender,EventArgse){RegisterStartupScript("提示","window.close();");},,,,（2）添加信息學(xué)生代碼,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("請(qǐng)將信息填寫完整");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("此學(xué)號(hào)已經(jīng)存在");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("請(qǐng)將信息填寫完整");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）修改學(xué)生信息,（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("請(qǐng)將信息填寫完整");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）數(shù)據(jù)庫(kù)連接代碼,addname="connstring"connectionString="DataSource=.;initialcatalog=Exam;UserID=sa;Password=123456",www.kasong-，，，，www.youlvjing-，，，，，，，，www.a-，www.a-，,ThankYou!,