Use Of SQLite

Backup Manager

 

This is a sample program which shows usage of SQLite in android application for saving data. This application has two buttons in the main menu one for saving information and another for showing all saved information. Last blog published in this forum is How to handle bluetooth settings from your application.

Underlying Algorithm:

Basic description of algorithm in step by step form:
1.) Create a Project DatabaseSample.
2.) Replace the following code with res/layout/main.xml :

 

 

 

3.) Create a helper class DataManipulator.java that can create the database and encapsulate other SQL details. In this DataManipulator class we will include an important inner class OpenHelper that provides a SQLiteOpenHelper.

 

 

 

4.) Create a save.xml in res/layout/save.xml:

 

 

 

5.) Create a Activity SaveData.java to Save the information :

 

 

 

6.) Create a ListView to show the all data in a list in res/layout/check.xml :

 

 

 

7.) Create a Activity CheckData.java :

 

 

 

9.) Run the Application.

Steps to Create:

1.) Open Eclipse. Use the New Project Wizard and select Android Project Give the respective project name i.e. DatabaseSample. Enter following information:
Project name: DatabaseSample
Build Target: Android 2.1
Application name: DatabaseSample
Package name: com.app.DatabaseSample
Create Activity: DatabaseSample

On Clicking Finish DatabaseSample code structure is generated with the necessary Android Packages being imported along with DatabaseSample.java. DatabaseSample class will look like following :

 

 

 

To download source code of above example Click Here.

Output – The final output:

