数据库课程设计2-学分管理系统

2——学分管理系统数据库课程设计课程名：学分管理系统姓名：XXX专业班级：XXXX年级：XXXX指导老师：XXXX设计时间：XXXXX一．课设题目：学分管理系统使用的开发工具：visualstudio2010系统,server2005,windowsxpsp3操作系统.开发语言：C#二．系统开发步骤：系统功能设计（软件结构设计）步骤:(1)系统总体功能模块图设计添添编按按查查按按按各密数代帮加加辑课班不应姓班班科码据码助，课学程级及留名级级的的库库删程生号号格级查统统平设数的除信分查查名名(计计均置据维学息数单单按不各分与转护生姓及分数修储信息名)格人数段改数人及数比及例比例系统总控模块编辑数据系统总控模块编辑数据查询数据统计数据系统维护退出将总体功能模块图中的每个模块进行逻辑过程的设计。系统封面设计：画出封面的显示图系统总控模块设计(菜单):数据库结构的设计数据库表格：Student(Sno,Sclass,Ssex,Sdept,Sname,Spsw),Course(Cno,Cname),SC(Sno,Cno,Grade),denglu(us_id,us_name,us_psw),ER图：姓名姓名性别班级专业学号学生登录密码选课课程编号课程课程名称登陆登陆名管理员编号登录密码系统的功能实现界面1>（用户角色：学生和管理员）学生登录界面 ：管理员登录界面：2>（查询各科的成绩，修改登录密码，退出系统）3>管理员模块（密码的设置与修改）修改用户密码编辑学生分数编辑分数界面各科平均分数及比例各学生的平均分数系统的代码（前台和后台）1>学生界面的母版页：<htmlxmlns=""><headid="Head1"runat="server"><title>学分管理系统[学生]</title><asp:ContentPlaceHolderID="head"runat="server"></asp:ContentPlaceHolder><styletype="text/css">.style1{}.style2{height:462px;width:812px;}.style4{width:130px;}.style5{width:988px;height:133px;}#body{background-color:White;border-bottom:0;width:990px;height:135px;}</style></head><bodystyle="background-color:Gray;"><div><formid="form1"runat="server"><table align="center"id="body"><trstyle="background-color:white"><tdclass="style5"style="background-attachment:scroll;background-image:url(../image/banner.png);background-repeat:no-repeat;width:990"colspan="2"></td></tr><tr><tdclass="style4"valign="top"bgcolor="#CCCCFF"style="border-style:none;background-color:#CCCCFF;"><asp:TreeViewID="TreeView1"runat="server"Height="465px"Width="175px"Font-Size="12pt"ForeColor="Black"Style="background-color:#CCCCFF"BackColor="#CCCCFF"><SelectedNodeStyleFont-Size="80pt"/><LeafNodeStyleFont-Size="12pt"ForeColor="Black"/><Nodes><asp:TreeNodeExpanded="True"SelectAction="Expand"Text="个人主页"Value="个人主页"Checked="True"><asp:TreeNodeText="个人信息"Value="个人信息"NavigateUrl="~/student/student_info.aspx"></asp:TreeNode><asp:TreeNodeExpanded="True"SelectAction="Expand"Text="修改密码"Value="修改密码"NavigateUrl="~/student/change_pswd.aspx"></asp:TreeNode><asp:TreeNodeExpanded="True"SelectAction="Expand"Text="退出系统"Value="退出系统"Checked="True"NavigateUrl="Default.aspx"></asp:TreeNode></asp:TreeNode><asp:TreeNodeExpanded="True"SelectAction="Expand"Text="我的事务"Value="我的事务"Checked="True"><asp:TreeNodeText="查询成绩"Value="查询成绩"NavigateUrl="~/student/see_grade.aspx"></asp:TreeNode><asp:TreeNodeText="所有课程"Value="所有课程"NavigateUrl="~/student/see_course.aspx"></asp:TreeNode></asp:TreeNode></Nodes></asp:TreeView></td><tdclass="style2"valign="top"><asp:ContentPlaceHolderID="ContentPlaceHolder1"runat="server"><divstyle="font-style:normal;font-variant:normal;text-transform:lowercase;#0066FF;">

