Check Mobile App
Read now
Start a Project

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.


When I think in getting solutions for my Ecommerce Platform, I think of Webkul. They have been such a blessing in our business. We have spent thousands of dollars in support and modules from them. We love their support team. They work very closely with us, and they always go the extra mile when we need help.

Michael Urresta

Michael Urresta

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