How to Create DataBase in Android


 

Download APK Download Source Code Contact Us

Create a new project in Android Studio

File – New Android Project

How to Create DataBase in Android

How to Create DataBase in Android

Using of DataBaseHelper Class

Once the projected is created create a new class in your project src directory and name it as DataBaseHendler.java(Right click on src/package – New – Class)

Now extend your DatabaseHandler.java class from SQLiteOpenHelper.

public class DataBaseHendler extends SqLiteOpenHelper {

After extends your class from SqLiteOpenHelper you need to override two method onCreate() and onUpgrade.

onCreate():-These is where we need to write create table statements. This is called when database is created.

onUpgrade():-This method is called when database is upgraded like modifying the table structure, adding constraints to database .

Create DataBaseHelper Class
Right click on package Name – New – Java Class

For Ex:-

public class DataBaseHelper extends SQLiteOpenHelper {
    // Database version name
    private static final int DATABASE_VERSION = 1;
    // Database name
    private static final String DATBASE_NAME = "regForm.db";

      public static final String TABLE_NAME = "user";
      public static final String USER_ID = "_id";
     public static final String NAME = "name";
     public static final String EMAIL = "email";

    public DataBaseHelper(Context context) {
        super(context, DATBASE_NAME, null, DATABASE_VERSION);
    }

    //Creating Tables
    @Override
    public void onCreate(SQLiteDatabase db) {
String CREATE_USER_TABLE = "create table " + TABLE_NAME
                + " ( " + USER_ID + " integer  primary key autoincrement,"
                + NAME + " TEXT,"
                + EMAIL + " TEXT,"
db.execSQL(CREATE_USER_TABLE);    }
    // Upgrading database
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

Inserting new Record in the Table

To Insert a new Record in Table we need to create an Object of ContentValues class and put the Values in this like:

 // Assign value for each row
    ContentValues values = new ContentValues();
    values.put(KEY_NAME, contact.getName()); // Contact Name
    values.put(KEY_PH_NO, contact.getAddress()); // Contact Address
    // Insert the row into your table
    db.insert(TABLE_CONTACTS, null, values);
    db.close(); // Closing database connection
}

Reading Row

For Ex:

How to Create DataBase in Android

Deleting Record

deleteContact() will delete single contact from database.
   deleteContact()
public void deleteContact(Contact contact){
SqLiteDatabase db=this.getWriteableDatabase();
 Db.delete(TABLE_CONTACTS, KEY_ID + “ ?”, new String [] { String.valueof(contact.getid)});
Db.close();
}
How to Create DataBase in Android
How to Create DataBase in Android
How to Create DataBase in Android

Download APK Download Source Code Contact Us

Posted in All Tutorials, Android Tutorials | Tagged | Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Powered By: wpnova.com