List
     
       list = this.jdbcTemplate.getJdbcOperations().query(sqlSb.toString(), params.toArray(), new RowMapper
      
       (){            @Override            public RivBillNoPatternL mapRow(ResultSet rs, int rowNum)                    throws SQLException {                RivBillNoPatternL billNoPatternL = new RivBillNoPatternL();                billNoPatternL.setBnplId(rs.getInt("bnpl_id"));                billNoPatternL.setBnplHeaderId(rs.getInt("bnpl_header_id"));                billNoPatternL.setBnplOrder(rs.getBigDecimal("bnpl_order"));                billNoPatternL.setBnplPatternType(rs.getString("bnpl_pattern_type"));                billNoPatternL.setBnplPattern(rs.getString("bnpl_pattern"));                billNoPatternL.setBnplResetNumber(rs.getBigDecimal("bnpl_reset_number"));                return billNoPatternL;            }});
      
     

final List
     
       list = new ArrayList
      
       ();        final Date date = new Date();        jdbcTemplate.query(sql, params.toArray(),new RowCallbackHandler(){            @Override            public void processRow(ResultSet rs) throws SQLException {                RivExpiredWarningL exw = new RivExpiredWarningL();                exw.setExwWarningDatetime(date);                exw.setExwOrgId(rs.getInt(1));                exw.setExwOwnerId(rs.getInt(2));                exw.setExwQuantId(rs.getInt(3));                list.add(exw);            }        });        return list;