qml中使用数据库

main.cpp中可以设置数据库的路径
engine.setOfflineStoragePath(“./”); //设置数据库存储路径

基本数据库接口示例

var db

function openDB(){
    db=LocalStorage.openDatabaseSync("temp","1.0","tempDB",1000)
}

function initDBPasswd(){
    openDB()
    db.transaction(function(tx)
    {
        tx.executeSql('CREATE TABLE IF NOT EXISTS passwd(name TEXT, value TEXT)')

        var reslut = tx.executeSql('select * from passwd where name="user"')
        if(reslut.rows.length===0)
        {
           tx.executeSql('INSERT INTO passwd VALUES(?,?)',['user','@123456@'])
        }
    }
    )
}

function readDBPasswd(){
    if(!db){return}

    var ret
    db.transaction(function(tx)
    {
        var reslut = tx.executeSql('select * from passwd where name="user"')
        if(reslut.rows.length===1)
        {
            ret=reslut.rows[0].value
        }
    }
    )
    return ret
}

function storeDBPasswd(stringPasswd){
    if(!db){return}
    db.transaction(function(tx)
    {
        tx.executeSql('UPDATE passwd set value=? where name="user"',[stringPasswd])
    }
    )
}

function initDBClientList(){
    openDB()
    db.transaction(function(tx)
    {
        tx.executeSql('CREATE TABLE IF NOT EXISTS clientList(devID INT, value TEXT)')
    }
    )
}

function readDBClientList(){
    if(!db){return}

    var reslut
    db.transaction(function(tx)
    {
        reslut = tx.executeSql('select * from clientList order by devID ASC')
    }
    )
    return reslut
}

function storeDBClientList(devID, stringClient){
    if(!db){return}
    db.transaction(function(tx)
    {
        var reslut = tx.executeSql('select * from clientList where devID=?',[devID])
        if(reslut.rows.length===1)
        {
           tx.executeSql('UPDATE clientList set value=? where devID=?',[stringClient,devID])
        }
        else
        {
           tx.executeSql('INSERT INTO clientList VALUES(?,?)',[devID,stringClient])
        }
    }
    )
}

function delDBClientList(devID){
    if(!db){return}
    db.transaction(function(tx)
    {
        tx.executeSql('DELETE from clientList where devID=?',[devID])
    }
    )
}