#java.sql.ResultSet

ResultSet接口表示SQL查询语句执行完成后的结果集,可以通过Statement的executeQuery方法或者getResultSet方法获取。该接口用于遍历查询结果。

YashanDB JDBC驱动对ResultSet接口已支持功能:

返回类型 方法
boolean next()
void close()
boolean wasNull()
String getString(int columnIndex)
String getString(String columnLabel)
String getNString(int columnIndex)
String getNString(String columnLabel)
boolean getBoolean(int columnIndex)
boolean getBoolean(String columnLabel)
byte getByte(int columnIndex)
byte getByte(String columnLabel)
short getShort(int columnIndex)
short getShort(String columnLabel)
int getInt(int columnIndex)
int getInt(String columnLabel)
long getLong(int columnIndex)
long getLong(String columnLabel)
SQLXML getSQLXML(int columnIndex)
SQLXML getSQLXML(String columnLabel)
float getFloat(int columnIndex)
float float getFloat(String columnLabel)
double getDouble(int columnIndex)
double getDouble(String columnLabel)
BigDecimal getBigDecimal(int columnIndex)
BigDecimal getBigDecimal(String columnLabel)
BigDecimal getBigDecimal(int columnIndex, int scale)
BigDecimal getBigDecimal(String columnLabel, int scale)
byte[] getBytes(int columnIndex)
byte[] getBytes(String columnLabel)
java.sql.Date getDate(int columnIndex)
java.sql.Date getDate(String columnLabel)
java.sql.Date getDate(int columnIndex, Calendar cal)
java.sql.Date getDate(String columnLabel, Calendar cal)
java.sql.Timestamp getTimestamp(int columnIndex)
java.sql.Timestamp getTimestamp(String columnLabel)
java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal)
java.sql.Timestamp getTimestamp(String columnLabel, Calendar cal)
java.io.InputStream getAsciiStream(int columnIndex)
java.io.InputStream getAsciiStream(String columnLabel)
java.io.InputStream getBinaryStream(int columnIndex)
java.io.InputStream getBinaryStream(String columnLabel)
java.io.Reader getCharacterStream(int columnIndex)
java.io.Reader getCharacterStream(String columnLabel)
ResultSetMetaData getMetaData()
Object getObject(int columnIndex)
Object getObject(String columnLabel)
int findColumn(String columnLabel)
boolean isFirst()
int getRow()
int getType()
int getConcurrency()
Statement getStatement()
RowId getRowId(int columnIndex)
RowId getRowId(String columnLabel)
boolean isClosed()
java.sql.Time getTime(int columnIndex)
java.sql.Time getTime(String columnLabel)
java.sql.Time getTime(int columnIndex, Calendar cal)
java.sql.Time getTime(String columnLabel, Calendar cal)
Blob getBlob(int columnIndex)
Blob getBlob(String columnLabel)
Clob getClob(int columnIndex)
Clob getClob(String columnLabel)
<T> T getObject(int columnIndex, Class<T> type)
<T> T getObject(String columnLabel, Class<T> type)
Object getObject(int columnIndex, java.util.Map<String,Class<?>> map)
Object getObject(String columnLabel, java.util.Map<String,Class<?>> map)
Array getArray(int columnIndex)
Array getArray(String columnLabel)
boolean isBeforeFirst()
boolean isAfterLast()
boolean isLast()
void beforeFirst()
void afterLast()
boolean first()
boolean last()
boolean absolute( int row )
boolean relative( int rows )
boolean previous()
boolean rowUpdated()
boolean rowInserted()
boolean rowDeleted()
void updateNull(int columnIndex)
void updateNull(String columnLabel)
void updateByte(int columnIndex, byte x)
void updateByte(String columnLabel, byte x)
void updateShort(int columnIndex, short x)
void updateShort(String columnLabel, short x)
void updateInt(int columnIndex, int x)
void updateInt(String columnLabel, int x)
void updateLong(int columnIndex, long x)
void updateLong(String columnLabel, long x)
void updateFloat(int columnIndex, float x)
void updateFloat(String columnLabel, float x)
void updateDouble(int columnIndex, double x)
void updateDouble(String columnLabel, double x)
void updateBigDecimal(int columnIndex, BigDecimal x)
void updateBigDecimal(String columnLabel, BigDecimal x)
void updateString(int columnIndex, String x)
void updateString(String columnLabel, String x)
void updateSQLXML(int columnIndex, SQLXML xmlObject)
void updateSQLXML(String columnLabel, SQLXML xmlObject)
void updateDate(int columnIndex, java.sql.Date x)
void updateDate(String columnLabel, java.sql.Date x)
void updateTime(int columnIndex, java.sql.Time x)
void updateTime(String columnLabel, java.sql.Time x)
void updateTimestamp(int columnIndex, java.sql.Timestamp x)
void updateTimestamp(String columnLabel, java.sql.Timestamp x)
void updateBoolean(String columnLabel, boolean x)
void updateObject(int columnIndex, Object x, int scaleOrLength)
void updateObject(int columnIndex, Object x)
void updateObject(String columnLabel, Object x, int scaleOrLength)
void updateObject(String columnLabel, Object x)
void updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)
void updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength)
void updateObject(int columnIndex, Object x, SQLType targetSqlType)
void updateObject(String columnLabel, Object x, SQLType targetSqlType)
void insertRow()
void updateRow()
void deleteRow()
void updateBytes(int columnIndex, byte x[])
void updateBytes(String columnLabel, byte x[])
void updateRowId(int columnIndex, RowId x)
void updateRowId(String columnLabel, RowId x)
void moveToInsertRow()
void moveToCurrentRow()
void refreshRow()