font-weight:normal;font-size:smaller;color: </div></asp:ContentPlaceHolder></td></tr><tr><tdstyle="height:21px;background-color:#CCCCFF;"align="center"colspan="2">©张友爱0计算机科学与技术2班2011年9月16日</td></tr></table></form></div></body></html>2>管理员界面的母版页：<htmlxmlns=""><headid="Head1"runat="server"><title>学分管理系统[管理员]</title><asp:ContentPlaceHolderID="head"runat="server"></asp:ContentPlaceHolder><styletype="text/css">.style1{}.style2{height:462px;width:812px;}.style4{width:130px;}.style5{width:988px;height:133px;}#body{</style></head>

background-color:White;border-bottom:0;width:990px;height:135px;}<bodystyle="background-color:Gray;"><div><formid="form1"runat="server"><table align="center"id="body"><trstyle="background-color:white"><td class="style5" style="background-attachment: background-image:url(../image/banner.png);background-repeat:no-repeat;width:990"colspan="2"></td></tr><tr><td class="style4" valign="top" style="border-style:none;background-color:#CCCCFF;"><asp:TreeViewID="TreeView1"runat="server"Height="465px"Width="175px"Font-Size="12pt"ForeColor="Black"Style="background-color: BackColor="#CCCCFF"><SelectedNodeStyleFont-Size="80pt"/><LeafNodeStyleFont-Size="12pt"ForeColor="Black"/><Nodes><asp:TreeNode SelectAction="Expand"个人主页个人主页"Checked="True"><asp:TreeNode SelectAction="Expand"Text=""Value=""NavigateUrl="~/admin/change_pswd.aspx"></asp:TreeNode><asp:TreeNode SelectAction="Expand"Text=""Value=""NavigateUrl="~/admin/createpsw.aspx"></asp:TreeNode><asp:TreeNode SelectAction="Expand"退出系统退出系统"Checked="True"NavigateUrl="Default.aspx"></asp:TreeNode></asp:TreeNode><asp:TreeNode SelectAction="Expand"编辑数据编辑数据"Checked="True"><asp:TreeNodeText="添加学生信息"Value="添

NavigateUrl="~/admin/add_student.aspx"></asp:TreeNode><asp:TreeNodeText="删除学生信息"Value="删NavigateUrl="~/admin/deletestudent.aspx"></asp:TreeNode><asp:TreeNodeText="添加课程信息"Value="添NavigateUrl="~/admin/add_course.aspx"></asp:TreeNode><asp:TreeNodeText="编辑学生分数"Value="编NavigateUrl="~/admin/changescore.aspx"></asp:TreeNode></asp:TreeNode><asp:TreeNode Expanded="True"SelectAction="Expand"Text="查询数据"Value="查询数据"Checked="True"><asp:TreeNodeText="按课程查询"Value="按课""

NavigateUrl="~/admin/check_by_Cno.aspx"></asp:TreeNode><asp:TreeNodeText="按班级查询"Value="按班NavigateUrl="~/admin/check_by_Sclass.aspx"></asp:TreeNode><asp:TreeNodeText="不及格名单"Value="不及格名单"NavigateUrl="~/admin/nopass_students.aspx"></asp:TreeNode><asp:TreeNodeText="应留级名单"Value="应留级名单"

NavigateUrl="~/admin/down_grade.aspx"></asp:TreeNode><asp:TreeNodeText="按姓名查询"Value="按姓名查询"NavigateUrl="~/admin/check_by_Sname.aspx"></asp:TreeNode></asp:TreeNode><asp:TreeNode SelectAction="Expand"统计数据统计数据"Checked="True"><asp:TreeNodeText="各分数段人数"Value="各分数段人数"NavigateUrl="~/admin/numbers_of_everyGrade.aspx"></asp:TreeNode><asp:TreeNodeText="各科平均分数"Value="各科平均分数"NavigateUrl="~/admin/course_average.aspx"></asp:TreeNode><asp:TreeNodeText="各班不及格情况"Value="

