课程名 上课教师 成绩 文本 文本 文本 20 5 10 否 否 否
3 学生成绩管理系统(登陆子系统)详细设计
登陆界面权限选择
protected void xueshengdenglu_Click(object sender, EventArgs e) {
(\); }
protected void jiaoshidenglu_Click(object sender, EventArgs e) {
(\); }
protected void jiaowuchudenglu_Click(object sender, EventArgs e) {
(\); }
管理员登陆界面
protected void queding1_Click(object sender, EventArgs e) { {
SqlConnection con = new
SqlConnection(\);
string sql = \ + + \ + + \;
(sql);
SqlCommand cmd = new SqlCommand(sql, con); ();
SqlDataReader set1 = (); if ()) { (\); } else {
= \; }
(); (); } }
protected void Button1_Click(object sender, EventArgs e) {
(\);}
教师登陆界面
protected void queding_Click(object sender, EventArgs e) {
SqlConnection con = new SqlConnection(
\);
string sql = \ + + \ + + \;
(sql);
database=Grad
eManage;uid=sa;pwd=123;\);
string sql = \ + + \ + + \;
(sql); //return;
SqlCommand cmd = new SqlCommand(sql, con); ();
SqlDataReader set1 = ();
if ())
{ (\); } else {
= \; }
(); (); }
protected void Button2_Click1(object sender, EventArgs e) {
(\); }
4 系统测试
管理员登陆进入