The following code shows how to create an SQLite database and a table in the database.

The SQLiteDatabase class from the package and the Cursor class from the android.database package provide all the functionality required for performing Data Manipulation Language (DML) and query operations on an SQLite table. For simplicity, I have created all fields of VARCHAR data type, which is a variable length character string. The application accepts a student's roll number, name and marks and adds these details to a student table.

The example application which I have created is a simple Student Management System, which allows a user to add, delete, modify and view student details. The example application shows how to perform basic DML and query operations on an SQLite table in Android. This article assumes that the user has a working knowledge of Android and basic SQL commands. Also most of the examples assume a deep knowledge of Android and SQL. Most of the articles and demos which I have seen on the net were not very simple for a layman to understand. In this article, I have attempted to demonstrate the use of SQLite database in Android in the simplest manner possible.

Android sqlite example