This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
The best practice is to write your own Data Access Object (DAO class/ look for DAO pattern). Your DAO class is responsible for accessing the data from the database and map the ResultSet to JavaBean(s) and return a Collection (i.e List, Set, Map etc) of JavaBeans or a single JavaBean.
Note: If you have heard of a O-R(Object to Relational mapping) framework called Hibernate that is what it does. Still you need to use a DAO.