How to return a list from MySQL?

Question

MySQL

I have a list of purchases in the database, the "purchase" entity has a "Date" field.
Can you please tell me how to get a list of purchases for a given date range.

Answer 1

Query query = session.createQuery("from Purchase p where p.bought between :startDate and :endDate");
query.setParameter("startDate", someDate);
query.setParameter("endDate", anotherDate);
List<Purchase> purchases = query.list();

Answer 2

Using any ORM you will get a list for a Select request
Example with ApacheCayenne
list roles;
SelectQuery select_role = new SelectQuery(Role.class);
roles = Context.getContext().performQuery(select_role);
as a result in roles there will be a list
In Hibernate I think in the same way. However, dates are a little more complicated.
This is how the Cayenne proposes to work with dates

Calendar c = new GregorianCalendar();
c.set(c.get(Calendar.YEAR) - 100, 0, 1, 0, 0, 0);
Expression qualifier3 = Expression.fromString("artist.dateOfBirth < $date");
qualifier3 = qualifier3.expWithParameters(Collections.singletonMap("date", c.getTime()));
SelectQuery select3 = new SelectQuery(Painting.class, qualifier3);
List paintings3 = context.performQuery(select3);
There is a selection of paintings by those artists who were born more than 100 years ago

Answer 3

SELECT * FROM `buys` WHERE `date` BETWEEN '2000-01-01' AND '2000-01-31'