A simple query util for Spring JDBC
package br.com.bradseg.gccs.gestaocartaocredito.cadastros.util;
import java.util.List;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.RowMapperResultSetExtractor;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations;
public final class QueryUtils {
public static final <T> T simpleQueryForObject(final NamedParameterJdbcOperations jdbcTemplate, final String sql, final MapSqlParameterSource params, final RowMapper<T> rowMapper) {
final List<T> results = jdbcTemplate.query(sql, params, new RowMapperResultSetExtractor<T>(rowMapper, 1));
if (results.isEmpty()) {
return null;
}
return results.get(0);
}
}