学生学籍管理系统课程设计报告

1、学生学籍管理系统1. 问题描述1.1 系统功能分析 1.2 系统功能模块设计 1 班级管理课程设置学生信息查询按政治面貌统计按成绩统计人数图 1 系统功能模块图2数据库系统设计2.1 需求分析 2.2 概念设计 2 N1N1MN图 2 系统 E-R图2.3 逻辑设计 表1-1 院系信息表可否为空列名说明departmentIDDepartmentnameNot nullNot null院系代码（主键）院系名称Vachar(50)表1-2 班级信息表列名可否为空Not nullNot null说明DepartmentIDstudentnumber院系代码（外键）班级人数smallint表1-3

2、课程信息表列名可否为空Not nullNot nullcoursenamescorehourdepartmentIDChar(20)院系代码（外键）表1-4 成绩信息表列名courseIDstudentIDscore数据类型Char(20)Char(20)smallint可否为空Not nullNot nul说明学生学号课程代码分数表1-5 学生信息表可否为空Not nullNot nullNationVarchar(10)Varcahr(50)Varchar(20)Varchar(50)Varchar(10)民族leavetype休复转退记录2.4 物理设计 0和 和 2.5 数据库实施和

3、, ;,(,3.系统实现3.1开发环境和3.2系统实现细节 和 3.3程序调试情况3.4 结论2.结束语参考文献RKCMC附录：源代码清单(部分)if (TextBox3.Text =)Response.Write(alert(请输入院系代码!););elseif (TextBox4.Text = )Response.Write(alert(请输入院系名称!););elseOleDbConnectionconn = new OleDbConnection(Provider=MSDAORA;DataSource=lab;PersistSecurity Info=true;User ID=scot

4、t;Password=tiger);string strVal = + TextBox3.Text +, + + TextBox4.Text +;string strIns = insert into department values( + strVal + ;/ Response.Write(strIns);/ Response.End();OleDbCommand insCom = new OleDbCommand(strIns, conn);conn.Open();insCom.ExecuteNonQuery();conn.Close();Response.Write(script 面

5、!););-if (txtbox1.Text = )Response.Write(alert(请输入班级代码!););elseif (txtbox2.Text = )Response.Write(alert(请输入班级名称!););elseif (txtbox3.Text = & txtbox4.Text = )Response.Write(alert(请填写详细信息););elseOleDbConnectionconn = new OleDbConnection(Provider=MSDAORA;DataSource=lab;PersistSecurity Info=true;User ID

6、=scott;Password=tiger);stringstrVal=+txtbox1.Text+,+txtbox2.Text+,+txtbox3.Text+ ,+ txtbox4.Text + ;string strIns = insert into class values( + strVal + );/Response.Write(strIns);/Response.End();OleDbCommand insCom = new OleDbCommand(strIns, conn);conn.Open();insCom.ExecuteNonQuery();conn.Close();Re

7、sponse.Write(alert(新纪录添加成功,请单击退出回到主页面!);); -if (TextBox1.Text =)Response.Write(alert(请输入学生学号!););elseif(TextBox2.Text =&TextBox3.Text = &TextBox4.Text =&TextBox5.Text= & TextBox2.Text = & TextBox6.Text = & TextBox7.Text = & TextBox8.Text =& TextBox9.Text = & TextBox10.Text = & TextBox11.Text = )Resp

8、onse.Write(alert(请输入详细信息!););elseOleDbConnectionconn = new OleDbConnection(Provider=MSDAORA;DataSource=lab;PersistSecurity Info=true;User ID=scott;Password=tiger);string strVal = + TextBox1.Text +, + + TextBox2.Text +, + +TextBox3.Text +, + TextBox4.Text+,+ TextBox5.Text +, +TextBox6.Text+, + TextBo

9、x7.Text +, + + TextBox8.Text +, + + TextBox9.Text +, + TextBox10.Text + , + + TextBox11.Text + ;string strIns = insert into student values( + strVal + );/Response.Write(strIns);/ Response.End();OleDbCommand insCom = new OleDbCommand(strIns, conn);tryconn.Open();insCom.ExecuteNonQuery();catch(Excepti

10、on ex)Response.Write(ex.Message);finallyconn.Close();Response.Write(script 面!););-string str;intcount = 0;str= select COUNT(*) from student where age= + TextBox1.Text + ;OleDbConnection conn = new OleDbConnectionProvider=MSDAORA;DataSource=lab;PersistSecurity Info=true;User ID=scott;Password=tiger);

11、conn.Open();OleDbCommand com =new OleDbCommand(str, conn);OleDbDataReaderdr = com.ExecuteReader();if (dr.Read()count = Int32.Parse(dr0.ToString();dr.Close();conn.Close();Label2.Text = count.ToString();string str;intcount = 0;str = select COUNT(*) from student where nativeplace= + TextBox2.Text + ;Ol

12、eDbConnectionconn = new OleDbConnection(Provider=MSDAORA;DataSource=lab;PersistSecurity Info=true;User ID=scott;Password=tiger);conn.Open();OleDbCommand com =new OleDbCommand(str, conn);OleDbDataReaderdr = com.ExecuteReader();if (dr.Read()count = Int32.Parse(dr0.ToString();dr.Close();conn.Close();La

13、bel3.Text = count.ToString();str = select COUNT(*) from student where status= + DropDownList1.Text + ;int i,j;if(DropDownList2.SelectedIndex =0)i = 90;j = 100;elseif (DropDownList2.SelectedIndex = 1)i = 80;j = 90;elseif (DropDownList2.SelectedIndex = 2)i = 70;j = 80;elseif (DropDownList2.SelectedInd

14、ex = 3)i = 60;j = 70;elsei = 0;j= 60;string str;intcount = 0;str = select COUNT(*) from score s,course c where s.courseID=c.courseID ANDc.coursename=+DropDownList3.SelectedItem.Text+ +AND score + i+ AND score +j ;OleDbConnection conn = new OleDbConnectionProvider=MSDAORA;DataSource=lab;Persist Secur

15、ityInfo=true;User ID=scott;Password=tiger);conn.Open();OleDbCommand com =new OleDbCommand(str, conn);OleDbDataReaderdr = com.ExecuteReader();if (dr.Read()count = Int32.Parse(dr0.ToString();dr.Close();conn.Close();Label5.Text = count.ToString();-if (TextBox1.Text =)Response.Write(alert(请输入学生学号!););/*

16、else if (TextBox2.Text = )Response.Write(alert(请输入学生姓名!););TextBox2.Text = ;*/elseOleDbConnectionconn = new OleDbConnection(Provider=MSDAORA;DataSource=lab;PersistSecurity Info=true;User ID=scott;Password=tiger);conn.Open();String str =select studentID 学号 ,studentname 姓名,classID班级名称,departmentID院系代码,sex性别,age年龄,nation民族,nativ