How to save image as blob in Sqlite and how to get it?

Question

I want to save an image (from url) to sqlite database.

For this, I use:

db = new DataBase(getApplicationContext()); URL url = new URL("http://sree.cc/wp-content/uploads/schogini_team.png"); URLConnection ucon = url.openConnection(); InputStream is = ucon.getInputStream(); BufferedInputStream bis = new BufferedInputStream(is,128); ByteArrayBuffer barb= new ByteArrayBuffer(128); int current = 0; while ((current = bis.read()) != -1) { barb.append((byte) current); } ContentValues filedata= new ContentValues(); filedata.put(DataBase.IMG_SRC,barb.toByteArray()); db.insert(DataBase.Table_Img, null, filedata); 

In Insert() :

 public void insert(String tableImg, Object object, ContentValues dataToInsert) { // TODO Auto-generated method stub String sql = "INSERT INTO "+tableImg+" ("+ID+","+IMG_SRC+") " + "VALUES ('"+1+"','"+dataToInsert+"')"; db.execSQL(sql); } 

To get an image:

 Cursor cursor = db.selectDataToShow(DataBase.Table_Img, DataBase.IMG_SRC); byte[] imageByteArray=cursor.getBlob(cursor.getColumnIndex(DataBase.IMG_SRC)); cursor.close(); ByteArrayInputStream imageStream = new ByteArrayInputStream(imageByteArray); Bitmap theImage = BitmapFactory.decodeStream(imageStream); System.out.println(">>>>>>>>>>>>>>>>>>>>>> "+theImage); 

So I got null .

And in my database the image value is stored as: Image=[B@43e5ac48]

Answer 1

Here is the code I used for my application

This code takes an image from a URL and converts it to a byte array

 byte[] logoImage = getLogoImage(IMAGEURL); private byte[] getLogoImage(String url){ try { URL imageUrl = new URL(url); URLConnection ucon = imageUrl.openConnection(); InputStream is = ucon.getInputStream(); BufferedInputStream bis = new BufferedInputStream(is); ByteArrayBuffer baf = new ByteArrayBuffer(500); int current = 0; while ((current = bis.read()) != -1) { baf.append((byte) current); } return baf.toByteArray(); } catch (Exception e) { Log.d("ImageManager", "Error: " + e.toString()); } return null; } 

To save the image in the database, I used this code.

  public void insertUser(){ SQLiteDatabase db = dbHelper.getWritableDatabase(); String delSql = "DELETE FROM ACCOUNTS"; SQLiteStatement delStmt = db.compileStatement(delSql); delStmt.execute(); String sql = "INSERT INTO ACCOUNTS (account_id,account_name,account_image) VALUES(?,?,?)"; SQLiteStatement insertStmt = db.compileStatement(sql); insertStmt.clearBindings(); insertStmt.bindString(1, Integer.toString(this.accId)); insertStmt.bindString(2,this.accName); insertStmt.bindBlob(3, this.accImage); insertStmt.executeInsert(); db.close(); } 

To restore the image, this is the code I used.

 public Account getCurrentAccount() { SQLiteDatabase db = dbHelper.getWritableDatabase(); String sql = "SELECT * FROM ACCOUNTS"; Cursor cursor = db.rawQuery(sql, new String[] {}); if(cursor.moveToFirst()){ this.accId = cursor.getInt(0); this.accName = cursor.getString(1); this.accImage = cursor.getBlob(2); } if (cursor != null && !cursor.isClosed()) { cursor.close(); } db.close(); if(cursor.getCount() == 0){ return null; } else { return this; } } 

Finally, to load this image into image viewer

 logoImage.setImageBitmap(BitmapFactory.decodeByteArray( currentAccount.accImage, 0,currentAccount.accImage.length)); 

Answer 2

in the database helper class DBAdaper ie declares the table as follows

  private static final String USERDETAILS= "create table userdetails(usersno integer primary key autoincrement,userid text not null ,username text not null,password text not null,photo BLOB,visibility text not null);"; 

insert values ​​like this

first convert images as bytes []

 ByteArrayOutputStream baos = new ByteArrayOutputStream(); Bitmap bitmap = ((BitmapDrawable)getResources().getDrawable(R.drawable.common)).getBitmap(); bitmap.compress(Bitmap.CompressFormat.PNG, 100, baos); byte[] photo = baos.toByteArray(); db.insertUserDetails(value1,value2, value3, photo,value2); 

in class DEADaper

  public long insertUserDetails(String uname,String userid, String pass, byte[] photo,String visibility) { ContentValues initialValues = new ContentValues(); initialValues.put("username", uname); initialValues.put("userid",userid); initialValues.put("password", pass); initialValues.put("photo",photo); initialValues.put("visibility",visibility); return db.insert("userdetails", null, initialValues); } 

get the image as follows

 Cursor cur=your query; while(cur.moveToNext()) { byte[] photo=cur.getBlob(index of blob cloumn); } 

convert byte [] to image

 ByteArrayInputStream imageStream = new ByteArrayInputStream(photo); Bitmap theImage= BitmapFactory.decodeStream(imageStream); 

I think this content may solve your problem.

Answer 3

Paste ()

 public void insert(String tableImg, Object object, ContentValues dataToInsert) { db.insert(tablename, null, dataToInsert); } 

Hope this helps you.

Answer 4

for ion project

     var imgURI = "";
     var imgBBDD = "";  // sqllite for save into

     function takepicture () {
                 var options = {
                     quality: 75,
                     destinationType: Camera.DestinationType.DATA_URL,
                     sourceType: Camera.PictureSourceType.CAMERA,
                     allowEdit: true,
                     encodingType: Camera.EncodingType.JPEG,
                     targetWidth: 300,
                     targetHeight: 300,
                     popoverOptions: CameraPopoverOptions,
                     saveToPhotoAlbum: false
                 };

                 $ cordovaCamera.getPicture (options) .then (function (imageData) {
                     imgURI = "data: image / jpeg; base64," + imageData;
                     imgBBDD = imageData;
                 }, function (err) {
                     // An error occured.  Show a message to the user
                 });
             }

And now we put imgBBDD in SqlLite

      function saveImage = function (theId, theimage) {
       var insertQuery = "INSERT INTO images (id, image) VALUES (" + theId + ", '" + theimage + "');"
       console.log ('>>>>>>>');
       DDBB.SelectQuery (insertQuery)
                     .then (function (result) {
                         console.log ("Image saved");
                     })
                     .catch (function (err) 
                      {
                         deferred.resolve (err);
                         return cb (err);
                     });
     }

Server side (php)

         $ request = file_get_contents ("php: // input");  // gets the raw data
         $ dades = json_decode ($ request, true);  // true for return as array


     if ($ dades == "") {
             $ array = array ();
             $ array ['error'] = -1;
             $ array ['descError'] = "Error when get the file";
             $ array ['logError'] = '';
             echo json_encode ($ array);
             exit
         }
         // send the image again to the client
         header ('Content-Type: image / jpeg');
         echo '';

Answer 5

 byte[] byteArray = rs.getBytes("columnname"); Bitmap bm = BitmapFactory.decodeByteArray(byteArray, 0 ,byteArray.length); 

Answer 6

you can also encode and decode to / from base64

  function uncompress(str:String):ByteArray { import mx.utils.Base64Decoder; var dec:Base64Decoder = new Base64Decoder(); dec.decode(str); var newByteArr:ByteArray=dec.toByteArray(); return newByteArr; } // Compress a ByteArray into a Base64 String. function compress(bytes:ByteArray):String { import mx.utils.Base64Decoder; //Transform String in a ByteArray. import mx.utils.Base64Encoder; //Transform ByteArray in a readable string. var enc:Base64Encoder = new Base64Encoder(); enc.encodeBytes(bytes); return enc.drain().split("\n").join(""); }