機(jī)房設(shè)備管理系統(tǒng)(ASP+SQL)
1.6萬(wàn)字 44頁(yè)
包括開(kāi)題報(bào)告，論文正文，答辯PPT，程序代碼




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

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



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