ai.yue.library.data.jdbc.support

Class ColumnMapRowMapper

java.lang.Object

ai.yue.library.data.jdbc.support.ColumnMapRowMapper

All Implemented Interfaces:

org.springframework.jdbc.core.RowMapper<com.alibaba.fastjson.JSONObject>

public class ColumnMapRowMapper
extends Object
implements org.springframework.jdbc.core.RowMapper<com.alibaba.fastjson.JSONObject>

参考 ColumnMapRowMapper，替换为 fastjson 的 JSONObject

Since:

2020年11月2日

Author:

ylyue

Constructor Summary

Constructors

Constructor and Description
ColumnMapRowMapper(DbBase dbBase, String... tableNames)

Method Summary

Modifier and Type	Method and Description
protected com.alibaba.fastjson.JSONObject	createColumnMap(int columnCount) Create a Map instance to be used as column map.
protected String	getColumnKey(String columnName) Determine the key to use for the given column in the column Map.
protected Object	getColumnValue(ResultSet rs, int index) Retrieve a JDBC object value for the specified column.
com.alibaba.fastjson.JSONObject	mapRow(ResultSet rs, int rowNum)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ColumnMapRowMapper

public ColumnMapRowMapper(DbBase dbBase,
                          String... tableNames)

Method Detail

mapRow

public com.alibaba.fastjson.JSONObject mapRow(ResultSet rs,
                                              int rowNum)
                                       throws SQLException

Specified by:

mapRow in interface org.springframework.jdbc.core.RowMapper<com.alibaba.fastjson.JSONObject>

Throws:

SQLException

createColumnMap

protected com.alibaba.fastjson.JSONObject createColumnMap(int columnCount)

Create a Map instance to be used as column map.

By default, a linked case-insensitive Map will be created.

Parameters:

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

Returns:

the new Map instance

See Also:

LinkedCaseInsensitiveMap

getColumnKey

protected String getColumnKey(String columnName)

Determine the key to use for the given column in the column Map.

Parameters:

columnName - the column name as returned by the ResultSet

Returns:

the column key to use

See Also:

ResultSetMetaData.getColumnName(int)

getColumnValue

@Nullable
protected Object getColumnValue(ResultSet rs,
                                          int index)
                                   throws SQLException

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.

Parameters:

rs - is the ResultSet holding the data

index - is the column index

Returns:

the Object returned

Throws:

SQLException

See Also:

JdbcUtils.getResultSetValue(java.sql.ResultSet, int, java.lang.Class<?>)