Listview image, text, sqlite

[extremevb]

I've been looking for days for a good example of how to do the following:

- store images locally (drawable folder)

- store location of image in database

- store several text items in the database

- query database to display a list (custom rows with an image and text)

a list with several text items

I guess it would be similar to a movie or recipe database layout
I'm not sure what I would need to do (ie. type of adapters, etc.)
I can make a ListView containing several TextViews, but I'm not sure how to add an image to the listview.

Any advice is appreciated.

 

[ArthurGray]

You have to employ RecyclerView instead of ListView. Here is a good example.
You can find the code here

 

[extremevb]

Not so. It can be done with a ListView.
See here:
http://valokafor.com/android-save-and-retrieve-image-path-from-database/

Full source code is available, if you can find the links (hint: pay special attention to 3rd paragraph)