【正文】 I / 41基于 Java+Oracle 的學(xué)生信息管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)目 錄摘 要 ................................................1ABSTRACT..............................................2第一章 緒論 .......................................3 課題背景和意義 ........................................3 國(guó)內(nèi)外研究現(xiàn)狀 ........................................3 本系統(tǒng)主要功能模塊 ....................................4 章節(jié)安排 ..............................................4第二章 學(xué)生信息管理系統(tǒng)需求分析 ....................5 系統(tǒng)的可行性調(diào)查 ......................................5 系統(tǒng)的經(jīng)濟(jì)可行性 ....................................5 系統(tǒng)的技術(shù)可行性 ....................................5 系統(tǒng)的社會(huì)可行性 ....................................5 用戶使用可行性 ......................................6 需求分析概述 ..........................................6 系統(tǒng)的數(shù)據(jù)性能需求 ....................................6 系統(tǒng)功能需求分析 ......................................8 管理員模塊功能需求 ..................................8II / 41 教師登錄模塊功能需求 ................................8 學(xué)生模塊功能需求 ....................................8 系統(tǒng)數(shù)據(jù)流圖 ..........................................8第三章 總體設(shè)計(jì) ...................................11 系統(tǒng)功能層次圖 .......................................11 設(shè)計(jì)目標(biāo) .............................................13 系統(tǒng)管理員管理模塊 .................................13 教師登錄管理模塊 ...................................13 學(xué)生登錄管理模塊 ...................................13第四章 數(shù)據(jù)庫(kù)設(shè)計(jì) .................................14 數(shù)據(jù)庫(kù)分析 ...........................................14 實(shí)體的分析 .........................................14 實(shí)體的屬性 .........................................14 數(shù)據(jù)表設(shè)計(jì) .........................................15 SQL 語(yǔ)句實(shí)現(xiàn) .........................................17第五章 系統(tǒng)模塊詳細(xì)設(shè)計(jì) ...........................19 管理員模塊設(shè)計(jì) .......................................19 添加學(xué)生信息功能 ...................................19 添加教師信息功能 ...................................19 添加新課程功能 .....................................19 修改學(xué)生信息功能 ...................................20 修改教師信息功能 ...................................20III / 41 修改課程信息功能 ...................................20 教師模塊設(shè)計(jì) .........................................21 查看教師信息功能 ...................................21 查看所授課程功能 ...................................21 查看聽(tīng)課通知功能 ...................................21 學(xué)生模塊設(shè)計(jì) .........................................22 學(xué)生選課功能 .......................................22 查看學(xué)生信息功能 ...................................22 查看已選課程功能 ...................................22 刪除已選課程功能 ...................................23第六章 系統(tǒng)實(shí)現(xiàn) ...................................24 系統(tǒng)登錄界面 .........................................24 錄入學(xué)生信息界面 .....................................24 修改學(xué)生信息界面 .....................................25 學(xué)生選課界面 .........................................25結(jié)束語(yǔ) ...............................................26參考文獻(xiàn) .............................................27致 謝 ...............................................28附 錄 ...................................................29摘 要隨著學(xué)校規(guī)模的不斷擴(kuò)大,學(xué)生數(shù)量急劇增加,有關(guān)學(xué)生的各種信息也,開(kāi)發(fā)學(xué)生信息管理系統(tǒng)來(lái)提高學(xué)生管理,可以做到信息的規(guī)范管理、科學(xué)統(tǒng)計(jì)和快速查詢,從而減少管理方面的工作量. 學(xué)生信息管理系統(tǒng)是典型的信息管理系統(tǒng) (MIS),其開(kāi)發(fā)主要包括后臺(tái)起數(shù)據(jù)一致性和完整性強(qiáng)、功能完備,易使用等特點(diǎn).經(jīng)過(guò)分析,我們使用Java開(kāi)發(fā)工具,利用其提供的各種面向?qū)ο蟮拈_(kāi)發(fā)工具,Java 技術(shù)具有卓越的通用性、高效性、平臺(tái)移植性和安全性,廣泛應(yīng)用于個(gè)人PC、數(shù)據(jù)中心、游戲控制臺(tái)、科學(xué)超級(jí)計(jì)算機(jī)、移動(dòng)電話和互聯(lián)網(wǎng),Oracle數(shù)據(jù)庫(kù)功能強(qiáng)大,學(xué)習(xí)起來(lái)也不難,然后,對(duì)初始原型系統(tǒng)進(jìn)行需求迭代,不斷修正和改進(jìn),直到形成用戶滿意的可行系統(tǒng).本文將分六個(gè)章節(jié)來(lái)敘述,第一章,概述,主要敘述系統(tǒng)開(kāi)發(fā)的背景和選題意義,以及開(kāi)發(fā)的必要性和可能性；第二章,系統(tǒng)需求分析,架構(gòu)系統(tǒng)的框架,為下面的內(nèi)容做好準(zhǔn)備；第三章,系統(tǒng)總體設(shè)計(jì),敘述數(shù)據(jù)庫(kù)設(shè)計(jì)和系統(tǒng)子模塊的功能；第四章,數(shù)據(jù)庫(kù)設(shè)計(jì),主要介紹實(shí)體和數(shù)據(jù)表和SQL語(yǔ)句實(shí)現(xiàn)；第五章,系統(tǒng)模塊的詳細(xì)設(shè)計(jì),主要講述了各個(gè)模塊的功能。第六章,系統(tǒng)實(shí)現(xiàn)；識(shí),但是只針對(duì)所用到的做大體的說(shuō)明.關(guān)鍵詞：學(xué)生信息 Java Oracle ODBC 數(shù)據(jù)庫(kù) ABSTRACTWith the expansion of schools, the number of students increases sharply, all kinds of information about the students also doubled. Faced with such a large amount of information, developing the student information management systems to improve the efficiency of the management of students has bee an inevitable. Through the system, the information can be standardized management, scientific statistics and fast query, thereby reducing the workload of management.Student Information Management System is a typical management information system (MIS), which mainly includes the establishment and maintenance of backend database and frontend application development aspects. For the former requirement to establish data consistency and integrity, data security, a good library. For the latter requires the application fully functional, easy to use features.After analysis, we use Java development tools, the use of its various objectoriented development tools, Java technology, excellent versatility, efficiency, platform portability, and security, are widely used in personal PC, data centers, gaming control Taiwan, scientific superputers, cell phones and the Inter, also has the world39。s largest developer of professional munity. Use of the database is Oracle Database, Oracle Database powerful, it is not difficult to learn, then, the initial prototype of the system needs to constantly revise and improve user satisfaction until the formation of a viable system.This article will be divided into six chapters to describe the first chapter, an overview of the main narrative system development background and significance of the topic, and the development of the necessity and possibility。 second chapter, system requirements analysis, system architecture framework for the following content prepared。 Chapter overall system design, database design and system description submodule functions。 fourth chapter, database design, introduces entities and data tables and SQL statements。 fifth chapter, detailed system modules design, mainly about the function