How to use $cordovaSQLite in Ionic Framework

本文来自google中的一篇关于$cordovaSQLite使用的例子，摘自https://codepad.co/snippet/131f3b

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(false);
        }
        if(window.StatusBar){
            StatusBar.styleDefault();
        }
        db = $cordovaSQLite.openDB({ name: 'app.db' });
        $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 ROWS EXIST");
            }
        }, function(error) {
            console.error(error);
        });
    };

});

实现这个的前提得先安装插件：cordova plugin add https://github.com/litehelpers/Cordova-sqlite-storage.git
还得引入ng-Cordova.js文件。