个人中心
gpt4 book ai didi

android - 使用 Ionic、SQLite 返回多个数据

转载 作者：搜寻专家 更新时间：2023-10-30 23:46:06 26 4
gpt4 key购买 nike

我正在尝试使用 ionic 框架中的 sqlite 检索一些数据。但我是新手，所以我需要你的帮助。

我想使用 sqlite 作为列表从数据库中检索数据，所有数据。

如果//console.log 行命令打开，我只会得到一个数据，而不会得到其他数据。如果 app.js 是这样的，我会得到这个错误。

TypeError: Cannot read property 'push' of undefined
    at app.js:65
    at processQueue (ionic.bundle.js:20962)
    at ionic.bundle.js:20978
    at Scope.$get.Scope.$eval (ionic.bundle.js:22178)
    at Scope.$get.Scope.$digest (ionic.bundle.js:21994)
    at Scope.scopePrototype.$digest (hint.js:1468)
    at ionic.bundle.js:22216
    at completeOutstandingRequest (ionic.bundle.js:12714)
    at ionic.bundle.js:13094

应用程序.js 

var db = null;
var example = angular.module('starter', ['ionic', 'ngCordova'])

.run(function($ionicPlatform, $cordovaSQLite) {
    $ionicPlatform.ready(function() {
        if(window.cordova && window.cordova.plugins.Keyboard) {
            cordova.plugins.Keyboard.hideKeyboardAccessoryBar(true);
        }
        if(window.StatusBar) {
            StatusBar.styleDefault();
        }
        if (window.cordova) {
          db = $cordovaSQLite.openDB({ name: "my.db" }); //device
        }else{
          db = window.openDatabase("my.db", '1', 'my', 1024 * 1024 * 100); // browser
        }

        $cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS people (id integer primary key, firstname text, lastname text)");
    });
});

example.controller("ExampleController", function($scope, $cordovaSQLite) {

    $scope.insert = function(firstname, lastname) {
        var query = "INSERT INTO people (firstname, lastname) VALUES (?,?)";

        $cordovaSQLite.execute(db, query, [firstname, lastname]).then(function(result) {
            console.log("INSERT ID -> " + result.insertId);
        }, function (error) {
            console.error(error);
        });
    }

    $scope.select = function(lastname) {
        var query = "SELECT firstname, lastname FROM people WHERE lastname = ?";
        $cordovaSQLite.execute(db, query, [lastname]).then(function(result) {
            if(result.rows.length > 0) {
                console.log("SELECTED -> " + result.rows.item(0).firstname + " " + result.rows.item(0).lastname);
            } else {
                console.log("No results found");
            }
        }, function (error) {
            console.error(error);
        });
    }

    $scope.selectAll = function() {
        var query = "SELECT firstname, lastname FROM people";
        var outputs = [];
        $cordovaSQLite.execute(db, query, []).then(function(result) {
            if(result.rows.length > 0) {
                for(var i = 0; i < result.rows.length; i++) {
                    //console.log("SELECTED -> " + result.rows.item(i).firstname + " " + result.rows.item(i).lastname);
                    /* $scope.outputs = [
                       {"firstname": result.rows.item(i).firstname}
                    ]; */

                    $scope.outputs.push({
                        "firstname" : result.rows.item(i).firstname,
                    });
                }
            } else {
                console.log("No results found");
            }
        }, function (error) {
            console.error(error);
        });
    }

});

example.controller("PeopleCtrl", function($scope) {
    $scope.people = [
        {firstName: 'John', lastName: 'Doe', address: {city: 'Chandler', state: 'AZ', zip: 85248}},
        {firstName: 'Jane', lastName: 'Doe', address: {city: 'Chandler', state: 'AZ', zip: 85248}},
        {firstName: 'Johnny', lastName: 'Doe', address: {city: 'Phoenix', state: 'AZ', zip: 85003}}
    ];
});

和index.html

<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="initial-scale=1, maximum-scale=1, user-scalable=no, width=device-width">
        <title></title>
        <link href="lib/ionic/css/ionic.css" rel="stylesheet">
        <link href="css/style.css" rel="stylesheet">
        <script src="lib/ionic/js/ionic.bundle.js"></script>
        <script src="js/ng-cordova.min.js"></script>
        <script src="cordova.js"></script>
        <script src="js/app.js"></script>
    </head>
    <body ng-app="starter">

    <ion-pane>
      <ion-header-bar class="bar-stable">
        <h1 class="title">Ionic Blank Starter</h1>
      </ion-header-bar>
      <ion-content>

          <div ng-controller="ExampleController">
             <button class="button" ng-click="insert('Arzu','Acar')">Insert</button>
             <button class="button" ng-click="selectAll()">Select</button>

             <ul>
                <li ng-repeat="output in outputs">
                    <span class="bold">{{output.firstname}}</span>
                </li>
            </ul>
         </div>

            <div ng-controller="PeopleCtrl">        
                <div id="peopleContainer">
                    People:<br /><br />
                    <ul>
                        <li ng-repeat="person in people">
                            <span class="bold">{{person.firstName}} {{person.lastName}}</span>
                            <br />
                            {{person.address.city}}, {{person.address.state}}&nbsp;&nbsp;{{person.address.zip}}
                        </li>
                    </ul>
                </div>
            </div>
        </ion-content>
    </ion-pane>
  </body>
</html>

谢谢。

最佳答案

在 ExampleController:selectAll 中，您有以下声明:

var outputs = [];

然后推送到 $scope 上不存在的数组:

 $scope.outputs.push({
   "firstname" : result.rows.item(i).firstname,
 });

我认为您的意思是每次调用 selectAll 时都初始化 $scope.outputs 数组:

$scope.outputs = [];

关于android - 使用 Ionic、SQLite 返回多个数据，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/28286455/

26 4 0
文章推荐： mysql - 用 VB 中的数据库表填充组合框
文章推荐： mysql - 如何从每个组中获取成员数以及组详细信息？
文章推荐： mysql - 我可以从 mysql 5.5 打开 mysql 5.1 数据库吗？
文章推荐： ruby - 从服务器上的 CSV 复制到 PostgreSQL 数据库
搜寻专家
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com