基于Access数据库的PowerBuilder事务对象参数加密与存取

Encryption and Access of PowerBuilder Transaction Object Parameters Based on Access Database

PowerBuilder通过事务对象建立与数据库连接的方式主要有两种,一是将事务对象参数直接在应用程序中设置,这种方式由于灵活性差,已很少在实际应用中使用;二是将事务对象参数经过加密存入.ini文件,通过PowerBuilder提供的函数存取的方法实现,这种方式灵活性和安全性兼备,是一种较理想的方式,但由于.ini文件是一个文本文件,仍然缺乏强有力的安全保证.针对上述问题,本文利用PowerBuilder支持多个事务对象的特点给出了另一种更加可靠、更加安全的实现方法.建立两个事务对象A,B,事务对象A通过方式二建立与Access数据库的连接,将事务对象B的参数经过加密处理存入Access数据库,应用程序通过事务对象B建立与应用程序数据库的连接.

There are two methods of PowerBuilder connection to database through transaction object.One is setting transaction object parameters in application directly,which has been rarely used in practical applications owing to its poor flexibility.The other one is transaction object parameters be stored into.ini file after encryption and accessed with functions of PowerBuilder.This method has both flexibility and security,then it is an ideal one.However,since.ini file is a text file,it is still lack of strong security guarantee. In response to these issues this paper gave a more reliable and secure method utilizing characteristics of PowerBuilder, which supports multiple transaction objects. With this method two transaction objects A and B were created, transaction object A connects Access database with aforementioned latter method, and B＇s parameters were stored into Access database after encryption. Transaction object B was used to connect application with its database.