sqlite code

前端之家收集整理的这篇文章主要介绍了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);
		});

猜你在找的Sqlite相关文章