银企互联中对账文件动态生成机制  

Dynamic Methods of Reconciliation File Generation in Interconnected System between Bank and Company

作　　者：彭秋生 PENG Qiu-sheng （Software Development Department, Guangdong Postal Information ＆ Technology Bureau, Guangzhou 510898, China）

机构地区：[1]广东省邮政信息技术局软件开发部,广东广州510898

出　　处：《电脑知识与技术》2014年第7期4368-4370,4386,共4页Computer Knowledge and Technology

摘　　要：针对银企互联中格式多样的对账文件,该文提出了两种动态文件生成机制。一种是基于结构体的动态文件生成机制,它利用了C语言中的结构体成员内存连续的原理,适用于对账明细数据源表固定的情况,但不适合多数据表的联合处理。另外一种是与动态SQL结合的文件生成机制,该机制不再局限于同一个数据源表,可以多表联合查询处理,同时又具备文件格式灵活配置的优点,适应范围更广,灵活度更高。In the interconnected system between bank and company, there are a variety of formats for reconciliation file. Two dynamic file generation methods were presented to the problem. One is based on the structure variables, whose members have continuous memory address in C language, and is suitable to fixed data source table, but not for the joint processing of multiple data tables. The other is combined with dynamic SQL; this method not only can process multi-table querying, but also have the advantage of flexible configuration of file format. The new method is no longer confined to the fixed data source table, and is suitable to a wider range with more flexibility.

关 键 词：对账文件 动态生成 结构体变更 动态SQL 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论;自动化与计算机技术—计算机科学与技术]