sqlite code

概述var db = new PGSQLitePlugin("TESTDB", function(dbResult, dbObject){ console.log("Database status=" + dbResult.status); console.log("Database version=" + dbResult.version); db = dbObj

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);		});

总结

以上是内存溢出为你收集整理的sqlite code全部内容，希望文章能够帮你解决sqlite code所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。