1,216
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
'以下例子通过.只是取记录集...目前没那个水准....日后再研究....
Private Declare Function mysql_server_init Lib "libmysql.dll" (ByVal arg1 As Long, ByVal arg2 As Long, ByVal arg3 As Long) As Long
Private Declare Function mysql_server_end Lib "libmysql.dll" () As Long
Private Declare Function mysql_init Lib "libmysql.dll" (ByVal arg1 As Long) As Long
Private Declare Function mysql_close Lib "libmysql.dll" (ByVal arg1 As Long) As Long
Private Declare Function mysql_real_connect Lib "libmysql.dll" (ByVal arg1 As Long, ByVal arg2 As String, ByVal arg3 As String, ByVal arg4 As String, ByVal arg5 As String, ByVal arg6 As Long, ByVal arg7 As Long, ByVal arg8 As Long) As Long
Private Declare Function mysql_query Lib "libmysql.dll" (ByVal arg1 As Long, ByVal arg2 As String) As Long
Private Sub Form_Load()
Dim MySql&
mysql_server_init 0, 0, 0
MySql = mysql_init(0)
Debug.Print mysql_real_connect(MySql, ("IP地址"), ("账号"), ("密码"), ("数据库名"), 端口号, 0, 0) '连接到MySQL服务器。
Debug.Print mysql_query(MySql, "这里输入sql语句")
mysql_close MySql
mysql_server_end
End
End Sub