前端之家收集整理的这篇文章主要介绍了
sqlite code,
前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
var db = new PGsqlitePlugin("TESTDB",function(dbResult,dbObject){
console.log("Database status=" + dbResult.status);
console.log("Database version=" + dbResult.version);
db = dbObject;
db.open(function(){
//alert("chengong")
db.executesql("CREATE TABLE IF NOT EXISTS TEST (ID INTEGER PRIMARY KEY ASC,IMGDATA TEXT,INSERTDATE TEXT,PARAM TEXT)",function(){
//console.log( "table test was created" );
//alert("table test was created");
var nowTime=new Date();
var nowTimeString=(nowTime.format('yyyy-MM-dd hh:mm:ss')).toString();
db.insert("TEST",{IMGDATA:dealedImg,INSERTDATE:nowTimeString,PARAM:'123456' },function(id){
//console.log("id="+id);
//alert("sadsdsa");
alert("id="+id);
},function(er){
console.log("error="+er);
});
db.query("TEST",["ID","IMGDATA","INSERTDATE","PARAM"],null,[],"ID",function(res){
for (var i in res.rows){
for (var key in res.rows[i]){
alert(key + "=" + res.rows[i][key]);
//console.log(key + "=" + res.rows[i][key] );
}
}
},function(er){
console.log("error="+er);
});
},function(err){
console.log("error creating table test::" + err);
});
},function(err){
alert("Error create database::err=" + err);
//console.log("Error create database::err=" + err);
});
//navigator.notification.alert("Database status=" + dbResult.status+"Database version=" + dbResult.version);
},function(err){
console.log("Error create database::err=" + err);
});