cordova数据库操作

     document.addEventListener('deviceready', function() {
                                  db = window.sqlitePlugin.openDatabase({name: 'test.db', location: 'default'});
                                  });
    function Select(){
        db.executeSql('SELECT * FROM yanghong where name=?', ['panpan'], function(rs) {
                 /**
                  *  数据库查询
                  */
                 for(var i=0;i<rs.rows.length;i++){
                 console.log('Record count (expected to be 2): ' + rs.rows.item(i).name);

                 }
                 }, function(error) {
                 console.log('SELECT SQL statement ERROR: ' + error.message);
                                     });

    }
    function Updata(){
        db.transaction(function(tx) {
                       /**
                        *  数据库修改
                        */
                       tx.executeSql('UPDATE yanghong SET name=? where age=12', ['qqqqq']);
           });


    }
    function Delect(){
        /**
         *  删除表 db.executeSql('DROP TABLE IF EXISTS DemoTable');
         */
        db.transaction(function(tx) {

                       tx.executeSql('DELETE FROM yanghong where age=?',[30],function() {
                                     console.log('Populated database OK');
                                     }, function(error) {
                                     console.log('Transaction ERROR: ' + error.message);
                                     });
                       });


    }
    function Insert(){
    //添加数据
        db.transaction(function(tx) {
                       console.log(999999)
                       var name=encodeURI("panpan");
                       tx.executeSql('INSERT INTO yanghong VALUES (?,?,?,?,?)', [name, 22,30,'abc','hahah']);

                       }, function(error) {
                       console.log('Transaction ERROR: ' + error.message);
                       }, function() {
                       console.log('Populated database OK');
                       });
    }