Android: Display Image From SQLite

Question

I'm learning about databases in android and have come across the following question, I would like to retrieve an image, how can I change the code below to image instead of string?

public List<String> getImage(){
    List<String> listRows = new ArrayList<String>();
    SQLiteDatabase db = this.getWritableDatabase();

    Cursor c;
    try {
        c = db.rawQuery("SELECT image FROM " + MY_TABLE + " WHERE _id = "  + _id, null);
        if(c == null) return null;

        String row;
        c.moveToFirst();
        do {            
            row = c.getString(0);            
            listRows.add(row);
        } while (c.moveToNext()); 
        c.close();
    }
    catch (Exception e) {
        Log.e("LOGmsg getDBImage", e.getMessage());
    }

    db.close();        

    return listRows;
}

More information on how your database is set up would be helpful. — mkorcha
– mkorcha, Commented Mar 2, 2015 at 18:10
Normally, you store images as byte arrays inside your database. BitmapFactory.decodeByteArray() could help you to decode them again. Check out this question: stackoverflow.com/questions/7331310/… — flxapps
– flxapps, Commented Mar 2, 2015 at 18:12

gadfil · Accepted Answer · 2015-03-02 18:15:14Z

2

store the image in the database is a bad practice, it is better to store pictures on the sd and store in the database paths to them

answered Mar 2, 2015 at 18:15

gadfil

4175 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TwoStarII Over a year ago

I just spoke to a colleague at work and was informed exactly the same. I will approach this method of storing the path in the DB rather than the image as a BLOB. Thanks.

Michael Powell · Accepted Answer · 2015-03-02 18:13:21Z

0

Treat the image as a byte array and write/retrieve it to/from your database as a Blob object.

answered Mar 2, 2015 at 18:13

Michael Powell

7664 silver badges11 bronze badges

Collectives™ on Stack Overflow

Android: Display Image From SQLite

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related