当前位置:编程学习 > html/css >>

PhoneGap-----DataBase

EveryThing in the code!!!


[html]
<!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> 

<!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>

 

补充:web前端 , HTML/CSS  ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,