How to use database with sqlite in android


In this blog,

I have shown how to use the database SQLite in android. I have shown how to create table, insert values in that table and fetch that data from the table to access.

SQLITE: SQLite is an open source SQL database which stores the data to a text file on a device.

Android uses the SQLite database for implementation.

There are some steps to use the SQLite in android.

 Step 1: How to Create Database

For creating a database you have to call the method named openOrCreateDatabase with your database name and mode as a parameter.

Step 2: How to create table and insert in table

For creating the table or insert data into table using execSQL method defined in SQLiteDatabase class

For insertion

or we can use the ContentValues for the insertionan,

Using this you can create and store the data in DB.

. . .

Leave a Comment

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

Be the first to comment.


We've bought a Shopware Extension which is a hybrid App, which we can now offer in the Google Play Store and the IOS App Store. I'am still impressed how fast and how sharp the support team leads us through every process of the App-Store clarification. Very fast and useful response.

Markus Walter

Markus Walter

Founder, Das Apartment Living

Talk to Sales


Live Chat
Start a Project

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home