SQLite 模块

CBrother在1.1.0版本提供了一个SQLite扩展，它可以帮助你操作SQLite数据库。

SQLite用法

import CBSQLite.code
function main(parm)
{
    var sqlite = new SQLite(GetRoot() + "aaa.db");
    if(!sqlite.connect())
    {
        print "sqlite connect err!!";
        return;
    }
    print GetRoot() + "aaa.db";
    var res = sqlite.upDate("CREATE TABLE IF NOT EXISTS test (intv INTEGER,strv VARCHAR(100) NOT NULL, floatv FLOAT)");
    if(!res)
    {
        print "update err " + sqlite.getErr();
    }
    var res = sqlite.upDate("INSERT INTO test (`strv`, `intv`, `floatv`) VALUES ('333', 222, 10.12)");
    if(!res)
    {
        print "update err " + sqlite.getErr();
    }
    var res = sqlite.query("select * from test");
    if(!res)
    {
        print "query err " + sqlite.getErr();
        return;
    }
    while(sqlite.next())
    {
        var strv = sqlite.getString(0);
        var intv = sqlite.getInt(1);
        var floatv = sqlite.getInt(2);
        print "sqlite data: " + strv + " " + intv + " " + floatv;
        var strv2 = sqlite.getString("strv");
        var intv2 = sqlite.getInt("intv");
        var floatv2 = sqlite.getInt("floatv");
        print "2 sqlite data: " + strv2 + " " + intv2 + " " + floatv2;
        var strv3 = sqlite.getValue(0);
        var intv3 = sqlite.getValue("intv");
        var floatv3 = sqlite.getValue("floatv");
        print "3 sqlite type: " + CBType(strv2) + " " + CBType(intv2) + " " + CBType(floatv2);
        print "3 sqlite data: " + strv2 + " " + intv2 + " " + floatv2;
    }    
    sqlite.freeQuery();
    sqlite.closeConnect();
}

结果:

sqlite data: 222 333 10
2 sqlite data: 333 222 10
3 sqlite type: string int int
3 sqlite data: 333 222 10
sqlite data: 222 333 10
2 sqlite data: 333 222 10
3 sqlite type: string int int
3 sqlite data: 333 222 10

SQLite接口