学生信息管理系统毕业论文

1、西安职业技术学院动漫软件学院毕 业 设 计题 目学生信息管理系统学 院动漫软件学院专 业软件技术班 级0761姓 名陈勋指导教师陈琨2010年-07月-07日独 创 性 声 明本人声明所呈交的学位论文是本人在导师指导下进行的研究工作及取得的研究成果。据我所知，除了文中特别加以标注和致谢的地方外，论文中不包含其他人已经发表或撰写过的研究成果，也不包其他教育机构的学位或证书而使用过的材料。与我一同工作的同志对本研究所做的任何贡献均已在论文中作了明确的说明并表示谢意。学位论文作者签名： 签字日期： 2010 年 07月 07 日学位论文版权使用授权书 本学位论文作者完全了解西安职业技术学院有关保留、

2、使用学位论文的规定，有权保留并向国家有关部门或机构送交论文的复印件和磁盘，允许论文被查阅和借阅。本人授权 西安职业技术学院 可以将学位论文的全部或部分内容编入有关数据库进行检索，可以采用影印、缩印或扫描等复制手段保存、汇编学位论文。（保密的学位论文在解密后适用本授权书）学位论文作者签名： 导师签名：签字日期： 2010 年 07月 07日 签字日期：2010 年 07 月 07 日 绪论学生信息管理系统是一个教育单位不可缺少的部分，它的内容对于学校的决策者和管理者来说都至关重要。本文介绍了学生信息管理系统的开发整个过程，阐述了系统分析、系统设计、数据库设计和系统实施的全过程。在开发方法上本系统

3、利用了软件工程化的思想和方法，总体上采用结构化生命周期开发方法，具体模块实施采用了原型法和面向对象系统开发方法。并采用VisualS2005作为开发工具，SQL Server 2000作为后台数据库。本系统具有学生档案管理,班级管理,课程管理,成绩管理，专业管理等模块,可分别完成日常学生档案，班级信息，课程信息，成绩信息的添加、修改、删除、查询、打印等功能。 本人在此次毕业设计中主要对“学生课程管理”，“学生成绩管理”，“学生档案管理”，“补助管理”四个模块进行了具体设计。关键字：信息管理系统、生命周期、软件工程、原型法。SummaryStudent Information

4、Management System is an educational unit indispensable part of its content for the schools, policy makers and managers are essential. This paper introduces the student information management system for the development of the whole process, described the system analysis, system design, database desig

5、n and system implementation of the entire process. In the development of methods on the use of the software engineering system of thinking and methods used on the whole structure of the life cycle of development methods, the use of specific modules of the prototype system development and object-orie

6、nted approach. Visual S2005 and used as a development tool, SQL Server 2000 as a background database. This system has the student records management, class management, curriculum management, performance management, professional management, and other modules, can be completed daily student r

7、ecords, class information, information on the courses, the results of information add, edit, delete, query, print, and other functions. I graduated in the design of the main student curriculum management, Student performance management, student records management, grant management four modules of a

8、specific design.Keyword:Manage Information management system, the life-cycle, software engineering, prototype. 学生信息管理系统一、系统功能分析：功能分析：学生信息管理系统属应用系统。系统是一个集成多功能的信息管理系统，有教师资料管理、学生管理、班级管理、专业管理、课程管理、成绩管理和院系管理功能模块。本系统将大大提高学生信息的管理效率，带来数据共享、网络查询和网络管理等便利，实现学生信息管理的数字化和智能化。1. 模块划分（整个系统功能结构图）系统结构图用户登录教师管理学生管理课程管

9、理成绩管理班级管理教师资料管理教师资料添加学生资料管理学生资料添加学生所在院系资料课程资料管理课程资料添加学生成绩查询学生成绩录入学生所在专业资料课程类别资料班级资料管理班级资料添加关系图2. 各模块功能简介 登录模块：本模块主要为用户登录，权限验证，管理员添加，实现系统的多用户管理功能，不同权限的用户，可对其进行不同功能的管理。 教师管理模块：本模块主要对教师的资料信息进行查询，删除，修改和添加。 学生管理模块：本模块主要对学生资料信息进行相应的查询，删除，修改和添加。添加了学生所在院系资料与学生所在专业资料，同时可对院系资料与专业资料进行相应的添加，修改，查询。 课程管理模块：本模块主要对

10、课程资料进行管理，对其进行查询，添加，修改和删除。又详细划分了课程类别资料，对其进行如上操作。 成绩管理模块：本模块对学生成绩进行查询操作，如发现成绩有输入错误，可对其进行相应的修改，还可对学生的成绩进行录入 班级管理模块：本模块班级资料信息进行管理，对其进行相应的查询，修改，删除和添加。二、 数据库设计根据学生管理系统所要求的数据信息，创建数据库SMSStudent ，根据各模块可创建如下数据表，其字段名，数据类型等内容如下：表1 users系统用户表列名数据类型可否为空说明idCHAR(10)NOT NULL用户帐号(主键)pwdCHAR(10)NULL用户密码nameCHAR(10)NU

