網上客戶服務中心系統(tǒng)的設計與實現(xiàn)
         為進一步落實中國電信戰(zhàn)略轉型目標，優(yōu)化中國電信渠道體系和架構，強化電子渠道的銷售服務功能，電信公司就2008年電子渠道銷售服務能力提升提出了一系列的數據庫具體要求. 重慶電信網上客戶服務中心是中國電信系統(tǒng)的重要組成部分, 應此重慶電信網上客戶服務中心數據庫也面臨一系列新的需求。
         對網上客服中心系統(tǒng)的設計思想、數據庫設計、系統(tǒng)架構等做了詳細的介紹，主要完成了網上客戶服務中心系統(tǒng)新增的發(fā)票寄送和充值記錄查詢兩大模塊的設計與實現(xiàn)，主要工作包括這兩個模塊的需求分析、系統(tǒng)功能設計、數據庫設計及這兩個模塊的實現(xiàn)。發(fā)票寄送模塊分為前臺和后臺兩個子模塊。用戶通過前臺進行發(fā)票寄送業(yè)務的申請及查詢操作，而電信工作人員通過后臺可進行發(fā)票寄送信息的查詢、發(fā)票寄送總量的查詢、發(fā)票收費設置等操作。充值記錄查詢模塊則是一個綜合查詢模塊，用戶通過它可以查詢11888、11819及銀行卡/支付寶三個業(yè)務的充值記錄。
本文設計開發(fā)的系統(tǒng)是基于B/S（瀏覽器/服務器）模式下，利用JSP作為編程技術，實現(xiàn)用戶和系統(tǒng)的交互。在數據庫方面則采用了Informix作為基礎數據操作的后臺。在本系統(tǒng)中，我們把JSP、Java、JavaScript等充分融合在各種功能模塊的編程中，并采用了Spring框架的IOC（控制反轉）、Spring對JDBC的支持、Spring的遠程調用等關鍵技術實現(xiàn)了上述的功能。關鍵詞：B/S，遠程調用，Spring

ABSTRACT

       To further implement the strategic restructuring goals of China Telecom, optimize its system and structure, enhance the abilities of online sale service, China Telecom put forwards a series of requests. As one important part of the China Telecom System, the CQ Telecom Integer Customer Service System also faces a series of new requirements.
This paper first gives a detailed introduction about the design and structure of the CQ Telecom Integer Customer Service System, then moves to the design and implementation of two new modules of the system—check Sending module and charge querying module. The main work includes requirements analysis, system function design, database design and realization of the two modules. The check Sending module can divide into two parts: foreground and background. The customers can apply check sending service or query the check sending records in the foreground and in background; the employee of China Telecom can query the detail of the check sending information, the total amount of the checks which have already been sent to the customers and so on. Besides, they also can set the price of the check sending service. The charge querying module is an integrative module, through which the customers can query their charge records of 11888, 11819 and bank services in a specified date.
This system is based on the B/S (browser/server) mode, using JSP as a programming language, realizes the interaction of the users and the system. The system adopts Informix database to store data. Based on the IOC, supporting to JDBC and remote invoke technologies of SPRING, I implement the two modules successfully using asp, java and JavaScript.

Keywords： B/S，remote invoke，spring

 （IT培訓頻道）