资源描述
一个在线考试系统的代码设计,www.kasong-，www.youlvjing-，www.a-，www.a-，,（1）登陆页面,protectedvoidbtnlogin_Click(objectsender,EventArgse)if(txtCode.Text.Trim()!=Sessionverify.ToString()Response.Write(alert(验证码错误);location=Login.aspx);elseif(this.ddlstatus.SelectedValue=学生)if(BaseClass.CheckStudent(txtNum.Text.Trim(),txtPwd.Text.Trim()SessionID=txtNum.Text.Trim();Response.Redirect(student/studentexam.aspx);elseResponse.Write(alert(您不是学生或者用户名和密码错误);location=Login.aspx);if(this.ddlstatus.SelectedValue=教师)if(BaseClass.CheckTeacher(txtNum.Text.Trim(),txtPwd.Text.Trim()Sessionteacher=txtNum.Text;Response.Redirect(teacher/TeacherManage.aspx);elseResponse.Write(alert(您不是教师或者用户名和密码错误);location=Login.aspx);if(this.ddlstatus.SelectedValue=管理员)if(BaseClass.CheckAdmin(txtNum.Text.Trim(),txtPwd.Text.Trim()Sessionadmin=txtNum.Text;Response.Redirect(admin/AdminManage.aspx);elseResponse.Write(alert(您不是管理员或者用户名和密码错误);location=Login.aspx);protectedvoidbtnconcel_Click(objectsender,EventArgse)RegisterStartupScript(提示,window.close(););,（2）添加信息学生代码,protectedvoidPage_Load(objectsender,EventArgse)if(Sessionadmin=null)Response.Redirect(./Login.aspx);protectedvoidbtnSubmit_Click(objectsender,EventArgse)if(txtName.Text=|txtNum.Text=|txtPwd.Text=)MessageBox.Show(请将信息填写完整);return;elseSqlConnectionconn=BaseClass.DBCon();conn.Open();SqlCommandcmd=newSqlCommand(selectcount(*)fromtb_StudentwhereStudentNum=+txtNum.Text+,conn);inti=Convert.ToInt32(cmd.ExecuteScalar();if(i0)MessageBox.Show(此学号已经存在);return;elsecmd=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.Pageprivatestaticintid;protectedvoidPage_Load(objectsender,EventArgse)if(Sessionadmin=null)Response.Redirect(./Login.aspx);if(!IsPostBack)id=Convert.ToInt32(Request.QueryStringstuid);SqlConnectionconn=BaseClass.DBCon();conn.Open();SqlCommandcmd=newSqlCommand(select*fromtb_StudentwhereID=+id,conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();txtStuName.Text=sdrStudentName.ToString();txtStuNum.Text=sdrStudentNum.ToString();txtStuPwd.Text=sdrStudentPwd.ToString();rblSex.SelectedValue=sdrStudentSex.ToString();sdr.Close();conn.Close();protectedvoidbtnSava_Click(objectsender,EventArgse)if(txtStuName.Text.Trim()=|txtStuPwd.Text.Trim()=)MessageBox.Show(请将信息填写完整);return;elsestringstr=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(Sessionadmin=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;elsestringisfb=;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=connstringconnectionString=DataSource=.;initialcatalog=Exam;UserID=sa;Password=123456,www.kasong-，www.youlvjing-，www.a-，www.a-，,ThankYou!,
展开阅读全文