ionic2本地数据库SQLite的增删改查

来源：互联网发布：怎么登录我的淘宝账号编辑：程序博客网时间：2024/06/06 02:05

1.在终端运行这两个命令

$ ionic cordova plugin add cordova-sqlite-storage$ npm install --save @ionic-native/sqlite2.在app.module.ts中添加

import { SQLite } from '@ionic-native/sqlite';

3.在app.module.ts的providers:[]中加入SQLite

4.在需要用到SQLite的ts文件中加入

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

5.在需要用到SQLite的ts文件的constructor中加入

constructor(private sqlite: SQLite,) {}

6.数据库操作

//数据库SQLite操作  database: SQLiteObject;  ngOnInit() {    this.initDB();  }  initDB(){  this.sqlite.create({   name: 'data.db',   location: 'default'  })  .then((db: SQLiteObject) => {    db.executeSql('create table if not exists saveQuestion(id INTEGER PRIMARY KEY AUTOINCREMENT, questionName text NOT NULL)', {})//建表     .then(() => console.log('Executed SQL'))     .catch(e => console.log(e));     this.database = db;  });   }  //插入数据  insert(params){    //console.log(params);    //获取当前时间    var date: string = new Date().toLocaleDateString();    var time: string = new Date().toTimeString().substring(0,5);    var datetime: string = date + " " + time;    console.log(datetime);    this.database.executeSql("INSERT INTO saveQuestion (questionName,important) VALUES (?,?);",[params.questionName,params.important])    .then(() => alert('暂存成功'))    .catch(e => console.log(e));//插入数据  }

 //修改数据  update(params){    //console.log(params);    var date: string = new Date().toLocaleDateString();    var time: string = new Date().toTimeString().substring(0,5);    var datetime: string = date + " " + time;    console.log(datetime);    this.database.executeSql("UPDATE saveQuestion set questionName=?,important=? WHERE id=?;",[params.questionName,

params.important

])

    .then(() => alert('修改成功'))    .catch(e => console.log(e));  }

//删除   buttonDelete(){     this.database.executeSql("DELETE FROM saveQuestion WHERE id=?;",[this.id])    .then(() => alert('删除成功'))    .catch(e => console.log(e));//删除数据   }

//查询  query() {    this.database.executeSql("select * from saveQuestion",{}).then((data)=>{         },(error)=>{      console.log('查询错误');    });  }

https://www.cnblogs.com/huihuihui/p/6930412.html

阅读全文

0 0