使用ZEOSDBO-7.0.3的TZConnection给SQLite加密

设置TZConnection的Properties属性增加加密属性encrypted=yes并且设置Password属性即可以为SQLite数据库加密,需要SQLite3.dll支持加密才可以。经本人测试可以行。win7+Delphi xe2+ZEOSDBO-7.0.3-stable,以上测试是在Delphi xe2 IDE上进行的。但是独立脱离IDE后则能连接但不能查询可其他操作。提示该数据库是加密的。

02-23
ZeosDBO is a database middleware components for Borland development tools, including Delphi, C++ Builder and Kylix. The following compilers are supported: Delphi 5 - 7C++ Builder 5 - 6Kylix 2 - 3ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface: MySQL 3.20 - 4.1PostgreSQL 6.5 - 7.4Firebird 1.0 - 1.5Interbase 5.0 - 7.5Microsoft SQL Server 7, 2000Sybase ASE 12.0, 12.5Oracle 9iSQLite 2.8For other databases we propose to use implemented Active Data Objects (ADO) Bridge. Advantages of using ZeosDBO: Platform independance. The ZeosDBO is highly generic. Applications written in ZeosDBO can be migrated across databases without major changes. ZeosDBO is open source, written for usability and extensibility. ZeosDBO leverages the amazing power of the Delphi development environment without relying on a performance killing middleware. ZeosDBO is an extremely thin abstraction layer, unlike ‘thick‘ layered protocols like ADO and BDE. Package contents: ZCore - Core classes and interfaces. Contains Java style objects and collections as well as compatibility types and functions. ZParseSql - SQL specific for syntax and lexical analysis. ZPlain - Native plain API to supported SQL servers. ZDbc - Port of Java Database Connectivity API (JDBC 2.0). DBC API acts as intermediate layer between Plain API and highlevel TDataset or DBExpress components. ZComponent - visual components descended from TDataset. Installed components: TZConnection: This component encapsulates the database connection and transaction management. TZReadOnlyQuery: TDataset component to execute SQL queries and process data in read-only mode. TZQuery: TDataset component which allows data modifications in regular and cached mode. TZUpdateSQL: Analog of standard TUpdateSQL component to explicite definition of Insert/Update/Delete SQL statements for TDataset modifications. TZStoredProc: The component to execute SQL stored procedures. TZSQLProcessor: The component to execute SQL scripts for different SQL and various delimiter types. TZSQLMonitor: The component to monitor all outgoing SQL queries and other logging information. TZSQLMetadata: Specialized TDataset component which provides an access to database metadata such as tables, columns, indices, etc.
要在Delphi 2007中安装zeosdbo-7.1.4-stable,您需要按照以下步骤进行操作: 1. 首先,您需要从Zeos官方网站(https://sourceforge.net/projects/zeoslib/files/)下载zeosdbo-7.1.4-stable的安装文件。 2. 下载完成后,解压缩安装文件并找到Delphi 2007所在的安装目录。 3. 将解压后的文件复制到Delphi 2007的安装目录中的相应文件夹下。通常,您可以将这些文件复制到Delphi 2007的安装目录下的"Library"文件夹中,或者根据您的喜好将其复制到其他文件夹。 4. 打开Delphi 2007,创建一个新的项目或打开一个已有的项目。 5. 单击Delphi 2007的"工具"菜单并选择"安装组件"。 6. 在"安装组件"对话框中,单击"添加"按钮。 7. 浏览到Delphi 2007安装目录下的zeosdbo-7.1.4-stable文件夹,并选择其中的"ZComponents_Dxx.bpl"文件("Dxx"表示您所使用Delphi版本,例如"D10"表示Delphi 10)。 8. 单击"打开"按钮,并在"安装组件"对话框中再次单击"添加"按钮。 9. 浏览到Delphi 2007安装目录下的zeosdbo-7.1.4-stable文件夹,并选择其中的"ZCore_Dxx.bpl"文件。 10. 单击"打开"按钮,然后单击"确定"按钮开始安装组件。 11. 安装完成后,您可以在Delphi 2007的组件面板中找到zeosdbo-7.1.4-stable组件。您可以将其拖放到您的项目窗口中,并使用其功能开发数据库应用程序。 这样,您就成功在Delphi 2007中安装了zeosdbo-7.1.4-stable组件。您可以利用这个组件开发出更加强大和功能丰富的数据库应用程序。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值