Detailed explanation of phonegap operation database-H5 Tutorial-php.cn

Home

Web Front-end

H5 Tutorial

Detailed explanation of phonegap operation database

Mar 26, 2018 pm 03:02 PM

database Detailed explanation

This time I will bring you a detailed explanation of the phonegap operation database, what are the precautions for phonegap operation database, the following is a practical case, let's take a look.

The examples are as follows:

&lt;!DOCTYPE html&gt; 
&lt;html&gt; 
   
    &lt;head&gt; 
        &lt;meta charset=&quot;UTF-8&quot;&gt; 
        &lt;title&gt;Database Example&lt;/title&gt; 
   
        &lt;script type=&quot;text/javascript&quot; charset=&quot;UTF-8&quot; src=&quot;cordova.js&quot;&gt;&lt;/script&gt; 
        &lt;script type=&quot;text/javascript&quot; charset=&quot;UTF-8&quot;&gt; 
            document.addEventListener("deviceready", onDeviceReady, false); 
   
            function onDeviceReady() { 
                var db=window.openDatabase("Test","1.0","Test",200000); 
                db.transaction(populateDB,errorDB,successDB); 
            } 
               
            //初始化数据库数据 
            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,"Tony")'); 
            } 
               
            //查询方法 
            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+"&lt;br /&gt;"; 
                for(var i=0;i&lt;len;i++){ 
                    string+=results.rows.item(i).name+"&lt;br /&gt;"; 
                } 
                status.innerHTML=string; 
            } 
               
            //执行初始化数据成功后的回调 
            function successDB(){ 
                var db=window.openDatabase("Test","1.0","Test",200000); 
                db.transaction(queryDB,errorDB); 
            } 
               
            //失败回调 
            function errorDB(err){ 
                alert('Error processing SQL:'+err.code); 
            } 
               
        &lt;/script&gt; 
    &lt;/head&gt; 
   
    &lt;body&gt; 
        &lt;h1&gt;Names&lt;/h1&gt; 
        &lt;p id=&#39;status&#39;&gt;&lt;/p&gt; 
    &lt;/body&gt; 
   
&lt;/html&gt;

Copy after login

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the PHP Chinese website !