String squery = "%" + query + "%";
MapSqlParameterSource params = new MapSqlParameterSource();
params.addValue("search", squery);
//.addValue("platformName", platformType.getKey());
NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
return namedTemplate.query(LIBRARY_DILUTION_SELECT_BY_SEARCH, params, new LazyLibraryDilutionMapper());
}
public List<LibraryDilution> listByLibraryId(long libraryId) throws IOException {
return template.query(LIBRARY_DILUTION_SELECT_BY_LIBRARY_ID, new Object[]{libraryId}, new LazyLibraryDilutionMapper());
}