Android storing image path in to SQLite DB

Question

I'm developing an application that intends to store the data in a SQLIte database. It's kind of a virtual city guide.
As so, I'm storing some text elements on the DB and I'd like to store the path of an image and a video stored in the device in different columns and tables of the DB.

Kind of:

_ID INTEGER PRIMARY KEY AUTOINCREMENT (id of the image)
IMAGE_PATH TEXT UNIQUE (path of the image associated with the ID)

Can anyone give some examples on how can I do this?

What have you tried? Showing an attempt at some code, or doing searches for examples shows that you've done you're homework — hooked82
– hooked82, Commented Mar 25, 2012 at 22:56

LisaMM · Accepted Answer · 2015-03-19 10:28:11Z

2

The answer of Bill Gary works well for one image, but as I want to do a gallery I used the code below :

this.imgPath = new String[mImageCursor.getCount()];

        int i = 0;

        while (mImageCursor.moveToNext()) {
            imgName = mImageCursor.getString(mImageCursor.getColumnIndex(MyDbAdapter.IMAGE_PATH));
            Log.w(TAG, baseDir + imgName);
            this.imgPath[i] = baseDir + imgName;
            Log.w(TAG, baseDir + mImageCursor.getString(mImageCursor.getColumnIndex(MyDbAdapter.IMAGE_PATH)) + " After");
            i++;
        }

        Gallery gallery = (Gallery) findViewById(R.id.VGgallery);
        gallery.setAdapter(new MyImageAdapter(this, this.imgPath));

Hope it helps someone else.

edited Mar 19, 2015 at 10:28

LisaMM

6811 gold badge16 silver badges28 bronze badges

answered Sep 12, 2012 at 18:39

Artifex

311 silver badge5 bronze badges

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

Comments

Bill Gary · Accepted Answer · 2012-03-25 23:47:05Z

0

Store the path as text, tehn when you get it in your cursor(variable imagePath for example), use this ...

imageResource = this.getResources().getIdentifier(
                imagePath, null, null);
ImageView.setImageResource(imageResource);

answered Mar 25, 2012 at 23:47

Bill Gary

3,0152 gold badges18 silver badges19 bronze badges

Collectives™ on Stack Overflow

Android storing image path in to SQLite DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related