wex5 sqllite本地数据库的运用

http://doc.wex5.com/?p=3774

需要引入包require("cordova!com.brodysoft.sqlitePlugin");

 

 

//本地数据库操作

document.addEventListener("deviceready", onDeviceReady, false);

//设备就绪

function onDeviceReady() {

self.db = window.sqlitePlugin.openDatabase({

name : "device.db"

});

self.db.transaction(function(tx) {

 

// 如果没有就建表 id integer primary key id自增长

tx.executeSql('CREATE TABLE IF NOT EXISTS health_table ( id integer primary key,name String,xueya String,xueyang String,xinlv String,time String)');

 

//查询

tx.executeSql("select * from health_table where name = ?;", [self.name], function(tx, res) {

for ( var i = 0; i < res.rows.length; i++) {

var json ="{defaultValues[{'id':'"+res.rows.item(i).id+"','name':'"+res.rows.item(i).name+"','xueya':'"+res.rows.item(i).xueya+"','xueyang':'"+res.rows.item(i).xueyang+"','xinlv':'"+res.rows.item(i).xinlv+"','time':'"+res.rows.item(i).time+"'}]}";

self.comp("healthbaasData").newData(eval("("+json+")"));

}

});

});

}

 

//查询

self.db.transaction(function(tx) {

tx.executeSql("select * from test_table;", [], function(tx, res) {

for ( var i = 0; i < res.rows.length; i++) {

var record = res.rows.item(i).id + " " + " " + res.rows.item(i).data + " " + res.rows.item(i).data_num;

console.info("记录内容： " + record);

}

});

});

 

//插入

self.db.transaction(function(tx) { //插入

tx.executeSql("INSERT INTO bloodg_table (name,xuetang,time) VALUES (?,?,?)", [self.name,xuetang,time], function(tx, res) {

});

});

 

//删除

self.db.transaction(function(tx) {

tx.executeSql("delete from test_table where id = ? ", [delId], function(tx, res) {

console.info(res);

});

});