11、LL用户名(2)学生信息表用于存放学生信息管理系统的学生基本信息。表中各个字段的数据类型及简短描述如表2所示。表2 students学生基本信息表列名数据类型可否为空说明idCHAR(10)NOT NULL学号(主键)nameCHAR(10)NULL学生姓名sexCHAR(4)NULL学生性别birthDATETIMENULL出生日期intimeDATETIMENULL入学日期classVARCHAR(20)NULL班级comefromVARCHAR(50)NULL籍贯beizhuVARCHAR(50)NULL备注(3)课程信息表存放学生信息管理系统的课程基本信息。表中各个字段的数据类型及简短

12、描述如表3所示。表3 course课程信息表列名数据类型可否为空说明courseidINT(4)NOT NULL课程编号(主键)coursenameCHAR(10)NULL课程名称timeCHAR(10)NULL学时creditFLOAT(8)NULL学分typeCHAR(10)NULL类型(4)学生成绩表存放学生信息管理系统的学生成绩信息。表中各个字段的数据类型及简短描述如表4所示。表4 score成绩信息表列名数据类型可否为空说明idCHAR(10)NOT NULL学号(主键/外码)courseidINT(4)NOT NULL课程编号(主键/外码)teacherCHAR(10)NULL教师

13、scoreNUMERICNULL分数yearCHAR(10)NULL学年1.系统中模块使用的存储过程本数据库共创建3处存储过程，其存储过程为：教师资料查询（teacher.aspx页面）Employess_Sel 存储过程：CREATE PROCEDURE dbo.Employess_Sel lastname nvarchar (20),department varchar (30)ASselect teacherid,teachername,department.departmentid,department.departmentname,sex,telephone from teacher

14、,department where teacher.departmentid=department.departmentid and ( teachername like % + lastname + % and department.departmentname=department)学生资料查询（student.aspx页面）Student_Sel 存储过程：CREATE PROCEDURE dbo.Student_Sel lastname nvarchar (20),department varchar (30),studentid varchar(10)ASselect * from

15、student,class where student.classid=class.classid and ( studentname like % + lastname + % or studentid=studentid ) and class.classname=department)管理员添加（register.aspx页面）procAdmin 存储过程：CREATE procedure cAdminAuser char(10),Apwd varchar(50),Atype varchar(20)ASinsert into users(username,mypasswor

16、d,usertype) values(Auser,Apwd,Atype)三、各模块页面设计，具体功能实现1. 学生信息管理系统总括：开发环境：Microsoft Visual Studio 2005开发语言：C#，JavaScript数据库： Microsoft SQL Server 2005辅助工具：Adobe Photoshop CS2，Dreamweaver MX 2004整体页面架构： 框架集（crm_admin_main.htm）（Width=763） 如上图所示 四个框架内容文件：（top.htm, left.htm, switch.htm, body.htm）1. top.htm

17、页面：JavaScript 特效rain.js(详细代码见项目)；2. left.htm页面：JavaScript 级联菜单，全部由JavaScript生成，通过数组定义子菜单，可任意添加目录项与级联子项，程序可扩展性良好。3. switch .htm页面：JavaScript 作开关按钮，实现框架的展开与合并功能。4. body.htm页面：定位框架的主内容文件。（主要是aspx文件的定位：后面加xxx.aspx target=mainFrame。例如：item_link20=student.aspx target=mainFrame;）注：本页面由Dreamweaver MX 2004实现

18、，经JavaScript代码进行修改而成。2. 全局配置文件：数据库访问类connDB.cs public static SqlConnection createConn() string sms_connstr = System.Configuration.ConfigurationManager.ConnectionStringscon.ToString(); SqlConnection conn = new SqlConnection(sms_connstr); return conn; 1. Web.Config文件配置信息：数据库连接字符串2.Web.sitemap文件配置整个站点的

19、层次结构以学生管理为例，站点地图代码如下： 3. SiteMapPath控件 SiteMapPath控件数据内容由Web.sitemap文件自动导航2.登录界面及代码：using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebPar

20、ts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class login : System.Web.UI.Page SqlConnection sms_conn; public int PageCount, PageSize, RecordCount, CurrentPage; protected void Page_Load(object sender, EventArgs e) string sms_connstr =System.Configuration.Configuratio

21、nManager.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=+mypassword.Te

22、xt+; SqlCommand cmd = new SqlCommand(sqlstr,sms_conn); sms_conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read() = true) Sessionuser = this.username.Text.Trim();/管理员用户,利用Session进行传值 Sessiontype = druserType.ToString().Trim();/管理员类型 Response.Redirect(crm_admin_main.htm); sms_conn.Close()

23、; else sms_conn.Close(); message.Text = 您必须输入有效的用户名和密码！; 3.teachers的界面及代码：using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using S

