基于JSP的學(xué)生學(xué)籍管理系統(tǒng)

摘要
隨著信息技術(shù)在管理上越來(lái)越深入而廣泛的應(yīng)用，管理信息系統(tǒng)的實(shí)施在技術(shù)上已逐步成熟。管理信息系統(tǒng)是一個(gè)不斷發(fā)展的新型學(xué)科，任何一個(gè)單位要生存要發(fā)展，要高效率地把內(nèi)部活動(dòng)有機(jī)地組織起來(lái)，就必須建立與自身特點(diǎn)相適應(yīng)的管理信息系統(tǒng)。
本文采用JSP和MS SQL-Server等軟件為開(kāi)發(fā)工具，以Windows XP（或Windows 2000）為開(kāi)發(fā)平臺(tái)，設(shè)計(jì)出一個(gè)學(xué)籍管理信息系統(tǒng)，對(duì)學(xué)生的信息、課程、成績(jī)進(jìn)行統(tǒng)一管理，便于查詢、修改和刪除。涉及到的主要內(nèi)容有：體系結(jié)構(gòu)規(guī)劃、設(shè)計(jì)平臺(tái)的搭建以及系統(tǒng)的設(shè)計(jì)。主要實(shí)現(xiàn)的功能模塊有管理系統(tǒng)的功能介紹子系統(tǒng)、新生入學(xué)子系統(tǒng)、學(xué)生成績(jī)管理子系統(tǒng)、在校學(xué)生管理子系統(tǒng)、離校學(xué)生管理子系統(tǒng)、各種信息查詢子系統(tǒng)以及系統(tǒng)維護(hù)子系統(tǒng)。
該系統(tǒng)功能完善，可使高校的學(xué)籍管理系統(tǒng)從純手工中解脫出來(lái)，實(shí)現(xiàn)高校學(xué)籍管理系統(tǒng)自動(dòng)化、規(guī)范化、合理化、科學(xué)化，其實(shí)用性強(qiáng)，用戶界面友好，有助于加快高校的信息傳遞和智能建設(shè)，并為高校整體實(shí)現(xiàn)信息化管理體系作好鋪墊。
關(guān)鍵字：學(xué)生學(xué)籍管理； B/S；JSP;SQL SERVER 2000；JDBC-ODBC；

Based on JSP student records management system
Abstract
    Along with information technology in management more and more thorough and widespread application, the management information system the implementation to be gradually mature in the technology. The management information system is the new discipline which unceasingly develops, any unit must survive and develop, wants the high efficiency organically to organize the internal activity, must establish the management information system which adapts with own characteristic.
    This article uses JSP and MS SQL-Server and so on is the development kit, (or Windows 2,000) as develops the platform take Windows XP, designs a school register management information system, to student's information, the curriculum, the result carries on the unification management, is advantageous for the inquiry, the revision and the deletion. Involves the main content includes: The system structure plan, designs the platform to build as well as the system design. The main realization function module has the management system management system the function to introduce the subsystem, the new born matriculation subsystem, the student result management subsystem, manages the subsystem in the school student, manages the subsystem, each kind of information inquiry subsystem as well as the system maintenance subsystem to the school student.
    This system function perfect, may cause the universities the school register management system to extricate from the pure handwork, realization universities school register management system automation, standardization, rationalization, scientific style, its usability strong, the user contact surface is friendly, is helpful to speeds up the universities the information transmission and the intelligent construction, and finishes the upholstery for the universities whole realization information management system.
Keywords: Student school records management ；B/S; JSP; SQL SERVER 2000; JDBC-ODBC
目  錄
摘要 I
ABSTRACT II
引言 3
第一章   緒論 4
1.1選題背景和意義 4
1.3系統(tǒng)開(kāi)發(fā)技術(shù) 5
1.3.1 B/S體系結(jié)構(gòu) 5
1.3.2 SQL SERVER 2000 6
1.3.3  JSP技術(shù) 7
1.3.4  ODBC數(shù)據(jù)訪問(wèn)接口 7
1.3.5 JDBC數(shù)據(jù)訪問(wèn)接口 8
1.3.6 JAVASCRIPT 9
第二章 系統(tǒng)設(shè)計(jì) 10
2.1需求分析 10
2.1.1運(yùn)行環(huán)境 10
2.2系統(tǒng)總體設(shè)計(jì) 10
2.2.1 系統(tǒng)目標(biāo)設(shè)計(jì) 10
2.2.2 系統(tǒng)設(shè)計(jì)思想 11
2.2.3 系統(tǒng)功能描述 11
2.2.4系統(tǒng)用例圖 14
2.2.5系統(tǒng)UML活動(dòng)圖 16
第三章 數(shù)據(jù)庫(kù)設(shè)計(jì) 18
3.1總體表設(shè)計(jì) 18
3.2 數(shù)據(jù)庫(kù)表的結(jié)構(gòu) 18
3.3 實(shí)體及ER圖 20
3.3.1 登錄管理 20
3.3.2實(shí)體的ER圖 21
3.4 數(shù)據(jù)庫(kù)表的關(guān)系圖 23
3.5 數(shù)據(jù)庫(kù)表的視圖 24
第四章 系統(tǒng)具體實(shí)現(xiàn) 25
4.1 關(guān)鍵應(yīng)用 25
4.1.1數(shù)據(jù)庫(kù)連接 25
4.2 登錄管理 28
4.3 菜單界面 29
4.4 系統(tǒng)管理 30
4.4.1學(xué)生信息顯示頁(yè)面 30
4.4.2學(xué)生信息修改頁(yè)面 33
4.4.3添加學(xué)生信息頁(yè)面 33
4.4.4成績(jī)查看頁(yè)面 34
4.5課程管理 35
4.5.1選修課表顯示 35
4.5.2選課情況頁(yè)面 36
4.6 學(xué)生管理頁(yè)面 37
4.6.1學(xué)籍維護(hù)頁(yè)面 38
4.6.2成績(jī)查看頁(yè)面 40
4.6.3學(xué)生選修課表頁(yè)面 40
4.6.4所選的課程 41
4.6.5修改個(gè)人密碼 42
第五章 全文總結(jié) 44
致  謝 45
參考文獻(xiàn)： 46