摘 要
教學(xué)信息管理系統(tǒng)是校園信息管理系統(tǒng)的一個(gè)有機(jī)組成部分,本文簡(jiǎn)要闡述了教學(xué)管理系統(tǒng)建設(shè)的意義以及系統(tǒng)的開(kāi)發(fā)過(guò)程。教學(xué)管理系統(tǒng)采用當(dāng)前最流行的Delphi編程技術(shù)，可以實(shí)現(xiàn)數(shù)據(jù)的高效、動(dòng)態(tài)、交互訪問(wèn)，具有強(qiáng)大的Server/Client交互能力。本系統(tǒng)以Delphi7.0 SQL Sever 2000為主要開(kāi)發(fā)平臺(tái),從用戶的角度出發(fā)，對(duì)教學(xué)管理系統(tǒng)的功能進(jìn)行了全面的分析。本系統(tǒng)實(shí)現(xiàn)的主要功能包括學(xué)生成績(jī)查詢、學(xué)生資料查詢、教師資料查詢、單科成績(jī)?yōu)g覽、學(xué)年開(kāi)課清單、學(xué)分計(jì)算、平均分計(jì)算、添加修改學(xué)生、教師、課程信息、刪除學(xué)生、教師、課程信息、數(shù)據(jù)庫(kù)的還原、備份、用戶信息的管理和維護(hù)及其它一些輔助功能。在數(shù)據(jù)庫(kù)的建立上主要采用Access作為關(guān)系數(shù)據(jù)庫(kù)的開(kāi)發(fā)工具。在數(shù)據(jù)庫(kù)的連接上采用ADO的數(shù)據(jù)庫(kù)訪問(wèn)技術(shù)。本文從開(kāi)發(fā)平臺(tái)、運(yùn)行環(huán)境、系統(tǒng)設(shè)計(jì)和模塊實(shí)現(xiàn)等方面闡述了系統(tǒng)的設(shè)計(jì)以及開(kāi)發(fā)過(guò)程，從該系統(tǒng)的開(kāi)發(fā)背景、系統(tǒng)功能、設(shè)計(jì)思路和一些程序開(kāi)發(fā)的細(xì)節(jié)等方面進(jìn)行了論述。尤其是詳細(xì)的說(shuō)明了學(xué)分計(jì)算、平均分計(jì)算、添加修改學(xué)生、教師、課程信息、刪除學(xué)生、教師、課程信息、數(shù)據(jù)庫(kù)的還原、備份、用戶信息的管理和維護(hù)這幾個(gè)模塊的設(shè)計(jì)與開(kāi)發(fā)過(guò)程。
關(guān)鍵詞：Delphi SQL 教學(xué)管理系統(tǒng) 數(shù)據(jù)庫(kù)



















Abstract
The teaching information management system is an organism that campus information manage the system to constitute the part, this text synopsis expatiated the teaching manages the meaning of system developments and the process of development of the systems.Teaching management system adoption front most popular of Delphi plait distance technique, can realize data efficiently, development, hand over to visit with each other, have the mighty Server/ Client hands over with each other ability.This system with Delphi7.0 SQLSever 2000 for main the terrace of development, set out from the angle of the customer, manage to the teaching the function of the system proceeded completely of analysis.The main function that this system realizes includes the student the score the search, student data search, teacher data search, single section score view, the academic year has a lecture detailed list, credit calculation, average cent calculation, increase to modify the student, teacher, course the information and delete the student, teacher, course the information, database restores, the management of the backup, customer information with support and other some assistance function.Establish the tool of development of the our main adoption in top Access conduct and actions relation database in the database.The database interview technique of the adoption ADO on the conjunction in database.This text is from the development terrace, circulate the environment, system design with mold a design for realizing etc. expatiating system and development processes, from the background of development, system function of that system, designed the way of thinking to proceed the treatise with details etc. that some procedure develop.Its is management that expatiation credit calculation, average cent calculation, increase to modify the student, teacher, course the information and delete the student, teacher, course the information, database restores, backup, customer information with design that support this a few molds piece and development process.

