articles

Home / DeveloperSection / Articles / Create Table in Android Database

Create Table in Android Database

Chris Anderson 14142 27-Oct-2011

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.



Updated 04-Mar-2020
hi I am software developer at mindstick software pvt. ltd.

Leave Comment

Comments

Liked By