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:
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.
|