sqlite code

来源：互联网发布：linux vi使用编辑：程序博客网时间：2024/05/20 02:55
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);});