• 新浪微博:
  • 微信 :
按键精灵电脑版
立即下载

软件版本:2014.06
软件大小:22.9M
更新时间:03-18

按键精灵安卓版
立即下载

软件版本:3.3.6
软件大小:62.5M
更新时间:01-16

按键精灵iOS版
立即下载

软件版本:1.6.0
软件大小:29.2M
更新时间:07-29

最新企业版UiBot
立即下载

软件版本:3.3
软件大小:282M
更新时间:08-06

快捷导航

登录 后使用快捷导航
没有帐号? 注册

登录 注册
发新话题 回复该主题

[插件下载] 大龙数据库插件,通用所有数据库,格式统一 [复制链接]

1#

数据库全平台统一格式,方便统一书写,任何数据库都可以使用了,全部都整合到一起了,高效快速。以下以按键调用例子为例,写法都差不多
数据库连接部分讲解
Plugin.DL.ConnectMyDB("MySQL", "用户名", "密码", "服务器IP", "数据库名字", 端口)
例如:
Plugin.DL.ConnectMyDB("MySQL", "root", "1234560", "localhost", "studb", 3306)
Plugin.DL.ConnectMyDB("SQLite", "", "", "", "D:\test.db", 0)
Plugin.DL.ConnectMyDB("SQL Server", "admin", "123456", "202.102.11.252", "datebase", 1433)
Plugin.DL.ConnectMyDB("SQLite", "", "", "", "D:\test.db", 0)
Plugin.DL.ConnectMyDB("Access", "", "", "localhost", "D:\my.accdb", 0)
Plugin.DL.ConnectMyDB("Oracle", "账号", "密码", "localhost", "", 0)
看到没所有数据库都支持,很方便的,书写格式都一致!!!
-------------------------------------------------------------------------------------------------------------
实战代码
//按键插件调用方式 MySQL
ret = Plugin.DL.ConnectMyDB("MySQL", "root", "1234560", "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
ret = Plugin.DL.ConnectMyDB("SQL Server", "admin", "123456", "202.102.11.252", "datebase", 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

//按键插件调用方式 SQLite
ret = Plugin.DL.ConnectMyDB("SQLite", "", "", "", "D:\test.db", 0)
If ret =1 Then
s = Plugin.DL.GetTable("SELECT * FROM people limit 0,10 ")
MessageBox s
//s = Plugin.DL.InsertSQL("insert into people(myname) values(1)")
//MessageBox s
//s = Plugin.DL.UpdateSQL("update people set myname ='givl2' where id = 3")
//MessageBox s
//s = Plugin.DL.DeleteSQL("delete from people where id = 3")
//MessageBox s
//s = Plugin.DL.ExecSQL("insert into people VALUES('1','1','2','3','1','2')")
//MessageBox s
ret = Plugin.DL.CloseMyDB
Else
MessageBox ret
End If

//按键插件调用方式 Access
ret = Plugin.DL.ConnectMyDB("Access", "", "", "localhost", "D:\my.accdb", 0)
If ret =1 Then
s = Plugin.DL.GetTable("SELECT top 10 * FROM people ")
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

//按键插件调用方式 Oracle
ret = Plugin.DL.ConnectMyDB("Oracle", "账号", "密码", "localhost", "", 0)
If ret =1 Then
s = Plugin.DL.GetTable("SELECT top 10 * FROM people ")
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



网盘地址
h ttps://pan.baidu.com/s/1cpUMke
QQ技术群:621816328

2#

2017-10-15日更新
网盘地址:h ttps://pan.baidu.com/s/1hspc8RU

3#

SQlite将更新 加密功能

4#

是免费使用吗

按键精灵写脚本培训支持微信QQ等多种交流方式联系QQ:239882038
5#

东西是好东西,但是我的按键不能用,应该是插件没有注册,系统提示脚本 无效的过程调用或参数: 'CreateObject', 缺少对象: 'DL', 这个插件怎么注册?

发新话题 回复该主题