QML使用数据库存储Model数据

(本文为utf-8格式,可以直接使用相应代码)  
Models 是用来提供数据的,它既可以以 QML 的形式出现也可以是 C++的类。QML中的Model有ListModel、XmlListModel、
VisualItemModel;C++ 中的 Model 有 QAbstractItemModel、QStringList、 QList<QObject*>等。另外我们可以把数
据存到数据库里,程序启动的时候从数据库中读取数据,退出的时候把Model中的数据存放回数据库中。主要代码如下所示:

    ListModel {
            id: mymodel
            Component.onCompleted: loadImageData()
            Component.onDestruction: saveImageData()
            function loadImageData() {
                var db = openDatabaseSync("MyDB", "1.0", "My model SQL", 50000);
                db.transaction(
                    function(tx) {
                        // Create the database if it doesn't already exist
                        tx.executeSql('CREATE TABLE IF NOT EXISTS Images(id INTEGER primary key, title TEXT, picture TEXT)');
     
                        var rs = tx.executeSql('SELECT * FROM Images');
                        var index = 0;
                        if (rs.rows.length > 0) {
                            var index = 0;
                            while (index < rs.rows.length) {
                                var myItem = rs.rows.item(index);
                                mymodel.append( {
                                    "id": myItem.id,
                                    "title": myItem.title ,
                                    "picture": myItem.picture  });
                                index++;
                            }
                        } else {
                            mymodel.append( {
                                "id": 1,
                                "title": 'apple' ,
                                "picture": 'content/pics/apple.png'  });
                            mymodel.append( {
                                "id": 2,
                                "title": 'Qt Quick!' ,
                                "picture": 'content/pics/Qt.png'  });
                            }
                    }
                )
            }
     
            function saveImageData() {
                var db = openDatabaseSync("MyDB", "1.0", "My model SQL", 50000);
                db.transaction(
                    function(tx) {
                        tx.executeSql('DROP TABLE Images');
                        tx.executeSql('CREATE TABLE IF NOT EXISTS Images(id INTEGER primary key, title TEXT, picture TEXT)');
                        var index = 0;
                        while (index < mymodel.count) {
                            var myItem = mymodel.get(index);
                            tx.executeSql('INSERT INTO Images VALUES(?,?,?)', [myItem.id, myItem.title, myItem.picture]);
                            index++;
 
  • 3
    点赞
  • 5
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值