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.
                


Labels:

Comments

Post a Comment

Popular posts from this blog

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...
36 comments
Read more

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 c...
52 comments
Read more

Simple Login Application Using Spring MVC and Hibernate – Part 2

 I hope you have visited my part1 of my tutorial . Let’s see the steps for integrating hibernate framework into Spring MVC. Here I have used MySQL database. I have created one database called “ springmvc ” and created one table called “ user ” with userid, username, password fields.  I have inserted some records into table like this. Step 1: Creating User POJO class.  We need to create a User POJO class for mapping user table. Ok let’s create it. Step 2: Creating hibernate mapping xml file for user class.  In hibernate we need to create hibernate mapping xml file for all domain class for mapping into corresponding database table. Instead of creating xml file you can use annotation for mapping domain class into database table. This is my mapping xml document created for mapping our user domain class into user database table. Step 3: Creating authenticate service class.  The method “verifyUserNameAndPassword” pres...
38 comments
Read more