JS html5 操作SQLite

//执行查询
	
	$("#btnSQL").tap(function(){
 	<span style="white-space:pre">	</span>var db = openDatabase("mydb", "1.0", "Test DB", 2 * 1024 * 1024); 
 		db.transaction(function (tx) {            
     		<span style="white-space:pre">	</span>tx.executeSql("CREATE TABLE IF NOT EXISTS testHtml (id unique, contentText)");
     		<span style="white-space:pre">	</span>tx.executeSql("INSERT INTO testHtml (contentText) VALUES ("insert data test1!")"); 
      		}); 
      	 <span style="white-space:pre">	</span>db.transaction(function(tx){           
     		tx.executeSql("SELECT * FROM testHtml",[],function(tx,result){
           <span style="white-space:pre">		</span>var len=result.rows.length;
          	<span style="white-space:pre">	</span>app.alert(len);
    		<span style="white-space:pre">	</span>var str=result.rows.item(0);
    		<span style="white-space:pre">	</span>app.alert(str.contentText);
        <span style="white-space:pre">	</span>},null);
     <span style="white-space:pre">		</span>}); 
	});