纳金网

标题: Unity3d 中文输入输出查询sqlite数据库 [打印本页]

作者: 艾朵儿 时间: 2012-10-26 10:27
标题: 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同级
部署 db1放在可执行文件同级
sqlite参照：
http://f***m.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/

作者: may 时间: 2012-11-30 19:35
支持楼主的帖子

欢迎光临纳金网 (http://go.narkii.com/club/)