How to save images into Database

by

You should use BLOB in your database:

Check this tutorial…

But I think you should download and store image in HashMap, which will make it simpler.

Code:

Stroring

var imageMap = new HashMap<String, byte[]>();

var imageUrl = "http://i.stack.imgur.com/TLjuP.jpg";

var imagedata = GetImage(imageUrl);      

imageMap.put("img",imagedata);

Retrieving

var imageData = imageMap.get("img");

var imageStream = new ByteArrayInputStream(imageData);

var image = BitmapFactory.decodeStream(imageStream);

GetImage

private byte[] GetImage(String url)
{
    try
    {
        var imageUrl = new URL(url);
        var urlConnection = imageUrl.openConnection();

        var inputStream = urlConnection.getInputStream();
        var bufferedInputStream = new BufferedInputStream(inputStream);

        var byteArrayBuffer = new ByteArrayBuffer(500);

        int current = 0;
        while ((current = bis.read()) != -1)
        {
            byteArrayBuffer.append((byte)current);
        }

        return byteArrayBuffer.toByteArray();
    }
    catch (Exception e)
    {
        Log.d("ImageManager", "Error: " + e.toString());
        return null;
    }       
}

Hope it helps you.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. Pros and Cons of SQLite and Shared Preferences [closed]
  5. Share SQLite database between 2 android apps?
  6. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  7. Android: upgrading DB version and adding new table
  8. How do I view the SQLite database on an Android device? [duplicate]
  9. Best way to work with dates in Android SQLite [closed]
  10. Android SQLite Example [closed]
  11. Android database encryption
  12. Best place to close database connection
  13. Import .csv file to Sqlite in Android
  14. Cursor adapter and sqlite example [closed]
  15. How to retrieve data from sqlite database in android and display it in TextView
  16. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  17. How do I create a database in android? [closed]
  18. Android SimpleCursorAdapter doesn’t update when database changes
  19. SQLite simultaneous reading and writing
  20. update sql database with ContentValues and the update-method
  21. How does one check if a table exists in an Android SQLite database?
  22. Create SQLite database in android
  23. Could not allocate CursorWindow
  24. Saving ArrayLists in SQLite databases
  25. SQLite android column not found
  26. How to store JSON object in SQLite database
  27. H2 Database vs SQLite on Android [closed]
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment