学生管理系统项目实训报告

实训报告书

课程:        Android项目实训            

                      

专业班级    软件1217     

学生姓名    何震亚           

    号:2012180653          

指导教师:      李法平        

完成日期:      2014/1/8       

重庆电子工程职业学院软件学院



目  录

目  录.............................................................................................................................. I

1 实训目的...................................................................................................................... 1

2  学生管理系统的分析与设计........................................................................................ 1

2.1  系统功能描述................................................................................................... 1

2.2  系统模块设计................................................................................................... 1

3主要代码清单................................................................................................................ 1

4  程序运行与测试........................................................................................................ 36

5  实训总结.................................................................................................................... 1


学生管理系统项目实训

1 实训目的

本次课程实训是专门针对大二学生的一次项目实践,本软件需求说明书是为学生管理系统编写,为了方便教师对自己的个人信息查询、课表查询、对班级学生的信息进行增删改查。

2  学生管理系统的分析与设计

2.1  学生管理系统简介

学生管理系统是各个学校都具备的基础教务系统,在计算机开始流行的时候,学生管理系统就开始在各个学校间流行并逐渐得到完善。

2.2  系统功能描述

学生管理系统是基于WEB应用开发,采用C#  ASP编辑,合理设计页面布局。

1) 登陆界面功能及设计:

学生管理系统登陆页面包含各种提示语,分别用Lable、textbox表现出;有两个输入框分别输入用户名和密码,密码采用加密方式,无法看到、复制;用一个列表选项框,内含两个登陆选择。并通过数据库连接进行账户密码验证。

2) 信息来源设计:通过数据库调出需要的数据并输入相应表中,表格合理,内容详细。

3) 以下是几个主要的子类:

//登陆button的动作功能描述

protected void btnLogin_Click(object sender, EventArgs e){

       ……
}

//保存button的动作功能描述

 protected void butSave_Click(object sender, EventArgs e){     

……

}

2.3系统模块设计

1) 在设计学生管理系统的过程中,首先调用一个登陆界面,用户选择登陆类型,输入用户名和密码点击登陆键进入主菜单来选择系统中的不同的功能。在用户名密码验证成功后进入相应的菜单。

2) 在系统中作者设计了五个按钮。分别是:登陆、取消、讲师登记学生成绩考评、保存、Submit。

3)页面跳转:利用ASP的 Response.Redirect("")功能进行跳转。

4)数据显示:利用数据源拖拽相应数据信息并修改。

5)数据库链接与关闭:需要连接时连接,不需要时关闭。

3  主要代码清单

(1)程序登陆的界面:

  public partial class Login : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                Session.Clear();//清除所有的session

            }

        }

        protected void btnLogin_Click(object sender, EventArgs e)

        {

            if (rbList.SelectedValue == "2")

            {

                string sql = @"SELECT [LecturerId]  ,  

                        [Password],FirstName,LastName

                          FROM [LecturerInfo]

                        where  LecturerId=@LoginId and [Password]=@password";

                SqlParameter[] paramsInfo ={

                           new SqlParameter("@LoginId",txtLoginId.Text.Trim()),

                           new SqlParameter("@password",txtPassword.Text)

                                       };

                DataSet ds = code.DBCommon.ExecuteQuery(sql, paramsInfo);

                if (ds.Tables[0].Rows.Count == 1 &&

                    ds.Tables[0].Rows[0][0].ToString() == txtLoginId.Text.Trim()

                    && ds.Tables[0].Rows[0][1].ToString() == txtPassword.Text)

                {

                    //验证成功

                    //设置Session对象

                    code.LoginInfo loginObj = new code.LoginInfo();

                    loginObj.LoginId = txtLoginId.Text.Trim();

                    loginObj.LoginDate = DateTime.Now;

                    loginObj.FirstName = ds.Tables[0].Rows[0]["FirstName"].ToString();

                    loginObj.LastName = ds.Tables[0].Rows[0]["LastName"].ToString();

                    loginObj.LoginTypes = "2";

                    //将登录的信息放到会话中保存

                    code.Common.Login= loginObj;

                    Response.Redirect("LecturerInfo.aspx");

                }

                else

                {

                    lbMsg.Text = "讲师登陆验证失败,请重新输入正确的讲师代码及密码";

                    txtLoginId.Text = "";

                    txtPassword.Text = "";

                }

            }

            if (rbList.SelectedValue == "3")

            {

                string sql = @"SELECT [Student_Id]  ,  

                        [Password],First_Name,Last_Name

                          FROM [StudentInfo]

                        where  Student_Id=@LoginId and [Password]=@password";

                SqlParameter[] paramsInfo ={

                           new SqlParameter("@LoginId",txtLoginId.Text.Trim()),

                           new SqlParameter("@password",txtPassword.Text)

                                       };

                DataSet ds = code.DBCommon.ExecuteQuery(sql, paramsInfo);

                if (ds.Tables[0].Rows.Count == 1 &&

                    ds.Tables[0].Rows[0][0].ToString() == txtLoginId.Text.Trim()

                    && ds.Tables[0].Rows[0][1].ToString() == txtPassword.Text)

                {

                    //验证成功

                    //设置Session对象

                    code.LoginInfo loginObj = new code.LoginInfo();

                    loginObj.LoginId = txtLoginId.Text.Trim();

                    loginObj.LoginDate = DateTime.Now;

                    loginObj.FirstName = ds.Tables[0].Rows[0]["First_Name"].ToString();

                    loginObj.LastName = ds.Tables[0].Rows[0]["Last_Name"].ToString();

                    loginObj.LoginTypes = "3";

                    //将登录的信息放到会话中保存

                    code.Common.Login = loginObj;

                    Response.Redirect("StudentInfo.aspx");

                }

                else

                {

                    lbMsg.Text = "学生登陆验证失败,请重新输入正确的学生代码及密码";

                    txtLoginId.Text = "";

                    txtPassword.Text = "";

                }

            }

        }

        protected void btnCancel_Click(object sender, EventArgs e)

        {

            Application.RemoveAll();

        }

}

(2)程序的登陆界面网页源代码:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="Task4.Login" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

    <style type="text/css">

        .style1

        {

            width: 55px;

        }

        .style2

        {

            text-align: center;

            font-size: xx-large;

        }

    </style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <h2 class="style2"><strong><em>Welcome To Student ProcessSystem</em></strong></h2>

    <table style="width: 100%;">

        <tr>

            <td class="style1">

              

                登录名</td>

            <td>

                <asp:TextBox ID="txtLoginId" CssClass="textEntry" runat="server"></asp:TextBox>

            </td>

            <td>

                如果当前登录的用户为讲师,请输入讲师的Id,若为学生,请输入学生的学号,管理员则不知道输入什么

            </td>

        </tr>

        <tr>

            <td class="style1">

                密码</td>

            <td>

                <asp:TextBox ID="txtPassword" TextMode="Password"  runat="server"

                    CssClass="textEntry"></asp:TextBox>

            </td>

            <td>

                 请输入正确的密码,不可以为空

            </td>

        </tr>

        <tr>

            <td class="style1">

               

                用户类型</td>

            <td>

                <asp:RadioButtonList ID="rbList" RepeatDirection="Horizontal" runat="server">

               

                <asp:ListItem Text="Lecturer" Value="2"></asp:ListItem>

                <asp:ListItem Text="Student" Value="3" Selected></asp:ListItem>

                </asp:RadioButtonList>

            </td>

            <td>

                请选择登录的类型,默认选择学生</td>

        </tr>

         <tr>

            <td class="style1">

               

                 </td>

            <td>

                <asp:Button ID="btnLogin" runat="server" CssClass="submitButton" Text="登陆"

                    onclick="btnLogin_Click" BackColor="Lime" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

                <asp:Button ID="btnCancel" runat="server" CssClass="submitButton"  Text="取消"

                    onclick="btnCancel_Click" BackColor="Lime" />

            </td>

            <td></td>

               

        </tr>

         <tr>

            <td class="style1">

               

                 </td>

            <td>

                <asp:Label ID="lbMsg" runat="server" ForeColor="Red" Text=""></asp:Label>

            </td>

            <td></td>

               

        </tr>

    </table>

</asp:Content>

(3) 学生信息页面的源代码:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="StudentInfo.aspx.cs" Inherits="Task4.StudentInfo" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    Assessment:

    <asp:GridView ID="GridViewResult" runat="server">

    </asp:GridView>

    Issue:

   <asp:GridView ID="GridViewIssue" runat="server">

   </asp:GridView>

</asp:Content>

(4) 教师信息页面的源代码:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="LecturerInfo.aspx.cs" Inherits="Task4.LecturerInfo" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">

        <Columns>

            <asp:BoundField FooterText="姓名" />

        </Columns>

    </asp:GridView>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

    <asp:Button ID="Button1" runat="server" BackColor="#00FF99"

        onclick="Button1_Click" Text="讲师登记学生考评" Width="108px" />

</asp:Content>

(5) 事件页面源代码:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Issue.aspx.cs" Inherits="Task4.Issue" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <asp:GridView ID="GridViewIssue" runat="server" Width="258px">

    <Columns >

    <asp:HyperLinkField DataNavigateUrlFields="IssueId"  ItemStyle-Width="60px"

                DataNavigateUrlFormatString="IssueEdit.aspx?id={0}" HeaderText="编辑"

                Text="编辑" >

<ItemStyle Width="60px"></ItemStyle>

            </asp:HyperLinkField>

    </Columns >

    </asp:GridView>

</asp:Content>

(6) 事件编辑页面源代码:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="IssueEdit.aspx.cs" Inherits="Task4.IssueEdit" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

    <style type="text/css">

        .style1

        {

            width: 237px;

        }

        .style2

        {

            width: 266px;

        }

    </style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <table style="width:100%;">

        <tr>

            <td class="style2">

                <asp:Label ID="labIssue" runat="server" Text="Issue ID"></asp:Label>

                :</td>

            <td class="style1">

                <asp:TextBox ID="txtIssueID" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labLecturerID" runat="server" Text="Lecturer ID"></asp:Label>

                :</td>

            <td class="style1">

                <asp:DropDownList ID="DropDownListLID" runat="server"

                    DataSourceID="SqlDataSource1" DataTextField="LecturerId"

                    DataValueField="LecturerId" Height="16px" Width="203px">

                </asp:DropDownList>

                <asp:SqlDataSource ID="SqlDataSource1" runat="server"

                    ConnectionString="<%$ ConnectionStrings:SPS_DBConnectionString %>"

                    SelectCommand="SELECT [LecturerId] FROM [LecturerInfo]"></asp:SqlDataSource>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labStudentID" runat="server" Text="Student ID"></asp:Label>

                :</td>

            <td class="style1">

                <asp:DropDownList ID="DropDownListSID" runat="server"

                    DataSourceID="SqlDataSource2" DataTextField="Student_Id"

                    DataValueField="Student_Id" Height="16px" Width="202px">

                </asp:DropDownList>

                <asp:SqlDataSource ID="SqlDataSource2" runat="server"

                    ConnectionString="<%$ ConnectionStrings:SPS_DBConnectionString %>"

                    SelectCommand="SELECT [Student_Id] FROM [StudentInfo]"></asp:SqlDataSource>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labSummary" runat="server" Text="Issue Summary"></asp:Label>

                :</td>

            <td class="style1">

                <asp:TextBox ID="txtSummary" runat="server" Height="75px" Width="222px"

                    TextMode="MultiLine"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labDescription" runat="server" Text="Issue Description"></asp:Label>

                :</td>

            <td class="style1">

                <asp:TextBox ID="txtDescription" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labDate" runat="server" Text="Issue Date"></asp:Label>

                :</td>

            <td class="style1">

                <asp:TextBox ID="txtDate" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labStatus" runat="server" Text="Issue Status"></asp:Label>

                :</td>

            <td class="style1">

                <asp:TextBox ID="txtStatus" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labFollwUpAction" runat="server" Text="Follow Up Action:"></asp:Label>

            </td>

            <td class="style1">

                <asp:TextBox ID="txtFollowUpAction" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labFollowUpDate" runat="server" Text="Follow Up Date"></asp:Label>

            </td>

            <td class="style1">

                <asp:TextBox ID="txtFollowUpDate" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labDateActionTaken" runat="server" Text="Date Action Taken:"></asp:Label>

            </td>

            <td class="style1">

                <asp:TextBox ID="txtDateActionTaken" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style2">

                <asp:Label ID="labActionTaken" runat="server" Text="Action Taken:"></asp:Label>

            </td>

            <td class="style1">

                <asp:TextBox ID="txtActionTaken" runat="server" Width="200px"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

         <tr>

            <td>

                &nbsp;</td>

            <td>

                <asp:Button ID="butSave" runat="server" Height="29px" Text="Sava"

                    Width="70px" onclick="butSave_Click" />

             </td>

        </tr>

        </table>

