马上加入TC
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
本帖最后由 OOOO 于 2017-8-29 14:37 编辑
TC使用动态链接库操作Mysql数据库详细演示
- //连接句柄
- var link = null
- //dll 路径
- var mdll = "c:/sql.dll"
- //指定表名
- var tbnm = "mytab"
- //指定字段
- var colu = "name"
- //连接数据库
- function start_click()
- link = dllcall(mdll,"int","sql_connect","char *","127.0.0.1","char *","root","char *","123456","char *","mydb","int",3306)
- if(link)
- messagebox("连接成功")
- else
- messagebox("连接失败")
- end
- end
- //断开数据库
- function exit_click()
- dllcall(mdll,"int","sql_close","int",link)
- end
- //===========================================================================================================增
- function insert_click()
- //模拟插入下面的一句话,用户可自定义
- var contents = "这是一个测试"
- if(dllcall(mdll,"int","insert","int",link,"char *",tbnm,"char *",colu&"='"&contents&"'"))
- messagebox("插入成功")
- else
- messagebox("插入失败")
- end
- end
- //===========================================================================================================删
- function delete_click()
- //条件用户可以自定义指定删除某条,本列是实现清空表(了解:在真正使用mysql命令的时候一般使用truncate清空表,效率高)
- if(dllcall(mdll,"int","delete","int",link,"char *",tbnm,"char *","id=id"))
- messagebox("删除成功")
- else
- messagebox("删除失败")
- end
- end
- //===========================================================================================================改
- function update_click()
- //把colu为old的值替换成new值
- //用户自定义以下两个变量
- var old = "旧值"
- var new = "新值"
- if(dllcall(mdll,"int","update","int",link,"char *",tbnm,"char *",colu&"='"&new&"'","char *",colu&"='"&old&"'"))
- messagebox("修改成功")
- else
- messagebox("修改失败")
- end
- end
- //===========================================================================================================查
- function find_click()
- //查colu列中的全部数据
- //用户可以自定义条件
- messagebox(dllcall(mdll,"char *","select","int",link,"char *",tbnm,"char *",colu,"char *","id=id","char *","id ASC"))
- end
复制代码
点击下面下载Mysql动态库
sql.dll
(1.55 MB, 下载次数: 118, 售价: 10 个金币)
|