學(xué)生學(xué)籍管理系統(tǒng)課程設(shè)計報告

1、學(xué)生學(xué)籍管理系統(tǒng)1. 問題描述1.1 系統(tǒng)功能分析 1.2 系統(tǒng)功能模塊設(shè)計 1 班級管理課程設(shè)置學(xué)生信息查詢按政治面貌統(tǒng)計按成績統(tǒng)計人數(shù)圖 1 系統(tǒng)功能模塊圖2數(shù)據(jù)庫系統(tǒng)設(shè)計2.1 需求分析 2.2 概念設(shè)計 2 N1N1MN圖 2 系統(tǒng) E-R圖2.3 邏輯設(shè)計 表1-1 院系信息表可否為空列名說明departmentIDDepartmentnameNot nullNot null院系代碼（主鍵）院系名稱Vachar(50)表1-2 班級信息表列名可否為空Not nullNot null說明DepartmentIDstudentnumber院系代碼（外鍵）班級人數(shù)smallint表1-3

2、課程信息表列名可否為空Not nullNot nullcoursenamescorehourdepartmentIDChar(20)院系代碼（外鍵）表1-4 成績信息表列名courseIDstudentIDscore數(shù)據(jù)類型Char(20)Char(20)smallint可否為空Not nullNot nul說明學(xué)生學(xué)號課程代碼分?jǐn)?shù)表1-5 學(xué)生信息表可否為空Not nullNot nullNationVarchar(10)Varcahr(50)Varchar(20)Varchar(50)Varchar(10)民族leavetype休復(fù)轉(zhuǎn)退記錄2.4 物理設(shè)計 0和 和 2.5 數(shù)據(jù)庫實施和

3、, ;,(,3.系統(tǒng)實現(xiàn)3.1開發(fā)環(huán)境和3.2系統(tǒng)實現(xiàn)細(xì)節(jié) 和 3.3程序調(diào)試情況3.4 結(jié)論2.結(jié)束語參考文獻(xiàn)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(請?zhí)顚懺敿?xì)信息););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(新紀(jì)錄添加成功,請單擊退出回到主頁面!);); -if (TextBox1.Text =)Response.Write(alert(請輸入學(xué)生學(xué)號!););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(請輸入詳細(xì)信息!););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(請輸入學(xué)生學(xué)號!););/*

16、else if (TextBox2.Text = )Response.Write(alert(請輸入學(xué)生姓名!););TextBox2.Text = ;*/elseOleDbConnectionconn = new OleDbConnection(Provider=MSDAORA;DataSource=lab;PersistSecurity Info=true;User ID=scott;Password=tiger);conn.Open();String str =select studentID 學(xué)號 ,studentname 姓名,classID班級名稱,departmentID院系代碼,sex性別,age年齡,nation民族,nativ