Unity3d 中文输入输出查询sqlite数据库

最新推荐文章于 2023-03-28 13:19:30 发布

Cancer05

最新推荐文章于 2023-03-28 13:19:30 发布

阅读量634

点赞数

分类专栏： Unity3D 文章标签： sqlite search function string 数据库 exe

本文链接：https://blog.csdn.net/Cancer05/article/details/5213247

版权

Unity3D 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

CnGuiDB.js

var db : dbAccess; public var mskin : GUISkin; private var mstring : String; var inputStr; function Start(){ inputStr = "1"; } function search(mid) { db = new dbAccess(); db.OpenDB("db1.db"); var tableName = "myTable"; // table name, I want to return everyone whose first name is Bob when their last name is = to Sagat, this returs an array var resultArray = db.SingleSelectWhere(tableName, "name", "id", "=", mid); // Remember the '' on String values mstring=resultArray[0]; print(mstring); // of course you can loop through them all if you wish db.CloseDB(); } function OnGUI() { GUI.skin=mskin; inputStr =GUI.TextField(new Rect(200, 154, 200, 30),inputStr,25); if(GUI.Button(new Rect(400,154,60,30),"search")) { search(inputStr); } GUI.Label(new Rect(10,400,400,900),mstring); }

编辑模式 db1放在工程总目录下，与assets/library/temp同级

exe部署 db1放在可执行文件同级

sqlite参照：

http://forum.unity3d.com/viewtopic.php?t=30249&start=0&postdays=0&postorder=asc&highlight=

中文输入输出参照：

http://bbs.vrchina.net/viewthread.php?tid=11357

http://bbs.vrchina.net/viewthread.php?tid=11636&extra=page%3D1

sqlite管理工具

http://img.newhua.com/softinfo/90240/