摘 要
學生成績管理系統是典型的信息管理系統(MIS),它作為學生信息管理的基礎,是實現校園信息化進程當中很重要的一個方面。其開發主要包括前端應用程序的開發以及后臺數據庫的建立和維護兩個方面。本系統分析了現今學生成績管理系統中所應用的幾個環節,并針對每個環節做出了詳細的闡述和探討。分別從用戶管理、課程管理、成績管理、班級管理等四大模塊詳細地講述了軟件開發的具體步驟和整個過程,介紹了系統開發用到的JSP環境NetBeans IDE 4.1、使用的相關JSP技術和Java編程語言、引入MVC設計模式理念,以及后臺數據庫SQL-Server 2000的搭建與操作,并對模塊的功能進行了具體分析和詳細設計。本系統主要功能包括:用戶管理、學生注冊、對班級信息、學生信息、班級課程、學校專業信息、課程信息、學生成績、教師信息、數據庫信息的錄入、查詢、添加、修改和刪除等,其中系統的核心是添加、修改和刪除三者之間的聯系,每一個表的修改都將聯動地影響其它的表。
關鍵詞:學生成績管理系統;NetBeans IDE 4.1;SQL-Server 2000;JSP;JAVA;MVC
The development of students score system software based on JSP
Abstract
Students’ score management system is a representative information management system (MIS), which, as the foundation of students’ information management, plays a vital role in implementation of campus informatization. Its development includes advanced application programs exploitation, as well as the establishment and maintenance of background database. This system analyses several links applied in the students’ score management system now, and details each link in the chain. It also tells us specifically procedure and whole process respectively from four modules including consumer management, course management, score management, class management and so on. This system introduces JSP, NetBeans IDE 4.1 applied to system exploitations, Java programming language, introducing MVC design pattern as well as the construction and operation of background database SQL-Server 2000, and makes detailed analysis besides complete design of module function. The main functions of this system cover: consumer administration; student enrollment; the record ,investigation ,accession, revision and deletion of class information, student information, class course, school major information, course information, teacher information and statistic information. Among them, the system kernel is the relation of accession, revision and deletion, and also the revision for every form will relevantly affect other forms.
Key words: Students’ score management system; NetBeans IDE 4.1; SQL-Server; JSP; JAVA; MVC