java rowmapper 通用实现_将每行映射为MAP对象的RowMapper实现

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.util.LinkedHashMap;

import java.util.Map;

import com.huawei.widget.commons.dao.RowMapper;

import com.huawei.widget.commons.dao.util.JdbcUtils;

/**

* 将每行映射为MAP对象的RowMapper实现。

*

* @author g00106664

* @version C02 2009-4-27

* @since OpenEye WIDGET_SRV V100R001C02

*/

@SuppressWarnings("unchecked")

public class ColumnMapRowMapper implements RowMapper{

/**

* 此方法用于将每行数据映射为实体类。

*

* @param rs

*            ResultSet

* @param rowNum

*            the row num

* @return the t

* @throws java.sql.SQLException

*             the SQL exception

* @see com.huawei.widget.db.RowMapper#mapRow(ResultSet, int)

*/

public Map mapRow(ResultSet rs, int rowNum) throws SQLException

{

ResultSetMetaData rsmd = rs.getMetaData();

int columnCount = rsmd.getColumnCount();

Map mapOfColValues = createColumnMap(columnCount);

for (int i = 1; i <= columnCount; i++)

{

String key = getColumnKey(rsmd.getColumnName(i));

Object obj = getColumnValue(rs, i);

mapOfColValues.put(key.toLowerCase(), obj);

}

return mapOfColValues;

}

/**

* Create a Map instance to be used as column map.

*

* By default, a linked case-insensitive Map will be created if possible,

* else a plain HashMap (see Spring's CollectionFactory).

*

* @param columnCount

*            the column count, to be used as initial capacity for the Map

* @return the new Map instance

* @see org.springframework.core.CollectionFactory#createLinkedCaseInsensitiveMapIfPossible

*/

protected Map createColumnMap(int columnCount)

{

return new LinkedHashMap(columnCount);

}

/**

* 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 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

* @throws java.sql.SQLException

*             如有异常，抛出。

* @see org.springframework.jdbc.support.JdbcUtils#getResultSetValue

*/

protected Object getColumnValue(ResultSet rs, int index)

throws SQLException

{

return JdbcUtils.getResultSetValue(rs, index);

}

}