how to store a images and retrieve from sqlite database using bitmap or from drawable folder

Question

please help me in store and retrieving of images in sqlite and i had used the tab layout for my app..My main activity is one of the tabs fragment please help me in write the exact code..

Answer 1

Get bitmap from ImageView:

Bitmap bitmap = ((BitmapDrawable)ivImage.getDrawable()).getBitmap();

If you have bitmap of your image then go with this one:

Save in database:

public void insertImg(Bitmap img) {
        byte[] data = getBitmapAsByteArray(img); // this is a function
        //Now save this byte array data as blob in database
    }

public static byte[] getBitmapAsByteArray(Bitmap bitmap) {
        ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
        bitmap.compress(CompressFormat.PNG, 0, outputStream);
        return outputStream.toByteArray();
    }

Retrieve from database:

public Bitmap getImage() {
        //fetch byte array from your query cursor
        byte[] imgByte = cur.getBlob(0);
        return BitmapFactory.decodeByteArray(imgByte, 0, imgByte.length);
    }

Set retrieved bitmap from database to ImageView:

ivImage.setImageBitmap(getImage());

But saving images as byte array in database is not a good practice. Because saving and retrieve images as byte array may be give an issue of outOfMemory. So if you have image url which you are getting from server then save that url as a string in database and retrieve it with same column where you have saved.

Or if you have any drawable image then save that drawable image name in database and retrieve with the same.