1】下載安裝好mySQL環境
2】FDConnection1的設定
3】執行增刪改SQL陳述句和查詢Select陳述句
4】客戶端連接
1】下載安裝好mySQL環境，注意32位/64位，本篇為32位
mysql32位下載鏈接: https://pan.baidu.com/s/1hVS_vbBQUAnMakDdlN07ZQ 提取碼: wx44
MYSQL新手入門篇https://www.cnblogs.com/winton-nfs/p/11524007.html
用戶命令列,修改密碼 ，增加DataBase，db1
cd c:\mysql-5.7\bin
mysqld --install
mysqld --initialize --console//有默認密碼，記得保存
net start mysql
mysql -u root -p //輸入密碼
alter user 'root'@'localhost' identified by 'root';
create database db1;
use db1;
show tables;
create table tb1 (id int);
insert into tb1 values (2);
Path路徑系統變數加入c:\mysql-5.7\bin
將libmysql.dll拷到C:\Windows\System32
確保MySQL服務啟動，也可以命令列啟動MySQL服務 net start mysql
2】FDConnection1的設定
FDConnection1.LoginPrompt: = False;//不提示登錄視窗，
3】執行,增insert，改update ，洗掉delete 陳述句SQL陳述句
procedure TForm3.Button1Click(Sender: TObject); begin FDConnection1.ExecSQL('insert into tb1 values(5);'); button1.Caption := FDConnection1.ExecSQLScalar('select MAX(id) from tb1'); end;
3-2】執行select 查詢陳述句，要新加FDQuery1，設定FDQuery1的Connection為FDConnection1
FDQuery1.Open('select * from tb1 where id>5');
4】客戶端連接
https://www.cnblogs.com/happyhills/p/3723842.html
1、SQLConnection1: TSQLConnection ConnectionName = 'MYSQLCONNECTION' DriverName = 'MySQL' GetDriverFunc = 'getSQLDriverMYSQL' LibraryName = 'dbxmys.dll' LoginPrompt = False Params.Strings = ( 'HostName=localhost' 'Database=mysqldb' 'User_Name=root' 'Password=pswd' 'MaxBlobSize=-1 ServerCharSet=utf8') VendorLib = 'libmysql.dll' Connected = True 2、 SQLTable1: TSQLTable GetMetadata = False MaxBlobSize = -1 SQLConnection = SQLConnection1 TableName = 'human' 3、DataSource1: TDataSource DataSet = ClientDataSet1 4、DataSetProvider1: TDataSetProvider DataSet = SQLTable1 5、ClientDataSet1: TClientDataSet Active = True ProviderName = 'DataSetProvider1' 6、DBGrid1: TDBGrid DataSource = DataSource1 7、 DBNavigator1: TDBNavigator DataSource = DataSource1 8、Button1: TButton Caption = 'Button1' OnClick = Button1Click需要的控制元件
procedure TForm1.Button1Click(Sender: TObject); begin ClientDataSet1.ApplyUpdates(0);//更新 end;
最后找到兩個庫檔案一同發布就可以了，
LibraryName = 'dbxmys.dll'
VendorLib = 'libmysql.dll'
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/313.html
標籤：Delphi