《Web应用开发实训》实训报告模板.doc

Web应用开发实训（适用于：软件专业，参考周数：2周）一、 实训目的本课程的修读对象是软件技术专业的学生。本课程的主要任务是使学生掌握ASP.NET编程技术及数据库相关知识、并能熟练使用ASP.NET环境和一种数据库管理软件进行Web应用程序的开发。二、 实训要求1了解ASP.NET的工作原理和开发工具，掌握其应用环境的配置。2掌握C#或者VB.NET语言，掌握ASP内置对象的功能，各内置对象属性、方法及数据集合的使用。3掌握HTML服务器控件和Web服务器控件的使用4熟悉SQL Server数据库管理，掌握使用ADO.NET访问数据库的方法。5掌握常用Web数据库应用程序开发的实例。三、 实训内容学生信息管理系统设计制作任务1 系统功能概述学生信息管理系统是常见的一个应用系统，能够大大提高学生信息的管理效率，实现数据共享、网络查询和网络管理等便利。本项目设计的学生信息管理系统主要包括以下功能模块：学生信息录入模块、学生信息管理模块（包括编辑、删除）、学生信息查询模块、用户登录模块、用户信息管理模块、用户权限设置模块、学生成绩录入模块、学生成绩管理模块、专业信息管理模块等。任务2 数据库设计2.1 数据库需求分析本系统为学生信息管理系统，数据库中存储的信息包括：学生信息、用户信息、院系表、管理员信息、课程信息、成绩信息等。2.2 数据库结构设计存放班级数据信息表Class存放课程信息表Course存放课程类型信息表Coursetype存放系部信息表Department存放年纪信息表GradeSpeciality表Speciality_course表student表Teacher表users表任务3 设计学生信息管理系统功能模块3.1 项目文件结构Web.config配置文件： 3.2 编写基础类文件代码在编写各页面前，需要在App_Code文件夹中添加四个类文件，分别是Class.cs、ClassConn.cs、connDB.cd和data.cs。 Class.cs类的功能是和数据库相关的操作； ClassConn.cs类的功能是实现对SQL数据库的各种操作； connDB.cs类的功能是建立与数据库的连接； data.cs类的功能是执行SQL语句。3.3 各页面详细设计1.用户登录界面用户登录界面Login.aspx主要功能是系统根据用户选择的身份对用户输入的用户名和密码以及用户选择的身份进行判断，如果合法，则进入相应的操作页面；如果不合法，给出提示，并要求用户重新登录。代码：protected void Page_Load(object sender, EventArgs e) string sms_connstr =System.Configuration.ConfigurationManager.AppSettingssms_dbconn; sms_conn = new SqlConnection(sms_connstr); protected void Button1_Click(object sender, EventArgs e) string str_pwd = this.mypassword.Text.Trim().Replace(, ); string sqlstr = select usertype from Users where username=+ username.Text+and mypassword=password; SqlCommand cmd = new SqlCommand(sqlstr,sms_conn); cmd.Parameters.Add(new SqlParameter(password, SqlDbType.VarChar,50); cmd.Parameterspassword.Value = str_pwd.ToString(); sms_conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read() = true) Sessionuser = this.username.Text.Trim(); Sessiontype = druserType.ToString().Trim(); FormsAuthentication.RedirectFromLoginPage(username.Text, false); sms_conn.Close(); else sms_conn.Close(); message.Text = 您必须输入有效的用户名和密码！; 2.教师资料管理页面Teacher.aspx显示系部教师的详细信息，支持查询功能，管理员有“删除”权限。主要使用GridView控件实现教师信息绑定。代码：public partial class teacher : System.Web.UI.PageSqlConnection sms_conn; string sms_sqlstr, sms_sqlstr2; protected void Page_Load(object sender, EventArgs e) SqlConnection conn = new SqlConnection(Data Source=(local);Initial Catalog=SMMStudent;Integrated Security=SSPI;); string sms_connstr = System.Configuration.ConfigurationManager.AppSettingssms_dbconn; sms_conn = new SqlConnection(sms_connstr); if (!IsPostBack) SMS_BindGrid(); private void SMS_BindGrid() sms_sqlstr = select teacherid,teachername,Department.DepartmentID,Department.DepartmentName,sex,telephone from teacher,Department where teacher.departmentID=Department.DepartmentID; SqlDataAdapter sms_da = new SqlDataAdapter(sms_sqlstr, sms_conn); DataSet sms_ds = new DataSet(); sms_da.Fill(sms_ds, T); sms_teacher.DataSource = sms_ds; sms_teacher.DataBind(); sms_sqlstr2 = select * from department; SqlDataAdapter sms_da2 = new SqlDataAdapter(sms_sqlstr2, sms_conn); DataSet sms_ds2 = new DataSet(); sms_da2.Fill(sms_ds2, T); DropDownList1.DataSource = sms_ds2.TablesT; DropDownList1.DataTextField = departmentname; DropDownList1.DataValueField = departmentname; DropDownList1.DataBind(); public void DataGrid_Page(object sender, DataGridPageChangedEventArgs e) sms_teacher.CurrentPageIndex = e.NewPageIndex; SMS_BindGrid(); public void DataGrid_edit(object sender, DataGridCommandEventArgs e) sms_teacher.EditItemIndex = (int)e.Item.ItemIndex; SMS_BindGrid(); protected void DataGrid_delete(object source, DataGridCommandEventArgs e) string sms_sqlstr = delete from teacher where Teacherid=teacher_id; SqlCommand sms_comm = new SqlCommand(sms_sqlstr, sms_conn); sms_comm.Parameters.Add(new SqlParameter(teacher_id, SqlDbType.Char, 8); sms_comm.Parametersteacher_id.Value = sms_teacher.DataKeys(int)e.Item.ItemIndex; sms_comm.Connection.Open(); try sms_comm.ExecuteNonQuery(); sms_lbl_note.Text = 删除成功; catch(SqlException) sms_lbl_note.Text = 删除失败; sms_lbl_note.Stylecolor = red; sms_comm.Connection.Close(); SMS_BindGrid(); protected void DataGrid_cancel(object source, DataGridCommandEventArgs e) sms_teacher.EditItemIndex = -1; SMS_BindGrid(); protected void Button1_Click(object sender, EventArgs e) SqlCommand sms_comm = new SqlCommand(Employess_Sel, sms_conn); sms_comm.CommandType = CommandType.StoredProcedure; sms_comm.CommandText = Employess_Sel; sms_comm.Connection = sms_conn; SqlDataAdapter sms_da = new SqlDataAdapter(sms_comm); sms_da.SelectCommand.Parameters.Add(lastname, SqlDbType.NVarChar); sms_da.SelectCommand.Parameters.Add(department, SqlDbType.NVarChar,30); sms_da.SelectCommand.Parameterslastname.Value = this.TextBox1.Text.Trim().Replace(, ); sms_da.SelectCommand.Parametersdepartment.Value = this.DropDownList1.SelectedValue.ToString(); DataSet sms_ds = new DataSet(); sms_da.Fill(sms_ds); sms_teacher.DataSource = sms_ds; sms_teacher.DataBind(); 3.教师信息页面Addteacher.aspx页面功能是将教师信息添加到数据库里。代码：protected void Button1_Click(object sender, EventArgs e) string sms_sqlstr = insert into teacher(Teachername,sex,technicalpost,telephone,homeaddr,pwd,remark,departmentid,teacherid) + values ( + TextBox2.Text + , + RadioButtonList1.SelectedItem.Text + , + DropDownList2.SelectedItem.Text + , + TextBox8.Text + , + TextBox7.Text + , + + TextBox9.Text + , + TextBox6.Text + , + DropDownList3.SelectedValue.ToString() + , + TextBox1.Text + ); SqlCommand sms_comm = new SqlCommand(sms_sqlstr, sms_conn); sms_comm.Connection.Open(); try sms_comm.ExecuteNonQuery(); Response.Redirect(teacher.aspx); catch (SqlException) sms_lbl_note.Text = 编辑失败; sms_lbl_note.Stylecolor = red; sms_comm.Connection.Close(); protected void Button2_Click(object sender, EventArgs e) Response.Redirect(teacher.aspx); 4.学生信息管理页面Student.aspx页面是显示学生信息，并对学生信息进行删除管理。代码：protected void Page_Load(object sender, EventArgs e) string sms_connstr = System.Configuration.ConfigurationManager.AppSettingssms_dbconn; sms_conn = new SqlConnection(sms_connstr); if (!IsPostBack) SMS_BindGrid(); public void SMS_BindGrid() sms_conn.Open(); string sms_sqlstr = select * from student,class where student.classid=class.classid; SqlDataAdapter sms_adp = new SqlDataAdapter(sms_sqlstr, sms_conn); DataSet sms_ds = new DataSet(); sms_adp.Fill(sms_ds); sms_conn.Close(); sms_student.DataSource = sms_ds; sms_student.DataBind(); sms_ds.Clear(); sms_ds.Dispose(); sms_conn.Open(); sms_sqlstr2 = select * from class; SqlDataAdapter sms_da2 = new SqlDataAdapter(sms_sqlstr2, sms_conn); DataSet sms_ds2 = new DataSet(); sms_da2.Fill(sms_ds2, T); sms_conn.Close(); DropDownList1.DataSource = sms_ds2.TablesT; DropDownList1.DataTextField = classname; DropDownList1.DataValueField = classname; DropDownList1.DataBind(); sms_ds2.Clear(); sms_ds2.Dispose();protected void Button2_Click(object sender, EventArgs e) SMS_BindGrid(); protected void LinkButton5_Click(object sender, EventArgs e) Response.Redirect(addstu.aspx); protected void RowDataBound(object sender, GridViewRowEventArgs e) if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onmouserover, this.style.backgroundColor=#E6F5FA); e.Row.Attributes.Add(onmouserout, this.style.backgroundColor=#FFFFFF); 5.学生信息页面Addstu.aspx页面的功能是将学生的信息添加到数据库。代码：protected void Button1_Click(object sender, EventArgs e) string sms_sqlstr = insert into student (studentname,sex,classid,telephone,address,pwd,remark,ru_date,studentid,birthday,credithour) values ( + TextBox2.Text + , + RadioButtonList1.SelectedItem.Text + , + DropDownList1.SelectedValue.ToString() + , + TextBox8.Text + , + TextBox10.Text + , + TextBox11.Text + , + TextBox6.Text + , + DropDownList2.SelectedValue.ToString() + , + TextBox1.Text + , + TextBox5.Text + , + TextBox7.Text + ); SqlCommand sms_comm = new SqlCommand(sms_sqlstr, sms_conn); sms_comm.Connection.Open(); try sms_comm.ExecuteNonQuery(); sms_lbl_note.Text = 编辑成功; catch (SqlException) sms_lbl_note.Text = 编辑失败; sms_lbl_note.Stylecolor = red; sms_comm.Connection.Close(); Response.Redirect(student.aspx); protected void Button3_Click(object sender, EventArgs e) Response.Redirect(student.aspx); protected void Button6_Click(object sender, EventArgs e) Response.Redirect(addstu.aspx); 6.系部信息页面Department.aspx页面的功能是显示系部信息。代码：protected void Page_Load(object sender, EventArgs e) string sms_connstr = ConfigurationSettings.AppSettingssms_dbconn; sms_conn = new SqlConnection(sms_connstr); if (!IsPostBack) SMS_BindRepeater(); sqlstr = select * from department; SqlDataAdapter cmd = new SqlDataAdapter(sqlstr, sms_conn); DataSet ds = new DataSet(); cmd.Fill(ds, T); for (int i = 0; i ds.TablesT.Rows.Count; i+) DropDownList1.Items.Add(new ListItem(ds.TablesT.Rowsidepartmentname.ToString(), ds.TablesT.Rowsidepartmentname.ToString(); ds.Clear(); ds.Dispose(); sms_conn.Close(); sms_conn.Dispose(); private void SMS_BindRepeater() sqlstr = select * from department; SqlDataAdapter cmd = new SqlDataAdapter(sqlstr, sms_conn); DataSet ds = new DataSet(); cmd.Fill(ds, TD1); RepeaterD.DataSource = ds.TablesTD1; RepeaterD.DataBind(); ds.Clear(); ds.Dispose(); public void RepeaterIC(object sender, RepeaterCommandEventArgs e) System.Web.UI.WebControls.LinkButton update = (LinkButton)e.Item.FindControl(LinkButton2); System.Web.UI.WebControls.LinkButton cancel = (LinkButton)e.Item.FindControl(LinkButton1); System.Web.UI.WebControls.LinkButton edit = (LinkButton)e.Item.FindControl(LinkButton3); System.Web.UI.WebControls.LinkButton delete = (LinkButton)e.Item.FindControl(LinkButton4); System.Web.UI.WebControls.Label LabDepid = (Label)e.Item.FindControl(LabDepid); System.Web.UI.WebControls.Label LabDepname = (Label)e.Item.FindControl(LabDepname); System.Web.UI.WebControls.Label LabDephead = (Label)e.Item.FindControl(LabDephead); System.Web.UI.WebControls.TextBox TxtDepid = (TextBox)e.Item.FindControl(TxtDepid); System.Web.UI.WebControls.TextBox TxtDepname = (TextBox)e.Item.FindControl(TxtDepname); System.Web.UI.WebControls.TextBox TxtDephead = (TextBox)e.Item.FindControl(TxtDephead); if (e.CommandName = edit) update.Visible = true; cancel.Visible = true; edit.Visible = false; LabDepname.Visible = false; LabDephead.Visible = false; TxtDepname.Visible = true; TxtDephead.Visible = true; if (e.CommandName = cancel) SMS_BindRepeater(); if (e.CommandName = update) sqlstr = update Department set departmentname= + TxtDepname.Text + ,departmenthead= + TxtDephead.Text + where departmentid= + LabDepid.Text + ; SqlCommand sqlcom = new SqlCommand(sqlstr, sms_conn); sms_conn.Open(); sqlcom.ExecuteNonQuery(); SMS_BindRepeater(); sms_conn.Close(); if (e.CommandName = delete) sqlstr = delete Department where departmentid= + LabDepid.Text + ; SqlCommand sqlcom = new SqlCommand(sqlstr, sms_conn); sms_conn.Open(); sqlcom.ExecuteNonQuery(); SMS_BindRepeater(); sms_conn.Close(); 7.专业信息显示页面Speciality.aspx页面的功能是显示专业信息。使用GridView控件，用于绑定专业信息。代码：public void SMS_BindView() sms_sqlstr = select * from speciality,department where department.departmentid=speciality.departmentid; SqlDataAdapter sms_adp = new SqlDataAdapter(sms_sqlstr, sms_conn); DataSet sms_ds = new DataSet(); sms_adp.Fill(sms_ds, T); sms_conn.Close(); sms_grade.DataSource = sms_ds.TablesT; sms_grade.DataBind(); sms_ds.Clear(); sms_ds.Dispose(); sms_sqlstr2 = select * from department; SqlDataAdapter sms_adp2 = new SqlDataAdapter(sms_sqlstr2, sms_conn); DataSet sms_ds2 = new DataSet(); sms_adp2.Fill(sms_ds2, T); DropDownList2.DataSource = sms_ds2.TablesT; DropDownList2.DataTextField = departmentname; DropDownList2.DataBind(); sms_ds2.Clear(); sms_ds2.Dispose(); protected void Button1_Click(object sender, EventArgs e) sms_sqlstr = select * from speciality,department where department.departmentid=speciality.departmentid and department.departmentname= + DropDownList2.SelectedValue.ToString() + ; sms_conn.Open(); SqlDataAdapter sms_da = new SqlDataAdapter(sms_sqlstr, sms_conn); DataSet sms_ds = new DataSet(); sms_da.Fill(sms_ds); sms_conn.Close(); sms_grade.DataSource = sms_ds; sms_grade.DataBind(); public void Data_Page(object sender, GridViewPageEventArgs e) try sms_grade.PageIndex = e.NewPageIndex; SMS_BindView(); catch #region Web Form Designer generated code protected override void OnInit(EventArgs e) InitializeComponent(); base.OnInit(e); private void InitializeComponent() this.Load += new System.EventHandler(this.Page_Load); #endregion protected void LinkButton1_Click(object sender, EventArgs e) for (int i = 0; i sms_grade.Rows.Count; i+) CheckBox chkSelect = (CheckBox)sms_grade.Rowsi.FindControl(chkSelect); chkSelect.Checked = true; 8.课程信息显示页面Course.aspx页面用于显示课程信息。代码：protected void Page_Load(object sender, EventArgs e) string sms_connstr = ConfigurationSettings.AppSettingssms_dbconn; sms_conn = new SqlConnection(sms_connstr); if (!IsPostBack) SMS_BindGrid(); public void SMS_BindGrid() sms_conn.Open(); string sms_sqlstr = select * from course,coursetype where course.coursetypeid=coursetype.coursetypeid; SqlDataAdapter sms_adp = new SqlDataAdapter(sms_sqlstr, sms_conn); DataSet sms_ds = new DataSet(); sms_adp.Fill(sms_ds); sms_conn.Close(); sms_student.DataSource = sms_ds; sms_student.DataBind(); sms_ds.Clear(); sms_ds.Dispose(); sms_conn.Open(); sms_sqlstr2 = select * from coursetype; SqlDataAdapter sms_da2 = new SqlDataAdapter(sms_sqlstr2, sms_conn); DataSet sms_ds2 = new DataSet(); sms_da2.Fill(sms_ds2, T); sms_conn.Close(); DropDownList1.DataSource = sms_ds2.TablesT; DropDownList1.DataTextField = typename; DropDownList1.DataValueField = typename; DropDownList1.DataBind(); sms_ds2.Clear(); sms_ds2.Dispose(); protected void Button1_Click(object sender, EventArgs e) sms_sqlstr = select * from course,coursetype where course.coursetypeid=coursetype.cours