【正文】 ulace 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ù)庫(kù)設(shè)計(jì) .................................................................................................. 14 數(shù)據(jù)庫(kù)需求分析 .......................................................................................... 14 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì) .................................................................................. 14 數(shù)據(jù)庫(kù)邏輯結(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 附 錄 ............................................................................................................................ 33 謝 辭 ............................................................................................................................ 48 內(nèi)蒙古工業(yè)大學(xué)本科畢業(yè)設(shè)計(jì)說明 書 5 引 言 管理信息系統(tǒng) 就是我們常說的 MIS（ Management Information System），在強(qiáng)調(diào)管理，強(qiáng)調(diào)信息的現(xiàn)代社會(huì)中變得越來越普及。 本系統(tǒng)是在以 MySQL 為后臺(tái)數(shù)據(jù)庫(kù)開發(fā)的。本論文敘述了現(xiàn)在高校學(xué)生成績(jī)管理的現(xiàn)狀以及 JAVA語(yǔ)言和一些開 源框架的概況。根據(jù)開發(fā)要求，它主要應(yīng)用于教育系統(tǒng)，完成對(duì)日常學(xué)生成績(jī)的錄入、查詢、更新、刪除等管理操作，實(shí)現(xiàn)學(xué)生成績(jī)管理的計(jì)算機(jī)化。內(nèi)蒙古工業(yè)大學(xué)本科畢業(yè)設(shè)計(jì)說明 書 1 摘 要 目前，學(xué)校工作復(fù)雜、資料重多，管理信息系統(tǒng)已進(jìn)入高校，但還未普及，而對(duì)于學(xué)生成績(jī)管理來說，還沒有一套完整的、統(tǒng)一的系統(tǒng)。因此，開發(fā)一套適合大眾的、兼容性好的系統(tǒng)是很有必要的。開發(fā)學(xué)生成績(jī)管理系統(tǒng)可使學(xué)院教職工減輕工作壓力，比較系統(tǒng)的對(duì)教務(wù)、教學(xué)上的各項(xiàng)服務(wù)和信息進(jìn)行管理，同時(shí)，可以減少勞動(dòng)力的使用，家快查詢速度、較強(qiáng)管理。重點(diǎn)介紹了學(xué)生成績(jī)管理系統(tǒng)的實(shí)現(xiàn)過程：包括系統(tǒng)分析、系統(tǒng)查詢、數(shù)據(jù)庫(kù)設(shè)計(jì)、功能設(shè)計(jì)、系統(tǒng)物理配置方案、系統(tǒng)實(shí)現(xiàn)、系統(tǒng)測(cè)試以及系統(tǒng)功能簡(jiǎn)介。學(xué)生管理系統(tǒng)在運(yùn)行階段，效果好，數(shù)據(jù)精確性高，提高了工作效率，同時(shí)也實(shí)現(xiàn)了學(xué)生管理的計(jì)算機(jī)化。 MIS 是一門新的科學(xué)，它跨越了若干個(gè)領(lǐng)域，比如管理