Home > DeveloperSection > Beginner > Create Table in Android Database

Create Table in Android Database


Android Android 
Ratings:
0 Comment(s)
 10456  View(s)
Rate this:

Create Table in Android Database

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.


Don't want to miss updates? Please click the below button!

Follow MindStick