Try popular Android Application by Feliz-Droid

Try popular Android Application by Feliz-Droid

Speaking Caller logo
Speaking Caller
   
Battery temperature logo
Battery Temperature
   
Dual Photo logo
Dual Photo
   
Ganesh Wallpapersl ogo
Lord Ganesh Wallpaper
   
Girly Pink Keyboard l ogo
Girly Pink Keyboard

Monday, November 21, 2011

sqlite example in android

Dear friends we will see how to create a sample project demo using SQLite.
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.

steps to create  a demo on sqlite.

1. copy below code of DatabaseHelper.java class.

/**
 *
 */
package com.android.sqlite.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;

/**
 * @author Sandeep
 * @since 18 Nov 2011
 */
public class DatabaseHelper extends SQLiteOpenHelper {

    private static final String DB_PATH = "/data/data/com.android.sqlite/databases/";
    private static final String DB_NAME = "example.db";

    /**
     * @param context
     * @param name
     * @param factory
     * @param version
     */
    public DatabaseHelper(Context context, String name, CursorFactory factory,
            int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        // TBL_CONTACT
        String query = "CREATE TABLE CONTACT "+" "+" (ID INTEGER, FName TEXT, LName TEXT, Contact_no TEXT);";

        db.execSQL(query);


    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    /**
     * Check if the database already exist to avoid
     * re-copying the file each time you open the application.
     * @return true if it exists, false if it doesn't
     */
    public boolean checkDataBase(){

        SQLiteDatabase checkDB = null;

        try{
            String myPath = DB_PATH + DB_NAME;
            checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);


        }catch(SQLiteException e){
            //database does't exist yet.
        }

        if(checkDB != null){
            checkDB.close();
        }

        return checkDB != null ? true : false;
    }
}


2. Now create a class DBOperation.java which contain all insert,delete functions.

package com.android.sqlite.db;


import com.android.sqlite.newcontact;
import com.android.sqlite.welcome;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class DbOperation {
    DatabaseHelper dbHelper = null;

    public DbOperation() {
        dbHelper = welcome.dbHelper;
    }

    /* Add contact */
    public void addContact(String fname, String lname, String number) {
        SQLiteDatabase db = dbHelper.getWritableDatabase();

        ContentValues cv = new ContentValues();
        cv.put("FName", fname);
        cv.put("LName", lname);
        cv.put("Contact_no", number);
        db.insert("CONTACT", null, cv);
        db.close();
    }

    public String[][] getAll(String query){
        String[][] array = null;
        SQLiteDatabase db = null;
        Cursor cursor = null;
       
        try {
            db = dbHelper.getReadableDatabase();
            cursor = db.rawQuery(query, null);
           
            if(!cursor.isFirst()){
                cursor.moveToFirst();
            }
           
            int rowCount = cursor.getCount();
            int columnCount = cursor.getColumnCount();
           
            array = new String[rowCount][columnCount];
           
            int index =0;
           
            if(cursor.isFirst()){
                do{
                    for(int j=0;j<columnCount;j++){
                        array[index][j]= cursor.getString(j);
                        System.out.println(cursor.getColumnName(j)+":"+cursor.getString(j));
                        System.out.println();
                    }
                    index++;
                }while(cursor.moveToNext());
            }
           
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            if(cursor!=null)
            cursor.close();
            if(db!=null)
            db.close();
        }
        return array;
    }
}


3. Now copy these code in main.java
package com.android.sqlite;



import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

import com.android.sqlite.db.DatabaseHelper;
import com.android.sqlite.db.DbOperation;

/**
 *
 * @author Sandeep Sharma
 *
 */
public class welcome extends Activity {
   
    public static DatabaseHelper dbHelper=null;
    public DbOperation dboper=null;
    private boolean dbExist;
    private EditText fname,lname,contact;
    Button newcontact;
   
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.lead_list);
       
       
      //---create db ---
        dbHelper = new DatabaseHelper(this,"example.db",
                null,1);
        dbExist = dbHelper.checkDataBase();
        dboper=new DbOperation();
       
        fname=(EditText)findViewById(R.id.edt_Fname);
        lname=(EditText)findViewById(R.id.edt_Lname);
        contact=(EditText)findViewById(R.id.edt_contact);
       
        newcontact=(Button)findViewById(R.id.button1);
       
        newcontact.setOnClickListener(new OnClickListener() {
           
            @Override
            public void onClick(View v) {
           
                dboper.addContact(fname.getText().toString()   , lname.getText().toString(), contact.getText().toString());
               
                Toast.makeText(getApplicationContext(), "Record Saved!", Toast.LENGTH_SHORT).show();
               
               }
        });      
      }
}
 

4. Overwrite your main.xml with below code.
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical" >

    <TextView
        android:id="@+id/lbl_Fname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/FName"
        android:textAppearance="?android:attr/textAppearanceLarge" />
   
    <EditText
        android:id="@+id/edt_Fname"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
       
        android:inputType="textPersonName" >

        <requestFocus />
    </EditText>

        <TextView
        android:id="@+id/lbl_Lname"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/LName"
        android:textAppearance="?android:attr/textAppearanceLarge" />

   
    <EditText
        android:id="@+id/edt_Lname"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:inputType="textPersonName" >

        <requestFocus />
    </EditText>
       
        <TextView
        android:id="@+id/lbl_contact"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/Contact"
        android:textAppearance="?android:attr/textAppearanceLarge" />

   
    <EditText
        android:id="@+id/edt_contact"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:inputType="textPersonName" >

        <requestFocus />
    </EditText>

    <Button
        android:id="@+id/button1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Save" android:gravity="center_vertical|center_horizontal" android:layout_gravity="center_horizontal" android:layout_margin="30dip"/>
       
</LinearLayout>


Now try to run code. If any variable declaration missing please correct it.

Now once you get these demo working you can find sqlite database file.

to get sqlite database file switch to ddms perspective. open file explorer you can see your database file in path below.
data/data/your_packagename/databases/example.db  
to open this file you need sqlite browser.click here to download sqlite browser