</asp:Content>

(7) 班级编辑页面源代码:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="ClassEdit.aspx.cs" Inherits="Task4.ClassEdit" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

    <style type="text/css">

        .style1

        {

            width: 233px;

        }

    </style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <table style="width:100%;">

        <tr>

            <td class="style1">

                <asp:Label ID="labClassID" runat="server" Text="Class ID"></asp:Label>

                :</td>

            <td>

                <asp:TextBox ID="txtID" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labLecturerID" runat="server" Text="Lecturer ID"></asp:Label>

                :</td>

            <td>

                <asp:DropDownList ID="DropDownList1" runat="server"

                    DataSourceID="SqlDataSource1" DataTextField="LecturerId"

                    DataValueField="LecturerId" Height="16px" Width="145px">

                </asp:DropDownList>

                <asp:SqlDataSource ID="SqlDataSource1" runat="server"

                    ConnectionString="<%$ ConnectionStrings:SPS_DBConnectionString %>"

                    SelectCommand="SELECT [LecturerId] FROM [LecturerInfo]"></asp:SqlDataSource>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labRoom" runat="server" Text="Room"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtRoom" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labBuiding" runat="server" Text="Building:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtBuilding" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labSemester" runat="server" Text="Semester"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtSemester" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labYear" runat="server" Text="Year:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtYesr" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labDay" runat="server" Text="Day:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtDay" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labStartTime" runat="server" Text="Start Time:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtStartTime" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labEndTime" runat="server" Text="End Time"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtEndTime" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                &nbsp;</td>

            <td>

                <asp:Button ID="butSave" runat="server" Text="保存" onclick="butSave_Click" />

            </td>

            <td>

                &nbsp;</td>

        </tr>

    </table>

</asp:Content>

