In this article I am going to explain how create a database in an Android application and how create table in the database.

·         Start a new project named TableDemo.

·         Open res/layout/main.xml and insert the following:

<?xml  version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent">
<TextView
       android:id="@+id/txtView"
       android:layout_marginLeft="100dp" 
       android:layout_width="fill_parent"
       android:layout_height="wrap_content"
       android:text="@string/hello"/>
</LinearLayout>

·         Open the Activity file and insert the following code:

import java.util.Locale;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.TextView;
 
public class DatabaseActivity extends Activity {
   
       private String table_name="StudentInfo";
      
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        SQLiteDatabase db;
       
        // create or open database file
        db = openOrCreateDatabase("Test.db" , SQLiteDatabase.CREATE_IF_NECESSARY, 
                                                                             
                                                                              null);
        db.setVersion(1);
        db.setLocale(Locale.getDefault());
        db.setLockingEnabled(true);
       
        // creating table in database
        db.execSQL("CREATE TABLE IF NOT EXISTS "+table_name+" " +
                        "( sid INTEGER PRIMARY KEY AUTOINCREMENT," +
                        "  name TEXT" +
                        "  age INTEGER" +
                        "  course TEXT ); ");
       
        // capture element id from layout
        TextView txtView=(TextView)findViewById(R.id.txtView);
        txtView.setText("Table created");
    }
}

·         Run the application.

The output should look like below:

Create Table in Android Database

TextView display a message Table created when you run an application.

·         Check the created table in the adb shell:

In order to check the tables and database information from the database, you can use adb shell provided by Android SDK:

1)      Run the cmd (command prompt).

2) Go to the following location: d:\android-sdk_r13-windows\android-sdk-windows\platform-tools> (you have to user your own location).

3)      Type adb shell and press enter, a # symbol will display.

4)      Type sqlite3 /data/data/ [package name]/databases/database-name Test.db) and press Enter.
For e.g. sqlite3 /data/data/com.android.databaseDemo/databases/Test.db

5)      Then type .tables in order to see the table present in the database.

6)      It will show you a list tables present in the database.

Thanks for reading this article. I think this will help you a lot.


Leave Comment