Java Code Examples for org.springframework.dao.support.DataAccessUtils#singleResult()

@SuppressWarnings("unchecked")
@Override
public T queryOne(Id id) throws Exception {
    String sql = "SELECT * FROM " + tableName + " WHERE " + primaryKey + " = ?";
    List<T> result = jdbcTemplate.query(sql, rowMapper, id);
    return DataAccessUtils.singleResult(result);
}
 

private <T> T selectRecipients(@VelocityCheck int companyID, RowMapper<T> mapper, String sqlStatement, Object... sqlParameters) throws SQLException {
	List<T> results = selectRecipients(companyID, new RowMapperResultSetExtractor<>(mapper, 1), sqlStatement, sqlParameters);
	return DataAccessUtils.singleResult(results);
}
 

@Override
public T queryOne(Criteria criteria) throws Exception {
    List<T> result = this.queryWithCriteria(criteria);
    return DataAccessUtils.singleResult(result);
}
 

public E queryOne() throws Exception {
    return DataAccessUtils.singleResult(queryList());
}
 

/**
 * Generic object finder method, used by all other {@code findObject} methods.
 * Object finder methods are like EJB entity bean finders, in that it is
 * considered an error if they return more than one result.
 * @return the result object, or {@code null} if not found. Subclasses may
 * choose to treat this as an error and throw an exception.
 * @see org.springframework.dao.support.DataAccessUtils#singleResult
 */
@Nullable
public T findObject(@Nullable Object[] params, @Nullable Map<?, ?> context) throws DataAccessException {
	List<T> results = execute(params, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method for named parameters.
 * @param paramMap a Map of parameter name to parameter object,
 * matching named parameters specified in the SQL statement.
 * Ordering is not significant.
 * @param context contextual information passed to the {@code mapRow}
 * callback method. The JDBC operation itself doesn't rely on this parameter,
 * but it can be useful for creating the objects of the result list.
 * @return a List of objects, one per row of the ResultSet. Normally all these
 * will be of the same class, although it is possible to use different types.
 */
@Nullable
public T findObjectByNamedParam(Map<String, ?> paramMap, @Nullable Map<?, ?> context) throws DataAccessException {
	List<T> results = executeByNamedParam(paramMap, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method, used by all other {@code findObject} methods.
 * Object finder methods are like EJB entity bean finders, in that it is
 * considered an error if they return more than one result.
 * @return the result object, or {@code null} if not found. Subclasses may
 * choose to treat this as an error and throw an exception.
 * @see org.springframework.dao.support.DataAccessUtils#singleResult
 */
@Nullable
public T findObject(@Nullable Object[] params, @Nullable Map<?, ?> context) throws DataAccessException {
	List<T> results = execute(params, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method for named parameters.
 * @param paramMap a Map of parameter name to parameter object,
 * matching named parameters specified in the SQL statement.
 * Ordering is not significant.
 * @param context contextual information passed to the {@code mapRow}
 * callback method. The JDBC operation itself doesn't rely on this parameter,
 * but it can be useful for creating the objects of the result list.
 * @return a List of objects, one per row of the ResultSet. Normally all these
 * will be of the same class, although it is possible to use different types.
 */
@Nullable
public T findObjectByNamedParam(Map<String, ?> paramMap, @Nullable Map<?, ?> context) throws DataAccessException {
	List<T> results = executeByNamedParam(paramMap, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method, used by all other {@code findObject} methods.
 * Object finder methods are like EJB entity bean finders, in that it is
 * considered an error if they return more than one result.
 * @return the result object, or {@code null} if not found. Subclasses may
 * choose to treat this as an error and throw an exception.
 * @see org.springframework.dao.support.DataAccessUtils#singleResult
 */
public T findObject(Object[] params, Map<?, ?> context) throws DataAccessException {
	List<T> results = execute(params, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method for named parameters.
 * @param paramMap Map of parameter name to parameter object,
 * matching named parameters specified in the SQL statement.
 * Ordering is not significant.
 * @param context contextual information passed to the {@code mapRow}
 * callback method. The JDBC operation itself doesn't rely on this parameter,
 * but it can be useful for creating the objects of the result list.
 * @return a List of objects, one per row of the ResultSet. Normally all these
 * will be of the same class, although it is possible to use different types.
 */
public T findObjectByNamedParam(Map<String, ?> paramMap, Map<?, ?> context) throws DataAccessException {
	List<T> results = executeByNamedParam(paramMap, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method, used by all other {@code findObject} methods.
 * Object finder methods are like EJB entity bean finders, in that it is
 * considered an error if they return more than one result.
 * @return the result object, or {@code null} if not found. Subclasses may
 * choose to treat this as an error and throw an exception.
 * @see org.springframework.dao.support.DataAccessUtils#singleResult
 */
public T findObject(Object[] params, Map<?, ?> context) throws DataAccessException {
	List<T> results = execute(params, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method for named parameters.
 * @param paramMap Map of parameter name to parameter object,
 * matching named parameters specified in the SQL statement.
 * Ordering is not significant.
 * @param context contextual information passed to the {@code mapRow}
 * callback method. The JDBC operation itself doesn't rely on this parameter,
 * but it can be useful for creating the objects of the result list.
 * @return a List of objects, one per row of the ResultSet. Normally all these
 * will be of the same class, although it is possible to use different types.
 */
public T findObjectByNamedParam(Map<String, ?> paramMap, Map<?, ?> context) throws DataAccessException {
	List<T> results = executeByNamedParam(paramMap, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method, used by all other {@code findObject} methods.
 * Object finder methods are like EJB entity bean finders, in that it is
 * considered an error if they return more than one result.
 * @return the result object, or {@code null} if not found. Subclasses may
 * choose to treat this as an error and throw an exception.
 * @see org.springframework.dao.support.DataAccessUtils#singleResult
 */
public T findObject(Object[] params, Map<?, ?> context) throws DataAccessException {
	List<T> results = execute(params, context);
	return DataAccessUtils.singleResult(results);
}
 

/**
 * Generic object finder method for named parameters.
 * @param paramMap Map of parameter name to parameter object,
 * matching named parameters specified in the SQL statement.
 * Ordering is not significant.
 * @param context contextual information passed to the {@code mapRow}
 * callback method. The JDBC operation itself doesn't rely on this parameter,
 * but it can be useful for creating the objects of the result list.
 * @return a List of objects, one per row of the ResultSet. Normally all these
 * will be of the same class, although it is possible to use different types.
 */
public T findObjectByNamedParam(Map<String, ?> paramMap, Map<?, ?> context) throws DataAccessException {
	List<T> results = executeByNamedParam(paramMap, context);
	return DataAccessUtils.singleResult(results);
}