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

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/