How to store bitmap image and retrieve image from sqlite database in android

Question

In my project I need to store an image into a sqlite database and also need to retrieve it to show in my android emulator  When I show it directly after decoding the encoded string  which I got from Java class using sockets  the image displays there  But when I store a byte array code of the string into the sqlite database with the datatype blob and then again retrieve it by using the getblob   function it contains a different value and this error occurs    JAVA lang NULLPointerException  Factory returns null    I need a suggestion to store a bitmap image into a sqlite database and also to retrieve it from the sqlite database

User · Answer

If you are working with Android s MediaStore database  here is how to store an image and then display it after it is saved   on button click write this   Intent in   new Intent Intent ACTION PICK                      android provider MediaStore Images Media EXTERNAL CONTENT URI               in putExtra  crop    true                in putExtra  outputX   100               in putExtra  outputY   100               in putExtra  scale   true               in putExtra  return-data   true                startActivityForResult in  1     then do this in your activity   Override     protected void onActivityResult int requestCode  int resultCode  Intent data               TODO Auto-generated method stub         super onActivityResult requestCode  resultCode  data            if  requestCode    1  amp  amp  resultCode    RESULT OK  amp  amp  data    null                 Bitmap bmp    Bitmap  data getExtras   get  data                 img setImageBitmap bmp               btnadd requestFocus                 ByteArrayOutputStream baos   new ByteArrayOutputStream                bmp compress Bitmap CompressFormat JPEG  100  baos               byte   b   baos toByteArray                String encodedImageString   Base64 encodeToString b  Base64 DEFAULT                byte   bytarray   Base64 decode encodedImageString  Base64 DEFAULT               Bitmap bmimage   BitmapFactory decodeByteArray bytarray  0                      bytarray length

User · Answer

Setting Up the database  public class DatabaseHelper extends SQLiteOpenHelper          Database Version     private static final int DATABASE VERSION   1          Database Name     private static final String DATABASE NAME    database name           Table Names     private static final String DB TABLE    table image           column names     private static final String KEY NAME    image name       private static final String KEY IMAGE    image data           Table create statement     private static final String CREATE TABLE IMAGE    CREATE TABLE     DB TABLE                                KEY NAME     TEXT                             KEY IMAGE     BLOB          public DatabaseHelper Context context            super context  DATABASE NAME  null  DATABASE VERSION               Override     public void onCreate SQLiteDatabase db                creating table         db execSQL CREATE TABLE IMAGE               Override     public void onUpgrade SQLiteDatabase db  int oldVersion  int newVersion               on upgrade drop older tables         db execSQL  DROP TABLE IF EXISTS     DB TABLE               create new table         onCreate db             Insert in the Database   public void addEntry  String name  byte   image  throws SQLiteException      SQLiteDatabase database   this getWritableDatabase        ContentValues cv   new  ContentValues        cv put KEY NAME     name       cv put KEY IMAGE    image       database insert  DB TABLE  null  cv        Retrieving data    byte   image   cursor getBlob 1     Note    Before inserting into database  you need to convert your Bitmap image into byte array first then apply it using database query  When retrieving from database  you certainly have a byte array of image  what you need to do is to convert byte array back to original image  So  you have to make use of BitmapFactory to decode    Below is an Utility class which I hope could help you   public class DbBitmapUtility           convert from bitmap to byte array     public static byte   getBytes Bitmap bitmap            ByteArrayOutputStream stream   new ByteArrayOutputStream            bitmap compress CompressFormat PNG  0  stream           return stream toByteArray                  convert from byte array to bitmap     public static Bitmap getImage byte   image            return BitmapFactory decodeByteArray image  0  image length             Further reading  If you are not familiar how to insert and retrieve into a database  go through this tutorial

[android] How to store(bitmap image) and retrieve image from sqlite database in android?

Examples related to android

Examples related to image

Examples related to sqlite

Examples related to bitmapimage