未支持功能:

返回类型 方法
java.net.URL getURL(int columnIndex)
java.net.URL getURL(String columnLabel)
java.io.InputStream getUnicodeStream(int columnIndex)
java.io.InputStream getUnicodeStream(String columnLabel)
java.io.Reader getNCharacterStream(int columnIndex)
java.io.Reader getNCharacterStream(String columnLabel)
SQLWarning getWarnings()
void clearWarnings()
String getCursorName()
void setFetchDirection(int direction)
int getFetchDirection()
void setFetchSize(int rows)
int getFetchSize()
void updateArray(int columnIndex, java.sql.Array x)
void updateArray(String columnLabel, java.sql.Array x)
void updateRef(int columnIndex, java.sql.Ref x)
void updateRef(String columnLabel, java.sql.Ref x)
void updateBlob(int columnIndex, java.sql.Blob x)
void updateBlob(String columnLabel, java.sql.Blob x)
void updateBlob(int columnIndex, InputStream inputStream, long length)
void updateBlob(String columnLabel, InputStream inputStream, long length)
void updateBlob(int columnIndex, InputStream inputStream)
void updateBlob(String columnLabel, InputStream inputStream)
void updateClob(int columnIndex, java.sql.Clob x)
void updateClob(int columnIndex, Reader reader)
void updateClob(String columnLabel, Reader reader)
void updateClob(String columnLabel, java.sql.Clob x)
void updateClob(int columnIndex, Reader reader, long length)
void updateClob(String columnLabel, Reader reader, long length)
void updateNClob(int columnIndex, NClob nClob)
void updateNClob(String columnLabel, NClob nClob)
void updateNClob(int columnIndex, Reader reader, long length)
void updateNClob(String columnLabel, Reader reader, long length)
void updateNClob(int columnIndex, Reader reader)
void updateNClob(String columnLabel, Reader reader)
void updateCharacterStream(int columnIndex, java.io.Reader x, int length)
void updateCharacterStream(String columnLabel, java.io.Reader reader, int length)
void updateCharacterStream(int columnIndex, java.io.Reader x, long length)
void updateCharacterStream(String columnLabel,java.io.Reader reader,long length)
void updateCharacterStream(int columnIndex, java.io.Reader x)
void updateCharacterStream(String columnLabel, java.io.Reader reader)
void updateNCharacterStream(int columnIndex, java.io.Reader x)
void updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
void updateNCharacterStream(String columnLabel, java.io.Reader reader, long length)
void updateNCharacterStream(String columnLabel, java.io.Reader reader)
void updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
void updateAsciiStream(String columnLabel, java.io.InputStream x, long length)
void updateAsciiStream(int columnIndex, java.io.InputStream x)
void updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
void updateAsciiStream(String columnLabel, java.io.InputStream x)
void updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
void updateBinaryStream(String columnLabel, java.io.InputStream x, int length)
void updateBinaryStream(String columnLabel,java.io.InputStream x,long length)
void updateBinaryStream(int columnIndex, java.io.InputStream x)
void updateBinaryStream(String columnLabel, java.io.InputStream x)
void updateNString(int columnIndex, String nString)
void updateNString(String columnLabel, String nString)
void cancelRowUpdates()
Ref getRef(int columnIndex)
Ref getRef(String columnLabel)
NClob getNClob(int columnIndex)
NClob getNClob(String columnLabel)
int getHoldability()
pdf-btn 下载文档
copy-btn 复制链接