摘要
隨著信息技術(shù)在管理上越來越深入而廣泛的應(yīng)用，管理信息系統(tǒng)的實(shí)施在技術(shù)上已逐步成熟。管理信息系統(tǒng)是一個(gè)不斷發(fā)展的新型學(xué)科，任何一個(gè)單位要生存要發(fā)展，要高效率地把內(nèi)部活動(dòng)有機(jī)地組織起來，就必須建立與自身特點(diǎn)相適應(yīng)的管理信息系統(tǒng)。
本文采用JSP和MS SQL-Server等軟件為開發(fā)工具，以Windows XP（或Windows 2000）為開發(fā)平臺(tái)，設(shè)計(jì)出一個(gè)學(xué)籍管理信息系統(tǒng)，對(duì)學(xué)生的信息進(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)、各種信息查詢子系統(tǒng)以及系統(tǒng)維護(hù)子系統(tǒng)。
該系統(tǒng)功能完善，可使高校的學(xué)籍管理系統(tǒng)從純手工中解脫出來，實(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 2005

















Based on WEB 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, 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.
Key words: Student school records management ;B/S; JSP; SQL SERVER 2005.
目 錄
ABSTRACT III
引 言 2
第一章 緒論 4
1.1選題背景和意義 4
1.3系統(tǒng)開發(fā)技術(shù) 5
1.3.1 B/S體系結(jié)構(gòu) 5
1.3.2 SQL SERVER 2005 6
1.3.3 JSP技術(shù) 7
1.3.4 ODBC數(shù)據(jù)訪問接口 7
1.3.5 JDBC數(shù)據(jù)訪問接口 9
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ì)思想 10
2.2.3 系統(tǒng)功能描述 10
2.2.4系統(tǒng)用例圖 13
2.2.5系統(tǒng)UML活動(dòng)圖 15
第三章 數(shù)據(jù)庫設(shè)計(jì) 17
3.1總體表設(shè)計(jì) 17
3.2 數(shù)據(jù)庫表的結(jié)構(gòu) 17
3.3 實(shí)體及ER圖 18
3.3.1 登錄管理 18
3.3.2實(shí)體的ER圖 18
第四章 系統(tǒng)具體實(shí)現(xiàn) 19
4.1 關(guān)鍵應(yīng)用 19
4.1.1數(shù)據(jù)庫連接 19
4.2 登錄管理 22
4.3 菜單界面 23
4.4 系統(tǒng)管理 24
4.4.1學(xué)生信息顯示頁面 24
4.4.2學(xué)生信息修改頁面 25
4.4.3添加學(xué)生信息頁面 25
4.4.4篩選 26
4.5 學(xué)生管理頁面 27
4.5.1學(xué)籍維護(hù)頁面 27
4.5.2公告查看頁面 28
4.5.3班級(jí)建設(shè)頁面 29
4.5.4同學(xué)搜索 29
4.5.5班級(jí)相冊(cè) 30
第五章 全文總結(jié) 31
致 謝 32
參考文獻(xiàn)： 33