在線選課系統(tǒng)的設(shè)計與實現(xiàn)
摘  要
由于學校教學制度的改革，現(xiàn)在大部分高等院校開始實行的是學生的自主選課模式，傳統(tǒng)的教學模式（學生按照學校安排好的課程上課）已經(jīng)不能適應(yīng)新型的教學手段，如果仍然通過紙上的方式選課，一方面浪費的大量的人力、物力資源，另一方面浪費時間以及在人為的統(tǒng)計過程中不可避免出現(xiàn)的差錯等情況。隨著高校人數(shù)的增多，這種弊端會越來越多的暴露出來。在線選課系統(tǒng)的實現(xiàn)顯得尤為必要。針對學生選課這一環(huán)節(jié)，本系統(tǒng)從學生網(wǎng)上自主選課以及教師的課程發(fā)布和管理員信息管理三個大方面進行了設(shè)計，基本實現(xiàn)了學生的在線信息查詢、選課功能以及教師對課程信息發(fā)布的管理和管理員對學生和教師信息的管理等功能。

關(guān)鍵詞：在線選課；B/S 結(jié)構(gòu)；JSP；J2EE；MySQL； 

Online Course Selection System Design and Implementation
Abstract 
As the reform of school education, most colleges and universities are now beginning to implement the student's own course selection patterns, the traditional teaching model (the students arranged in accordance with school curriculum classes) can not adapt to new teaching methods, if they remain on paper on the way to course selection, on the one hand and waste a lot of manpower, material resources, on the other hand a waste of time and in the process of artificial statistical errors inevitably occur and so on. With the increasing number of universities, such shortcomings would be exposed more and more. Online Course Selection System is particularly essential. Elective for students in this part of the system independently from the online course selection students and teachers and administrators released information management courses are three major aspects of the design, the basic realization of the students online information inquiry, course selection function as well as teachers of the curriculum information dissemination management and administrators to students and teachers to information management.
Key Words: Online course selection; B / S structure; JSP; J2EE; MySQL;

目  錄
摘  要 I
Abstract II
前  言 １
1設(shè)計的可行性 ２
1.1系統(tǒng)的產(chǎn)生和發(fā)展情況 ２
1.2網(wǎng)上選課系統(tǒng)的產(chǎn)生和可行性分析 ３
1.2.1 網(wǎng)上選課系統(tǒng)的產(chǎn)生 ３
1.2.2 網(wǎng)上選課系統(tǒng)的可行性 ３
2 相關(guān)軟件及技術(shù)介紹 ４
2.1 Myeclipse 6.5 ４
2.2 MySQL 5.0 ４
2.3 Tomcat 5.5 ５
2.4 HTML 語言介紹 ６
2.5  JSP 介紹 ６
2.6 J2EE 技術(shù)介紹 ７
2.7 Struts 框架 ８
2.8 Hibernate 框架 ９
3系統(tǒng)概述 ９
3.1 項目范圍 ９
3.2 設(shè)計策略 １０
4系統(tǒng)總體設(shè)計 １０
4.1 系統(tǒng)結(jié)構(gòu)設(shè)計 １０
4.1.2 模塊間的調(diào)用關(guān)系 １１
4.1.3系統(tǒng)功能結(jié)構(gòu) １４
5 數(shù)據(jù)庫設(shè)計說明 １５
5.1數(shù)據(jù)庫系統(tǒng)分析 １５
5.2 數(shù)據(jù)庫邏輯設(shè)計 １９
5.3 數(shù)據(jù)庫設(shè)計 ２０
6 詳細設(shè)計 ２３
6.1 教師/學生/管理員登錄功能 ２３
6.2 學生選課功能 ２８
6.3 教師添加課程： ３０
6.4 管理員操作 ３２
7 設(shè)計過程中的問題及解決 ３４
7.1 數(shù)據(jù)庫的連接 ３４
7.2 參數(shù)的傳遞 ３４
7.3 公共數(shù)據(jù) ３４
8 總結(jié) ３５
參 考 文 獻 ３６
致　 謝 ３７