Key Words: Delphi SQL teaching management system data-base










目 錄
摘 要 I
Abstract II
目 錄 III
引 言 1
第1章 管理信息系統(tǒng)概述 2
1. 1管理信息系統(tǒng)產(chǎn)生的背景 2
1. 2管理信息系統(tǒng)的定義 3
1. 3管理信息系統(tǒng)的類型 4
1. 4管理信息系統(tǒng)設(shè)計(jì)原則 5
第2章 開(kāi)發(fā)工具的介紹 7
2. 1 Delphi簡(jiǎn)介 7
2. 2 Delphi 的特點(diǎn) 7
2. 3 Server數(shù)據(jù)庫(kù)開(kāi)發(fā) 8
2. 4 ODBC概述 8
第3章 系統(tǒng)設(shè)計(jì)和數(shù)據(jù)庫(kù)設(shè)計(jì) 10
3. 1 系統(tǒng)設(shè)計(jì) 10
3. 1. 1 系統(tǒng)功能分析 10
3. 1. 2系統(tǒng)功能模塊設(shè)計(jì) 10
3. 2 數(shù)據(jù)庫(kù)設(shè)計(jì) 10
3. 2. 1數(shù)據(jù)庫(kù)需求分析 10
3. 2. 2數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì) 10
3. 3數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) 12
第4章 教學(xué)管理系統(tǒng)的詳細(xì)設(shè)計(jì) 15
4. 1用戶登陸模塊 15
4. 2系統(tǒng)模塊 15
4. 3查詢模塊 15
4. 4瀏覽模塊 15
4. 5計(jì)算模塊 16
4. 6維護(hù)模塊 16
4. 7幫助模塊 17
第5章 動(dòng)態(tài)數(shù)據(jù)訪問(wèn)的實(shí)現(xiàn) 18
5. 1 數(shù)據(jù)庫(kù)的基礎(chǔ)知識(shí) 18
5. 1. 1數(shù)據(jù)庫(kù)技術(shù)的發(fā)展 18
5. 1. 2數(shù)據(jù)庫(kù)(DataBase,簡(jiǎn)稱DB) 20
5. 1. 3 表(Table) 21
5. 2數(shù)據(jù)庫(kù)的建立 21
5. 3 ADO簡(jiǎn)介 23
5. 4用ADO連接數(shù)據(jù)庫(kù) 23
第6章 教學(xué)管理系統(tǒng)的開(kāi)發(fā)過(guò)程 24
6. 1登錄窗體 24
6. 2主窗體 24
6. 3系統(tǒng) 24
6. 4 查詢 25
6. 4. 1學(xué)生成績(jī)查詢 25
6. 4. 2學(xué)生資料查詢 25
6. 4. 3 教師資料查詢 25
6. 5 瀏覽 26
6. 5. 1單科成績(jī)?yōu)g覽 26
6. 5. 2學(xué)年開(kāi)課清單 26
6. 6 計(jì)算 27
6. 6. 1 學(xué)分累加計(jì)算 27
6. 6. 2 平均分計(jì)算 28
6. 6. 3 學(xué)生成績(jī)分布直方圖 29
6. 6. 4 計(jì)算器 31
6. 7 維護(hù) 31
6. 7. 1 添加學(xué)生信息 31
6. 7. 2 添加教師信息 33
6. 7. 3 添加課程信息 33
6. 7. 4 學(xué)生成績(jī)錄入 35
6. 7. 5 刪除學(xué)生記錄 36
6. 7. 6 刪除教師信息 37
6. 7. 7 刪除課程信息 38
6. 7. 8 刪除成績(jī)記錄 39
6. 7. 9備份數(shù)據(jù)庫(kù) 40
6. 7. 10 還原數(shù)據(jù)庫(kù) 41
6. 7. 11更改密碼 41
6. 7. 12 添加新用戶 42
6. 7. 13 刪除用戶 43
6. 8幫助 43
6. 8. 1給我發(fā)郵件 43
6. 8. 2關(guān)于 43..