DBExpress组件连接远程Mysql数据库

来源:计算机等级考试    发布时间:2012-08-28    计算机等级考试视频    评论

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

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

  源程序:
interfaceusesWindows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,Dialogs, DBXpress, DB, SqlExpr, StdCtrls, ComCtrls, FMTBcd, Grids,DBGrids, Provider, DBClient, DBLocal, DBLocalS, DBTables;typeTForm1 = 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;varForm1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);beginwith SQLConnection dobeginClose;Params.Values['HostName']:=HostName.Text;Params.Values['UserName']:=User_Name.Text;Params.Values['Password']:=Password.Text;Params.Values['Database']:=Database.Text;tryConnected:=True;Statusbar1.Panels[0].Text:='Connect OK';ButtonGo.Enabled:=True;exceptMessageDlg('Connect Error',mtError,[mbyes],0);end;end;end;procedure TForm1.ButtonGoClick(Sender: TObject);beginwith SQLClientDataSet dobeginClose;CommandText:=ESQL.Text;Open;end;end;procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);beginSQLConnection.Close;end;end.

视频学习

我考网版权与免责声明

① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件,版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源:我考网",违者本网将依法追究责任;

② 本网部分稿件来源于网络,任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益,应该及时向我考网书面反馈,并提供身份证明、权属证明及详细侵权情况证明,我考网在收到上述法律文件后,将会尽快移除被控侵权内容。

最近更新

社区交流

考试问答