" mcd ON (mc.length_class_id = mcd.length_class_id)";
final Map<String, LengthClass> dataMap = new HashMap<String, LengthClass>();
getJdbcOperations().query(sql, new RowCallbackHandler(){
@Override
public void processRow(ResultSet rs) throws SQLException {
LengthClass lc = new LengthClass();
lc.setId(rs.getInt("length_class_id"));
lc.setTitle(rs.getString("title"));
lc.setUnit(rs.getString("unit"));
lc.setValue(rs.getBigDecimal("value"));
String key = rs.getInt("language_id")+"_"+lc.getId();
dataMap.put(key, lc);
}
});
this.lengthClassMap = dataMap;
}