cordova sqlite ionic 4/5 总结

cordova-sqlite-storage


import {SQLite, SQLiteObject, SQLiteTransaction} from '@ionic-native/sqlite/ngx';

SQLite // 创建sql db 实例

SQLiteObject //数据库对象

/ 创建sql db 实例 
public initDb() {
  // this.sqlite.
 return  this.sqlite.create({
    name: 'task.db', 
    location: 'default'
  })
  
}

 

/**
 * 执行sql语句
 * @param {string} sql
 * @param {*} [params={}]
 * @returns {Promise<any>}
 * @memberof SQLService
 */
executeSql(sql: string, params: any = []): Promise<any> {
  return new Promise((resolve, reject) => {
    try {
      this.database.transaction((tx: SQLiteTransaction) => {
        tx.executeSql(sql, params, (tx, res) => {
          resolve({tx: tx, res: res});
        }, (tx, err) => {
          reject({tx: tx, err: err});
        });
      });
    } catch (err) {
      reject({err: err});
    }
  });
}

 

createTaskTable()
{
  let sql = 'create table IF NOT EXISTS task(id VARCHAR(255), keguanTitles VARYING CHARACTER(255), ' +
      'zhuguanTitles TEXT)';
  this.executeSql(sql).then((data) => {
    console.log(data);
  }).catch((err) => {
    console.log(err)
  });
}

 

insertTask(taskid,keguanTitles,zhuGuanTitles){

  let sql = "insert into task values('"+ taskid +"', '"+keguanTitles + "', '" + zhuGuanTitles+"')";
  console.log(sql);
  this.executeSql(sql).then((data) => {
    console.log(data);
  }).catch((err) => {
    console.log(err)
  });
}

 

updateKeGunTask(taskid,keguanTitles){

  let sql = "UPDATE task SET keguanTitles = '"+keguanTitles+"' WHERE id = '"+taskid+"'";
  console.log(sql);
  this.executeSql(sql).then((data) => {
    console.log(data);
  }).catch((err) => {
    console.log(err)
  });
}

updateZhuGuanTask(taskid,zhuguanTitle){
  let sql = "UPDATE task SET zhuguanTitles = '"+zhuguanTitle+"' WHERE id = '"+taskid+"'";
  console.log(sql);
  this.executeSql(sql).then((data) => {
    console.log(data);
  }).catch((err) => {
    console.log(err)
  });
}

getTask(taskid){
  let sql = " SELECT * FROM task where id = '"+taskid+"'";
  return this.executeSql(sql);
}

取数据