(8) AssessmentList 页面代码源:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="ClassEdit.aspx.cs" Inherits="Task4.ClassEdit" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

    <style type="text/css">

        .style1

        {

            width: 233px;

        }

    </style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <table style="width:100%;">

        <tr>

            <td class="style1">

                <asp:Label ID="labClassID" runat="server" Text="Class ID"></asp:Label>

                :</td>

            <td>

                <asp:TextBox ID="txtID" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labLecturerID" runat="server" Text="Lecturer ID"></asp:Label>

                :</td>

            <td>

                <asp:DropDownList ID="DropDownList1" runat="server"

                    DataSourceID="SqlDataSource1" DataTextField="LecturerId"

                    DataValueField="LecturerId" Height="16px" Width="145px">

                </asp:DropDownList>

                <asp:SqlDataSource ID="SqlDataSource1" runat="server"

                    ConnectionString="<%$ ConnectionStrings:SPS_DBConnectionString %>"

                    SelectCommand="SELECT [LecturerId] FROM [LecturerInfo]"></asp:SqlDataSource>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labRoom" runat="server" Text="Room"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtRoom" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labBuiding" runat="server" Text="Building:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtBuilding" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labSemester" runat="server" Text="Semester"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtSemester" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labYear" runat="server" Text="Year:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtYesr" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labDay" runat="server" Text="Day:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtDay" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labStartTime" runat="server" Text="Start Time:"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtStartTime" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                <asp:Label ID="labEndTime" runat="server" Text="End Time"></asp:Label>

            </td>

            <td>

                <asp:TextBox ID="txtEndTime" runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;</td>

        </tr>

        <tr>

            <td class="style1">

                &nbsp;</td>

            <td>

                <asp:Button ID="butSave" runat="server" Text="保存" onclick="butSave_Click" />

            </td>

            <td>

                &nbsp;</td>

        </tr>

    </table>

</asp:Content>

(9) Assessment Edit 页面源代码:

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="AssessmentEdit.aspx.cs" Inherits="Task4.AssessmentEdit" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

    <style type="text/css">

        .style1

        {

            height: 21px;

        }

    </style>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

 <h2>Assessment Modify </h2>

    <table style="width: 100%;">

        <tr>

            <td>

         

                Assessment Id:</td>

            <td>

         

                <asp:TextBox ID="txtId" CssClass="textEntry"  Enabled=false runat="server"></asp:TextBox>

            </td>

            <td>

                &nbsp;

            </td>

        </tr>

        <tr>

            <td class="style1">

             Assessment Title:

            </td>

            <td class="style1">

                

                <asp:TextBox ID="txtAssessmentTitle" CssClass="textEntry" runat="server"></asp:TextBox>

            </td>

            <td class="style1">

                &nbsp;

            </td>

        </tr>

        <tr>

            <td>

                Lecturer:</td>

            <td>

                <asp:DropDownList ID="ddlLecture" CssClass="textEntry" runat="server"

                    DataSourceID="SqlDataSource1" DataTextField="Name" DataValueField="LecturerId">

                </asp:DropDownList>

                <asp:SqlDataSource ID="SqlDataSource1" runat="server"

                    ConnectionString="<%$ ConnectionStrings:SPS_DBConnectionString %>"

                    SelectCommand="SELECT [LecturerId], [LastName]+'  '+[FirstName] [Name] FROM [LecturerInfo]">

                </asp:SqlDataSource>

            </td>

            <td>

                &nbsp;

            </td>

        </tr>

        <tr>

            <td class="style1">

             Assessment Description:

            </td>

            <td class="style1">

                

                <asp:TextBox ID="txtDesc" CssClass="textEntry" runat="server"

                   Height="80"  TextMode="MultiLine"></asp:TextBox>

            </td>

            <td class="style1">

                &nbsp;

            </td>

        </tr>

        <tr>

            <td>

                Assessment Type:</td>

            <td>

                <asp:DropDownList ID="ddlTypes" CssClass="textEntry" runat="server">

                <asp:ListItem Text="平时" Value="平时" />

                <asp:ListItem Text="期中" Value="期中" />

                <asp:ListItem Text="期末" Value="期末" />

                </asp:DropDownList>

            </td>

            <td>

                &nbsp;

            </td>

        </tr>

          <tr>

            <td class="style1">

             Create Date:

            </td>

            <td class="style1">

                

                <asp:TextBox ID="txtCreateDate" CssClass="textEntry" runat="server"></asp:TextBox>

            </td>

            <td class="style1">

                &nbsp;

            </td>

        </tr>

         <tr>

            <td class="style1">

             Due Date:

            </td>

            <td class="style1">

                

                <asp:TextBox ID="txtDueDate" CssClass="textEntry" runat="server"></asp:TextBox>

            </td>

            <td class="style1">

                &nbsp;

            </td>

        </tr>

         <tr>

            <td class="style1">

            

            </td>

            <td class="style1">

                

                <asp:Button ID="btnSave" runat="server" Text="Save" CssClass="submitButton"

                    onclick="btnSave_Click" /> 

            </td>

            <td class="style1">

                &nbsp;

            </td>

        </tr>

    </table>

