Top Fields Constructors Methods
com.mysql.cj.jdbc.result

public Class ResultSetImpl

extends NativeResultset
implements ResultSetInternalMethods, WarningListener
Class Inheritance
All Implemented Interfaces
com.mysql.cj.WarningListener, com.mysql.cj.jdbc.result.ResultSetInternalMethods, com.mysql.cj.protocol.Resultset, com.mysql.cj.protocol.ProtocolEntity, com.mysql.cj.protocol.ResultsetRowsOwner, java.sql.ResultSet, java.lang.AutoCloseable, java.sql.Wrapper
Known Direct Subclasses
com.mysql.cj.jdbc.result.UpdatableResultSet
Imports
java.io.InputStream, .InputStreamReader, .Reader, .UnsupportedEncodingException, java.math.BigDecimal, .BigInteger, java.net.MalformedURLException, .URL, java.sql.Array, .Date, .NClob, .Ref, .ResultSet, .RowId, .SQLException, .SQLFeatureNotSupportedException, .SQLType, .SQLWarning, .SQLXML, .Struct, .Time, .Timestamp, java.time.Duration, .LocalDate, .LocalDateTime, .LocalTime, .OffsetDateTime, .OffsetTime, .ZonedDateTime, java.util.Calendar, .HashSet, .Set, java.util.concurrent.locks.Lock, com.mysql.cj.Messages, .MysqlType, .NativeSession, .Query, .Session, .WarningListener, com.mysql.cj.conf.PropertyKey, .PropertySet, .RuntimeProperty, com.mysql.cj.exceptions.CJException, .ExceptionFactory, .ExceptionInterceptor, .MysqlErrorNumbers, com.mysql.cj.jdbc.Blob, .BlobFromLocator, .Clob, .CloseOption, .JdbcConnection, .JdbcPreparedStatement, .JdbcStatement, .MysqlSQLXML, .StatementImpl, com.mysql.cj.jdbc.exceptions.NotUpdatable, .SQLError, .SQLExceptionsMapping, com.mysql.cj.log.ProfilerEvent, .ProfilerEventHandler, com.mysql.cj.protocol.ColumnDefinition, .ResultsetRows, com.mysql.cj.protocol.a.result.NativeResultset, .OkPacket, com.mysql.cj.result.BigDecimalValueFactory, .BinaryStreamValueFactory, .BooleanValueFactory, .ByteValueFactory, .DoubleValueFactory, .DurationValueFactory, .Field, .FloatValueFactory, .IntegerValueFactory, .LocalDateTimeValueFactory, .LocalDateValueFactory, .LocalTimeValueFactory, .LongValueFactory, .OffsetDateTimeValueFactory, .OffsetTimeValueFactory, .ShortValueFactory, .SqlDateValueFactory, .SqlTimeValueFactory, .SqlTimestampValueFactory, .StringValueFactory, .UtilCalendarValueFactory, .ValueFactory, .ZonedDateTimeValueFactory, com.mysql.cj.util.LogUtils, .StringUtils

Field Summary

Modifier and TypeField and Description
private ValueFactory<BigDecimal>
private ValueFactory<InputStream>
private ValueFactory<Boolean>
private ValueFactory<Byte>
protected boolean[]
columnUsed

Keep track of columns accessed

protected volatile JdbcConnection
connection

The Connection instance that created us

protected int
currentRow

The current row #, -1 == before start of result set

protected String
db

The database that was in use when we were created

private ValueFactory<LocalDateTime>
private ValueFactory<LocalDate>
private ValueFactory<LocalTime>
private ValueFactory<OffsetDateTime>
private ValueFactory<OffsetTime>
private ValueFactory<Timestamp>
private ValueFactory<Time>
private ValueFactory<Calendar>
private ValueFactory<ZonedDateTime>
private ValueFactory<Double>
protected RuntimeProperty<Boolean>
protected ProfilerEventHandler
private ExceptionInterceptor
pack-priv Calendar
pack-priv Calendar
protected int
fetchDirection

The direction to fetch rows (always FETCH_FORWARD)

protected int
fetchSize

The number of rows to fetch in one go...

protected char
firstCharOfQuery

