DBManager SQLite use in Android

 

//--------------------------------------------Code Detail and Working---------------------------------------------------------

Create Database in Android

//============================java Code Start =========================================

public class DBManager extends SQLiteOpenHelper {
    public DBManager(@Nullable Context context) {
        super(context, "demo.db", null, 1);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table if not " +
                "exists user(userid integer primary key, username text," +
                "password text,role text)");
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
    }

=========================================End==========================================

//--------------------------------------------Code Detail and Working---------------------------------------------------------

Save Database Data in Android

//============================java Code Start =========================================

public void saveUser(int id,String uname,String password, String role){
    ContentValues values = new ContentValues();
    values.put("userid",id);
    values.put("username",uname);
    values.put("password",password);
    values.put("role",role);

    SQLiteDatabase db = getWritableDatabase();
    db.insertOrThrow("user",null,values);

}

=========================================End==========================================

//--------------------------------------------Code Detail and Working---------------------------------------------------------

Update Database Data in Android

//============================java Code Start =========================================

public void userUpdate(int id,String uname,String password, String role){
    ContentValues values = new ContentValues();
    values.put("userid",id);
    values.put("username",uname);
    values.put("password",password);
    values.put("role",role);

    SQLiteDatabase db = getWritableDatabase();
    db.update("user",values,"userid=?",new String[]{id+""});

}

=========================================End==========================================

 

//--------------------------------------------Code Detail and Working---------------------------------------------------------

Delete Database Data in Android

//============================java Code Start =========================================

public void deletePerson(int pid){
    SQLiteDatabase db = getWritableDatabase();
    db.delete("user","userid=?",new String[]{pid+""});
}

=========================================End==========================================

//--------------------------------------------Code Detail and Working---------------------------------------------------------

Show data Database in Android

//============================java Code Start =========================================

public ArrayList<String> getAllPerson(){
    ArrayList<String> personList = new ArrayList<>();
    SQLiteDatabase db = getReadableDatabase();

    Cursor cursorRef = db.rawQuery("Select * from user",
            null);
    cursorRef.moveToFirst();
    while(cursorRef.isAfterLast() == false){
        int id = cursorRef.getInt(0);
        String user = cursorRef.getString(1);
        String pass = cursorRef.getString(2);
        String role = cursorRef.getString(3);
        String row = "Id : "+id+ ", NameUser : "+user+", Pass : "+pass+", Role "+role;
        personList.add(row);
        cursorRef.moveToNext();
    }
    cursorRef.close();
    return personList;
}

=========================================End==========================================

 

-------------------------------------------Calling--------------------------------------------------------------------

//--------------------------------------------Code Detail and Working---------------------------------------------------------

Show data Database in Android

//============================java Code Start =========================================

public ArrayList<String> getAllPerson(){
    ArrayList<String> personList = new ArrayList<>();
    SQLiteDatabase db = getReadableDatabase();

    Cursor cursorRef = db.rawQuery("Select * from user",
            null);
    cursorRef.moveToFirst();
    while(cursorRef.isAfterLast() == false){
        int id = cursorRef.getInt(0);
        String user = cursorRef.getString(1);
        String pass = cursorRef.getString(2);
        String role = cursorRef.getString(3);
        String row = "Id : "+id+ ", NameUser : "+user+", Pass : "+pass+", Role "+role;
        personList.add(row);
        cursorRef.moveToNext();
    }
    cursorRef.close();
    return personList;
}

=========================================End==========================================

//--------------------------------------------Code Detail and Working---------------------------------------------------------

Store Image and data calling DB function

//============================java Code Start =========================================

binding.buttonSave.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View view) {
        int id = Integer.parseInt
                (binding.editTextId.
                        getText().toString());
        String name = binding.editTextName.getText().toString();
        String address = binding.editTextAddress.getText().toString();
        String gender = "Male";
        if(binding.radioButtonFemaleProfile.isChecked())
            gender = "Female";

//drawble create
        BitmapDrawable bmpDrawble = (BitmapDrawable)
                binding.imageViewProfile.getDrawable();

//drawble to bitmap change
        Bitmap bmpImage = bmpDrawble.getBitmap();

//create byte object
        ByteArrayOutputStream outputStream =
                new ByteArrayOutputStream();

//compress file Stream
        bmpImage.compress(Bitmap.CompressFormat.PNG,
                100,outputStream);

//save byte
        byte[] imgeArr = outputStream.toByteArray();
        Profile p = new Profile(id,
                name,
                gender,
                address, imgeArr);

//DB object create
        DBManager objMgr =new DBManager(ProfileActivity.this);
        objMgr.saveProfile(p);
        Toast.makeText(ProfileActivity.this,
                "Data Saved", Toast.LENGTH_LONG)
                .show();


    }
});=========================================End==========================================