NavigateUrl="~/admin/nopass_class.aspx"></asp:TreeNode><asp:TreeNodeText="学生的平均成绩"Value="NavigateUrl="~/admin/student_avag.aspx"></asp:TreeNode></asp:TreeNode></Nodes></asp:TreeView></td><tdclass="style2"valign="top"><asp:ContentPlaceHolder ID="ContentPlaceHolder1"runat="server"><div style="font-style: normal; font-variant: normal;text-transform:lowercase;#0066FF;">

font-weight: normal; font-size: smaller;  </div></asp:ContentPlaceHolder></td></tr><tr>colspan="2">

<tdstyle="height:21px;background-color:#CCCCFF;"align="center"©张友爱0计算机科学与技术2班2011年9月16日</td></tr></table></form></div></body></html>3>登录界面的关键代码：publicpartialclass_Default:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse)//登录按钮触发的事件{stringtype=userType.SelectedValue.ToString();stringuser=userName.Text;stringpassword=FormsAuthentication.HashPasswordForStoringInConfig,"MD5");

stringsel=switch(type){case"1":sel="selectSnofromstudentwhereSname='"user+"'andSpswd='"+password+"'";break;case"2":sel="selectus_idfromdengluwhereus_name='"user+"'andus_psw='"+password+"'";break;}objectbody=dbConnection.MyExecuteScalar(sel);if(body==null){Page.ClientScript.RegisterStartupScript(this.GetType(), "","<script>alert('用户名或密码错误！');location.href='Default.aspx'</script>");}else{Session["userID"]=body.ToString();switch(type){case"1":Response.Redirect("student/student_index.aspx");break;case"2":Response.Redirect("admin/admin_index.aspx");break;}}}protectedvoidButton2_Click(objectsender,EventArgse)//重置按钮触发的事件{userName.Text=pwd.Text="";}}4>学生修改个人密码的后台代码：protectedvoidtijiao_Click(objectsender,EventArgse)//提交按钮触发的事件{string pwd = FormsAuthentication.HashPasswordForStoringInConfig,"md5");/////修改密码if(txtnewpwd2.Text.Trim()==txtnewpwd.Text.Trim()){string newpwd FormsAuthentication.HashPasswordForStoringInConfig,"md5");stringsele="selectcount(Sno)fromStudentwhereSno="+Convert.ToInt32(Session["userID"].ToString())+"andSpswd='"+pwd+"'";int num =Convert.ToInt32(dbConnection.MyExecuteScalar(sele).ToString());if(num>0){stringchang="updateStudentsetSpswd='"+newpwd+"' where Sno=" Convert.ToInt32(Session["userID"].ToString());if(dbConnection.insert(chang))Response.Write("<script>alert('密码修改成功！');</script>");');</script>");

}else{

else

Response.Write("<script>alert('密码修改失败！');</script>");}}else{

Response.Write("<script>alert('原始密码不正确，请重新输入！');</script>");}

