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); }
取数据