【正文】 ................................................... 6 SQL Server2020數(shù)據(jù)庫(kù) .............................................................................................. 6 PowerDesiner .............................................................................................................. 6 3 教務(wù)管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) .................................................................................................. 7 開(kāi)發(fā)和運(yùn)行環(huán)境選擇 ............................................................................................................. 7 系統(tǒng)設(shè)計(jì) .............................................................................................................................. 7 系統(tǒng)功能分析 ............................................................................................................. 7 系統(tǒng)功能模塊設(shè)計(jì) ...................................................................................................... 7 WEB系統(tǒng)架構(gòu)設(shè)計(jì) ....................................................................................................... 9 學(xué)生管理子系統(tǒng)功能分 析 ...................................................................................................... 9 數(shù)據(jù)庫(kù)設(shè)計(jì) ......................................................................................................................... 10 4 教務(wù)系統(tǒng)公共模塊設(shè)計(jì) ....................................................................................................... 14 院系設(shè)置 ............................................................................................................................ 14 考試類(lèi)型 ............................................................................................................................ 14 教室類(lèi)型 ............................................................................................................................ 14 教室管理 ............................................................................................................................ 15 用戶管理 ............................................................................................................................ 15 IV 專業(yè)設(shè)置 ............................................................................................................................ 15 修改個(gè)人信息 ..................................................................................................................... 16 5 模塊詳細(xì)設(shè)計(jì) (學(xué)生管理子模塊 ) ......................................................................................... 17 學(xué)生基本信息條件 查詢 ....................................................................................................... 17 學(xué)生基本信息界面設(shè)計(jì) ............................................................................................. 17 學(xué)院和專業(yè)級(jí)聯(lián)設(shè)計(jì) ................................................................................................ 18 專業(yè)和班級(jí)級(jí)聯(lián)查詢服務(wù)器關(guān)鍵代碼 ........................................................................ 19 學(xué)生信息從 Excel批量導(dǎo)入 ................................................................................................ 20 客戶端 swfUpload組件 ............................................................................................. 20 上傳組件 monsupload ........................................................................................ 23 解析 Excel工具 poi ................................................................................................. 25 學(xué)生信息增加 ..................................................................................................................... 27 學(xué)生信息修改 ..................................................................................................................... 30 學(xué)生信息導(dǎo)出到 Excel ........................................................................................................ 31 學(xué)生功能模塊設(shè)計(jì) 之學(xué)生權(quán)限 ............................................................................................. 34 學(xué)生權(quán)限基本界面 .................................................................................................... 34 驗(yàn)證碼的制作 ........................................................................................................... 35 6 系統(tǒng)測(cè)試與維護(hù) .................................................................................................................. 37 系統(tǒng)的測(cè)試目標(biāo) .................................................................................................................. 37 單位測(cè)試介紹 ..................................................................................................................... 37 系統(tǒng)測(cè)試 ............................................................................................................................ 37 系統(tǒng)維護(hù) ............................................................................................................................ 39 附 錄 ................................................................................................................................................... 40 參考文獻(xiàn) .............................................................................................................................................. 60 致謝 ..................................................................................................................................................... 61 1 第一章 緒論 . 課題的研究背景與意義 . 國(guó)內(nèi)外現(xiàn)狀 教學(xué)管理系統(tǒng)現(xiàn)在已經(jīng)成為大中專院校普遍使用的教學(xué)管理手段之一。SERVLET。 In this paper, the various school management system, to solve the problems in school management, designed and developed the educational management system, and the system is based on the WINDOWS operating system based on B/S mode of academic information management system based on J2EE the JSP + Servlet + SQLSERVER2020 database development. The system consists of four modules administrator management module, two faculty management module, teacher and student management module management module. Which through the