First character of the query that created this result set...Used to determine whether or not to parse server info messages in certain circumstances.

private ValueFactory<Float>
protected boolean
private ValueFactory<Integer>
private String
protected boolean
isClosed

Has this result set been closed?

private ValueFactory<Long>
private boolean
private StatementImpl
owningStatement

The statement that created us

private boolean
private String
pointOfOrigin

StackTrace generated where ResultSet was created...

pack-priv static int
resultCounter

Counter used to generate IDs for profiling.

protected int
resultSetConcurrency

Are we read-only or updatable?

protected int
resultSetType

Are we scroll-sensitive/insensitive?

protected boolean
scrollTolerant

Is ResultSet.TYPE_FORWARD_ONLY scroll tolerant?

protected NativeSession
private ValueFactory<Short>
pack-priv JdbcPreparedStatement
protected boolean
private boolean
protected boolean
protected SQLWarning
warningChain

The warning chain

protected Statement
protected boolean
Inherited from com.mysql.cj.protocol.a.result.NativeResultset:
columnDefinitionlocknextResultsetresultIdrowDataserverInfothisRowupdateCountupdateId

Constructor Summary

AccessConstructor and Description
public
ResultSetImpl(OkPacket ok, JdbcConnection
the Connection that created us.
conn
,
StatementImpl
the Statement that created us.
creatorStmt
)

Create a result set for an executeUpdate statement.

public
ResultSetImpl(ResultsetRows
actual row data
tuples
,
JdbcConnection
the Connection that created us.
conn
,
StatementImpl
the Statement that created us.
creatorStmt
)

Creates a new ResultSet object.

Method Summary

Modifier and TypeMethod and Description
public boolean
absolute(int
the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set
row
)

Implements java.sql.ResultSet.absolute.

Moves the cursor to the given row number in this ResultSet object.

public void
afterLast()

Implements java.sql.ResultSet.afterLast.

Moves the cursor to the end of this ResultSet object, just after the last row.

public void
beforeFirst()

Implements java.sql.ResultSet.beforeFirst.

Moves the cursor to the front of this ResultSet object, just before the first row.

public void
cancelRowUpdates()

Implements java.sql.ResultSet.cancelRowUpdates.

Cancels the updates made to the current row in this ResultSet object.

protected final JdbcConnection

Returns:

connection
checkClosed
()

Ensures that the result set is not closed

protected final void
checkColumnBounds(int
the index to check
columnIndex
)

Checks if columnIndex is within the number of columns in this result set.

protected void
checkRowPos()

Ensures that the cursor is positioned on a valid row and that the result set is not closed

public void
clearWarnings()

Implements java.sql.ResultSet.clearWarnings.

Clears all warnings reported on this ResultSet object.

public void
close()

Implements java.sql.ResultSet.close.

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

public void
public void
deleteRow()

Implements java.sql.ResultSet.deleteRow.

Deletes the current row from this ResultSet object and from the underlying database.

public void
doClose(CloseOption...
options indicating how the close was initiated and/or what should be performed during the close
options
)

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.doClose.

Close this ResultSet and release resources.