</asp:Content>

4  程序运行与测试

1 功能表

2 功能实现

1)登陆界面连接数据库,通过数据信息与用户输入的信息进行比较,如果成功则成功登陆,否则提示输入错误。

5  实训总结

学生管理系统项目实训总结

班级:软件1217班        姓名:何震亚        学号:2012180653

学生成绩查询系统是为了方便教学管理人员进行成绩管理和统计而设计的。系统其有登录验证、成绩查询、数据维护、事件处理。新系统的生成经历了系统需求分析,系统可行性分析,系统性分析,系统设计四个部分,还应有系统实施,系统运行和维护。通过这次系统设计,我得到了更好的动手锻炼机会,不仅加强掌握了书本上的知识,而且做到了理论联系实际。先开始我只是按照书本的思路进行了简单的分析,并没有考虑到现实生活中学生成绩查询系统的工作流程以及涉及的人员不仅仅是学生和老师。在经过老师的指导和自己的调查后,我明白了系统是符合实际要求的,是为了满足现实世界的工作要求而设计的,并不是空想的结果,是需要在考虑现实工作流程经过仔细思考后而设计的。在设计过程中,我遇到 T 许多的困难,但在听过指导老师的讲解后,我的思路渐渐清晰,通过缤密的思考和查阅书籍,将问题逐一解决了。在此,谢谢老师的谆谆教导,我会进一步完善自己的知识和技术,将系统做得更好。随着学校规模的不断扩大,学生数量的急剧增加,有关学生的各种信息量也在不断成倍增长。面对庞大的信.息量,就需要有学生成绩管理系统来提高学生管理工作的效率。传统手工的学生成绩管理,管理过程繁琐而复杂,执行效率低,并且易于出错。通过这样的系统,我们可以做到信.息的规范管理和快速查询,实现了学生成绩管理的系统化、规范化和自动化,这样不仅减少了管理工作量,还提高了管理效率,降低了管理成本。在软件的编写过程中,我充分体会了软件编程工作者的辛苦,因为每一个细微的细节都必须十分的注意,如果稍有不慎,就会全盘皆输,而且往往很多的时候,程序我自己觉得非常的正确,但是就是编译通不过,在查找错误的过程中,面临着否认自己的过程,非常的痛苦,而且由于自己的经验及各方面的能力的不足,所以进展的速度非常的缓慢,往往几天的时间还没有一点进展。

在开始编写程序的时候,我看到别人的软件功能非常的详细,而且界面非常的漂亮,总希望自己的软件也非常的完善,但是,经过二个月的学习,发现编一个优秀的软件决不是一减而就的事情,需要长时间的积累和经验,而这个方面又是我的弱项,因此,在朋友的帮助下,我终于认清自己的不足及劣势,不要贪图大而全,只要尽我所能,编制一个实用简单的软件也是件很不容易的事情。在反反复复的学习及不耻下问之下,我的辛勤努力有了汇报,终于做出了一个简单的软件,虽然这个软件的功能非常的简单,而且我想,在实际的运用中,肯定会有所不足,因为学生成绩管理工作的内容非常的丰富,我涉及到的仅仅是学生管理的一部分简单内容,离实际的客户需求肯定还有一定的差距。在本系统的设计过程和论文编写过程中,很多系统管理员、同事和朋友都给与了我许多无私的帮助,尤其是老师给我的论文提出了很多宝贵的修改意见,在这里,我向这些无私帮助我的人表示衷心的感谢。

相关推荐