ASP+SQL機房設備管理系統(tǒng)
1.6萬字 44頁
包括開題報告，畢業(yè)論文，答辯PPT，程序代碼


摘要
本論文是從北方軟件學院的實際業(yè)務出發(fā)，針對現(xiàn)在手工管理現(xiàn)狀，經過詳細的系統(tǒng)分析調查，為計算中心“量體裁衣”開發(fā)的一個實用的機房設備管理系統(tǒng)。本系統(tǒng)主要實現(xiàn)的是機房設備管理功能。此系統(tǒng)與國內現(xiàn)有的原有的機房管理系統(tǒng)進行了比較，分析了它的技術可行和經濟可行性，進行了必要的需求分析，最終開發(fā)了本系統(tǒng)。本系統(tǒng)有嚴格的管理權限功能，管理員可以通過要求進行詳細的信息錄入，從而保證信息的有效性。本論文詳細闡述了整個軟件的開發(fā)過程，在論文的最后我又談了我畢業(yè)設計的收獲和感想。
在本模塊的開發(fā)過程中使用了軟件工程設計方法，ASP語言是目前比較流行的軟件技術，它是當今最有發(fā)展前景的軟件開發(fā)技術，作為新一代的軟件開發(fā)技術，與傳統(tǒng)的生命周期方法相比，有其獨特的一面。本論文從軟件工程的角度描述了本模塊的開發(fā)過程，從計劃期的問題定義、可行性研究和需求分析一直到開發(fā)期的系統(tǒng)設計、詳細設計、編碼設計及編碼調試都進行了比較詳細的介紹。將作為今后本模塊修改與維護及進一步開發(fā)的重要參考資料。
本系統(tǒng)的前端開發(fā)工具為DREAMWEVER,采用ASP腳本語言，后臺關系數(shù)據(jù)庫選擇的是關系數(shù)據(jù)庫SQL-SERVER，并且采用ODBC連接數(shù)據(jù)庫。

關鍵詞：機房管理；ASP；SQL-SERVER；ODBC


Abstract
The present paper is embarks from the north software study actual service, in view of the present manual management present situation, passes through the detailed system analysis investigation, “acts according to circumstances” a development practical engine room equipment management system management system for the data processing center. This system main realization is the engine room equipment management function.I have carried on this systematic and the domestic existing original engine room management system management system the comparison, has analyzed its technology feasible and the economical feasibility. Simultaneously has carried on the market survey, has carried on the essential demand analysis, finally has developed this system. This system has the strict management jurisdiction function, the manager may carry on the detailed information input through the request, thus guarantee information validity.The present paper elaborated in detail the entire software performance history, finally I also talk my graduation project harvest and the feelings in the paper.
Has used IIS and the ASP design method in this module performance history, the ASP language is the present quite popular software development language, it most has the prospects for development software development technology now, takes the new generation of software development technology, Compares with the traditional life cycle method, has its unique one side. The present paper described this module performance history from the software engineering angle, from the plan time question definition, the feasibility study and the demand analysis continuously to the development period system design, the detailed design, the code designed and codes the debugging all to carry on the quite detailed introduction. Took the next this module revision and the maintenance and will further develop important reference.
This system front end development kit is DREAMWEVER, uses the ASP script language, the backstage relational database choice is relational database SQL-SERVER, and uses the ODBC connection database.
Key word: Engine room management; ASP; SQL-SERVER; ODBC.


目錄

1系統(tǒng)需求分析 1
1.1本課題的研究意義 1
1.2問題定義及內容簡介 3
1.3背景 3
2系統(tǒng)分析 4
2.1系統(tǒng)分析的概念 4
2.1.1系統(tǒng)分析的基本含義 5
2.1.2初步調查 5
2.2可行性分析 9
2.2.1系統(tǒng)可行性研究分析 10
2.2.2可行性分析報告 11
2.2.3系統(tǒng)開發(fā)具體研究分析 11
2.3詳細設計 12
3 系統(tǒng)設計 13
3.1系統(tǒng)關鍵問題分析 13
3.1.1 開發(fā)語言的選擇 13
3.1.2系統(tǒng)設計的任務與原則 14
3.1.3系統(tǒng)的總體設計 14
3.1.4運行環(huán)境與開發(fā)平臺的選擇 15
3.1.5數(shù)據(jù)庫設計 15
3.2系統(tǒng)設計原則 18
3.2.1 設計的總原則 18
3.2.2 關鍵技術的分析 19
4系統(tǒng)實現(xiàn) 19
4.1程序界面及程序代碼的建立與編寫 19
4.1.1權限管理 19
4.1.2數(shù)據(jù)庫的連接 21
4.1.3信息有效性判斷 22
4.1.4添加、修改、查找、刪除、敏感信息提示 22
4.1.5分頁功能 26
4.1.6導出EXCEL表功能 30
5 結論與展望 31
5.1系統(tǒng)測試 31
5.2系統(tǒng)功能的總結 32
5.2.1用戶信息的登錄功能 32
5.2.2會員添加功能 33
5.2.3用戶信息的維護 33
5.2.4硬件信息維護 34
5.2.5安全性考慮 34
5.3系統(tǒng)展望 36
參考文獻 36
致 謝 37



參考文獻
[1]《ASP 3 初級編程》. David Buser John Kauffman . 機械工業(yè)出版社
[2]《ASP與SQL Server網(wǎng)站架設》.賈佳 郝洪明 . 機械工業(yè)出版社
[3]《SQL Server 2000 開發(fā)指南》. Michael Otey,Paul Conte.清華大學出版社
[4]《構建面向CRM的數(shù)據(jù)挖掘應用》.Alex Berson Stephen Smith Kurt Thearling. 人民郵電出版社
[5] 《分析型CRM：讀你千遍不厭倦》. 李蓓 .創(chuàng)智CRM知識園地 2003
[6] 《建立CRM數(shù)據(jù)庫的幾個原則》.辛志華 .創(chuàng)智CRM知識園地