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, [], null, null, "ID", null, 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);
});
sqlite code
最新推荐文章于 2022-05-06 17:11:13 发布