摘要
當今社會中,計算機的使用已經深入到日常工作和生活的方方面面。Windows系統的推出使電腦從高雅的學術殿堂走入了尋常百姓家,各行各業的人們無須經過特別的訓練就能夠使用電腦完成許許多多復雜的工作。然而,雖然現在世界上已經充滿了多如牛毛的各種軟件,但它們依然不能滿足用戶的各種特殊需要,人們還不得不開發適合自己特殊需求的軟件。我們都知道,對于學生的學籍管理是一個教育單位不可缺少的部分,它的內容對學校的管理者來說至關重要,所以學生學籍管理系統應該能夠為用戶提供充足的信息和快捷的查詢手段。但一直以來人們使用傳統人工的方式管理文件檔案,這種管理方式存在著許多缺點,如:效率低、保密性差,另外時間一長,將產生大量的文件和數據,這對于查找、更新和維護都帶來了不少的困難。而使用以SQL Server 2000為數據庫,PowerBuilder為開發工具對學生學籍信息進行管理,具有手工管理所無法比擬的優點.例如:檢索迅速、查找方便、存儲量大、保密性好等。這些優點能夠極大地提高學生管理的效率,也是學校科學化、正規化管理的重要途徑。
關鍵詞:PowerBuilder SQL數據庫 數據字典 模塊 菜單
Abstract
Nowadays in society, computer sigmatism already goes deep into the Fang Fang face arriving at daily work and life. Systematic debuting of Windows makes a computer run a family from elegant learning palace hall to have entered common common people , the all professions and trades people uses a computer to be completed unnecessarily by that special training can right away lots and lots of complicated job.But although having already been full of the countless various software in the world now, they can not satisfy consumer's various requiring that people has to develop the software being suitable to self peculiar need peculiarly as before. We all know the self's status as a student to the student manages the part being a indispensability educating an unit, its content is to the school director all-important, therefore student self's status as a student management system ought to be able to be that the consumer provides sufficient information and rapid inquiry means[13].But always in the past people is using the artificial tradition way administration document file , this there is existing a lot of shortcoming in supervisor mode, such as: Inefficient , keep secret nature is bad , time is besides once long, will produce large amount of document and data, with regard to, this seeks , renews and defends the difficulty having brought about quite a few. Use PowerBuilder to develop student to the student manages while built on the basis of SQL Server 2000 to carry out administration on student self's status as a student information but , have unable parallel handwork administration merit. For instance: The retrieva l is prompt , seek to store reserves conveniently, keeping secret greatly, nature is easy to wait. These merit is able to improve efficiency managed by student tremendously , is also school scientification , regularization administrative important approach.
Keyword: PowerBuilder SQL server 2000 Data Dictionary Module Menu
目 錄
摘要 I
Abstract II
第一章 引言 1
1.1 選題的背景與意義: 1
1.2 研究內容 2
第二章 系統設計的開發環境 3
2.1 系統環境 3
2.1.1 系統設計環境 3
2.1.2 系統運行環境 3
2.2 語言環境 3
第三章 系統分析 5
3.1 系統的初步調查 5
3.2 系統的可行性研究 6
3.3 現行系統的詳細調查 6
3.4 新系統邏輯方案的提出 7
第四章 系統設計 16
4.1 系統總體功能設計 16
4.2 數據庫設計: 17
4.2.1 數據庫概念結構設計 17
4.2.2 數據庫邏輯結構設計 21
第五章 系統的實現 26
5.1 登錄界面設計 26
5.2 系統主界面設計 29
5.3 學籍管理界面的設計 30
5.4 學籍查詢窗體設計 35
5.5 學籍修改窗體的設計 37
5.6學籍的異動錄入窗體設計 38
5.7 學生成績的錄入窗體設計 40
5.8 學生補考窗體的設計 42
5.9 成績查詢窗體的設計 42
5.10 用戶管理窗體的設計 44
第六章 系統實施與維護 46
6.1物理配置方案 46
6.2代碼設計中的困難 47
6. 3系統的測試 47
6.4系統的維護與管理 47
第七章 結束語 48
致謝 49
參考文獻 50