com.jn.sqlhelper.common.resultset.MapRowMapper Maven / Gradle / Ivy
package com.jn.sqlhelper.common.resultset;
import com.jn.langx.annotation.Nullable;
import com.jn.langx.util.Throwables;
import com.jn.langx.util.collection.LinkedCaseInsensitiveMap;
import java.sql.ResultSet;
import java.util.Map;
public class MapRowMapper implements RowMapper> {
@Override
public Map mapping(ResultSet row, int currentRowIndex, ResultSetDescription resultSetDescription) {
int columnCount = resultSetDescription.getColumnCount();
Map mapOfColumnValues = createColumnMap(columnCount);
for (int i = 1; i <= columnCount; i++) {
String column = resultSetDescription.getColumnName(i);
mapOfColumnValues.put(getColumnKey(column), getColumnValue(row, i));
}
return mapOfColumnValues;
}
/**
* Determine the key to use for the given column in the column Map.
*
* @param columnName the column name as returned by the ResultSet
* @return the column key to use
* @see java.sql.ResultSetMetaData#getColumnName
*/
protected String getColumnKey(String columnName) {
return columnName;
}
/**
* Retrieve a JDBC object value for the specified column.
* The default implementation uses the {@code getObject} method.
* Additionally, this implementation includes a "hack" to get around Oracle
* returning a non standard object for their TIMESTAMP datatype.
*
* @param rs is the ResultSet holding the data
* @param index is the column index
* @return the Object returned
*/
@Nullable
protected Object getColumnValue(ResultSet rs, int index) throws RuntimeException {
try {
return ResultSets.getResultSetValue(rs, index);
} catch (Throwable ex) {
throw Throwables.wrapAsRuntimeException(ex);
}
}
protected Map createColumnMap(int columnCount) {
return new LinkedCaseInsensitiveMap