Skip to main content

Creating SQL lite database using PhoneGap


1. Create a new android mobile application using Jquery mobile and PhoneGap.
 The openDatabase() method used for creating database in mobile.
                Syntax:
        var dbShell = window.openDatabase(name, version, display_name, size);
 Description :
                This method will create a new SQL Lite database and return a new database object. You can  use this database for performing sql operation.       
                Parameters
1.       Name – The name of the database
2.       Version – The version of the database
3.       Display name – The display name of the database
4.       Size – The size of the database in bytes.
2. Replace the index.html with following code.

<!DOCTYPE HTML>
<html>
  <head>
    <meta name="viewport" content="width=320; user-scalable=no" />
    <meta http-equiv="Content-type" content="text/html; charset=utf-8">
    <title>PhoneGap Demo With JQuery Mobile</title>
      <link rel="stylesheet" href="jquery.mobile/jquery.mobile-1.0rc2.css" type="text/css" charset="utf-8" />
        <link rel="stylesheet" href="pgandjqm-style-override.css" type="text/css" charset="utf-8" />
        <script type="text/javascript" src="jquery.mobile/jquery-1.6.4.min"></script>
        <script type="text/javascript" charset="utf-8" src="phonegap-1.1.0.js"></script>
        <script src="jquery.mobile/jquery.mobile-1.0rc2.js"></script>
        <script type="text/javascript" charset="utf-8" src="main.js"></script>
  </head>
  <body onload="init();">
    <div data-role="page" data-theme="b">
            <div data-role="header">
            <h4>PhoneGap with JQuery Mobile</h4>
            </div> <!-- end jqm header -->
      <div data-role="content">
            <a href="#" data-role="button" onclick="displayDatabaseDetails()">DB Details</a>
            <span id="databaseDetails">
                 
            </span>
      </div> <!-- end jqm content -->
      <div data-role="footer">
            <h4>Footer content</h4>
      </div> <!-- end jqm footer -->
    </div><!-- end jqm page -->
  </body>
</html>

3. Open the main.js and replace with following code.

 
var localDatabase = null;
function init() {
      //Creating SQL Lite database..
      localDatabase = window.openDatabase("TestDB","1.0","PhoneGap TestDB ",300000);
      localDatabase.transaction(populateDatabase,errorCreateDatabase,successCreateDatabase);
}

function populateDatabase(db) {
      db.executeSql("DROP TABLE IF EXISTS DEMO");
      db.executeSql("CREATE TABLE IF NOT EXISTS DEMO(id unique,name)");
      //Inserting some dummy records into demo table.
      db.executeSql("INSERT INTO DEMO(id,name) VALUES (1,'xxxxxxx')");
      db.executeSql("INSERT INTO DEMO(id,name) VALUES (2,'yyyyyyy')");
      db.executeSql("INSERT INTO DEMO(id,name) VALUES (3,'zzzzzzz')");
}

function errorCreateDatabase(err) {
      alert("Error in creation database function...! " + err.code);
}

function successCreateDatabase() {
      //alert("Database created successfully....!");
}

function displayDatabaseDetails() {
      localDatabase.transaction(executeQuery,errorTransaction,successTransaction);
}

function errorTransaction(err) {
      alert("Error in transaction....!");
}

function successTransaction() {
      alert("Success transaction....!");
}

function executeQuery(db) {
      db.executeSql("SELECT * FROM DEMO",[],querySuccess,queryFailure);
}

function querySuccess(tx,results) {
      //alert("Query executed successfully....!");
      //Getting row length...
var rowLength = results.rows.length;
      var str = "ID     Name<br/>";
      for(var i=0;i<rowLength;i++) {
            //Getting id and name value using item() method
            str += results.rows.item(i).id + "     " + results.rows.item(i).name + "<br/>";
      }
      $("#databaseDetails").html(str);
}

function queryFailure() {
      alert("Query execution failed....!");
}

Here the  executeSql()method was used for executing sql query.

4. Now run the application .
                    
               

5. Click the DB Details button, you can able to see the all the inserted records.
                


Comments

Popular posts from this blog

Ext JS 4 – Creating web page using Ext.container.Viewport class and region propery

The Ext.container.Viewport is used for creating general web page and region property is used for splitting web page into different parts. Ext.container.Viewport is a specialized container represents the viewable area of the application (the browser area). It render itself to the document body, there is no need for providing renderTo property and it automatically sizes itself to size of the browser viewport. The viewport also re-size the child elements based on view area(based on browser width and height). The default layout of the viewport is border layout and we can customize this property according to our requirements. The viewport does not provide any scrolling. If necessary, the child elements(generally panels) within viewport needs to provide a scroll feature by using autoScroll property. See the below example for better understanding. This is Home.js file placed into app/view folder. Ext.define('MyApp.view.Home', { extend : 'Ext.container.Viewport&#

Getting key/value pair from JSON object and getting variable name and value from JavaScript object.

 Hi, I had faced one issue like this. I have an JSON object but I don't know any key name but I need to get the all the key and corresponding value from JSON object using client side JavaScript. Suddenly I wondered whether it's possible or not, after that I had done lot of workaround and finally got this solution. See the below example.    function getKeyValueFromJSON() {     var jsonObj =  {a:10,b:20,c:30,d:50} ;     for ( var key in jsonObj) {       alert( "Key: " + key + " value: " + jsonObj[key]);     }  }  In this example I have created the one json array as string, and converted this string into JSON object using eval() function. Using for-each loop I got all the key value from jsonObj, and finally using that key I got the corresponding value.  Finally I got the alert like this,    Key: a value:10    Key: b value:20    Key: c value:30    Key: d value:50  During this workaround I got one more idea, using this same way I got

Simple Login Application Using Spring MVC and Hibernate – Part 1

 I hope developers working in web application development might hear about MVC architecture. Almost all technologies provide support for MVC based web application development, but the success is based on many factors like reusable of the code, maintenance of the code, future adaption of the code, etc..,  The success of the Spring MVC is “ Open for extension and closed for modification ” principle. Using Spring MVC the developers can easily develop MVC based web application. We don’t need any steep learning curve at the same time we need to know the basics of spring framework and MVC architecture. The Spring MVC consists of following important components. 1. Dispatcher servlet 2. Controller 3. View Resolver 4. Model Spring MVC - Overview  The overall architecture of Spring MVC is shown here.  1. When “Dispatcher Servlet” gets any request from client, it finds the corresponding mapped controller for the request and just dispatches the request to the corresponding contro