|
楼主 |
发表于 2017-10-14 03:22:11
|
显示全部楼层
最新版大龙数据库插件,支持所有数据库的读取 增删改查等功能,陆续完善中, 网盘地址: h t t p s://pan.baidu.com/s/1o861oy2
按键调用
//按键插件调用方式 MySQL 数据库类型,账号,密码,IP,数据库名,端口
ret = Plugin.DL.ConnectMyDB("MySQL", "root", "1234345fdsa", "localhost", "studb", 3306)
If ret =1 Then
s = Plugin.DL.GetTable("SELECT * FROM 本地学员 limit 0,10 ")
MessageBox s
//s = Plugin.DL.InsertSQL("insert into 本地学员(stuname) values(1)")
//MessageBox s
//s = Plugin.DL.UpdateSQL("update 本地学员 set stuname ='givl' where id = 1")
//MessageBox s
// s = Plugin.DL.DeleteSQL("delete from 本地学员 where id = 1")
//MessageBox s
//s = Plugin.DL.ExecSQL("insert into 本地学员 VALUES('1','1','2','3','1','2')")
//MessageBox s
ret = Plugin.DL.CloseMyDB
Else
MessageBox ret
End If
//按键插件调用方式 SQL Server 数据库类型,账号,密码,IP,数据库名,端口
ret = Plugin.DL.ConnectMyDB("SQL Server", "cdfdsg2017", "987342dsfasdf", "136.125.22.55", "dbdsf", 1433)
If ret =1 Then
s = Plugin.DL.GetTable("SELECT top 10 * FROM whsw ")
MessageBox s
//s = Plugin.DL.InsertSQL("insert into 本地学员(stuname) values(1)")
//MessageBox s
//s = Plugin.DL.UpdateSQL("update 本地学员 set stuname ='givl' where id = 1")
//MessageBox s
// s = Plugin.DL.DeleteSQL("delete from 本地学员 where id = 1")
//MessageBox s
//s = Plugin.DL.ExecSQL("insert into 本地学员 VALUES('1','1','2','3','1','2')")
//MessageBox s
ret = Plugin.DL.CloseMyDB
Else
MessageBox ret
End If
TC的调用类似 直接可以查看参数 |
|