使用Delphi6的DBExpress组件连接远程的Mysql数据库

标签：sql数据库教程,access数据库教程,oracle数据库教程,http://www.duowen123.com 使用Delphi6的DBExpress组件连接远程的Mysql数据库,

Delphi6新增的DBExpress专门用来对付Mysql,DB2，Interbase,Oracle等数据库，使用时注意将libmysql.dll

拷贝到当前目录或系统目录(98:system,NT:system32)下，并保证您的3306端口与远程服务器是相通的。

源程序：
interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DBXpress, DB, SqlExpr, StdCtrls, ComCtrls, FMTBcd, Grids,
  DBGrids, Provider, DBClient, DBLocal, DBLocalS, DBTables;

type
  TForm1 = class(TForm)
    SQLConnection: TSQLConnection;
    StatusBar1: TStatusBar;
    Label1: TLabel;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Password: TEdit;
    User_Name: TEdit;
    HostName: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    Button1: TButton;
    GroupBox2: TGroupBox;
    Label5: TLabel;
    ESQL: TEdit;
    Label6: TLabel;
    Database: TEdit;
    ButtonGo: TButton;
    SQLClientDataSet: TSQLClientDataSet;
    procedure Button1Click(Sender: TObject);
    procedure ButtonGoClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  with SQLConnection do
  begin
    Close;
    Params.Values['HostName']:=HostName.Text;
    Params.Values['UserName']:=User_Name.Text;
    Params.Values['Password']:=Password.Text;
    Params.Values['Database']:=Database.Text;
    try
      Connected:=True;
      Statusbar1.Panels[0].Text:='Connect OK';
      ButtonGo.Enabled:=True;
    except
      MessageDlg('Connect Error',mtError,[mbyes],0);
    end;
  end;

end;

procedure TForm1.ButtonGoClick(Sender: TObject);
begin
  with SQLClientDataSet do
  begin
    Close;
    CommandText:=ESQL.Text;
    Open;
  end;
end;

procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  SQLConnection.Close;
end;

end.

  上一篇      目录      下一篇 来源：unknown   ◆ 本站相关教程 用perl访问mysql数据库用javabean来实现MySQL的分页显示mysql让存储结果分页，用于复杂查询一个基于mysql的登陆验证程序MySQL的数据类型和建库策略MySQL怎样优化WHERE子句用gcc批量建mysql库表不同平台上mysql的对比，使用Delphi6的DBExpress组件连接远程的Mysql数据库