protected void btnSelect_Click(object sender, EventArgs e)
{
string cmdsql = "SELECT s.*, d.name AS dname " +
"FROM student s, department d " +
"WHERE sno='" + ddlStudent.SelectedValue + "' and s.depart=d.no;";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblOldSno.Text = myRead["sno"].ToString();
txtNewSno.Text = lblOldSno.Text;
lblOldSname.Text = myRead["sname"].ToString();
txtNewSname.Text = lblOldSname.Text;
lblOldGender.Text = myRead["gender"].ToString();
ddlNewGender.SelectedValue = lblOldGender.Text;
lblOldAge.Text = myRead["age"].ToString();
txtNewAge.Text = lblOldAge.Text;
lblOldDepart.Text = myRead["dname"].ToString();
ddlNewDepart.SelectedValue = myRead["depart"].ToString();
lblOldSpecialty.Text = myRead["specialty"].ToString();
txtNewSpecialty.Text = lblOldSpecialty.Text;
}
myRead.Close();
}
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 = "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 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)
{
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 ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
{
string cmdsql = "SELECT * FROM teacher " +
"where tno='" + ddlTeacher.SelectedValue + "';";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblOldTno.Text = myRead["tno"].ToString();
txtNewTno.Text = lblOldTno.Text;
lblOldTname.Text = myRead["tname"].ToString();
txtNewTname.Text = lblOldTname.Text;
lblOldGender.Text = myRead["gender"].ToString();
ddlNewGender.SelectedValue = lblOldGender.Text;
lblOldAge.Text = myRead["age"].ToString();
txtNewAge.Text = lblOldAge.Text;
lblOldDepart.Text = myRead["depart"].ToString();
ddlNewDepart.SelectedValue = lblOldDepart.Text;
lblOldProf.Text = myRead["prof"].ToString();
txtNewProf.Text = lblOldProf.Text;
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</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 btnSelect_Click(object sender, EventArgs e)
{
string cmdsql = "SELECT t.*, d.name " +
"FROM teacher t, department d " +
"where tno='" + ddlTeacher.SelectedValue + "' and t.depart = d.no;";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblTno.Text = myRead["tno"].ToString();
lblTname.Text = myRead["tname"].ToString();
lblGender.Text = myRead["gender"].ToString();
lblAge.Text = myRead["age"].ToString();
lblDepart.Text = myRead["name"].ToString();
lblProf.Text = myRead["prof"].ToString();
}
myRead.Close();
}
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 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 Page_Load(object sender, EventArgs e)
{
if (Session["identity"] == null || Session["identity"].ToString() != "teacher")
{
Response.Redirect("../../404.aspx");
}
string cmdsql = "SELECT t.*, d.name " +
"FROM teacher t, department d " +
"where tno='" + Session["id"].ToString() + "' and t.depart = d.no;";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblTname.Text = myRead["tname"].ToString();
lblGender.Text = myRead["gender"].ToString();
lblDepart.Text = myRead["name"].ToString();
lblProf.Text = myRead["prof"].ToString();
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</script>");
}
/*lblDno.Text = ddlDepart.SelectedValue;
* txtDno.Text = lblDno.Text;
* lblDname.Text = ddlDepart.Text;
* txtDname.Text = lblDname.Text;
* lblPcno.Text = ddlPcno.Text;
* lblTno.Text = ddlTno.Text;*/
}
protected void btnSelect_Click(object sender, EventArgs e)
{
lblDno.Text = ddlDepart.SelectedValue;
txtDno.Text = lblDno.Text;
lblDean.Text = ddlDean.Text;
string cmdsql = "SELECT d.*, t.tname " +
"FROM department d, teacher t " +
"WHERE d.no='" + ddlDepart.SelectedValue + "' AND d.dean=t.tno;";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblDname.Text = myRead["name"].ToString();
txtDname.Text = lblDname.Text;
ddlDean.SelectedValue = myRead["dean"].ToString();
lblDean.Text = myRead["tname"].ToString();
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</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 = "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 btnSelect_Click(object sender, EventArgs e)
{
string cmdsql = "SELECT c1.*, c2.cname AS pcname, t.tname " +
"FROM course c1 LEFT JOIN course c2 ON c1.pcno=c2.cno , teacher t " +
"WHERE t.tno=c1.tno and c1.cno='" + ddlCourse.SelectedValue + "';";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblCname.Text = myRead["cname"].ToString();
if (myRead["pcno"].ToString() != " ")
{
lblPcno.Text = myRead["pcname"].ToString();
}
else
{
lblPcno.Text = "无";
}
lblTno.Text = myRead["tname"].ToString();
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</script>");
}
}
protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
{
lblCno.Text = ddlCourse.SelectedValue;
txtCno.Text = lblCno.Text;
lblCname.Text = ddlCourse.Text;
txtCname.Text = lblCname.Text;
lblPcno.Text = ddlPcno.Text;
lblTno.Text = ddlTno.Text;
string cmdsql = "SELECT * " +
"FROM course " +
"WHERE cno='" + ddlCourse.SelectedValue + "';";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblCname.Text = myRead["cname"].ToString();
txtCname.Text = lblCname.Text;
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</script>");
}
}
protected void btnSelect_Click(object sender, EventArgs e)
{
string cmdsql = "SELECT t.*, d.name AS dname " +
"FROM teacher t, department d " +
"WHERE t.depart=d.no AND tno='" + ddlTeacher.SelectedValue + "';";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblOldTno.Text = myRead["tno"].ToString();
txtNewTno.Text = lblOldTno.Text;
lblOldTname.Text = myRead["tname"].ToString();
txtNewTname.Text = lblOldTname.Text;
lblOldGender.Text = myRead["gender"].ToString();
ddlNewGender.SelectedValue = lblOldGender.Text;
lblOldAge.Text = myRead["age"].ToString();
txtNewAge.Text = lblOldAge.Text;
lblOldDepart.Text = myRead["dname"].ToString();
ddlNewDepart.SelectedValue = myRead["depart"].ToString();
lblOldProf.Text = myRead["prof"].ToString();
txtNewProf.Text = lblOldProf.Text;
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</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)
{
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 btnSelect_Click(object sender, EventArgs e)
{
string cmdsql = "SELECT s.*, d.name " +
"FROM student s, department d " +
"WHERE sno='" + Session["id"].ToString() + "' and s.depart=d.no;";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblSno.Text = myRead["sno"].ToString();
lblSname.Text = myRead["sname"].ToString();
lblGender.Text = myRead["gender"].ToString();
lblAge.Text = myRead["age"].ToString();
lblDepart.Text = myRead["name"].ToString();
lblSpecialst.Text = myRead["specialty"].ToString();
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</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>");
}
}
}
public void TestMethod()
{
MyXml mx = new MyXml();
OperateDataBase op = new OperateDataBase();
string path = "F:\\visual-stdio-2019\\asp_core_web_4\\练习\\TestXml\\TestXml\\ArticlesData\\world2.xml";
mx.GetNewItems(path);
//op.ExceRead(mx.GetNewItems(path));
}
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 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 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 btnSelect_Click(object sender, EventArgs e)
{
string cmdsql = "SELECT grade FROM score " +
"WHERE sno='" + ddlStudent.SelectedValue + "' and cno='" + ddlCourse.SelectedValue + "';";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblGrade.Text = myRead["grade"].ToString();
}
myRead.Close();
}
else
{
Response.Write("<script>alert(\"查询失败\")</script>");
}
}
protected void ddlDepart_SelectedIndexChanged(object sender, EventArgs e)
{
lblDname.Text = ddlDepart.Text;
string cmdsql = "SELECT * " +
"FROM department " +
"WHERE no='" + ddlDepart.SelectedValue + "';";
OperateDataBase odb = new OperateDataBase();
SqlDataReader myRead = odb.ExceRead(cmdsql);
if (myRead.HasRows)
{
while (myRead.Read())
{
lblDname.Text = myRead["name"].ToString();
}
myRead.Close();
}
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>");
}
}
}
