您好,欢迎访问一九零五行业门户网

delphi 连接MYSQL 的方法_MySQL

需要的控件:(view as form)
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'
其它类似信息

推荐信息