- 相關(guān)推薦
教研室輔助管理軟件Delphi+SQL
畢業(yè)論文
教研室輔助管理軟件
摘 要：教研室管理是大學(xué)的主要日常管理工作之1，涉及到教師信息管理、教師所授課程管理等諸多方面，隨著教學(xué)體制的不斷改革，尤其是學(xué)分制、選課制的展開和深入，教研室日常管理工作日趨繁重、復(fù)雜。如何使教研室管理工作便捷化是現(xiàn)代高校發(fā)展的重點(diǎn)，所以迫切需要研制開發(fā)1種綜合性的教研室輔助管理軟件。
本文結(jié)合教研室輔助管理軟件，對(duì)數(shù)據(jù)庫管理系統(tǒng)、SQL語言原理、Delphi應(yīng)用程序設(shè)計(jì)，Delphi數(shù)據(jù)庫技術(shù)進(jìn)行了較深入的探討，主要介紹了教研室輔助管理軟件的需求分析、功能模塊劃分、數(shù)據(jù)庫模式分析，具體描述了數(shù)據(jù)庫結(jié)構(gòu)和應(yīng)用程序。程序運(yùn)行結(jié)果證明，本次畢業(yè)設(shè)計(jì)所開發(fā)的教研室輔助管理軟件能夠滿足教研室日常事務(wù)處理的需要。
該軟件主要實(shí)現(xiàn)了針對(duì)本教研室所管理的教師個(gè)人信息、教師所授課程等信息的添加、修改、刪除。實(shí)現(xiàn)了相關(guān)教學(xué)信息的錄入，資料的上傳和上傳資料的統(tǒng)計(jì)。設(shè)計(jì)充分利用Delphi 7數(shù)據(jù)庫技術(shù)的強(qiáng)大力量，靈活運(yùn)用了數(shù)據(jù)庫組件、數(shù)據(jù)表組件、查詢組件、數(shù)據(jù)感知組件等，提高了編程效率。
關(guān)鍵詞：數(shù)據(jù)庫；SQL語言；Delphi 7；數(shù)據(jù)庫組件。
The assistant management software of staff room
Abstract：The management of staff room is one of the university’s main works, it involves the management of personal information of teachers and the courses they teach and so on. With the teaching system reform, particularly with the launch of credit system reform and select elective courses reform, the management work becomes heavy and complicated. How to make the management work more conveniently is the emphases of the development of the modern higher education. So it is imminently for us to develop a synthetical management software of staff room .
This text unites the assistant management software of staff room, studies and uses SQL language ,the Delphi application program design and Delphi database technique, mainly introduces the need analysis of the management software of staff room, the partition of function mold and the database mode analysis, designs the database structure and application procedure. The result of the program running certificates that assistant management software of staff room which we design in this text can satisfies the usual need of our work.
The software mainly realizes adding, modifying and deleting personal information of teachers and the courses they teach, which is in this management of staff room . Also it can be used to transfer the document and finish the statistical work. The design makes full use of the great technical power of database technique of Delphi7,uses the database component , data watch module, the search module , and the data feeling module flexibly, it improves the efficiency of programme .
Key words: database; SQL language; Delphi7; database component .
目 錄
前 言 1
1 SQL 語言介紹 2
1.1 SQL概述 2
1.2 SQL語句 2
2 DELPHI數(shù)據(jù)庫編程 3
2.1 Delphi 7 的特點(diǎn) 3
2.2 Delphi 7數(shù)據(jù)庫的體系結(jié)構(gòu) 3
2.3 Delphi 7數(shù)據(jù)庫組件簡(jiǎn)介 4
2.4 SQL語言在Delphi中的應(yīng)用 4
3 教研室輔助管理軟件設(shè)計(jì)分析 6
3.1 應(yīng)用需求分析 6
3.2 系統(tǒng)數(shù)據(jù)庫設(shè)計(jì) 7
4 教研室輔助管理軟件應(yīng)用程序設(shè)計(jì) 10
4.1 系統(tǒng)功能模塊組成 10
4.2 數(shù)據(jù)模塊窗體的設(shè)置 10
4.3 用戶登陸窗體的創(chuàng)建 11
4.4 主窗體設(shè)計(jì) 14
4.5 教師信息管理模塊設(shè)計(jì) 14
4.5.1 教師基本信息錄入 15
4.5.2 教師信息刪除、修改窗體設(shè)計(jì) 16
4.6 課程信息管理模塊設(shè)計(jì) 18
4.7 系統(tǒng)用戶管理模塊設(shè)計(jì) 19
4.8 教學(xué)資料上傳管理模塊設(shè)計(jì) 22
4.8.1 資料上傳設(shè)計(jì) 23
4.8.2 資料信息管理設(shè)計(jì) 25
4.8.3 上傳檔案管理設(shè)計(jì) 28
5 結(jié)束語 31
參考文獻(xiàn) 32
致 謝 33
注:不包括源代碼.
【教研室輔助管理軟件Delphi+SQL】相關(guān)文章：
編寫計(jì)算機(jī)輔助教學(xué)軟件之我見09-01