24、ystem.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class teacher : System.Web.UI.Page SqlConnection sms_conn;string sms_sqlstr,sms_sqlstr2; private void Page_Load(object sender, System.EventArgs e) string sms_connstr = System.Configuration.ConfigurationManager.AppSettingssms_dbconn

25、; sms_conn = new SqlConnection(sms_connstr); if (!IsPostBack) SMS_BindGrid(); 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.EditI

26、temIndex = (int)e.Item.ItemIndex; SMS_BindGrid(); public void DataGrid_cancel(object sender, DataGridCommandEventArgs e) sms_teacher.EditItemIndex = -1; SMS_BindGrid(); public void DataGrid_delete(object sender, DataGridCommandEventArgs e) string sms_sqlstr = delete from teacher where Teacherid=teac

27、her_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(); trysms_comm.ExecuteNonQuery();sms_lbl_note.Text =

28、删除成功; catch (SqlException)sms_lbl_note.Text = 删除失败;sms_lbl_note.Stylecolor =red; sms_comm.Connection.Close(); SMS_BindGrid(); public void SMS_BindGrid() sms_sqlstr = select teacherid,teachername,department.departmentid,department.departmentname,sex,telephone from teacher,department where teacher.dep

29、artmentid=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

30、_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(); protected void Button1_Click(object sender, EventArgs e)

31、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.NVarC

32、har); sms_da.SelectCommand.Parameters.Add(department, SqlDbType.VarChar,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.Fi

33、ll(sms_ds); sms_teacher.DataSource = sms_ds; sms_teacher.DataBind();4. teacherlist的界面及代码：using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.W

34、ebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class teacherlist : System.Web.UI.PageSqlConnection sms_conn; string sms_sqlstr, sms_sqlstr2; private void Page_Load(object sender, System.EventArgs e) string sms_connstr = System.Configuration.ConfigurationManager.A

35、ppSettingssms_dbconn; sms_conn = new SqlConnection(sms_connstr); if (!IsPostBack) SMS_BindGrid(); public void SMS_BindGrid() TextBox1.Text = Request.QueryStringid; sms_sqlstr = select * from teacher,department where Teacherid= + TextBox1.Text + and teacher.departmentid=department.departmentid; sms_c

36、onn.Open(); SqlDataAdapter sms_da = new SqlDataAdapter(sms_sqlstr, sms_conn); DataSet sms_ds = new DataSet(); sms_da.Fill(sms_ds,table1); TextBox2.Text = sms_ds.Tablestable1.Rows0teachername.ToString(); RadioButtonList1.SelectedValue= sms_ds.Tablestable1.Rows0sex.ToString(); DropDownList3.SelectedIt

37、em.Text = sms_ds.Tablestable1.Rows0departmentname.ToString(); DropDownList2.SelectedItem.Text= sms_ds.Tablestable1.Rows0technicalpost.ToString(); TextBox8.Text = sms_ds.Tablestable1.Rows0telephone.ToString(); TextBox7.Text = sms_ds.Tablestable1.Rows0homeaddr.ToString(); TextBox9.Text = sms_ds.Tables

38、table1.Rows0pwd.ToString(); TextBox6.Text = sms_ds.Tablestable1.Rows0remark.ToString(); sms_ds.Clear(); sms_ds.Dispose(); sms_conn.Close(); sms_sqlstr2 = select * from department; protected void Button1_Click(object sender, EventArgs e) string sms_sqlstr = update teacher set Teachername= + TextBox2.

39、Text + ,sex= + RadioButtonList1.SelectedItem.Text + ,technicalpost= + DropDownList2.SelectedItem.Text + ,telephone= + TextBox8.Text + ,homeaddr= + TextBox7.Text + ,pwd= + TextBox9.Text + ,remark= + TextBox6.Text + ,departmentid= + DropDownList3.SelectedValue.ToString() + where Teacherid= + TextBox1.

40、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(); SMS_BindGrid(); protected void Button3

41、_Click(object sender, EventArgs e) Response.Redirect(teacher.aspx); protected void Button2_Click(object sender, EventArgs e) SMS_BindGrid(); 5.addteacher的界面及代码：using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.W

42、eb.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class addteacher : System.Web.UI.Page SqlConnection sms_conn; string sms_sqlstr; private void Page_Load(object sender, System.EventArgs e) string

43、 sms_connstr = System.Configuration.ConfigurationManager.AppSettingssms_dbconn; sms_conn = new SqlConnection(sms_connstr); protected void Button1_Click(object sender, EventArgs e) string sms_sqlstr = insert into teacher (Teachername,sex,technicalpost,telephone,homeaddr,pwd,remark,departmentid,teache

44、rid) 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_sqlst

45、r, 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 Button3_Click(object sender, EventArgs e) Response.Redirect(teacher.asp

46、x); protected void TextBox6_TextChanged(object sender, EventArgs e) 6.Student界面及代码： using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web

47、.UI.WebControls;using System.Web.UI.HtmlControls;using System.Configuration;public partial class student : System.Web.UI.Page SqlConnection sms_conn; string sms_sqlstr, sms_sqlstr2, str; 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