public int
findColumn(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.findColumn.

Maps the given ResultSet column label to its ResultSet column index.

public boolean
first()

Implements java.sql.ResultSet.first.

Moves the cursor to the first row in this ResultSet object.

public Array
getArray(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getArray.

Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

public Array
getArray(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
colName
)

Implements java.sql.ResultSet.getArray.

Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

public InputStream
getAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getAsciiStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

public InputStream
getAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getAsciiStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

public BigDecimal
getBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBigDecimal.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

public BigDecimal
getBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex
,
int
the number of digits to the right of the decimal point
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.

public BigDecimal
getBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getBigDecimal.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

public BigDecimal
getBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
int
the number of digits to the right of the decimal point
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.

public BigInteger
public InputStream
getBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBinaryStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

public InputStream
getBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getBinaryStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

public Blob
getBlob(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBlob.

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

public Blob
getBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
colName
)

Implements java.sql.ResultSet.getBlob.

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

public boolean
getBoolean(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBoolean.

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

public boolean
getBoolean(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getBoolean.

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

public byte
getByte(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getByte.

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

public byte
getByte(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getByte.

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

public byte[]
getBytes(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getBytes.

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

public byte[]
getBytes(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getBytes.

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

public Reader
getCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getCharacterStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public Reader
getCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getCharacterStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public Clob
getClob(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getClob.

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

public Clob
getClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
colName
)

Implements java.sql.ResultSet.getClob.

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

public int
getConcurrency()

Implements java.sql.ResultSet.getConcurrency.

Retrieves the concurrency mode of this ResultSet object.

public JdbcConnection
public String
getCursorName()

Implements java.sql.ResultSet.getCursorName.

Retrieves the name of the SQL cursor used by this ResultSet object.

public Date
getDate(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getDate.

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.

public Date
getDate(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

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.

public Date
getDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getDate.

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.

public Date
getDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

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.

public double
getDouble(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getDouble.

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

public double
getDouble(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getDouble.

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

protected ExceptionInterceptor
public int
getFetchDirection()

Implements java.sql.ResultSet.getFetchDirection.

Retrieves the fetch direction for this ResultSet object.

public int
getFetchSize()

Implements java.sql.ResultSet.getFetchSize.

Retrieves the fetch size for this ResultSet object.

public char
getFirstCharOfQuery()

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.getFirstCharOfQuery.

Returns the first character of the query that was issued to create this result set, upper-cased.

public float
getFloat(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getFloat.

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

public float
getFloat(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getFloat.

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

public int
getHoldability()

Implements java.sql.ResultSet.getHoldability.

Retrieves the holdability of this ResultSet object

public int
getInt(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getInt.

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

public int
getInt(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getInt.

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

public LocalDate
getLocalDate(int columnIndex)

public LocalDateTime
getLocalDateTime(int columnIndex)

public LocalTime
getLocalTime(int columnIndex)

public Lock
public long
getLong(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getLong.

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

public long
getLong(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getLong.

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

public ResultSetMetaData
getMetaData()

Implements java.sql.ResultSet.getMetaData.

Retrieves the number, types and properties of this ResultSet object's columns.

public ColumnDefinition
public Reader
getNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNCharacterStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public Reader
getNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getNCharacterStream.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

public NClob
getNClob(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNClob.

Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

public NClob
getNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getNClob.

Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

public String
getNString(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNString.

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public String
getNString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getNString.

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public Object
getObject(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getObject.

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public <T> T
getObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Class<T>
Class representing the Java data type to convert the designated column to.
type
)

Implements java.sql.ResultSet.getObject.

Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.

public <T> T
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Class<T>
Class representing the Java data type to convert the designated column to.
type
)

Implements java.sql.ResultSet.getObject.

Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.

public Object
getObject(int
the first column is 1, the second is 2, ...
i
,
Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public Object
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getObject.

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public Object
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
colName
,
Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

public Object
getObjectStoredProc(int
1-based column index
columnIndex
,
int
desired column type, one of Types
desiredSqlType
)

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.getObjectStoredProc.

Functions like ResultSet.getObject(), but using the given SQL type (as registered during CallableStatement.registerOutParameter()).

public Object
getObjectStoredProc(int
1-based column index
i
,
Map<Object, Object>
map
map
,
int
desired column type, one of Types
desiredSqlType
)

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.getObjectStoredProc.

Functions like ResultSet.getObject(), but using the given SQL type (as registered during CallableStatement.registerOutParameter()).

public Object
getObjectStoredProc(String
column name
columnName
,
int
desired column type, one of Types
desiredSqlType
)

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.getObjectStoredProc.

Functions like ResultSet.getObject(), but using the given SQL type (as registered during CallableStatement.registerOutParameter()).

public Object
getObjectStoredProc(String
column name
colName
,
Map<Object, Object>
map
map
,
int
desired column type, one of Types
desiredSqlType
)

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.getObjectStoredProc.

Functions like ResultSet.getObject(), but using the given SQL type (as registered during CallableStatement.registerOutParameter()).

public int
public Query
public StatementImpl
public int
public int
public long
public String
getPointOfOrigin()

Implements com.mysql.cj.protocol.ResultsetRowsOwner.getPointOfOrigin.

StackTrace generated where ResultSet was created...

public Ref
getRef(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getRef.

Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

public Ref
getRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
colName
)

Implements java.sql.ResultSet.getRef.

Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

public int
getRow()

Implements java.sql.ResultSet.getRow.

Retrieves the current row number.

public RowId
getRowId(int
the first column is 1, the second 2, ...
columnIndex
)

Implements java.sql.ResultSet.getRowId.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

public RowId
getRowId(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getRowId.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

public Session
public short
getShort(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getShort.

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

public short
getShort(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getShort.

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

public SQLXML
getSQLXML(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getSQLXML.

Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

public SQLXML
getSQLXML(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getSQLXML.

Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

public Statement
getStatement()

Implements java.sql.ResultSet.getStatement.

Retrieves the Statement object that produced this ResultSet object.

public String
getString(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getString.

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

public String
getString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getString.

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

private String
getStringForClob(int columnIndex)

private String
getStringForNClob(int columnIndex)

public Time
getTime(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getTime.

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.

public Time
getTime(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

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.

public Time
getTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getTime.

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.

public Time
getTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Calendar
the java.util.Calendar object to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

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.

public Timestamp
getTimestamp(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getTimestamp.

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.

public Timestamp
getTimestamp(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the timestamp
cal
)

Implements java.sql.ResultSet.getTimestamp.

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.

public Timestamp
getTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getTimestamp.

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.

public Timestamp
getTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getTimestamp.

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.

public int
getType()

Implements java.sql.ResultSet.getType.

Retrieves the type of this ResultSet object.

public InputStream
getUnicodeStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated

Retrieves the value of the designated column in the current row of this ResultSet object as as a stream of two-byte 3 characters.

public InputStream
getUnicodeStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters.

public URL
getURL(int
the index of the column 1 is the first, 2 is the second,...
colIndex
)

Implements java.sql.ResultSet.getURL.

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.

public URL
getURL(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
colName
)

Implements java.sql.ResultSet.getURL.

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.

public Calendar
getUtilCalendar(int columnIndex)

public SQLWarning
getWarnings()

Implements java.sql.ResultSet.getWarnings.

Retrieves the first warning reported by calls on this ResultSet object.

public void
public void
insertRow()

Implements java.sql.ResultSet.insertRow.

Inserts the contents of the insert row into this ResultSet object and into the database.

public boolean
isAfterLast()

Implements java.sql.ResultSet.isAfterLast.

Retrieves whether the cursor is after the last row in this ResultSet object.

public boolean
isBeforeFirst()

Implements java.sql.ResultSet.isBeforeFirst.

Retrieves whether the cursor is before the first row in this ResultSet object.

public boolean
isClosed()

Implements java.sql.ResultSet.isClosed.

Retrieves whether this ResultSet object has been closed.

public boolean
isFirst()

Implements java.sql.ResultSet.isFirst.

Retrieves whether the cursor is on the first row of this ResultSet object.

public boolean
isLast()

Implements java.sql.ResultSet.isLast.

Retrieves whether the cursor is on the last row of this ResultSet object

Note

Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.

protected boolean

Returns:

true if this result set type is ResultSet.TYPE_FORWARD_ONLY and the connection property 'scrollTolerantForwardOnly' has not been set to true.
isStrictlyForwardOnly
()

Checks whether this ResultSet is scrollable even if its type is ResultSet.TYPE_FORWARD_ONLY.

public boolean
isWrapperFor(Class<?>
a Class defining an interface.
iface
)

Implements java.sql.Wrapper.isWrapperFor.

Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.

public boolean
last()

Implements java.sql.ResultSet.last.

Moves the cursor to the last row in this ResultSet object.

public void
moveToCurrentRow()

Implements java.sql.ResultSet.moveToCurrentRow.

Moves the cursor to the remembered cursor position, usually the current row.

public void
moveToInsertRow()

Implements java.sql.ResultSet.moveToInsertRow.

Moves the cursor to the insert row.

public boolean
next()

Implements java.sql.ResultSet.next.

Moves the cursor forward one row from its current position.

public void
public boolean

Returns:

true if the new current is valid; false if there are no more rows
prev
()

The prev method is not part of JDBC, but because of the architecture of this driver it is possible to move both forward and backward within the result set.

public boolean
previous()

Implements java.sql.ResultSet.previous.

Moves the cursor to the previous row in this ResultSet object.

public void
refreshRow()

Implements java.sql.ResultSet.refreshRow.

Refreshes the current row with its most recent value in the database.

public boolean
relative(int
an int specifying the number of rows to move from the current row; a positive number moves the cursor forward; a negative number moves the cursor backward
rows
)

Implements java.sql.ResultSet.relative.

Moves the cursor a relative number of rows, either positive or negative.

public boolean
rowDeleted()

Implements java.sql.ResultSet.rowDeleted.

Retrieves whether a row has been deleted.

public boolean
rowInserted()

Implements java.sql.ResultSet.rowInserted.

Retrieves whether the current row has had an insertion.

public boolean
rowUpdated()

Implements java.sql.ResultSet.rowUpdated.

Retrieves whether the current row has been updated.

public void
setFetchDirection(int
an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
direction
)

Implements java.sql.ResultSet.setFetchDirection.

Gives a hint as to the direction in which the rows in this ResultSet object will be processed.

public void
setFetchSize(int
the number of rows to fetch
rows
)

Implements java.sql.ResultSet.setFetchSize.

Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.

public void
setFirstCharOfQuery(char
character
c
)

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.setFirstCharOfQuery.

Sets the first character of the query that was issued to create this result set.

public void
setOwningStatement(JdbcStatement
the statement this result set will belong to
owningStatement
)

Implements com.mysql.cj.jdbc.result.ResultSetInternalMethods.setOwningStatement.

Sets the statement that "owns" this result set (usually used when the result set should internally "belong" to one statement, but is created by another.

public void
setResultSetConcurrency(int
CONCUR_UPDATABLE or CONCUR_READONLY
concurrencyFlag
)

Sets the concurrency

public void
setResultSetType(int
SCROLL_SENSITIVE or SCROLL_INSENSITIVE (we only support SCROLL_INSENSITIVE)
typeFlag
)

Sets the result set type

private void
public void
setServerInfo(String
the server info message
info
)

Sets server info (if any)

public void
public void
public String
toString()

Overrides java.lang.Object.toString.

Returns a string representation of the object.

public <T> T
unwrap(Class<T>
A Class defining an interface that the result must implement.
iface
)

Implements java.sql.Wrapper.unwrap.

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public void
updateArray(int
the first column is 1, the second is 2, ...
columnIndex
,
Array
the new column value
arg1
)

Implements java.sql.ResultSet.updateArray.

Updates the designated column with a java.sql.Array value.

public void
updateArray(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Array
the new column value
arg1
)

Implements java.sql.ResultSet.updateArray.

Updates the designated column with a java.sql.Array value.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value.

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex
,
BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

Updates the designated column with a java.math.BigDecimal value.

public void
updateBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

Updates the designated column with a java.sql.BigDecimal value.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
Blob
the new column value
arg1
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column with a java.sql.Blob value.

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Blob
the new column value
arg1
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column with a java.sql.Blob value.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream, which will have the specified number of bytes.

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream, which will have the specified number of bytes.

public void
updateBoolean(int
the first column is 1, the second is 2, ...
columnIndex
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

Updates the designated column with a boolean value.

public void
updateBoolean(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

Updates the designated column with a boolean value.

public void
updateByte(int
the first column is 1, the second is 2, ...
columnIndex
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

Updates the designated column with a byte value.

public void
updateByte(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

Updates the designated column with a byte value.

public void
updateBytes(int
the first column is 1, the second is 2, ...
columnIndex
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

Updates the designated column with a byte array value.

public void
updateBytes(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

Updates the designated column with a byte array value.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
reader
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Reader
the java.io.Reader object containing the new column value
reader
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
reader
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Clob
the new column value
arg1
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column with a java.sql.Clob value.

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Clob
the new column value
clob
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column with a java.sql.Clob value.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateDate(int
the first column is 1, the second is 2, ...
columnIndex
,
Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

Updates the designated column with a java.sql.Date value.

public void
updateDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

Updates the designated column with a java.sql.Date value.

public void
updateDouble(int
the first column is 1, the second is 2, ...
columnIndex
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

Updates the designated column with a double value.

public void
updateDouble(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

Updates the designated column with a double value.

public void
updateFloat(int
the first column is 1, the second is 2, ...
columnIndex
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

Updates the designated column with a float value.

public void
updateFloat(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

Updates the designated column with a float value.

public void
updateInt(int
the first column is 1, the second is 2, ...
columnIndex
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

Updates the designated column with an int value.

public void
updateInt(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

Updates the designated column with an int value.

public void
updateLong(int
the first column is 1, the second is 2, ...
columnIndex
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

Updates the designated column with a long value.

public void
updateLong(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

Updates the designated column with a long value.

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value.

public void
updateNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
reader
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value.

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
reader
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
NClob
the value for the column to be updated
nClob
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column with a java.sql.NClob value.

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
NClob
the value for the column to be updated
nClob
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column with a java.sql.NClob value.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached.

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNString(int
the first column is 1, the second 2, ...
columnIndex
,
String
the value for the column to be updated
nString
)

Implements java.sql.ResultSet.updateNString.

Updates the designated column with a String value.

public void
updateNString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
String
the value for the column to be updated
nString
)

Implements java.sql.ResultSet.updateNString.

Updates the designated column with a String value.

public void
updateNull(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.updateNull.

Updates the designated column with a null value.

public void
updateNull(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
)

Implements java.sql.ResultSet.updateNull.

Updates the designated column with a null value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Object
the new column value
x
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Object
the new column value
x
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Object
the new column value
x
,
SQLType
the SQL type to be sent to the database
targetSqlType
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength
)

Overrides default java.sql.ResultSet.updateObject.

Updates the designated column with an Object value.

public void
updateRef(int
the first column is 1, the second is 2, ...
columnIndex
,
Ref
the new column value
arg1
)

Implements java.sql.ResultSet.updateRef.

Updates the designated column with a java.sql.Ref value.

public void
updateRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Ref
the new column value
arg1
)

Implements java.sql.ResultSet.updateRef.

Updates the designated column with a java.sql.Ref value.

public void
updateRow()

Implements java.sql.ResultSet.updateRow.

Updates the underlying database with the new contents of the current row of this ResultSet object.

public void
updateRowId(int
the first column is 1, the second 2, ...
columnIndex
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

Updates the designated column with a RowId value.

public void
updateRowId(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

Updates the designated column with a RowId value.

public void
updateShort(int
the first column is 1, the second is 2, ...
columnIndex
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

Updates the designated column with a short value.

public void
updateShort(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

Updates the designated column with a short value.

public void
updateSQLXML(int
the first column is 1, the second 2, ...
columnIndex
,
SQLXML
the value for the column to be updated
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates the designated column with a java.sql.SQLXML value.

public void
updateSQLXML(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
SQLXML
the column value
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates the designated column with a java.sql.SQLXML value.

public void
updateString(int
the first column is 1, the second is 2, ...
columnIndex
,
String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

Updates the designated column with a String value.

public void
updateString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

Updates the designated column with a String value.

public void
updateTime(int
the first column is 1, the second is 2, ...
columnIndex
,
Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

Updates the designated column with a java.sql.Time value.

public void
updateTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

Updates the designated column with a java.sql.Time value.

public void
updateTimestamp(int
the first column is 1, the second is 2, ...
columnIndex
,
Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

Updates the designated column with a java.sql.Timestamp value.

public void
updateTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnName
,
Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

Updates the designated column with a java.sql.Timestamp value.

public void
warningEncountered(String warning)

Implements com.mysql.cj.WarningListener.warningEncountered.

Accumulate internal warnings as the SQLWarning chain.

public boolean
wasNull()

Implements java.sql.ResultSet.wasNull.

Reports whether the last column read had a value of SQL NULL.

Inherited from com.mysql.cj.protocol.a.result.NativeResultset:
clearNextResultsetgetColumnDefinitiongetNextResultsetgetResultIdgetRowsgetServerInfogetUpdateCountgetUpdateIDhasRowsinitRowsWithMetadatasetColumnDefinitionsetNextResultset