Create Database SQLite,Create Table and columns and Insert Data

package Database;

import android.content.Intent;

import android.database.SQLException;

import java.util.Locale;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;Save Now

import android.app.Activity;

import android.content.ContentValues;

public class SQLiteMainActivity extends Activity {

SQLiteDatabase databaseObj;

/** Called when the activity is first created. */

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

createOpenDatabase();

createTable();

insertInTable();

}

boolean createOpenDatabase() {

try {

String dbName = "MyDataBase";

databaseObj= openOrCreateDatabase(dbName,

SQLiteDatabase.CREATE_IF_NECESSARY, null);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return true;

}

boolean createTable() {

databaseObj.setVersion(1);

databaseObj.setLocale(Locale.getDefault());

databaseObj.setLockingEnabled(true);

try {

final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS TBL_MyTable ("

+ "id INTEGER PRIMARY KEY AUTOINCREMENT,"

+ "Name TEXT,"

+ "Address TEXT,"

+ "Country TEXT)";

databaseObj.execSQL(CREATE_TABLE);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return true;

}

void insertInTable() {

ContentValues values = new ContentValues();

values.put("Name", "NasirAftab");

values.put("Address", "JLT Dubai");

values.put("Country", "UAE");

try {

databaseObj.insertOrThrow("TBL_MyTable", null, values);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}