【正文】 在線選課系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 摘 要 由于學(xué)校教學(xué)制度的改革，現(xiàn)在大部分高等院校開始實(shí)行的是學(xué)生的自主選課模式，傳統(tǒng)的教學(xué)模式（學(xué)生按照學(xué)校安排好的課程上課）已經(jīng)不能適應(yīng)新型的教學(xué)手段，如果仍然通過(guò)紙上的方式選課，一方面浪費(fèi)的大量的人力、物力資源，另一方面浪費(fèi)時(shí)間以及在人為的統(tǒng)計(jì)過(guò)程中不可避免出現(xiàn)的差錯(cuò)等情況。隨著高校人數(shù)的增多，這種弊端會(huì)越來(lái)越多的暴露出來(lái)。在線選課系統(tǒng)的實(shí)現(xiàn)顯得尤為必要。 針對(duì)學(xué)生選課這一環(huán)節(jié)，本系統(tǒng)從學(xué)生網(wǎng)上自主選課以及教師的課程發(fā)布和管理員信息管理三個(gè)大方面進(jìn)行了設(shè)計(jì)，基本實(shí)現(xiàn)了學(xué)生的在 線信息查詢、選課功能以及教師對(duì)課程信息發(fā)布的管理 和管理員對(duì)學(xué)生和教師信息的管理等功能。 關(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 student39。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 shortings 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è)計(jì)的可行性 ..............................................................................................................２ 系統(tǒng)的產(chǎn)生和發(fā)展情況 .....................................................................................２ 網(wǎng)上選課系統(tǒng)的產(chǎn)生和可行性分析 ...................................................................３ 網(wǎng)上選課系統(tǒng)的產(chǎn)生 ..............................................................................３ 網(wǎng)上選課系統(tǒng)的可行性 ..........................................................................３ 2 相 關(guān)軟件及技術(shù)介紹 ..................................................................................................４ Myeclipse .....................................................................................................４ MySQL .........................................................................................................４ Tomcat .........................................................................................................５ HTML 語(yǔ)言介紹 ...............................................................................................５ JSP 介紹 ...................................................................................................６ J2EE 技術(shù)介紹 ..................................................................................................７ Struts 框架 ........................................................................................................８ Hibernate 框架 ..................................................................................................８ 3 系統(tǒng)概述 .....................................................................................................................９ 項(xiàng)目范圍 ..........................................................................................................９ 設(shè)計(jì)策略 ..........................................................................................................９ 4 系統(tǒng)總體設(shè)計(jì) .......................................................................................................... １０ 系統(tǒng) 結(jié)構(gòu)設(shè)計(jì) ............................................................................................... １０ 模塊間的調(diào)用關(guān)系 .............................................................................. １１ 系統(tǒng)功能結(jié)構(gòu) ...................................................................................... １４ 5 數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明 ...................................................................................................... １５ 數(shù)據(jù)庫(kù)系統(tǒng)分析 ............................................................................................ １５ 數(shù)據(jù)庫(kù)邏輯設(shè)計(jì) ........................................................................................... １９ 數(shù)據(jù)庫(kù)設(shè)計(jì) ................................................................................................... １９ 6 詳細(xì)設(shè)計(jì) ................................................................................................................. ２３ 教師 /學(xué)生 /管理員登錄功能 ........................................................................... ２３ 學(xué)生選課功能 ............................................................................................... ２９ 教師添加課程： ........................................................................................... ３１ 管理員操作 ................................................................................................... ３３ 7 設(shè)計(jì)過(guò)程中的問(wèn)題及解決 ....................................................................................... ３６ 數(shù)據(jù) 庫(kù)的連接 ............................................................................................... ３６ 參數(shù)的傳遞 ................................................................................................... ３６ 公共數(shù)據(jù) ...................................................................................................... ３６ 8 總結(jié) ......................................