Qt5:QML:LocalStorage

最新推荐文章于 2024-09-19 16:33:04 发布

天已青色等烟雨来

最新推荐文章于 2024-09-19 16:33:04 发布

阅读量2.4k

点赞数 1

分类专栏： Qt Qt学习笔记文章标签： qt qt5 数据库

博客地址:blog.csdn.net/x356982611，未经允许不得转载，不得转载，不得转载

本文链接：https://blog.csdn.net/x356982611/article/details/53283674

版权

Qt 同时被 2 个专栏收录

37 篇文章 6 订阅

订阅专栏

Qt学习笔记

35 篇文章 22 订阅

订阅专栏

简介

LocalStorage是本地SQLite的数据库，程序关闭后仍存在，用于持久化数据。比如游戏数据的本地保存等等，在windows 10中位于(储存在哪不重要 搜一下OfflineStorage) 比如

C:\Users\用户\AppData\Local\localstorage\QML\OfflineStorage\Databases

文件夹中

示例代码

import QtQuick 2.5
import QtQuick.Controls 1.4
import QtQuick.Layouts 1.1
import QtQuick.LocalStorage 2.0


ApplicationWindow {
    visible: true
    width: 800
    height: 600
    title: qsTr("localstorage")

    property var localdb

    ListModel {
        id:idListMode
        ListElement {
            name: "testname"
            score: "99.5"
        }
    }


    ColumnLayout {
        id: columnLayout1
        anchors.fill: parent

        Rectangle {
            id: rectangle1
            Layout.fillWidth: true
            Layout.fillHeight: true
            height: 200
            color: "#ffffff"

            ListView
            {
                anchors.fill: parent
                model:idListMode
                delegate: Text {
                    text: name + "        :       " + score
                }

                Component.onCompleted:
                {
                    openDB();
                    getDBData();
                }
            }

        }

        Rectangle {
            id: rectangle2

            Layout.fillWidth: true
            height: 100


            Label {
                id: label1
                x: 91
                y: 35
                width: 101
                height: 21
                text: "姓名"
                verticalAlignment: Text.AlignVCenter
                horizontalAlignment: Text.AlignHCenter
                wrapMode: Text.WordWrap
            }

            Label {
                id: label2
                x: 91
                y: 62
                width: 101
                height: 21
                text: "成绩"
                wrapMode: Text.WordWrap
                verticalAlignment: Text.AlignVCenter
                horizontalAlignment: Text.AlignHCenter
            }


            TextField {
                id: idName
                x: 205
                y: 36
                placeholderText: qsTr("")
            }

            TextField {
                id: idScore
                x: 205
                y: 63
                inputMask: "00"

            }

            Button {
                id: button1
                x: 416
                y: 35
                width: 112
                height: 48
                text:"添加"
                onClicked:
                {

                    if((idName.text.length>0)&&(idScore.text.length))
                    {
                        insertDBData(idName.text,idScore.text);
                        idListMode.append({"name":idName.text,"score":idScore.text});
                    }
                    else
                    {
                        console.log("cann't empty");
                    }
                }
            }
        }
    }

    //打开数据库，没有则创建，没有指定表则创建
    function  openDB()
    {
        localdb = LocalStorage.openDatabaseSync("QQmlValueRecordDB", "1.0", "QML LocalStorage", 1000000);

        localdb.transaction(function(tx){

            tx.executeSql('CREATE TABLE IF NOT EXISTS datasheet(name TEXT, score TEXT)');
        })
    }

    //数据库插入数据
    function insertDBData(name,score)
    {
        localdb.transaction(function(tx)
        {
            tx.executeSql('INSERT INTO datasheet VALUES(?,?)', [name,score]);
        })

    }

    //从数据库获取数据
    function getDBData()
    {
        localdb.transaction(function(tx)
        {
            var rs = tx.executeSql('SELECT * FROM datasheet');

            for(var i = 0; i < rs.rows.length; i++)
            {
                idListMode.append({"name":rs.rows.item(i).name,"score":rs.rows.item(i).score});
            }
        })

    }

}