Comments 70

  1. Thanks a bunch!! its is exactly what i was looking for in my project.
    Qn: i am working on an android app which i want to connect to webservice (in this case json-rpc webservice i have created in php) using Json-rpc method. could you please help me on this if u don’t mind.. thanks again.

    • You might be using mismatched build and AVD version.

      To add a new AVD in eclipse:

      * Window => “Android SDK and AVD manager”
      * New

      Check what version you are using in your project and create a new AVD with that target version.

      Thanks..

  2. Hi shusant,
    when ever i run the program and click to any function it say “This king of launch is configured to open the debug perspective when it suspends.
    This debug perspective is designed to support application debugging. It incorporates views for displaying the debug stack variables and breakpoint management.”

    what it means and what is the error i am repeating which gives this.
    plz help me in this

    • You might not running your app. You are debugging it. You can do following to fix this problem:

      1.) Press Ctrl+F11 and run your app instead of start debugging.
      2.) Go to Run->Remove All breakpoints and then run your app.

      The message you are getting is debugger message.

  3. hi,i am able to see my screen with 2 btns save , check data.But when clicked gettting bellow err : The application datsabasesample(process com.app.DatabseSample) has stopped unexpectedly .Please try again with a btn ‘FORCE CLOSE’
    Plz give me solution

  4. hi sushant first thanx for valuable guidance ………this application work proper but where is the database file generated ,i check in the file explorer file in com.package name but …i cant able to find database file

  5. hey im new to android development, i did this sample and it managed to work perfectly i was wondering if i can be able to view the database in sqlite browser , how would i be able to open it , any assistance will be very much appreciated

  6. hey thanks fr the post i was wondering whether it was possible to export this database to be viewed in sqlite browser if so please advice im new in android development thanks

  7. hello sushant. I want to do my final year project with android.i want to make an app dat can mange a list of things to do and alert the user when its time.any help will be appreciated??

  8. sushant, am trying to add date and time to every contact in the list so i can recieve a notification in the title bar when its that time.pls can you help??

  9. Thanks its working properly.It helped me a lot.Now i want to retrieve data from sqlite using select query with where clause.Can u tell me how can i do this.Please help me.Its very urgent.Thanks in advance.

  10. Pingback: Breakhearts
  11. Hi Sushant,

    I am new to android programming and I am a student. I am working on a project similar to DNA-Alignment given in this site “https://market.android.com/details?id=blink.dna.align&feature=search_result#?t=W251bGwsMSwxLDEsImJsaW5rLmRuYS5hbGlnbiJd” but I am using Boyer-Moore Algorithm to align the strings. I have done with the framework “main.xml” but I’m getting confused as I don’t know how to manipulate the comparison step by step in android using indents as shown in this java applet “http://home.avvanta.com/~doyle/bmi.html”. Please help me as I am working on my final project for my academics. I am looking forward to hearing from you!

  12. Hi,i have same errors as madhavi when i try click save data it gives me gives error:the application datsabasesample(process com.app.DatabseSample) has stopped unexpectedly .Please try again with a btn ‘FORCE CLOSE’, i run d app without debugging your code have been the only code i exported without errors. really need this for my project.

  13. Hi,i have same errors as madhavi when i try click save data it gives me gives error:the application datsabasesample(process com.app.DatabseSample) has stopped unexpectedly .Please try again with a btn ‘FORCE CLOSE’, i run d app without debugging your code have been the only code i exported without errors. really need this for my project. Thanks

  14. hi madhavi…i m gettng the same problm of “The application datsabasesample(process com.app.DatabseSample) has stopped unexpectedly .Please try again with a btn ‘FORCE CLOSE’”….plz tell me whot did u do to overcome it….

  15. Sushant, can I know how to display few columns from database table to different text views? Because I want to make my data to be display more organize.. Thank you

  16. I hit the same problem with the Force Close, and looked at my logs. This showed:

    FATAL EXCEPTION: main
    android.content.ActivityNotFoundException: Unable to find explicit activity class {com.app.DatabaseSample/com.app.DatabaseSample.SaveData};

    I checked my code against the source code, and found the activities missing from the manifest xml:

    Now it WORKS!! This was a good activity for me, not only did I learn about integration with the sqllite database, but also a good example of using multiple activities. I am going to build a similar app, and will post a link back here.

    THANKS FOR THE GREAT EXAMPLE!!!
    -ac

  17. I hit the same problem with the Force Close, and looked at my logs. This showed:

    FATAL EXCEPTION: main
    android.content.ActivityNotFoundException: Unable to find explicit activity class {com.app.DatabaseSample/com.app.DatabaseSample.SaveData};

    I checked my code against the source code, and found the activities missing from the manifest xml:

    <activity android:name=".SaveData" android:label="@string/app_name">
    </activity>
    <activity android:name=".CheckData" android:label="@string/app_name">

    </activity>

    Now it WORKS!! This was a good activity for me, not only did I learn about integration with the sqllite database, but also a good example of using multiple activities. I am going to build a similar app, and will post a link back here.

    THANKS FOR THE GREAT EXAMPLE!!!
    -ac

  18. Hi Sushant,

    Great article, thanks.

    I just started learning Android, and hope you can help with a question of your sample app. In the app, the background is black, while the text’s foreground is white. That seems to be opposite to the default color setting. Could you let me know how you achieved that? I tried looking through the sample code, but couldn’t figure out.

    Thanks for your help.

  19. Hi Sushant,

    Great article, thanks.

    I just started learning Android, and hope you can help with a question of your sample app. In the app, the background is black, while the text’s foreground is white. That seems to be opposite to the default color setting. Could you let me know how you achieved that? I tried looking through the sample code, but couldn’t figure out.

    Thanks for your help.

  20. Nice looking app. However when I load the code into Eclipse I get an error in the onClick(View). I loaded the code into a Android project from existing code. When I look at the build properties it tells me that it is using 2.3.3. Could this be the reason that I’m seeing these error.

  21. Hi

    I have the same error as savita, rabiu,…

    the application datsabasesample(process com.app.DatabseSample) has stopped unexpectedly .Please try again with a btn ‘FORCE CLOSE’

    Does some of you have a solution already?

  22. Hi susanth thanks and i have small doubt how i could see the table and table data by using sqlite browser for above application

    Thanks in advance

  23. hi,pleaz i need your help when i click save button or check data button i receive :”unfortunately “myproject” has qtopped” also the expession “showDialog(DIALOG_ID);” is barred it tells me that:”The method showDialog(int) from the type Activity is deprecated”

  24. can anyone suggest solution for foreclose problem after you press save button…..and its showing fatal error in log cat also please help

  25. Hi Sushant,plz help me i have followed the same code as in the blog.. i can see SaveData and Check button in thw mean while onclick of any one button it is followed with err:”Unfortunately DatabaseSample has stopped” plz do help me to come out of this error its very needfull for me.
    Thanks

  26. good tutorial….but i want to know is it possible to store received sms directly in database?if you have any idea then please explain.i appreciate if any suggestion from you.

  27. Hi and thank for your effort but I think there must be some difference between deleteAll and delete(int id)…
    Did u get what I mean :)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">