Скачать или смотреть Practical approach to insert record in SQLite database in Android using Java Programming

Android provides different ways to store data locally so using SQLite is one the way to store data. SQLite is a structure query base database, hence we can say it’s a relation database. Android os has its own implementation to perform CRUD (Create, Read, Update, Delete)operations, so Android provides set of classes available in android.database and android.database.sqlite packages.

While using SQLite there could be two different ways to perform different operations like create, read, update and delete. One writing raw queries and another is using parameterized functions or we can say parametrized queries.

Create: Creating a database is very simple in android by using SQLiteOpenHelper class. SQLiteOpenHelper is an abstract class with two abstract methods onCreate(SQLiteDatabase db) and onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) and many more database helpful functions.

onCreate(SQLiteDatabase sqLiteDatabase) method is called only for once throughout the application lifecycle, it will be called whenever there is first call to getReadableDatabase() or getWritableDatabase() function available in super SQLiteOpenHelper class so SQLiteOpenHelper class call the onCreate() method after creating database and instantiate SQLiteDatabase object. Database name is passed in constructor call.

onUpgrade(SQLiteDatabase db,int oldVersion, int newVersion) is only called whenever there is a updation in existing version so to update a version we have to increment the value of version variable passed in the superclass constructor. In onUpgrade method we can write queries to perform whatever action is required. In most example you will see that existing table(s) are being dropped and again onCreate() method is being called to create tables again. But it’s not mandatory to do so it all depends upon your requirements. We have to change database version if we have added a new row in the database table in this case if we have requirement that we don’t want to lost existing data in the table then we can write alter table query in the onUpgrade(SQLiteDatabase db,int oldVersion, int newVersion) method.

Insert, Read, Delete & Update Operation In Sqlite:
To perform insert, read, delete, update operation there are two different ways:

Write parameterized queries (Recommended)

Write raw queries
Parameterized Queries: These are those queries which are performed using inbuilt functions to insert, read, delete or update data. These operation related functions are provided in SQLiteDatabase class.

Raw Queries: These are simple sql queries similar to other databases like MySql, Sql Server etc, In this case user will have to write query as text and passed the query string in rawQuery(String sql,String [] selectionArgs) or execSQL(String sql,Object [] bindArgs) method to perform operations.

To insert data into a table, you use the INSERT statement. SQLite provides various forms of the INSERT statements that allow you to insert a single row, multiple rows, and default values into a table.

In addition, you can insert a row into a table using data provided by a SELECT statement.

SQLite INSERT – inserting a single row into a table
To insert a single row into a table, you use the following form of the INSERT statement:

INSERT INTO table (column1,column2 ,..)
VALUES( value1, value2 ,...);

Code language: SQL (Structured Query Language) (sql)

Let’s examine the INSERT statement in more detail:
First, specify the name of the table to which you want to insert data after the INSERT INTO keywords.
Second, add a comma-separated list of columns after the table name. The column list is optional. However, it is a good practice to include the column list after the table name.
Third, add a comma-separated list of values after the VALUES keyword. If you omit the column list, you have to specify values for all columns in the value list. The number of values in the value list must be the same as the number of columns in the column list.

The following statement insert a new row into the artists table:
INSERT INTO artists (name)
VALUES('CDPATEL');