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


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

關(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問題定義及內(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)開發(fā)具體研究分析 11
2.3詳細(xì)設(shè)計(jì) 12
3 系統(tǒng)設(shè)計(jì) 13
3.1系統(tǒng)關(guān)鍵問題分析 13
3.1.1 開發(fā)語言的選擇 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)境與開發(fā)平臺(tái)的選擇 15
3.1.5數(shù)據(jù)庫設(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程序界面及程序代碼的建立與編寫 19
4.1.1權(quán)限管理 19
4.1.2數(shù)據(jù)庫的連接 21
4.1.3信息有效性判斷 22
4.1.4添加、修改、查找、刪除、敏感信息提示 22
4.1.5分頁功能 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 開發(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í)園地 2003
[6] 《建立CRM數(shù)據(jù)庫的幾個(gè)原則》.辛志華 .創(chuàng)智CRM知識(shí)園地