【正文】 內(nèi)蒙古工業(yè)大學(xué)本科畢業(yè)設(shè)計(jì)說明 書 1 摘 要 目前，學(xué)校工作復(fù)雜、資料重多，管理信息系統(tǒng)已進(jìn)入高校，但還未普及，而對于學(xué)生成績管理來說，還沒有一套完整的、統(tǒng)一的系統(tǒng)。因此，開發(fā)一套適合大眾的、兼容性好的系統(tǒng)是很有必要的。根據(jù)開發(fā)要求，它主要應(yīng)用于教育系統(tǒng)，完成對日常學(xué)生成績的錄入、查詢、更新、刪除等管理操作，實(shí)現(xiàn)學(xué)生成績管理的計(jì)算機(jī)化。開發(fā)學(xué)生成績管理系統(tǒng)可使學(xué)院教職工減輕工作壓力，比較系統(tǒng)的對教務(wù)、教學(xué)上的各項(xiàng)服務(wù)和信息進(jìn)行管理，同時(shí)，可以減少勞動(dòng)力的使用，家快查詢速度、較強(qiáng)管理。本論文敘述了現(xiàn)在高校學(xué)生成績管理的現(xiàn)狀以及 JAVA語言和一些開 源框架的概況。重點(diǎn)介紹了學(xué)生成績管理系統(tǒng)的實(shí)現(xiàn)過程：包括系統(tǒng)分析、系統(tǒng)查詢、數(shù)據(jù)庫設(shè)計(jì)、功能設(shè)計(jì)、系統(tǒng)物理配置方案、系統(tǒng)實(shí)現(xiàn)、系統(tǒng)測試以及系統(tǒng)功能簡介。 本系統(tǒng)是在以 MySQL 為后臺(tái)數(shù)據(jù)庫開發(fā)的。學(xué)生管理系統(tǒng)在運(yùn)行階段，效果好，數(shù)據(jù)精確性高，提高了工作效率，同時(shí)也實(shí)現(xiàn)了學(xué)生管理的計(jì)算機(jī)化。 關(guān)鍵字：管理系統(tǒng) ； 數(shù)據(jù)庫 ； MySQL 內(nèi)蒙古工業(yè)大學(xué)本科畢業(yè)設(shè)計(jì)說明 書 2 Abstract At present, the school work is numerous and diverse, material is heavy, the management information system enters into the university, but does not popular, but regarding the student achievement management, does not have a set pletely and unification ,develops a set suitable, populace and patible good system is very necessary. According to the development request, it mainly applies in the educational system, pletes to daily student achievement maintenance operations and so on input inquiry renewal deletion, and realizes student achievement maintenance puterizing. Developing the student achievement maintenance system can let the institute teaching and administrative staff to reduce the working pressure, pare with systematically to the educational administration, teaching each service and the information carries on the management,simultaneously,can reduce the labor force which is used, speed up the inquiry speed, strengthen the management. The paper narrated the present university’s study result management in the present situation and the JAVA language and some opens the source frame of the survey. Introduce the realizes process of the student achievement management system: Including the system analysis、 the system investigation、 the database design、 the functional design、 the system physics disposition plan、 the system realize、 the system testing the System Introduction. The system’s opening relies on MySQL as a backup of data management. this technology not only shortened the managing time but also, it highlights the highquality by providing more accurate diapason top of it, it has also put the puterized” The Management of Students” into practice. Keywords: Administrative System； the Database ； MySQL 內(nèi)蒙古工業(yè)大學(xué)本科畢業(yè)設(shè)計(jì)說明 書 3 目 錄 摘 要 .............................................................................................................................. 1 引 言 .............................................................................................................................. 5 第一章 可行性分析 .................................................................................................. 7 問題的定義 .................................................................................................... 7 系統(tǒng)可行性分析 ............................................................................................ 7 第二章 需求分析 ...................................................................................................... 8 系統(tǒng)開發(fā)環(huán)境 ................................................................................................ 8 Java 的主要特 性 .................................................................................. 8 SQL 介紹 ............................................................................................. 9 C/S 結(jié)構(gòu)介紹 ..................................................................................... 10 系統(tǒng)需要解決的主要問題 .......................................................................... 10 系統(tǒng)具備的基本功能 .................................................................................. 10 第三章 系統(tǒng)設(shè)計(jì) .................................................................................................... 12 系統(tǒng)目標(biāo)設(shè)計(jì) .............................................................................................. 12 開發(fā)設(shè)計(jì)思想 .............................................................................................. 12 系統(tǒng)功能分析 .............................................................................................. 12 系統(tǒng)功能模塊設(shè)計(jì) ...................................................................................... 13 第四章 數(shù)據(jù)庫設(shè)計(jì) .................................................................................................. 14 數(shù)據(jù)庫需求分析 .......................................................................................... 14 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì) .................................................................................. 14 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì) .................................................................................. 14 SQL 腳本實(shí)現(xiàn) ............................................................................................. 14 第五章 系統(tǒng)主要功能模塊 ...................................................................................... 17 登陸和主 窗體界面設(shè)計(jì) .............................................................................. 17 管理員界面主要代碼 ........................................................................ 20 學(xué)生界面設(shè)計(jì) .............................................................................................. 22 學(xué)生界面主要代碼 ............................................................................ 24 教師界面設(shè)計(jì) .............................................................................................. 27 教師界面主要代碼 ............................................................................ 29 結(jié) 論 ............................................................................................................................ 31 內(nèi)蒙古工業(yè)大學(xué)本科畢業(yè)設(shè)計(jì)說明 書 4 參考文獻(xiàn) ...................................................................................................................... 32 附 錄 ...............................................................................................................