com.jn.sqlhelper.common.resultset

类 ResultSets

java.lang.Object

com.jn.sqlhelper.common.resultset.ResultSets

public class ResultSets
extends Object

字段概要

字段

限定符和类型	字段和说明
static List<JdbcType>	intTypes

构造器概要

构造器

构造器和说明
ResultSets()

方法概要

限定符和类型	方法和说明
static Object	getResultSetValue(ResultSet rs, int index) Retrieve a JDBC column value from a ResultSet, using the most appropriate value type.
static Object	getResultSetValue(ResultSet rs, int index, Class<?> requiredType) Retrieve a JDBC column value from a ResultSet, using the specified value type.

从类继承的方法 java.lang.Object

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

字段详细资料

intTypes

public static final List<JdbcType> intTypes

构造器详细资料

ResultSets

public ResultSets()

方法详细资料

getResultSetValue

@Nullable
public static Object getResultSetValue(ResultSet rs,
                                                  int index,
                                                  @Nullable
                                                  Class<?> requiredType)
                                           throws SQLException

Retrieve a JDBC column value from a ResultSet, using the specified value type.

Uses the specifically typed ResultSet accessor methods, falling back to getResultSetValue(java.sql.ResultSet, int) for unknown types.

Note that the returned value may not be assignable to the specified required type, in case of an unknown type. Calling code needs to deal with this case appropriately, e.g. throwing a corresponding exception.

参数:

rs - is the ResultSet holding the data

index - is the column index

requiredType - the required value type (may be null)

返回:

the value object (possibly not of the specified required type, with further conversion steps necessary)

抛出:

SQLException - if thrown by the JDBC API

另请参阅:

getResultSetValue(ResultSet, int)

getResultSetValue

@Nullable
public static Object getResultSetValue(ResultSet rs,
                                                  int index)
                                           throws SQLException

Retrieve a JDBC column value from a ResultSet, using the most appropriate value type. The returned value should be a detached value object, not having any ties to the active ResultSet: in particular, it should not be a Blob or Clob object but rather a byte array or String representation, respectively.

Uses the getObject(index) method, but includes additional "hacks" to get around Oracle 10g returning a non-standard object for its TIMESTAMP datatype and a java.sql.Date for DATE columns leaving out the time portion: These columns will explicitly be extracted as standard java.sql.Timestamp object.

参数:

rs - is the ResultSet holding the data

index - is the column index

返回:

the value object

抛出:

SQLException - if thrown by the JDBC API

另请参阅:

Blob, Clob, Timestamp