智能网计费模块兼容Informix和Oracle数据库

Interllient Network Bill Module Supporting with Informix and Oracle Database

智能网由于海外市场的扩展,需要能够同时兼容多种流行的数据库,比如Oracle和Informix等。以计费模块为例,介绍了在同一个应用系统内连接这两种数据库的一种方法。当前数据库类型在文件中可配置。使用类工厂模式创建数据库中必需的数据表,以ESQL/C与Informix数据库通信、中间件SQLAPI与Oracle数据库通信,实现数据库中各个数据表内记录的增加、删除、修改和查询操作。所有的数据库操作最终落实到使用标准化SQL语句来执行。

Because of the expansion of overseas markets,intelligent network need be synchronously compatible with a variety of popular databases such as Oracle and Informix etc.Taking BILL module for example,the article introduces a method of connecting these two databases in one systerm.Current database type can be configed in the file.Using the Factory Method to create the database tables necessary,communicating Informix database With ESQL/C,communicating Oracle database With SQLAPI,we can perform the operation of addition、deletion、modification and inquire the data records in the table within the database.All operations on database system must be excuted using standard SQL sentences at last.