| 限定符和类型 | 字段和说明 |
|---|---|
protected String |
catalog
数据库名称
|
protected Map |
columnNameToIndex
列名到索引的映射对象
|
protected Connection |
connection
Connection 会话对象
|
protected Object[] |
currentRow
结果集的当前行
|
protected boolean |
cursorHasMoreRows
游标接收时,查询数据是否已经读取完(false 表示全部数据已经读完)
|
Field[] |
fields
结果集的列信息
|
protected Map |
fullColumnNameToIndex
完整列名到索引的映射对象
|
protected boolean |
hasBuiltIndexMapping
判断是否已经创建列名到索引的映射
|
protected boolean |
isClosed
是否结果集已经关闭
|
RowData |
resRowData
结果集的实际行数据
|
int |
rsCurIndex
结果集当前行的index
|
boolean |
rsIsOver
是否本结果集已经接收全部对象
|
protected Statement |
statement
Statement SQL执行容器
|
protected Statement |
statementWrapp
2008-10-15 cao 添加Statement池对象
|
protected boolean |
wasNullFlag
记录刚检索出来的值是否为空
|
| 限定符和类型 | 方法和说明 |
|---|---|
boolean |
absolute(int row)
将指针移动到此 ResultSet 对象的给定行编号。
|
void |
afterLast()
将指针移动到此 ResultSet 对象的末尾,正好位于最后一行之后。
|
void |
beforeFirst()
将指针移动到此 ResultSet 对象的开头,正好位于第一行之前。
|
static String |
bitToString(byte[] bytes,
int rangeSize)
游标是否还有更多数据
Title: hasMoreResultSetForCursor
Description:
|
void |
cancelRowUpdates()
取消对 ResultSet 对象中的当前行所作的更新。
|
void |
clearWarnings()
Clears all warnings reported on this
ResultSet object. |
void |
close()
立即释放此 ResultSet 对象的数据库和 JDBC 资源,而不是等待该对象自动关闭时发生此操作。
|
void |
deleteRow()
从此 ResultSet 对象和底层数据库中删除当前行。
|
int |
findColumn(String columnName)
将给定的 ResultSet 列名称映射到其 ResultSet 列索引
|
boolean |
first()
将指针移动到此 ResultSet 对象的第一行。
|
Array |
getArray(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as an Array object
in the Java programming language. |
Array |
getArray(String colName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as an Array object
in the Java programming language. |
InputStream |
getAsciiStream(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a stream of ASCII characters. |
InputStream |
getAsciiStream(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a stream of
ASCII characters. |
BigDecimal |
getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.math.BigDecimal with full precision. |
BigDecimal |
getBigDecimal(int columnIndex,
int scale)
已过时。
|
BigDecimal |
getBigDecimal(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.math.BigDecimal with full precision. |
BigDecimal |
getBigDecimal(String columnName,
int scale)
已过时。
|
InputStream |
getBinaryStream(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a binary stream of
uninterpreted bytes. |
InputStream |
getBinaryStream(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a stream of uninterpreted
bytes. |
Blob |
getBlob(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Blob object
in the Java programming language. |
Blob |
getBlob(String colName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Blob object
in the Java programming language. |
boolean |
getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a boolean in the Java programming language. |
boolean |
getBoolean(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a boolean in the Java programming language. |
byte |
getByte(int columnIndex)
返回指定列的byte值
|
byte |
getByte(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a byte in the Java programming language. |
byte[] |
getBytes(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a byte array in the Java programming language. |
byte[] |
getBytes(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a byte array in the Java programming language. |
Reader |
getCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.io.Reader object. |
Reader |
getCharacterStream(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.io.Reader object. |
Clob |
getClob(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Clob object
in the Java programming language. |
Clob |
getClob(String colName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Clob object
in the Java programming language. |
int |
getConcurrency()
获取此 ResultSet 对象的并发模式。
|
String |
getCur_num() |
String |
getCursorName()
Retrieves the name of the SQL cursor used by this
ResultSet
object. |
Date |
getDate(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a java.sql.Date object in the Java programming language. |
Date |
getDate(int columnIndex,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Date object
in the Java programming language. |
Date |
getDate(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a java.sql.Date object in the Java programming language. |
Date |
getDate(String columnName,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Date object
in the Java programming language. |
double |
getDouble(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a double in the Java programming language. |
double |
getDouble(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a double in the Java programming language. |
int |
getFetchDirection()
获取此 ResultSet 对象的获取方向
Retrieves the fetch direction for this
ResultSet object. |
int |
getFetchSize()
获取此 ResultSet 对象的需要多行时获取行数大小。
|
float |
getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a float in the Java
programming language. |
float |
getFloat(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a float in the Java programming language. |
DBobject |
getGeometry(int columnIndex) |
int |
getHoldability() |
int |
getInt(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
an int in the Java programming language. |
int |
getInt(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
an int in the Java programming language. |
String |
getInterval(int columnIndex)
以时间间隔类型 INTERVAL 获取当前行的指定列中
返回两个时间
|
String |
getInterval(String columnName)
获取时间间隔类型
|
java.time.LocalDateTime |
getLocalDatetime(int columnIndex) |
long |
getLong(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a long in the Java programming language. |
long |
getLong(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a long in the Java programming language. |
ResultSetMetaData |
getMetaData()
检索此 ResultSet 对象的列的编号、类型和属性
|
Reader |
getNCharacterStream(int columnIndex) |
Reader |
getNCharacterStream(String columnLabel) |
NClob |
getNClob(int columnIndex)
未实现类型NClob
|
NClob |
getNClob(String columnLabel)
未实现类型NClob
|
String |
getNString(int columnIndex) |
String |
getNString(String columnLabel) |
Object |
getObject(int columnIndex)
以 Java 编程语言中 Object 的形式获取此 ResultSet 对象的当前行中指定列的值
---未完成
|
<T> T |
getObject(int columnIndex,
Class<T> type) |
Object |
getObject(int columnIndex,
Map<String,Class<?>> arg1) |
Object |
getObject(String columnName)
以 Java 编程语言中 Object 的形式获取此 ResultSet 对象的当前行中指定列的值
|
<T> T |
getObject(String columnLabel,
Class<T> type) |
Object |
getObject(String columnName,
Map<String,Class<?>> arg1) |
Ref |
getRef(int i)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Ref object
in the Java programming language. |
Ref |
getRef(String colName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a Ref object
in the Java programming language. |
int |
getRow()
检索当前行编号。
|
int |
getRowCount()
返回RS结果集的当前记录数
|
RowId |
getRowId(int columnIndex) |
RowId |
getRowId(String columnLabel) |
short |
getShort(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a short in the Java programming language. |
short |
getShort(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a short in the Java programming language. |
SQLXML |
getSQLXML(int columnIndex)
未实现类型SQLXML读取
|
SQLXML |
getSQLXML(String columnLabel)
未实现类型SQLXML读取
|
Statement |
getStatement()
检索生成此 ResultSet 对象的 Statement 对象。
|
String |
getString(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a String in the Java programming language. |
String |
getString(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a String in the Java programming language. |
Time |
getTime(int columnIndex)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a java.sql.Time object in the Java programming language. |
Time |
getTime(int columnIndex,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Time object
in the Java programming language. |
Time |
getTime(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a java.sql.Time object in the Java programming language. |
Time |
getTime(String columnName,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Time object
in the Java programming language. |
Timestamp |
getTimestamp(int columnIndex) |
Timestamp |
getTimestamp(int columnIndex,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
Timestamp |
getTimestamp(String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a java.sql.Timestamp object. |
Timestamp |
getTimestamp(String columnName,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
int |
getType()
获取此 ResultSet 对象的类型。
|
InputStream |
getUnicodeStream(int columnIndex)
已过时。
use
getCharacterStream in place of
getUnicodeStream |
InputStream |
getUnicodeStream(String columnName)
已过时。
use
getCharacterStream instead |
URL |
getURL(int columnIndex)
以 Java 编程语言中 java.net.URL 对象的形式获取此 ResultSet 对象的当前行中指定列的值
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.net.URL
object in the Java programming language. |
URL |
getURL(String columnName)
以 Java 编程语言中 java.net.URL 对象的形式获取此 ResultSet 对象的当前行中指定列的值。
|
SQLWarning |
getWarnings()
Retrieves the first warning reported by calls on this
ResultSet object. |
boolean |
hasMoreRows()
结果集当前数据集是否还有可读取数据
|
void |
insertRow()
将插入行的内容插入到此 ResultSet 对象和数据库中。
|
boolean |
isAfterLast()
检索指针是否位于此 ResultSet 对象的最后一行之后。
|
boolean |
isBeforeFirst()
检索指针是否位于此 ResultSet 对象的第一行之前。
|
boolean |
isClosed()
检查连接是否已关闭
|
boolean |
isCursor() |
protected boolean |
isCursorHasMoreRows()
获取游标结果集数据是否已经读完
|
static boolean |
isDate(String s) |
boolean |
isFirst()
检索指针是否位于此 ResultSet 对象的第一行。
|
boolean |
isLast()
检索指针是否位于此 ResultSet 对象的最后一行。
|
static boolean |
isTime(String s) |
static boolean |
isTimestamp(String s) |
boolean |
isWrapperFor(Class<?> iface) |
boolean |
last()
将指针移动到此 ResultSet 对象的最后一行。
|
void |
moveToCurrentRow()
将指针移动到记住的指针位置,通常为当前行。
|
void |
moveToInsertRow()
将指针移动到插入行。
|
boolean |
next()
将指针从当前位置下移一行。
|
boolean |
next(boolean isRowSet,
Connection rowsetCon)
将指针从当前位置下移一行。
|
boolean |
previous()
将指针移动到此 ResultSet 对象的上一行。
|
void |
refreshRow()
用数据库中的最近值刷新当前行。
|
boolean |
relative(int rows)
按相对行数(或正或负)移动指针。
|
int |
rowdataCapacity() |
int |
rowdataSize() |
boolean |
rowDeleted()
检索是否已删除某行。
|
boolean |
rowInserted()
检索当前行是否已有插入。
|
boolean |
rowUpdated()
检索是否已更新当前行。
|
protected void |
setCursorHasMoreRows(boolean rsHasMoreRows)
设置游标结果集数据是否已经读完
|
void |
setFetchDirection(int direction)
设置此 ResultSet 对象中行的处理方向
Gives a hint as to the direction in which the rows in this
ResultSet object will be processed. |
void |
setFetchSize(int rows)
设置 JDBC 驱动程序中,此 Statement 生成的 ResultSet 对象需要更多行时应该从数据库获取的行数。
|
void |
setWrapperStatement(Statement wrapperStatement)
2008-10-15 cao 添加 在getSatatement时好决定是用statement还是使用statment池中已有的statement
|
<T> T |
unwrap(Class<T> iface) |
void |
updateArray(int columnIndex,
Array x)
用 java.sql.Array 值更新指定列。
|
void |
updateArray(String columnName,
Array x)
Updates the designated column with a
java.sql.Array value. |
void |
updateAsciiStream(int columnIndex,
InputStream x) |
void |
updateAsciiStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(int columnIndex,
InputStream x,
long length)
JDBC4.0
|
void |
updateAsciiStream(String columnName,
InputStream x) |
void |
updateAsciiStream(String columnName,
InputStream x,
int length)
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(String columnLabel,
InputStream x,
long length) |
void |
updateBigDecimal(int columnIndex,
BigDecimal x)
Updates the designated column with a
java.math.BigDecimal
value. |
void |
updateBigDecimal(String columnName,
BigDecimal x)
Updates the designated column with a
java.sql.BigDecimal
value. |
void |
updateBinaryStream(int columnIndex,
InputStream x) |
void |
updateBinaryStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(int columnIndex,
InputStream x,
long length)
以Binary流更新当前行指定列
由于数据可能超过INT类型的范围,所以暂不支持该方法
|
void |
updateBinaryStream(String columnName,
InputStream x) |
void |
updateBinaryStream(String columnName,
InputStream x,
int length)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(String columnLabel,
InputStream x,
long length)
以Binary流更新当前行指定列
由于数据可能超过INT类型的范围,所以暂不支持该方法
|
void |
updateBlob(int columnIndex,
Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
updateBlob(int columnIndex,
InputStream inputStream) |
void |
updateBlob(int columnIndex,
InputStream inputStream,
long length) |
void |
updateBlob(String columnName,
Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
updateBlob(String columnLabel,
InputStream inputStream) |
void |
updateBlob(String columnLabel,
InputStream inputStream,
long length) |
void |
updateBoolean(int columnIndex,
boolean x)
Updates the designated column with a
boolean value. |
void |
updateBoolean(String columnName,
boolean x)
Updates the designated column with a
boolean value. |
void |
updateByte(int columnIndex,
byte x)
Updates the designated column with a
byte value. |
void |
updateByte(String columnName,
byte x)
Updates the designated column with a
byte value. |
void |
updateBytes(int columnIndex,
byte[] x)
Updates the designated column with a
byte array value. |
void |
updateBytes(String columnName,
byte[] x)
Updates the designated column with a byte array value.
|
void |
updateCharacterStream(int columnIndex,
Reader x) |
void |
updateCharacterStream(int columnIndex,
Reader x,
int length)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(int columnIndex,
Reader x,
long length) |
void |
updateCharacterStream(String columnLabel,
Reader reader) |
void |
updateCharacterStream(String columnName,
Reader reader,
int length)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(String columnLabel,
Reader reader,
long length) |
void |
updateClob(int columnIndex,
Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
updateClob(int columnIndex,
Reader reader) |
void |
updateClob(int columnIndex,
Reader reader,
long length) |
void |
updateClob(String columnName,
Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
updateClob(String columnLabel,
Reader reader) |
void |
updateClob(String columnLabel,
Reader reader,
long length) |
void |
updateDate(int columnIndex,
Date x)
Updates the designated column with a
java.sql.Date value. |
void |
updateDate(String columnName,
Date x)
Updates the designated column with a
java.sql.Date value. |
void |
updateDouble(int columnIndex,
double x)
Updates the designated column with a
double value. |
void |
updateDouble(String columnName,
double x)
Updates the designated column with a
double value. |
void |
updateFloat(int columnIndex,
float x)
Updates the designated column with a
float value. |
void |
updateFloat(String columnName,
float x)
Updates the designated column with a
float value. |
void |
updateInt(int columnIndex,
int x)
Updates the designated column with an
int value. |
void |
updateInt(String columnName,
int x)
Updates the designated column with an
int value. |
void |
updateLong(int columnIndex,
long x)
Updates the designated column with a
long value. |
void |
updateLong(String columnName,
long x)
Updates the designated column with a
long value. |
void |
updateNCharacterStream(int columnIndex,
Reader x) |
void |
updateNCharacterStream(int columnIndex,
Reader x,
long length) |
void |
updateNCharacterStream(String columnLabel,
Reader reader) |
void |
updateNCharacterStream(String columnLabel,
Reader reader,
long length) |
void |
updateNClob(int columnIndex,
NClob nClob) |
void |
updateNClob(int columnIndex,
Reader reader) |
void |
updateNClob(int columnIndex,
Reader reader,
long length) |
void |
updateNClob(String columnLabel,
NClob nClob) |
void |
updateNClob(String columnLabel,
Reader reader) |
void |
updateNClob(String columnLabel,
Reader reader,
long length) |
void |
updateNString(int columnIndex,
String nString) |
void |
updateNString(String columnLabel,
String nString) |
void |
updateNull(int columnIndex)
Gives a nullable column a null value.
|
void |
updateNull(String columnName)
Updates the designated column with a
null value. |
void |
updateObject(int columnIndex,
Object x)
用 Object 值更新指定列。
|
void |
updateObject(int columnIndex,
Object x,
int scale)
用 Object 值更新指定列。
|
void |
updateObject(String columnName,
Object x)
用 Object 值更新指定列。
|
void |
updateObject(String columnName,
Object x,
int scale)
Updates the designated column with an
Object value. |
void |
updateRef(int columnIndex,
Ref x)
Updates the designated column with a
java.sql.Ref value. |
void |
updateRef(String columnName,
Ref x)
Updates the designated column with a
java.sql.Ref value. |
void |
updateRow()
用此 ResultSet 对象的当前行的新内容更新底层数据库。
|
void |
updateRowId(int columnIndex,
RowId x)
JDBC4.0
|
void |
updateRowId(String columnLabel,
RowId x) |
void |
updateShort(int columnIndex,
short x)
Updates the designated column with a
short value. |
void |
updateShort(String columnName,
short x)
Updates the designated column with a
short value. |
void |
updateSQLXML(int columnIndex,
SQLXML xmlObject)
未实现类型SQLXML更新
|
void |
updateSQLXML(String columnLabel,
SQLXML xmlObject)
未实现类型SQLXML更新
|
void |
updateString(int columnIndex,
String x)
Updates the designated column with a
String value. |
void |
updateString(String columnName,
String x)
Updates the designated column with a
String value. |
void |
updateTime(int columnIndex,
Time x)
Updates the designated column with a
java.sql.Time value. |
void |
updateTime(String columnName,
Time x)
Updates the designated column with a
java.sql.Time value. |
void |
updateTimestamp(int columnIndex,
Timestamp x)
Updates the designated column with a
java.sql.Timestamp
value. |
void |
updateTimestamp(String columnName,
Timestamp x)
Updates the designated column with a
java.sql.Timestamp
value. |
boolean |
wasNull()
报告最后一个读取的列是否具有值 SQL NULL。
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitupdateObject, updateObject, updateObject, updateObjectpublic RowData resRowData
public Field[] fields
protected Object[] currentRow
public int rsCurIndex
public volatile boolean rsIsOver
protected boolean cursorHasMoreRows
protected boolean isClosed
protected Connection connection
protected Statement statement
protected Statement statementWrapp
protected String catalog
protected boolean hasBuiltIndexMapping
protected Map columnNameToIndex
protected Map fullColumnNameToIndex
protected boolean wasNullFlag
public boolean next()
throws SQLException
next 在接口中 ResultSetSQLExceptionpublic boolean next(boolean isRowSet,
Connection rowsetCon)
throws SQLException
SQLExceptionpublic void close()
throws SQLException
close 在接口中 AutoCloseableclose 在接口中 ResultSetSQLExceptionpublic boolean wasNull()
throws SQLException
wasNull 在接口中 ResultSetSQLExceptionpublic String getString(int columnIndex) throws SQLException
ResultSet object as
a String in the Java programming language.getString 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is nullSQLException - if a database access error occurspublic boolean getBoolean(int columnIndex)
throws SQLException
ResultSet object as
a boolean in the Java programming language.getBoolean 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is falseSQLException - if a database access error occurspublic byte getByte(int columnIndex)
throws SQLException
getByte 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is 0SQLException - if a database access error occurspublic short getShort(int columnIndex)
throws SQLException
ResultSet object as
a short in the Java programming language.getShort 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is 0SQLException - if a database access error occurspublic int getInt(int columnIndex)
throws SQLException
ResultSet object as
an int in the Java programming language.getInt 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is 0SQLException - if a database access error occurspublic long getLong(int columnIndex)
throws SQLException
ResultSet object as
a long in the Java programming language.getLong 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is 0SQLException - if a database access error occurspublic float getFloat(int columnIndex)
throws SQLException
ResultSet object as a float in the Java
programming language.getFloat 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is 0SQLException - if a database access error occurspublic double getDouble(int columnIndex)
throws SQLException
ResultSet object as
a double in the Java programming language.getDouble 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is 0SQLException - if a database access error occurspublic BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
ResultSet object as
a java.sql.BigDecimal in the Java programming language.getBigDecimal 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...scale - the number of digits to the right of the decimal pointNULL, the
value returned is nullSQLException - if a database access error occurspublic byte[] getBytes(int columnIndex)
throws SQLException
ResultSet object as
a byte array in the Java programming language.
The bytes represent the raw values returned by the driver.getBytes 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is nullSQLException - if a database access error occurspublic static boolean isDate(String s)
public static boolean isTime(String s)
public static boolean isTimestamp(String s)
public Date getDate(int columnIndex) throws SQLException
ResultSet object as
a java.sql.Date object in the Java programming language.getDate 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is nullSQLException - if a database access error occurspublic Time getTime(int columnIndex) throws SQLException
ResultSet object as
a java.sql.Time object in the Java programming language.getTime 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is nullSQLException - if a database access error occurspublic Timestamp getTimestamp(int columnIndex) throws SQLException
getTimestamp 在接口中 ResultSetSQLExceptionpublic java.time.LocalDateTime getLocalDatetime(int columnIndex)
throws SQLException
SQLExceptionpublic String getInterval(int columnIndex) throws SQLException
返回两个时间
SQLExceptionpublic InputStream getAsciiStream(int columnIndex) throws SQLException
ResultSet object as
a stream of ASCII characters. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0 when the method
InputStream.available
is called whether there is data available or not.
getAsciiStream 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is nullSQLException - if a database access error occurspublic InputStream getUnicodeStream(int columnIndex) throws SQLException
getCharacterStream in place of
getUnicodeStreamResultSet object as
as a stream of two-byte Unicode characters. The first byte is
the high byte; the second byte is the low byte.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHARvalues. The
JDBC driver will do any necessary conversion from the database
format into Unicode.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream.
Also, a stream may return 0 when the method
InputStream.available
is called, whether there is data available or not.
getUnicodeStream 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the value returned is
nullSQLException - if a database access error occurspublic InputStream getBinaryStream(int columnIndex) throws SQLException
ResultSet object as a binary stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0 when the method
InputStream.available
is called whether there is data available or not.
getBinaryStream 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the value returned is
nullSQLException - if a database access error occurspublic String getString(String columnName) throws SQLException
ResultSet object as
a String in the Java programming language.getString 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is nullSQLException - if a database access error occurspublic boolean getBoolean(String columnName) throws SQLException
ResultSet object as
a boolean in the Java programming language.getBoolean 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is falseSQLException - if a database access error occurspublic byte getByte(String columnName) throws SQLException
ResultSet object as
a byte in the Java programming language.getByte 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is 0SQLException - if a database access error occurspublic short getShort(String columnName) throws SQLException
ResultSet object as
a short in the Java programming language.getShort 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is 0SQLException - if a database access error occurspublic int getInt(String columnName) throws SQLException
ResultSet object as
an int in the Java programming language.getInt 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is 0SQLException - if a database access error occurspublic long getLong(String columnName) throws SQLException
ResultSet object as
a long in the Java programming language.getLong 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is 0SQLException - if a database access error occurspublic float getFloat(String columnName) throws SQLException
ResultSet object as
a float in the Java programming language.getFloat 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is 0SQLException - if a database access error occurspublic double getDouble(String columnName) throws SQLException
ResultSet object as
a double in the Java programming language.getDouble 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is 0SQLException - if a database access error occurspublic BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
ResultSet object as
a java.math.BigDecimal in the Java programming language.getBigDecimal 在接口中 ResultSetcolumnName - the SQL name of the columnscale - the number of digits to the right of the decimal pointNULL, the
value returned is nullSQLException - if a database access error occurspublic byte[] getBytes(String columnName) throws SQLException
ResultSet object as
a byte array in the Java programming language.
The bytes represent the raw values returned by the driver.getBytes 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is nullSQLException - if a database access error occurspublic Date getDate(String columnName) throws SQLException
ResultSet object as
a java.sql.Date object in the Java programming language.getDate 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is nullSQLException - if a database access error occurspublic Time getTime(String columnName) throws SQLException
ResultSet object as
a java.sql.Time object in the Java programming language.getTime 在接口中 ResultSetcolumnName - the SQL name of the columnNULL,
the value returned is nullSQLException - if a database access error occurspublic Timestamp getTimestamp(String columnName) throws SQLException
ResultSet object as
a java.sql.Timestamp object.getTimestamp 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the
value returned is nullSQLException - if a database access error occurspublic String getInterval(String columnName) throws SQLException
SQLExceptionpublic InputStream getAsciiStream(String columnName) throws SQLException
ResultSet object as a stream of
ASCII characters. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHAR values.
The JDBC driver will
do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0 when the method available
is called whether there is data available or not.
getAsciiStream 在接口中 ResultSetcolumnName - the SQL name of the columnNULL,
the value returned is null.SQLException - if a database access error occurspublic InputStream getUnicodeStream(String columnName) throws SQLException
getCharacterStream insteadResultSet object as a stream of two-byte
Unicode characters. The first byte is the high byte; the second
byte is the low byte.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHAR values.
The JDBC technology-enabled driver will
do any necessary conversion from the database format into Unicode.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream.
Also, a stream may return 0 when the method
InputStream.available is called, whether there
is data available or not.
getUnicodeStream 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the value returned
is null.SQLException - if a database access error occurspublic InputStream getBinaryStream(String columnName) throws SQLException
ResultSet object as a stream of uninterpreted
bytes.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0 when the method available
is called whether there is data available or not.
getBinaryStream 在接口中 ResultSetcolumnName - the SQL name of the columnNULL, the result is nullSQLException - if a database access error occurspublic SQLWarning getWarnings() throws SQLException
ResultSet object.
Subsequent warnings on this ResultSet object
will be chained to the SQLWarning object that
this method returns.
The warning chain is automatically cleared each time a new
row is read. This method may not be called on a ResultSet
object that has been closed; doing so will cause an
SQLException to be thrown.
Note: This warning chain only covers warnings caused
by ResultSet methods. Any warning caused by
Statement methods
(such as reading OUT parameters) will be chained on the
Statement object.
getWarnings 在接口中 ResultSetSQLWarning object reported or
null if there are noneSQLException - if a database access error occurs or this method is
called on a closed result setpublic void clearWarnings()
throws SQLException
ResultSet object.
After this method is called, the method getWarnings
returns null until a new warning is
reported for this ResultSet object.clearWarnings 在接口中 ResultSetSQLException - if a database access error occurspublic String getCursorName() throws SQLException
ResultSet
object.
In SQL, a result table is retrieved through a cursor that is
named. The current row of a result set can be updated or deleted
using a positioned update/delete statement that references the
cursor name. To insure that the cursor has the proper isolation
level to support update, the cursor's SELECT statement
should be of the form SELECT FOR UPDATE. If
FOR UPDATE is omitted, the positioned updates may fail.
The JDBC API supports this SQL feature by providing the name of the
SQL cursor used by a ResultSet object.
The current row of a ResultSet object
is also the current row of this SQL cursor.
Note: If positioned update is not supported, a
SQLException is thrown.
getCursorName 在接口中 ResultSetResultSet object's cursorSQLException - if a database access error occurspublic ResultSetMetaData getMetaData() throws SQLException
getMetaData 在接口中 ResultSetSQLExceptionpublic Object getObject(int columnIndex) throws SQLException
---未完成
getObject 在接口中 ResultSetSQLExceptionpublic DBobject getGeometry(int columnIndex) throws SQLException
SQLExceptionpublic Object getObject(String columnName) throws SQLException
getObject 在接口中 ResultSetSQLExceptionpublic int findColumn(String columnName) throws SQLException
findColumn 在接口中 ResultSetSQLExceptionpublic Reader getCharacterStream(int columnIndex) throws SQLException
ResultSet object as a
java.io.Reader object.getCharacterStream 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...java.io.Reader object that contains the column
value; if the value is SQL NULL, the value returned is
null in the Java programming language.SQLException - if a database access error occurspublic Reader getCharacterStream(String columnName) throws SQLException
ResultSet object as a
java.io.Reader object.getCharacterStream 在接口中 ResultSetcolumnName - the name of the columnjava.io.Reader object that contains the column
value; if the value is SQL NULL, the value returned is
null in the Java programming languageSQLException - if a database access error occurspublic BigDecimal getBigDecimal(int columnIndex) throws SQLException
ResultSet object as a
java.math.BigDecimal with full precision.getBigDecimal 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...NULL, the value returned is
null in the Java programming language.SQLException - if a database access error occurspublic BigDecimal getBigDecimal(String columnName) throws SQLException
ResultSet object as a
java.math.BigDecimal with full precision.getBigDecimal 在接口中 ResultSetcolumnName - the column nameNULL, the value returned is
null in the Java programming language.SQLException - if a database access error occurspublic boolean isBeforeFirst()
throws SQLException
isBeforeFirst 在接口中 ResultSetSQLExceptionpublic boolean isAfterLast()
throws SQLException
isAfterLast 在接口中 ResultSetSQLExceptionpublic boolean isFirst()
throws SQLException
isFirst 在接口中 ResultSetSQLExceptionpublic boolean isLast()
throws SQLException
注:调用 isLast 方法可能开销很大,因为 JDBC 驱动程序可能需要再往后获取一行,以确定当前行是否为结果集中的最后一行。
isLast 在接口中 ResultSetSQLExceptionpublic void beforeFirst()
throws SQLException
beforeFirst 在接口中 ResultSetSQLExceptionpublic void afterLast()
throws SQLException
afterLast 在接口中 ResultSetSQLExceptionpublic boolean first()
throws SQLException
first 在接口中 ResultSetSQLExceptionpublic boolean last()
throws SQLException
last 在接口中 ResultSetSQLExceptionpublic int getRow()
throws SQLException
getRow 在接口中 ResultSetSQLExceptionpublic boolean absolute(int row)
throws SQLException
absolute 在接口中 ResultSetSQLExceptionpublic boolean relative(int rows)
throws SQLException
relative 在接口中 ResultSetSQLExceptionpublic boolean previous()
throws SQLException
previous 在接口中 ResultSetSQLExceptionpublic void setFetchDirection(int direction)
throws SQLException
ResultSet object will be processed.
The initial value is determined by the
Statement object
that produced this ResultSet object.
The fetch direction may be changed at any time.setFetchDirection 在接口中 ResultSetdirection - an int specifying the suggested
fetch direction; one of ResultSet.FETCH_FORWARD,
ResultSet.FETCH_REVERSE, or
ResultSet.FETCH_UNKNOWNSQLException - if a database access error occurs or
the result set type is TYPE_FORWARD_ONLY and the fetch
direction is not FETCH_FORWARDStatement.setFetchDirection(int),
getFetchDirection()public int getFetchDirection()
throws SQLException
ResultSet object.getFetchDirection 在接口中 ResultSetResultSet objectSQLException - if a database access error occurssetFetchDirection(int)public void setFetchSize(int rows)
throws SQLException
ResultSet object.
If the fetch size specified is zero, the JDBC driver
ignores the value and is free to make its own best guess as to what
the fetch size should be. The default value is set by the
Statement object
that created the result set. The fetch size may be changed at any time.setFetchSize 在接口中 ResultSetrows - the number of rows to fetchSQLException - if a database access error occurs or the
condition 0 <= rows <= Statement.getMaxRows() is not satisfiedgetFetchSize()public int getFetchSize()
throws SQLException
ResultSet object.getFetchSize 在接口中 ResultSetResultSet objectSQLException - if a database access error occurssetFetchSize(int)public int getType()
throws SQLException
ResultSet object.
The type is determined by the Statement object
that created the result set.getType 在接口中 ResultSetResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE,
or ResultSet.TYPE_SCROLL_SENSITIVESQLException - if a database access error occurspublic int getConcurrency()
throws SQLException
getConcurrency 在接口中 ResultSetSQLExceptionpublic boolean rowUpdated()
throws SQLException
rowUpdated 在接口中 ResultSetSQLExceptionpublic boolean rowInserted()
throws SQLException
rowInserted 在接口中 ResultSetSQLExceptionpublic boolean rowDeleted()
throws SQLException
rowDeleted 在接口中 ResultSetSQLExceptionpublic void updateNull(int columnIndex)
throws SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or insertRow methods are called to update the database.
updateNull 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...SQLException - if a database access error occurspublic void updateBoolean(int columnIndex,
boolean x)
throws SQLException
boolean value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBoolean 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateByte(int columnIndex,
byte x)
throws SQLException
byte value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateByte 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateShort(int columnIndex,
short x)
throws SQLException
short value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateShort 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateInt(int columnIndex,
int x)
throws SQLException
int value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateInt 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateLong(int columnIndex,
long x)
throws SQLException
long value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateLong 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateFloat(int columnIndex,
float x)
throws SQLException
float value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateFloat 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateDouble(int columnIndex,
double x)
throws SQLException
double value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateDouble 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateBigDecimal(int columnIndex,
BigDecimal x)
throws SQLException
java.math.BigDecimal
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBigDecimal 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateString(int columnIndex,
String x)
throws SQLException
String value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateString 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateBytes(int columnIndex,
byte[] x)
throws SQLException
byte array value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBytes 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateDate(int columnIndex,
Date x)
throws SQLException
java.sql.Date value.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow or insertRow
methods are called to update the database.updateDate 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateTime(int columnIndex,
Time x)
throws SQLException
java.sql.Time value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateTime 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateTimestamp(int columnIndex,
Timestamp x)
throws SQLException
java.sql.Timestamp
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateTimestamp 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateAsciiStream(int columnIndex,
InputStream x,
int length)
throws SQLException
updateRow or
insertRow methods are called to update the database.updateAsciiStream 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamSQLException - if a database access error occurspublic void updateBinaryStream(int columnIndex,
InputStream x,
int length)
throws SQLException
updateRow or
insertRow methods are called to update the database.updateBinaryStream 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamSQLException - if a database access error occurspublic void updateCharacterStream(int columnIndex,
Reader x,
int length)
throws SQLException
updateRow or
insertRow methods are called to update the database.updateCharacterStream 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamSQLException - if a database access error occurspublic void updateObject(int columnIndex,
Object x,
int scale)
throws SQLException
Object value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateObject 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuescale - for java.sql.Types.DECIMA
or java.sql.Types.NUMERIC types,
this is the number of digits after the decimal point. For all other
types this value will be ignored.SQLException - if a database access error occurspublic void updateObject(int columnIndex,
Object x)
throws SQLException
Object value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateObject 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateNull(String columnName) throws SQLException
null value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateNull 在接口中 ResultSetcolumnName - the name of the columnSQLException - if a database access error occurspublic void updateBoolean(String columnName, boolean x) throws SQLException
boolean value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBoolean 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateByte(String columnName, byte x) throws SQLException
byte value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateByte 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateShort(String columnName, short x) throws SQLException
short value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateShort 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateInt(String columnName, int x) throws SQLException
int value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateInt 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateLong(String columnName, long x) throws SQLException
long value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateLong 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateFloat(String columnName, float x) throws SQLException
float value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateFloat 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateDouble(String columnName, double x) throws SQLException
double value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateDouble 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
java.sql.BigDecimal
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBigDecimal 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateString(String columnName, String x) throws SQLException
String value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateString 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateBytes(String columnName, byte[] x) throws SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or insertRow methods are called to update the database.
updateBytes 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateDate(String columnName, Date x) throws SQLException
java.sql.Date value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateDate 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateTime(String columnName, Time x) throws SQLException
java.sql.Time value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateTime 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateTimestamp(String columnName, Timestamp x) throws SQLException
java.sql.Timestamp
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateTimestamp 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
updateRow or
insertRow methods are called to update the database.updateAsciiStream 在接口中 ResultSetcolumnName - the name of the columnx - the new column valuelength - the length of the streamSQLException - if a database access error occurspublic void updateAsciiStream(int columnIndex,
InputStream x)
throws SQLException
updateAsciiStream 在接口中 ResultSetSQLExceptionpublic void updateAsciiStream(String columnName, InputStream x) throws SQLException
updateAsciiStream 在接口中 ResultSetSQLExceptionpublic void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
updateRow or
insertRow methods are called to update the database.updateBinaryStream 在接口中 ResultSetcolumnName - the name of the columnx - the new column valuelength - the length of the streamSQLException - if a database access error occurspublic void updateBinaryStream(int columnIndex,
InputStream x)
throws SQLException
updateBinaryStream 在接口中 ResultSetSQLExceptionpublic void updateBinaryStream(String columnName, InputStream x) throws SQLException
updateBinaryStream 在接口中 ResultSetSQLExceptionpublic void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
updateRow or
insertRow methods are called to update the database.updateCharacterStream 在接口中 ResultSetcolumnName - the name of the columnreader - the java.io.Reader object containing
the new column valuelength - the length of the streamSQLException - if a database access error occurspublic void updateObject(String columnName, Object x, int scale) throws SQLException
Object value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateObject 在接口中 ResultSetcolumnName - the name of the columnx - the new column valuescale - for java.sql.Types.DECIMAL
or java.sql.Types.NUMERIC types,
this is the number of digits after the decimal point. For all other
types this value will be ignored.SQLException - if a database access error occurspublic void updateObject(String columnName, Object x) throws SQLException
Object value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateObject 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void insertRow()
throws SQLException
---目前只能够在单表查询的结果集上实现插入
insertRow 在接口中 ResultSetSQLExceptionpublic void updateRow()
throws SQLException
---目前只能够更新单表查询的结果集
updateRow 在接口中 ResultSetSQLExceptionpublic void deleteRow()
throws SQLException
---已经实现对多表查询结果的删除
deleteRow 在接口中 ResultSetSQLExceptionpublic void refreshRow()
throws SQLException
refreshRow 方法提供一种让应用程序显式告知 JDBC 驱动程序从数据库重新获取行的方式。 应用程序可能需要在 JDBC 驱动程序完成缓存或预获取操作后调用 refreshRow,以便从数据库获取行的最新值。 如果获取大小大于 1,则 JDBC 驱动程序可以一次实际刷新多行。
应根据事务隔离级别和指针敏感度确定是否重新获取所有值。 如果在调用更新方法之后,但在调用 updateRow 方法之前调用 refreshRow,则会丢失对行所作的更新。 频繁调用方法 refreshRow 可能导致性能下降。
refreshRow 在接口中 ResultSetSQLExceptionpublic void cancelRowUpdates()
throws SQLException
cancelRowUpdates 在接口中 ResultSetSQLExceptionpublic void moveToInsertRow()
throws SQLException
moveToInsertRow 在接口中 ResultSetSQLExceptionpublic void moveToCurrentRow()
throws SQLException
moveToCurrentRow 在接口中 ResultSetSQLExceptionpublic Statement getStatement() throws SQLException
getStatement 在接口中 ResultSetSQLExceptionpublic void setWrapperStatement(Statement wrapperStatement)
wrapperStatement - public Ref getRef(int i) throws SQLException
ResultSet object as a Ref object
in the Java programming language.getRef 在接口中 ResultSeti - the first column is 1, the second is 2, ...Ref object representing an SQL REF
valueSQLException - if a database access error occurspublic Blob getBlob(int columnIndex) throws SQLException
ResultSet object as a Blob object
in the Java programming language.getBlob 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...Blob object representing the SQL
BLOB value in the specified columnSQLException - if a database access error occurspublic Clob getClob(int columnIndex) throws SQLException
ResultSet object as a Clob object
in the Java programming language.getClob 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...Clob object representing the SQL
CLOB value in the specified columnSQLException - if a database access error occurspublic Array getArray(int columnIndex) throws SQLException
ResultSet object as an Array object
in the Java programming language.getArray 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...Array object representing the SQL
ARRAY value in the specified columnSQLException - if a database access error occurspublic Ref getRef(String colName) throws SQLException
ResultSet object as a Ref object
in the Java programming language.getRef 在接口中 ResultSetcolName - the column nameRef object representing the SQL REF
value in the specified columnSQLException - if a database access error occurspublic Blob getBlob(String colName) throws SQLException
ResultSet object as a Blob object
in the Java programming language.getBlob 在接口中 ResultSetcolName - the name of the column from which to retrieve the valueBlob object representing the SQL BLOB
value in the specified columnSQLException - if a database access error occurspublic Clob getClob(String colName) throws SQLException
ResultSet object as a Clob object
in the Java programming language.getClob 在接口中 ResultSetcolName - the name of the column from which to retrieve the valueClob object representing the SQL CLOB
value in the specified columnSQLException - if a database access error occurspublic Array getArray(String colName) throws SQLException
ResultSet object as an Array object
in the Java programming language.getArray 在接口中 ResultSetcolName - the name of the column from which to retrieve the valueArray object representing the SQL ARRAY value in
the specified columnSQLException - if a database access error occurspublic Date getDate(int columnIndex, Calendar cal) throws SQLException
ResultSet object as a java.sql.Date object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the date if the underlying database does not store
timezone information.getDate 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the java.util.Calendar object
to use in constructing the datejava.sql.Date object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurspublic Date getDate(String columnName, Calendar cal) throws SQLException
ResultSet object as a java.sql.Date object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the date if the underlying database does not store
timezone information.getDate 在接口中 ResultSetcolumnName - the SQL name of the column from which to retrieve the valuecal - the java.util.Calendar object
to use in constructing the datejava.sql.Date object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurspublic Time getTime(int columnIndex, Calendar cal) throws SQLException
ResultSet object as a java.sql.Time object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the time if the underlying database does not store
timezone information.getTime 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the java.util.Calendar object
to use in constructing the timejava.sql.Time object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurspublic Time getTime(String columnName, Calendar cal) throws SQLException
ResultSet object as a java.sql.Time object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the time if the underlying database does not store
timezone information.getTime 在接口中 ResultSetcolumnName - the SQL name of the columncal - the java.util.Calendar object
to use in constructing the timejava.sql.Time object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurspublic Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
ResultSet object as a java.sql.Timestamp object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.getTimestamp 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the java.util.Calendar object
to use in constructing the timestampjava.sql.Timestamp object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurspublic Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
ResultSet object as a java.sql.Timestamp object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.getTimestamp 在接口中 ResultSetcolumnName - the SQL name of the columncal - the java.util.Calendar object
to use in constructing the datejava.sql.Timestamp object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurspublic URL getURL(int columnIndex) throws SQLException
ResultSet object as a java.net.URL
object in the Java programming language.getURL 在接口中 ResultSetcolumnIndex - the index of the column 1 is the first, 2 is the second,...java.net.URL object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurs,
or if a URL is malformedpublic URL getURL(String columnName) throws SQLException
ResultSet object as a java.net.URL
object in the Java programming language.getURL 在接口中 ResultSetcolumnName - the SQL name of the columnjava.net.URL object;
if the value is SQL NULL,
the value returned is null in the Java programming languageSQLException - if a database access error occurs
or if a URL is malformedpublic void updateRef(int columnIndex,
Ref x)
throws SQLException
java.sql.Ref value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateRef 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateRef(String columnName, Ref x) throws SQLException
java.sql.Ref value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateRef 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateBlob(int columnIndex,
Blob x)
throws SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBlob 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateBlob(String columnName, Blob x) throws SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBlob 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateClob(int columnIndex,
Clob x)
throws SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateClob 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateClob(String columnName, Clob x) throws SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateClob 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic void updateArray(int columnIndex,
Array x)
throws SQLException
java.sql.Array value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateArray 在接口中 ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if a database access error occurspublic void updateArray(String columnName, Array x) throws SQLException
java.sql.Array value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateArray 在接口中 ResultSetcolumnName - the name of the columnx - the new column valueSQLException - if a database access error occurspublic int getHoldability()
throws SQLException
getHoldability 在接口中 ResultSetSQLExceptionpublic Reader getNCharacterStream(int columnIndex) throws SQLException
getNCharacterStream 在接口中 ResultSetSQLExceptionpublic Reader getNCharacterStream(String columnLabel) throws SQLException
getNCharacterStream 在接口中 ResultSetSQLExceptionpublic NClob getNClob(int columnIndex) throws SQLException
getNClob 在接口中 ResultSetSQLExceptionpublic NClob getNClob(String columnLabel) throws SQLException
getNClob 在接口中 ResultSetSQLExceptionpublic String getNString(int columnIndex) throws SQLException
getNString 在接口中 ResultSetSQLExceptionpublic String getNString(String columnLabel) throws SQLException
getNString 在接口中 ResultSetSQLExceptionpublic RowId getRowId(int columnIndex) throws SQLException
getRowId 在接口中 ResultSetSQLExceptionpublic RowId getRowId(String columnLabel) throws SQLException
getRowId 在接口中 ResultSetSQLExceptionpublic SQLXML getSQLXML(int columnIndex) throws SQLException
getSQLXML 在接口中 ResultSetSQLExceptionpublic SQLXML getSQLXML(String columnLabel) throws SQLException
getSQLXML 在接口中 ResultSetSQLExceptionpublic boolean isClosed()
throws SQLException
isClosed 在接口中 ResultSetSQLExceptionpublic void updateAsciiStream(int columnIndex,
InputStream x,
long length)
throws SQLException
updateAsciiStream 在接口中 ResultSetSQLExceptionpublic void updateBinaryStream(int columnIndex,
InputStream x,
long length)
throws SQLException
updateBinaryStream 在接口中 ResultSetSQLExceptionpublic void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException
updateBinaryStream 在接口中 ResultSetSQLExceptionpublic void updateBlob(int columnIndex,
InputStream inputStream,
long length)
throws SQLException
updateBlob 在接口中 ResultSetSQLExceptionpublic void updateBlob(int columnIndex,
InputStream inputStream)
throws SQLException
updateBlob 在接口中 ResultSetSQLExceptionpublic void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException
updateBlob 在接口中 ResultSetSQLExceptionpublic void updateBlob(String columnLabel, InputStream inputStream) throws SQLException
updateBlob 在接口中 ResultSetSQLExceptionpublic void updateCharacterStream(int columnIndex,
Reader x,
long length)
throws SQLException
updateCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException
updateAsciiStream 在接口中 ResultSetSQLExceptionpublic void updateCharacterStream(int columnIndex,
Reader x)
throws SQLException
updateCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
updateCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateCharacterStream(String columnLabel, Reader reader) throws SQLException
updateCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateClob(int columnIndex,
Reader reader,
long length)
throws SQLException
updateClob 在接口中 ResultSetSQLExceptionpublic void updateClob(int columnIndex,
Reader reader)
throws SQLException
updateClob 在接口中 ResultSetSQLExceptionpublic void updateClob(String columnLabel, Reader reader, long length) throws SQLException
updateClob 在接口中 ResultSetSQLExceptionpublic void updateClob(String columnLabel, Reader reader) throws SQLException
updateClob 在接口中 ResultSetSQLExceptionpublic void updateNCharacterStream(int columnIndex,
Reader x,
long length)
throws SQLException
updateNCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateNCharacterStream(int columnIndex,
Reader x)
throws SQLException
updateNCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
updateNCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException
updateNCharacterStream 在接口中 ResultSetSQLExceptionpublic void updateNClob(int columnIndex,
NClob nClob)
throws SQLException
updateNClob 在接口中 ResultSetSQLExceptionpublic void updateNClob(int columnIndex,
Reader reader,
long length)
throws SQLException
updateNClob 在接口中 ResultSetSQLExceptionpublic void updateNClob(int columnIndex,
Reader reader)
throws SQLException
updateNClob 在接口中 ResultSetSQLExceptionpublic void updateNClob(String columnLabel, NClob nClob) throws SQLException
updateNClob 在接口中 ResultSetSQLExceptionpublic void updateNClob(String columnLabel, Reader reader, long length) throws SQLException
updateNClob 在接口中 ResultSetSQLExceptionpublic void updateNClob(String columnLabel, Reader reader) throws SQLException
updateNClob 在接口中 ResultSetSQLExceptionpublic void updateNString(int columnIndex,
String nString)
throws SQLException
updateNString 在接口中 ResultSetSQLExceptionpublic void updateNString(String columnLabel, String nString) throws SQLException
updateNString 在接口中 ResultSetSQLExceptionpublic void updateRowId(int columnIndex,
RowId x)
throws SQLException
updateRowId 在接口中 ResultSetSQLExceptionpublic void updateRowId(String columnLabel, RowId x) throws SQLException
updateRowId 在接口中 ResultSetSQLExceptionpublic void updateSQLXML(int columnIndex,
SQLXML xmlObject)
throws SQLException
updateSQLXML 在接口中 ResultSetSQLExceptionpublic void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException
updateSQLXML 在接口中 ResultSetSQLExceptionpublic String getCur_num()
public boolean isCursor()
public boolean hasMoreRows()
public int getRowCount()
public int rowdataSize()
public int rowdataCapacity()
protected boolean isCursorHasMoreRows()
protected void setCursorHasMoreRows(boolean rsHasMoreRows)
public <T> T getObject(int columnIndex,
Class<T> type)
throws SQLException
getObject 在接口中 ResultSetSQLExceptionpublic <T> T getObject(String columnLabel, Class<T> type) throws SQLException
getObject 在接口中 ResultSetSQLExceptionpublic Object getObject(int columnIndex, Map<String,Class<?>> arg1) throws SQLException
getObject 在接口中 ResultSetSQLExceptionpublic Object getObject(String columnName, Map<String,Class<?>> arg1) throws SQLException
getObject 在接口中 ResultSetSQLExceptionpublic boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor 在接口中 WrapperSQLExceptionpublic <T> T unwrap(Class<T> iface) throws SQLException
unwrap 在接口中 WrapperSQLExceptionpublic static String bitToString(byte[] bytes, int rangeSize) throws SQLException
Title: hasMoreResultSetForCursor
Description:
SQLExceptionCopyright © 2025. All rights reserved.