Sqlite database for an Android app

Full Example Of Sqlite DB for Android

package com.example.demo.db;

import java.util.ArrayList;
import java.util.List;

import com.example.demo.model.UserInfo;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DatabaseHandler extends SQLiteOpenHelper {
  private static final int DB_VERSION = 1;
     private static final String DB_NAME = "ubserInfo";
     private static final String TBL_NAME = "users";

     private static final String KEY_NAME = "name";
     private static final String KEY_EMAIL_ID = "email_id";
     private static final String KEY_PH_NUMBER = "ph_number";
     private static final String KEY_PHOTO = "photo";
     
     public DatabaseHandler(Context context) {
         super(context, DB_NAME, null, DB_VERSION);
     }

  @Override
  public void onCreate(SQLiteDatabase db) {
   // TODO Auto-generated method stub
   String CREATE_USER_TABLE = "CREATE TABLE " + TBL_NAME + "("
                 + KEY_NAME + " TEXT," + KEY_EMAIL_ID + " TEXT ,"
                 + KEY_PH_NUMBER + " TEXT," + KEY_PHOTO + " BLOB"+ ")";
   Log.d("qry", CREATE_USER_TABLE);
         db.execSQL(CREATE_USER_TABLE);
   
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   // TODO Auto-generated method stub
    db.execSQL("DROP TABLE IF EXISTS " + TBL_NAME);
          onCreate(db);
   
  }
  
  
  public void addUserDetails(UserInfo user) {
         SQLiteDatabase db = this.getWritableDatabase();
  
         ContentValues values = new ContentValues();
         values.put(KEY_NAME, user.getName()); 
         values.put(KEY_EMAIL_ID, user.getEmail_id()); 
         values.put(KEY_PH_NUMBER, user.getPh_number()); 
         values.put(KEY_PHOTO, user.getPhoto()); 

         db.insert(TBL_NAME, null, values);
         db.close(); 
     }
  

     public ArrayList<UserInfo> getAllContacts() {
      ArrayList<UserInfo> userList = new ArrayList<UserInfo>();
         String selectQuery = "SELECT  * FROM " + TBL_NAME;
  
         SQLiteDatabase db = this.getWritableDatabase();
         Cursor cursor = db.rawQuery(selectQuery, null);

         if (cursor.moveToFirst()) {
             do {
              UserInfo user = new UserInfo();
              user.setName(cursor.getString(0));
              user.setEmail_id(cursor.getString(1));
              user.setPh_number(cursor.getString(2));
              user.setPhoto(cursor.getBlob(3));
              userList.add(user);
             } while (cursor.moveToNext());
         }
         return userList;
     }

}

Model Class

package com.example.demo.model;

public class UserInfo {
 private String email_id;
 private String ph_number;
 private byte[] photo;
 
 private String name;
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getEmail_id() {
  return email_id;
 }
 public void setEmail_id(String email_id) {
  this.email_id = email_id;
 }
 public String getPh_number() {
  return ph_number;
 }
 public void setPh_number(String ph_number) {
  this.ph_number = ph_number;
 }
 public byte[] getPhoto() {
  return photo;
 }
 public void setPhoto(byte[] photo) {
  this.photo = photo;
 }

}

Bishnu