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

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

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