leodutra
6/18/2014 - 6:55 PM

A simple query util for Spring JDBC

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);
	}
}