Response.Write("<script>alert('两次密码不匹配，请重新输入！}protectedvoidbtcancel_Click(objectsender,EventArgse)//取消修改{txtoldpwd.Text="";txtnewpwd.Text="";txtnewpwd2.Text=}}5>学生查看个人信息的后台代码：publicpartialclassstudent_student_info:System.Web.UI.Page{if(!IsPostBack){studentstu=newstudent();DataTabledt=newdt=CreateAdapter.getAdapter("selectSno,Sclass,Sdept,Ssex,SnamefromStudentwhereSno="+Convert.ToInt32(Session["userID"].ToString()));stu.setSclass(dt.Rows[0][1].ToString());stu.setSdept(dt.Rows[0][2].ToString());stu.setSname(dt.Rows[0][4].ToString());stu.setSno(dt.Rows[0][0].ToString());stu.setSsex(dt.Rows[0][3].ToString());Session.Add("stu",stu);Sno.Text=stu.getSno();Sclass.Text=stu.getSclass();Ssex.Text=stu.getSsex();Sname.Text=stu.getSname();dept.Text=stu.getSdept();}}}6>学生查看课程的后台代码：protectedvoidPage_Load(objectsender,EventArgse){stringsql="selectCname,Course.CnofromStudent,Course,SCStudent.Sno=SC.SnoandCourse.Cno=SC.CnoandStudent.Sno="Convert.ToInt32(Session["userID"].ToString());DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_course.DataSource=dt;grid_course.DataBind();}7>学生查看分数的后台代码：protectedvoidPage_Load(objectsender,EventArgse){stringsql="selectCname,GradefromStudent,Course,SCStudent.Sno=SC.Sno and Course.Cno=SC.Cno Student.Sno="+Convert.ToInt32(Session["userID"].ToString());DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_Sname.DataSource=dt;grid_Sname.DataBind();}8>管理员添加学生课程：protectedvoidsubmit_Click(objectsender,EventArgs提交按钮触发的事件{stringsql="insertintoCourse(Cno,Cname)"+"values(@Cno,@Cname)";List<SqlParameter>parmeters=newList<SqlParameter>();parmeters.Add(newSqlParameter("@Cno",Cnumber.Text));parmeters.Add(newSqlParameter("@Cname",Cname.Text));//dbConnection.MyExecuteScalar(sql);if(Boolean.Parse(dbConnection.insert(sql,parmeters).ToString())){Response.Write("<script>alert('添加成功');</script>");}elseResponse.Write("<script>alert('添加失败');</script>");}protectedvoidButton1_Click(objectsender,EventArgse)//钮触发的事件{stringsql="selectSnofromStudent";DataTabledt=CreateAdapter.getAdapter(sql);for(inti=0;i<dt.Rows.Count;i++){stringsql1="insertintoSC(Sno,Cno,Grade)values(@Sno,@Cno,'')";List<SqlParameter>parmeters1=newList<SqlParameter>();parmeters1.Add(newSqlParameter("@Cno",Cnumber.Text));parmeters1.Add(newSqlParameter("@Sno",dt.Rows[i][0]));if(Boolean.Parse(dbConnection.insert(sql1,parmeters1).ToString())){Response.Write("<script>alert('添加成功');</script>");}else}

Response.Write("<script>alert('添加失败');</script>");}}9>管理员添加学生：protectedvoidadd_Click(objectsender,EventArgse)//添加学生{stringsql="insertintoStudent(Sno,Sname,Ssex,Sdept,Sclass,Spswd)"+"values(@Sno,@Sname,@Ssex,@Sdept,@Sclass,@Spswd)";//string sql1="insertintoSC()"List<SqlParameter>parmeters=newList<SqlParameter>();parmeters.Add(newSqlParameter("@Sno",Snumber.Text));parmeters.Add(newSqlParameter("@Sname",Sname.Text));parmeters.Add(newSqlParameter("@Ssex",sex.Text));parmeters.Add(newSqlParameter("@Sdept",dept.SelectedValue));parmeters.Add(newSqlParameter("@Sclass",S_class.Text));parmeters.Add(new FormsAuthentication.HashPasswordForStoringInConfigFile("123","md5")));if(Boolean.Parse(dbConnection.insert(sql,parmeters).ToString())){}else

Response.Write("<script>alert('添加成功');</script>");Response.Write("<script>alert('该学号已使用，添加失败！请重新添加！');</script>");}protectedvoidagain_Click(objectsender,EventArgse)//重置按钮触发的事件{Snumber.Text=Sname.Text="";sex.Text="";S_class.Text="";}protectedvoidadd_course_Click(objectsender,EventArgse)//为学生添加课程{stringsql="selectCnofromCourse";DataTabledt=CreateAdapter.getAdapter(sql);for(inti=0;i<dt.Rows.Count;i++){stringsql1="insertintoSC(Sno,Cno,Grade)values(@Sno,@Cno,'')";List<SqlParameter>parmeters1=newList<SqlParameter>();parmeters1.Add(newSqlParameter("@Cno",dt.Rows[i][0]));parmeters1.Add(newSqlParameter("@Sno",Snumber.Text));if(Boolean.Parse(dbConnection.insert(sql1,parmeters1).ToString())){Response.Write("<script>alert('添加成功');</script>");}else}}

