wex5 sqllite本地数据库的运用
需要引入包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);
});
});
