AAL3.sharedJdbcTemplate.java

AAL3.sharedJdbcTemplate.java

public class MyJdbcDaoImpl extends JdbcDaoSupport implements MyJdbcDao {

  @Override
  protected void initTemplateConfig() {
    getJdbcTemplate().setFetchSize(200);
  }

  public MyResult loadAll() {
    final MyResult result = new MyResult();
    
    getJdbcTemplate().query("select a, b, c from table",

      new RowCallbackHandler() {
        @Override
        public void processRow(ResultSet rs) throws SQLException {
          ...
          result.add(...);
        }
      }
    );

  } // end of loadAll
}