Response.Write("<script>alert('添加失败');</script>");10>管理员修改个人密码：protectedvoidbt_tijiao_Click(objectsender,EventArgse)//提交按钮触发的事件{string pwd = FormsAuthentication.HashPasswordForStoringInConfig,"md5");

if(txtnewpwd2.Text.Trim()==txtnewpwd.Text.Trim()){string newpwd FormsAuthentication.HashPasswordForStoringInConfig,"md5");stringsele="selectcount(us_id)fromdengluwhereus_id="+Convert.ToInt32(Session["userID"].ToString())+"andus_psw='"+pwd+"'";int num =Convert.ToInt32(dbConnection.MyExecuteScalar(sele).ToString());if(num>0){stringchang="updatedenglusetus_psw='"+newpwd+"' where us_id=" Convert.ToInt32(Session["userID"].ToString());if(dbConnection.insert(chang))Response.Write("<script>alert('密码修改成功！');</script>");');</script>");

}else{

else

Response.Write("<script>alert('密码修改失败！');</script>");}}else{

Response.Write("<script>alert('原始密码不正确，请重新输入！');</script>");}

Response.Write("<script>alert('两次密码不匹配，请重新输入！}protectedvoidcancel_Click(objectsender,EventArgse){txtoldpwd.Text="";txtnewpwd.Text="";txtnewpwd2.Text=}管理员编辑学生分数：<asp:ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server"><asp:GridViewID="GridView1"runat="server"AllowPaging="True"AutoGenerateColumns="False"CellPadding="4"DataKeyNames="Sno,Cno"PageSize="20"DataSourceID="SqlDataSource1"ForeColor="#333333"GridLines="None"Width="811px"><AlternatingRowStyleBackColor="White"/><Columns><asp:BoundFieldDataField="Sno"HeaderText="学号"SortExpression="Sno"/><asp:BoundFieldDataField="Cno"HeaderText="课程号"SortExpression="Cno"/><asp:BoundFieldDataField="Grade"HeaderText="分数"SortExpression="Grade"/><asp:CommandFieldShowEditButton="True"/></Columns><FooterStyleBackColor="#CCCCFF"Font-Bold="True"ForeColor="White"/><RowStyleBackColor="#EFF3FB"HorizontalAlign="Center"Font-Size="Smaller"/><PagerStyleBackColor="#CCCCFF"ForeColor="White"HorizontalAlign="Center"/><SelectedRowStyleBackColor="#D1DDF1"Font-Bold="True"ForeColor="#333333"/><HeaderStyleBackColor="#CCCCFF"Font-Bold="True"ForeColor="White"Font-Size="Smaller"/><EditRowStyleBackColor="#D1DDF1"/><AlternatingRowStyleBackColor="White"/><EmptyDataTemplate>温馨提示：当前没有任何记录哦。</EmptyDataTemplate></asp:GridView><asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings:db_xuefenConnectionString%>"DeleteCommand="DELETEFROM[SC]WHERE[Sno]=@SnoAND[Cno]=@Cno"InsertCommand="INSERTINTO[SC]([Sno],[Cno],[Grade])VALUES(@Sno,@Cno,@Grade)"SelectCommand="SELECT*FROM[SC]"UpdateCommand="UPDATE[SC]SET[Grade]=@GradeWHERE[Sno]=@SnoAND[Cno]=@Cno">

<DeleteParameters><asp:ParameterName="Sno"Type="String"/><asp:ParameterName="Cno"Type="String"/></DeleteParameters><InsertParameters><asp:ParameterName="Sno"Type="String"/><asp:ParameterName="Cno"Type="String"/><asp:ParameterName="Grade"Type="Double"/></InsertParameters><UpdateParameters><asp:ParameterName="Grade"Type="Double"/><asp:ParameterName="Sno"Type="String"/><asp:ParameterName="Cno"Type="String"/></UpdateParameters></asp:SqlDataSource></asp:Content>12>按照课程编号查：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.IO;publicpartialclassteacher_check_by_Cno:System.Web.UI.Page{stringCno="";protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),');location.href='../Default.aspx'</script>");}if(!IsPostBack){stringsql="selectCno,CnamefromCourse";

"", "<script>alert('请先登录！DataTabletemp=CreateAdapter.getAdapter(sql);select_Cno.DataSource=temp;select_Cno.DataTextField="Cname";select_Cno.DataValueField="Cno";select_Cno.DataBind();select_Cno.Items.Insert(0,newListItem("全部",""));grid_Cno_DataBind("");}}privatevoidgrid_Cno_DataBind(stringC_number){string sql = "select Student.Sno,Sname,Sdept,Sclass,Ssex,Course.Cno,Cname,Grade fromStudent,Course,SCwhereStudent.Sno=SC.SnoandCourse.Cno=SC.Cno andCourse.Cnolike'%"+C_number+"%'";DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_Cno.DataSource=dt;grid_Cno.DataBind();}protectedvoidselect_Cno_SelectedIndexChanged(objectsender,EventArgse){Cno=select_Cno.SelectedValue;grid_Cno_DataBind(Cno);}}13>按照班级查：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.IO;publicpartialclassteacher_check_by_Sclass:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}}protectedvoidButton1_Click(objectsender,EventArgse){stringsql="selectStudent.Sno,Sname,Sdept,Sclass,Ssex,Course.Cno,Cname"+"fromStudent,Course,SCwhereStudent.Sno=SC.Sno"+"andCourse.Cno=SC.CnoandSdeptlike'"+dept.Text.ToString()+"'"+"andSclasslike'"+class1.Text.ToString()+"'";DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_class.DataSource=dt;grid_class.DataBind();}}14>按照学生姓名查：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.IO;publicpartialclassteacher_check_by_Sname:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}}protectedvoidButton1_Click(objectsender,EventArgse){string sql = "select Student.Sno,Sname,Sdept,Sclass,Ssex,Course.Cno,Cname,Grade fromStudent,Course,SCwhereStudent.Sno=SC.SnoandCourse.Cno=SC.CnoandSnamelike'"+name.Text.ToString()+"'";DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_Sname.DataSource=dt;grid_Sname.DataBind();}}15>查各科平均分数：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.IO;usingSystem.Data;publicpartialclassteacher_course_average:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}stringsql="selectCno,avg(Grade)asfromSCgroupbyDataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_course.DataSource=dt;grid_course.DataBind();}}16>修改用户密码：usingSystem;usingSystem.Collections.Generic;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.Web.Security;usingSystem.IO;usingSystem.Data.SqlClient;publicpartialclasscreatepsw:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){stringstu_newpwd=FormsAuthentication.HashPasswordForStoringInConfig(),stringtea_newpwd=FormsAuthentication.HashPasswordForStoringInConfig(),stringupdate="updateStudentsetSpswd='"+stu_newpwd+"';"+"updatedenglusetus_psw='"+tea_newpwd+if(dbConnection.insert(update))Response.Write("<script>alert('密码修改成功');</script>");}}17>删除学生：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data.SqlClient;usingSystem.Data;publicpartialclassadmin_deletestudent:System.Web.UI.Page{DataTabledt=newDataTable();protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}stringsql="selectSno,Sclass,Sdept,Ssex,SnamefromStudent";dt=CreateAdapter.getAdapter(sql);grid_student.DataSource=dt;grid_student.DataBind();}protectedvoidstudnetediting(objectsender,GridViewEditEventArgse){stringno=dt.Rows[0][0].ToString();stringsql1="deletefromSCwhereSno='"+no+"'";stringsql2="deletefromStudentwhereSno='"+no+dbConnection.MyExecuteScalar(sql1);dbConnection.MyExecuteScalar(sql2);Response.Redirect("deletestudent.aspx");}}18>应留级的学生：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.IO;publicpartialclassteacher_down_grade:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}stringsql="selectSno,Sname,sdept,Sclass,SsexfromstudentwhereSnoin(selectSnofromSCGrade<60groupbySnohavingcount(Cno)>=3)";DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);down_grade.DataSource=dt;down_grade.DataBind();}}19>各班不及格的人数及比例：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;publicpartialclassteacher_nopass_class:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}}protectedvoidButton1_Click(objectsender,EventArgse){stringsql="selectCno,count(Sno)asnumber,(selectdistinctcount(Sno)fromSC"+"whereSC.Snoin(selectSnofromstudentwhereSdept='"+dept.Text.ToString()+"'"+"andSclass='"+class1.Text.ToString()+"')"+"groupbyCno)astotel,cast(count(Sno)*1.0/(selectdistinctcount(Sno)fromSC"+"whereSC.Snoin(selectSnofromstudentwhereSdept='"+dept.Text.ToString()+"'andSclass='"+class1.Text.ToString()+"')"+"groupbyCno)asvarchar)+'%'asscale"+"fromSCwhereGrade<60andSC.Snoin""(selectSnofromstudentwhereSdept='"+dept.Text.ToString()+"'"+"andSclass='"+class1.Text.ToString()+"')groupbyCno";DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_class.DataSource=dt;grid_class.DataBind();}}20>不及格的学生：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.IO;publicpartialclassteacher_nopass_students:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}string sql = "select Student.Sno,Sname,Sdept,Sclass,Ssex,Course.Cno,Cname,Grade Student,Course,SCwhereStudent.Sno=SC.SnoandCourse.Cno=SC.CnoandGrade<60";DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql);grid_Sname.DataSource=dt;grid_Sname.DataBind();}}21>各分数段的人数及比例：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;publicpartialclassteacher_numbers_of_everyGrade:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}}protectedvoidButton1_Click(objectsender,EventArgse){//stringsql="selectCno,count(Sno)asnumberfromSCwhereGradebetween"+grade1.Text+"and"+grade2.Text+// "andSC.Snoin(selectSnofromstudentwhereSdept='"+dept.Text.ToString()+"'"+"Sclass='"+class1.Text.ToString()+"')groupbyCno";stringsql1="selectCno,count(Sno)asnumber,(selectdistinctcount(Sno)fromSC"+"whereSC.Snoin(selectSnofromstudentwhereSdept='"+dept.Text.ToString()+"'"+"andSclass='"+class1.Text.ToString()+"')"+"groupbyCno)astotel,cast(count(Sno)*1.0/(selectdistinctcount(Sno)fromSC"+"whereSC.Snoin(selectSnofromstudentwhereSdept='"+dept.Text.ToString()+"'andSclass='"+class1.Text.ToString()+"')"+"groupbyCno)asvarchar)+'%'asscale"+"fromSCwhereGradebetween50and70andSC.Snoin"+"(selectSnofromstudentwhereSdept='"+dept.Text.ToString()+"'"+"andSclass='"class1.Text.ToString()+"')groupbyCno";DataTabledt=newDataTable();dt=CreateAdapter.getAdapter(sql1);grid_grade.DataSource=dt;grid_grade.DataBind();}}22>学生的平均成绩：usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;publicpartialclassteacher_student_avag:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["userID"]==null){Page.ClientScript.RegisterStartupScript(this.GetType(),"", "<script>alert('请先登录！');location.href='../Default.aspx'</script>");}stringsql="selectSno,avg(Grade)asavagfromSCgroupbyDataTabledt=newDataTable();dt=CreateAd