電費(fèi)征繳系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)【數(shù)據(jù)庫(kù)+源代碼+文獻(xiàn)及翻譯+畢業(yè)設(shè)計(jì)報(bào)告】

摘 要
為了突破手工繳費(fèi)模式，經(jīng)過(guò)多年的電力信息化建設(shè)，電力企業(yè)已經(jīng)建成了一系列服務(wù)于多方面的計(jì)算機(jī)信息系統(tǒng)。電費(fèi)征繳系統(tǒng)這種新的繳費(fèi)方式使原來(lái)供電企業(yè)直管直抄不斷上升趨勢(shì)的居民客戶的繳費(fèi)難問(wèn)題得以解決。
本系統(tǒng)包括電力收費(fèi)部門(mén)所必須的繳費(fèi)用戶的開(kāi)戶登記，用戶繳費(fèi)，用戶和費(fèi)用余額查詢等功能。系統(tǒng)可以安全、快捷、一目了然的查詢用電費(fèi)用發(fā)生情況、欠費(fèi)情況和賬戶資金情況，并進(jìn)行電費(fèi)的繳納。
根據(jù)實(shí)際需求，電費(fèi)征繳系統(tǒng)這個(gè)項(xiàng)目采用了JSP技術(shù)，在Windows XP操作系統(tǒng)環(huán)境下，使用JSP技術(shù)設(shè)計(jì)完成，并使用SQL Server 2000建設(shè)網(wǎng)絡(luò)數(shù)據(jù)庫(kù)。本系統(tǒng)采用JDBC接口連接數(shù)據(jù)庫(kù)，整個(gè)開(kāi)發(fā)過(guò)程是在JSP頁(yè)面上進(jìn)行，WEB工具采用Tomcat。通過(guò)B/S模式（瀏覽器/服務(wù)器模式）進(jìn)行前臺(tái)后臺(tái)的操作，對(duì)用戶及時(shí)地進(jìn)行添加，刪除，查詢。
本系統(tǒng)具有多方面特點(diǎn)：系統(tǒng)功能完備，使用方便簡(jiǎn)捷，人性化的用戶界面，大大減少了操作人員的工作負(fù)擔(dān)。該系統(tǒng)詳盡描述了開(kāi)發(fā)電費(fèi)征繳系統(tǒng)的全過(guò)程。
 
關(guān)鍵詞: 開(kāi)戶登記；JSP技術(shù)；電費(fèi)征繳；

 
Abstract
In order to break manual paying mode ，and after many years electric power information construction, the electric power enterprise has already completed a series of services to the production, the marketing and so on the various computer information system. The electrical bill newly pays expenses information this kind to pay expenses the way to cause the original power supply enterprise ascending pipe straight to copy the unceasing trend of escalation the inhabitant customer to pay expenses the difficult question to be able to solve.
This system is including the electric power charge department must pays expenses the user to open a bank account the registration, the user pays expenses, function and so on remaining sum inquiry. The system may the security, quick, the clear inquiry use electricity the expense to have the situation, the situation and the account fund situation, and carries on the electrical bill paying.
According to the actual demand, the project of the electrical bill system adopts the JSP technology, in Windows under the XP operating system environment, and use SQL Server 2000 to build the network database. This system uses JDBC interface to connect the database, the entire development process is in the JSP page, WEB tools uses Tomcat. Through the B/S to operate in the front and the background, and users timely to add, delete, query.
This system has the various characteristic: System function complete, easy to operate simple and direct, the human nature user contact surface, greatly reduced operator's work load. This system is described the development process of the electrical bill system.

Key word:  the user to open a bank; JSP; the electrical bill paying

 
目 錄
引 言 1
第一章 系統(tǒng)開(kāi)發(fā)相關(guān)技術(shù)介紹 3
1.1系統(tǒng)設(shè)計(jì)的相關(guān)知識(shí)介紹 3
1.1.1 JSP 3
1.1.2 MyEclipse簡(jiǎn)介 3
1.1.3 JDBC 4
1.1.4 SQL Server 2000 5
1.1.5 JDK簡(jiǎn)介 6
1.1.6 Tomcat簡(jiǎn)介 7
1.2系統(tǒng)環(huán)境配置 7
1.2.1 JDK配置 7
1.2.2 SQL Server 2000配置 9
第二章 電費(fèi)征繳系統(tǒng)概述 10
2.1系統(tǒng)功能概述 10
2.2需求分析 10
2.2.1系統(tǒng)目標(biāo) 10
2.2.2功能實(shí)現(xiàn) 10
2.3系統(tǒng)設(shè)計(jì) 11
2.3.1電費(fèi)征繳系統(tǒng)功能模塊結(jié)構(gòu)圖 11
2.3.2電費(fèi)征繳系統(tǒng)流程圖 13
第三章 數(shù)據(jù)庫(kù)設(shè)計(jì) 14
3.1數(shù)據(jù)庫(kù)分析 14
3.2數(shù)據(jù)庫(kù)概念設(shè)計(jì) 14
3.3數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu) 15
3.3.1數(shù)據(jù)表的結(jié)構(gòu)圖 15
3.3.2數(shù)據(jù)庫(kù)表 16
第四章 公共類設(shè)計(jì) 17
4.1數(shù)據(jù)庫(kù)相關(guān)類 17
4.2獲取時(shí)間類 19
第五章 系統(tǒng)設(shè)計(jì)實(shí)現(xiàn) 21
5.1頁(yè)面概述 21
5.2 后臺(tái)頁(yè)面設(shè)計(jì) 21
5.3 前臺(tái)頁(yè)面設(shè)計(jì) 27
結(jié) 論 32
參考文獻(xiàn) 33
謝 辭 34