ZEOSDBO-7安装

zeosdbo是一套免费开源的Delphi数据库连接组件,可连接mssql、mysql、sybase、oracle、firebird、sqlite、postgresql等多种数据库。调用方法简单。

连接MySql数据库库的方法:

添加Zconnection组件,设置如下内容:

Database:要连接的数据库名称;

Hostname:MySQl数据库所在的主机的名称或者Ip地址;

Password:MySql数据库的用户密码;

Port:MySql数据库的端口号,默认的是3306,如果更改了就改成更改后的端口地址;

Protocol:选中连接数据库的类型,比方说是Mysql5就选中mysql-5,需要说明的是编写的程序目录下应该有LibMysql5.dll动态库,否则会出错。

User:就是MySql数据库的用户名。

如果这些项都设置了,把connected设为True,连接成功!

要访问MySql数据库,就可以用ZQuery或者Ztable组件了。非常的方便。

ZEOSDBO控件的安装及使用方法

(可从http://sourceforge.net/projects/zeoslib/下载)

首先,我们来看一下安装过程:

1.解压缩ZEOSDBO-7.1.2-stable.zip到c盘根目录,删除packages、src两文件夹外的其他文件夹;
2.删除packages文件夹中delphi7文件之外的其他版本文件夹;
3.运行delphi7,然后选择Component菜单中的New Component子菜单,在弹出的窗口中点击最下面的“Search path”一行中最后的“...”按钮,在随后弹出的“Directories”对话框中的最下面一行【“Greyed items denote invalid path”的下面】文本框中输入build路径“C:\ZEOSDBO-7.1.2-stable\packages\delphi7\build”,然后点击“Add”按钮,再点击“OK”,退出即可。
注意 :在delphi7中 这里不要添加其它的目录(这个问题折腾了我好几天)

4.然后从“File”菜单中选择“Open Project”打开并顺次编译以下文件:
1.   ZCore.dpk
2.   ZParseSql.dpk
3.   ZPlain.dpk
4.   ZDbc.dpk
5.   ZComponent.dpk
编译完成后在最下面的“ZComponentDesign70.dpk”上单击右键选择“Install”,提示安装成功后,重启Delphi7,即可看到控件栏中增加了一个“Zeos Access”标签。

转载于:https://www.cnblogs.com/Thenext/p/9408472.html

  • 1
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
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.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值