PhoneGap-----DataBase

最新推荐文章于 2020-06-23 16:43:36 发布

js_dada

最新推荐文章于 2020-06-23 16:43:36 发布

阅读量1.2k

点赞数

分类专栏： phonegap html5 文章标签： HTML PhoneGap

本文链接：https://blog.csdn.net/js_dada/article/details/9188009

版权

phonegap 同时被 2 个专栏收录

9 篇文章 0 订阅

订阅专栏

html5

8 篇文章 0 订阅

订阅专栏

EveryThing in the code!!!

<!DOCTYPE html>
<html>
<head>
<title>DataBase Example</title>
<script type="text/javascript" charset="utf-8" src="cordova.js"></script>
<script type="text/javascript" charset="utf-8">
   document.addEventListener("deviceready",onDeviceReady,false);
   
   function populateDB(tx){
	   tx.executeSql('DROP TABLE IF EXISTS test1');
	   tx.executeSql('CREATE TABLE IF NOT EXISTS test1(id unique,name)');
	   tx.executeSql('INSERT INTO test1(id,name)VALUES(1,"Tony")');
	   tx.executeSql('INSERT INTO test1(id,name)VALUES(2,"Bill")');
	   tx.executeSql('INSERT INTO test1(id,name)VALUES(3,"Thomas")');
   }
   
   function queryDB(tx){
	   tx.executeSql('SELECT * FROM test1',[],querySuccess,errorDB);
   }
   
   function querySuccess(tx,results){
	   var len = results.rows.length;
	   var status = document.getElementById("status");
	   var string = "Rows: " + len + "<br/>";
	   for(var i = 0;i<len;i++){
		   string += results.rows.item(i).name + "<br/>";
	   }
	   status.innerHTML = string;
   }
   
   function errorDB(err){
	   alert("Error processing SQL: "+err.code);
   }
   
   function successDB(){
	   var db = window.openDatabase("Test","1.0","Test",200000);
	   db.transaction(queryDB,errorDB);
   }
   
   function onDeviceReady(){
	   var db = window.openDatabase("Test","1.0","Test",200000);
	   db.transaction(populateDB,errorDB,successDB);
   }
   
</script>
</head>
<body>
   <h1>Names</h1>
   <div id="status"></div>
</body>
</html>

comments welcome!!!