How to organize data filtering from a database in an Android application?

Question

Android

Hello. There is an application - a catalog of clothes. There is a complete database. How can I organize the interaction of the application with the database by filtering the criteria selected by the user from the application. Those. the user selects certain items in the menu, and at the exit he is given a selection of objects from the database that matches his parameters. I'm new to this business, if you can - in simple terms. Thank you.
And just one more question. Database in SQL. In addition to the text, respectively, there are also images. Where is it preferable to store them in the same database? Or there are some other options, I would like the access to the database to be offline. And the application would not need constant access to the Internet. Thank you.

Answer 1

Have a look at Select queries. In general, it is better to use ORM, there are a lot of them on Android, and even here this topic has been raised more than once, just google it and choose what you need.
Concerning images - to store in a DB it from crafty. In the database, you need to store relative (absolute) paths to image files that will be cached on your device.