protected void btnSubmit_Click(object sender, EventArgs e) { string no = txtDno.Text; string name = txtDname.Text; string dean = ddlDean.SelectedValue; if (no.Length != 3 || name.Length > 20 || dean.Length != 4) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "UPDATE department SET no = '" + txtDno.Text + "', name = '" + txtDname.Text + "', dean = '" + ddlDean.SelectedValue + "' WHERE no = '" + ddlDepart.SelectedValue + "'; "; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"部门" + name + "添加成功\");</script>"); Response.Redirect(".\\AltDepart.aspx"); } else { Response.Write("<sCrIpT>alert(\"部门" + name + "添加失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string sno = txtSno.Text; string sname = txtSname.Text; string gender = ddlGender.SelectedValue; int age = Convert.ToInt32(txtAge.Text); string depart = ddlDepart.SelectedValue; string specialty = txtSpecialty.Text; if (sno.Length != 10 || sname.Length > 20 || (gender != "男" && gender != "女") || age < 0 || age > 150 || depart.Length != 3 || specialty.Length > 50) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "INSERT INTO student(sno, sname, gender, age, depart, specialty, spwd) " + "VALUES('" + sno + "', '" + sname + "', '" + gender + "', " + age + ", '" + depart + "', '" + specialty + "', '" + sno + "');"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"学生" + sname + "添加成功\");</script>"); } else { Response.Write("<sCrIpT>alert(\"学生" + sname + "添加失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string no = txtDno.Text; string name = txtDname.Text; string dean = ddlDean.SelectedValue; if (no.Length != 3 || name.Length > 20 || dean.Length != 4) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "INSERT INTO department(no, name, dean) " + "VALUES('" + no + "', '" + name + "', '" + dean + "'); "; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"部门" + name + "添加成功\");</script>"); } else { Response.Write("<sCrIpT>alert(\"部门" + name + "添加失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { int grade = Convert.ToInt32(txtNewGrade.Text); if (grade < 0 || grade > 100) { Response.Write("<script>alert('请输入正确的成绩');</script>"); } else { string sqlCom = "UPDATE score " + "SET grade=" + txtNewGrade.Text + " " + "WHERE sno='" + ddlStudent.SelectedValue + "' and cno='" + ddlCourse.SelectedValue + "';"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的成绩修改成功\");</script>"); //Response.Redirect(".\\AltScore.aspx"); } else { Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的成绩修改失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string id = txtId.Text; string pwd = txtPwd.Text; if (id.Length > 20 || pwd.Length > 20) { Response.Write("<script>alert('账号和密码长度不能超过20字符');</script>"); } else { string sqlCom = "UPDATE admin " + "SET adminID='" + id + "', adminPwd='" + pwd + "' WHERE adminID='" + ddlAdmin.SelectedValue + "';"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"管理员" + ddlAdmin.SelectedValue + "的信息修改成功\");</script>"); Response.Redirect(".\\AltAdmin.aspx"); } else { Response.Write("<sCrIpT>alert(\"管理员" + ddlAdmin.SelectedValue + "的信息修改失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string cno = txtCno.Text; string cname = txtCname.Text; string pcno = ddlPcno.SelectedValue; string tno = ddlTno.SelectedValue; if (cno.Length != 8 || cname.Length > 20 || pcno.Length != 8 || tno.Length != 4) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "UPDATE course SET cno = '" + txtCno.Text + "', cname = '" + txtCname.Text + "', pcno = '" + ddlPcno.SelectedValue + "', tno = '" + ddlTno.SelectedValue + "' WHERE cno = '" + ddlCourse.SelectedValue + "'; "; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(/课程" + cname + "添加成功/);</script>"); Response.Redirect(".\\AltCourses.aspx"); } else { Response.Write("<sCrIpT>alert(/课程" + cname + "添加失败/);</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string tno = txtNewTno.Text; string tname = txtNewTname.Text; string gender = ddlNewGender.SelectedValue; int age = Convert.ToInt32(txtNewAge.Text); string depart = ddlNewDepart.SelectedValue; string prof = txtNewProf.Text; if (tno.Length != 4 || tname.Length > 20 || (gender != "男" && gender != "女") || age < 0 || age > 150 || depart.Length != 3 || prof.Length > 10) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "UPDATE teacher " + "SET tno='" + tno + "', tname='" + tname + "', gender='" + gender + "', age=" + age + ", prof='" + prof + "', depart='" + depart + "' WHERE tno='" + ddlTeacher.SelectedValue + "';"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"教师" + ddlTeacher.SelectedValue + "的信息修改成功\");</script>"); //Response.Redirect(".\\AltTeacher.aspx"); } else { Response.Write("<sCrIpT>alert(\"教师" + ddlTeacher.SelectedValue + "的信息修改失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string cno = txtCno.Text; string cname = txtCname.Text; string pcno = ddlPcno.SelectedValue; string tno = ddlTno.SelectedValue; if (cno.Length != 8 || cname.Length > 20 || pcno.Length != 8 || tno.Length != 4) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "INSERT INTO course(cno, cname, pcno, tno) " + "VALUES('" + cno + "', '" + cname + "', '" + pcno + "', '" + tno + "'); "; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(/课程" + cname + "添加成功/);</script>"); } else { Response.Write("<sCrIpT>alert(/课程" + cname + "添加失败/);</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string oldPwd = txtOld.Text; string newPwd = txtNew.Text; string newPwd2 = txtNew2.Text; if (oldPwd.Length > 20 || newPwd.Length > 20) { Response.Write("<script>alert('密码长度不能超过20字符');</script>"); } else if (newPwd != newPwd2) { Response.Write("<script>alert('两次输入的密码不一致');</script>"); } else { string sqlCom = "UPDATE student SET spwd='" + newPwd + "' " + "WHERE sno='" + Session["id"].ToString() + "';"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"密码修改成功\");</script>"); } else { Response.Write("<sCrIpT>alert(\"密码修改失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string cno = ddlCourse.SelectedValue; string sno = txtSno.Text; int grade = Convert.ToInt32(txtGrade.Text); if (sno.Length != 10 || grade > 100 || grade < 0) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "INSERT INTO score(sno, cno, grade) " + "VALUES('" + sno + "', '" + cno + "', " + grade + "); "; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"学生" + sno + "的成绩录入成功\");</script>"); } else { Response.Write("<sCrIpT>alert(\"学生" + sno + "的成绩录入失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string sno = txtNewSno.Text; string sname = txtNewSname.Text; string gender = ddlNewGender.SelectedValue; int age = Convert.ToInt32(txtNewAge.Text); string depart = ddlNewDepart.SelectedValue; string specialty = txtNewSpecialty.Text; if (sno.Length != 10 || sname.Length > 20 || (gender != "男" && gender != "女") || age < 0 || age > 150 || depart.Length != 3 || specialty.Length > 50) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "UPDATE student " + "SET sno='" + sno + "', sname='" + sname + "', gender='" + gender + "', age=" + age + ", depart='" + depart + "', specialty='" + specialty + "' WHERE sno='" + ddlStudent.SelectedValue + "';"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的信息修改成功\");</script>"); //Response.Redirect(".\\AltStudent.aspx"); } else { Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的信息修改失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string cno = ddlCourse.SelectedValue; string sno = Session["id"].ToString(); int grade = -1; if (sno.Length != 10) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "INSERT INTO score(sno, cno, grade) " + "VALUES('" + sno + "', '" + cno + "', " + grade + "); "; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"选课成功\");</script>"); } else { Response.Write("<sCrIpT>alert(\"选课失败\");</script>"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string tno = txtTno.Text; string tname = txtTname.Text; string gender = ddlGender.SelectedValue; int age = Convert.ToInt32(txtAge.Text); string depart = ddlDepart.SelectedValue; string prof = txtProf.Text; if (tno.Length != 4 || tname.Length > 20 || (gender != "男" && gender != "女") || age < 0 || age > 150 || depart.Length != 3 || prof.Length > 10) { Response.Write("<script>alert('请输入正确的信息');</script>"); } else { string sqlCom = "INSERT teacher(tno, tname, gender, age, prof, depart, tpwd) " + "VALUES('" + tno + "', '" + tname + "', '" + gender + "', " + age + ", '" + prof + "', '" + depart + "', '" + tno + "');"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"教师" + tname + "添加成功\");</script>"); } else { Response.Write("<sCrIpT>alert(\"教师" + tname + "添加失败\");</script>"); } } }
protected void btnDel_Click(object sender, EventArgs e) { string sqlCom = "DELETE FROM student " + "where sno='" + ddlSno.SelectedValue + "';"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"成绩记录已删除\");</script>"); } else { Response.Write("<sCrIpT>alert(\"成绩记录删除失败\");</script>"); } }
protected void btnDel_Click(object sender, EventArgs e) { string no = ddlDno.SelectedValue; string sqlCom = "DELETE FROM department " + "WHERE no = '" + no + "'; "; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"部门已删除\");</script>"); } else { Response.Write("<sCrIpT>alert(\"部门删除失败\");</script>"); } }
protected void btnDel_Click(object sender, EventArgs e) { string sqlCom = "DELETE FROM admin " + "WHERE adminID='" + ddlAdmin.SelectedValue + "';"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"管理员账号已删除\");</script>"); Response.Redirect(".\\DelAdmin.aspx"); } else { Response.Write("<sCrIpT>alert(\"管理员账号删除失败\");</script>"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string id = txtId.Text; string pwd = txtPwd.Text; if (id.Length > 20 || pwd.Length > 20) { Response.Write("<script>alert('账号或密码长度不超过20字符');</script>"); } else { string sqlCom = "INSERT admin(adminID, adminPwd) " + "VALUES('" + id + "', '" + pwd + "');"; OperateDataBase operate = new OperateDataBase(); if (operate.ExceSql(sqlCom)) { Response.Write("<sCrIpT>alert(\"管理员" + id + "添加成功\");</script>"); } else { Response.Write("<sCrIpT>alert(\"管理员" + id + "添加失败\");</script>"); } } }