网上客户服务中心系统的设计与实现
为进一步落实中国电信战略转型目标,优化中国电信渠道体系和架构,强化电子渠道的销售服务功能,电信公司就2008年电子渠道销售服务能力提升提出了一系列的数据库具体要求. 重庆电信网上客户服务中心是中国电信系统的重要组成部分, 应此重庆电信网上客户服务中心数据库也面临一系列新的需求。
对网上客服中心系统的设计思想、数据库设计、系统架构等做了详细的介绍,主要完成了网上客户服务中心系统新增的发票寄送和充值记录查询两大模块的设计与实现,主要工作包括这两个模块的需求分析、系统功能设计、数据库设计及这两个模块的实现。发票寄送模块分为前台和后台两个子模块。用户通过前台进行发票寄送业务的申请及查询操作,而电信工作人员通过后台可进行发票寄送信息的查询、发票寄送总量的查询、发票收费设置等操作。充值记录查询模块则是一个综合查询模块,用户通过它可以查询11888、11819及银行卡/支付宝三个业务的充值记录。
本文设计开发的系统是基于B/S(浏览器/服务器)模式下,利用JSP作为编程技术,实现用户和系统的交互。在数据库方面则采用了Informix作为基础数据操作的后台。在本系统中,我们把JSP、Java、JavaScript等充分融合在各种功能模块的编程中,并采用了Spring框架的IOC(控制反转)、Spring对JDBC的支持、Spring的远程调用等关键技术实现了上述的功能。关键词: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培训频道)