Continue: How the Data Access Bean Look Like

Here is one of the data access bean.

package com.mycomp.app1.data; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Collection; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.core.support.JdbcDaoSupport; public final class SimpleApp1ReaderImpl extends JdbcDaoSupport implements Appl1Reader { private static final String SELECT_SQL = "SELECT ..."; ... private final class App1Mapper implements RowMapper<App1DTO> { @Override public App1DTO mapRow(ResultSet rs, int row) throws SQLException { ... return new App1DTO(...); } } }

I always choose JdbcDaoSupport over Hibernate because I can have so much more control over what I want to do with the database.