📄 resultset.java
字号:
* @param column The name of the column to return. * @return The column value as a <code>double</code>. * @exception SQLException If an error occurs. */ public double getDouble(String columnName) throws SQLException; /** * This method returns the value of the specified column as a Java * <code>BigDecimal</code>. * * @param index The index of the column to return. * @return The column value as a <code>BigDecimal</code>. * @exception SQLException If an error occurs. * @deprecated */ public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException; /** * This method returns the value of the specified column as a Java * byte array. * * @param column The name of the column to return. * @return The column value as a byte array * @exception SQLException If an error occurs. */ public byte[] getBytes(String columnName) throws SQLException; /** * This method returns the value of the specified column as a Java * <code>java.sql.Date</code>. * * @param column The name of the column to return. * @return The column value as a <code>java.sql.Date</code>. * @exception SQLException If an error occurs. */ public Date getDate(String columnName) throws SQLException; /** * This method returns the value of the specified column as a Java * <code>java.sql.Time</code>. * * @param column The name of the column to return. * @return The column value as a <code>java.sql.Time</code>. * @exception SQLException If an error occurs. */ public Time getTime(String columnName) throws SQLException; /** * This method returns the value of the specified column as a Java * <code>java.sql.Timestamp</code>. * * @param column The name of the column to return. * @return The column value as a <code>java.sql.Timestamp</code>. * @exception SQLException If an error occurs. */ public Timestamp getTimestamp(String columnName) throws SQLException; /** * This method returns the value of the specified column as an ASCII * stream. Note that all the data from this stream must be read before * fetching the value of any other column. Please also be aware that * calling <code>next()</code> or <code>close()</code> on this result set * will close this stream as well. * * @param column The name of the column to return. * @return The column value as an ASCII <code>InputStream</code>. * @exception SQLException If an error occurs. */ public InputStream getAsciiStream(String columnName) throws SQLException; /** * This method returns the value of the specified column as a Unicode UTF-8 * stream. Note that all the data from this stream must be read before * fetching the value of any other column. Please also be aware that * calling <code>next()</code> or <code>close()</code> on this result set * will close this stream as well. * * @param column The name of the column to return. * @return The column value as a Unicode UTF-8 <code>InputStream</code>. * @exception SQLException If an error occurs. * @deprecated Use getCharacterStream instead. */ public InputStream getUnicodeStream(String columnName) throws SQLException; /** * This method returns the value of the specified column as a raw byte * stream. Note that all the data from this stream must be read before * fetching the value of any other column. Please also be aware that * calling <code>next()</code> or <code>close()</code> on this result set * will close this stream as well. * * @param column The name of the column to return. * @return The column value as a raw byte <code>InputStream</code>. * @exception SQLException If an error occurs. */ public InputStream getBinaryStream(String columnName) throws SQLException; /** * This method returns the first SQL warning associated with this result * set. Any additional warnings will be chained to this one. * * @return The first SQLWarning for this result set, or <code>null</code> if * there are no warnings. * @exception SQLException If an error occurs. */ public SQLWarning getWarnings() throws SQLException; /** * This method clears all warnings associated with this result set. * * @exception SQLException If an error occurs. */ public void clearWarnings() throws SQLException; /** * This method returns the name of the database cursor used by this * result set. * * @return The name of the database cursor used by this result set. * @exception SQLException If an error occurs. */ public String getCursorName() throws SQLException; /** * This method returns data about the columns returned as part of the * result set as a <code>ResultSetMetaData</code> instance. * * @return The <code>ResultSetMetaData</code> instance for this result set. * @exception SQLException If an error occurs. */ public ResultSetMetaData getMetaData() throws SQLException; /** * This method returns the value of the specified column as a Java * <code>Object</code>. * * @param index The index of the column to return. * @return The column value as an <code>Object</code>. * @exception SQLException If an error occurs. */ public Object getObject(int columnIndex) throws SQLException; /** * This method returns the value of the specified column as a Java * <code>Object</code>. * * @param column The name of the column to return. * @return The column value as an <code>Object</code>. * @exception SQLException If an error occurs. */ public Object getObject(String columnName) throws SQLException; /** * This method returns the column index of the specified named column. * * @param column The name of the column. * @return The index of the column. * @exception SQLException If an error occurs. */ public int findColumn(String columnName) throws SQLException; /** * This method returns the value of the specified column as a character * stream. Note that all the data from this stream must be read before * fetching the value of any other column. Please also be aware that * calling <code>next()</code> or <code>close()</code> on this result set * will close this stream as well. * * @param index The index of the column to return. * @return The column value as an character <code>Reader</code>. * @exception SQLException If an error occurs. */ public Reader getCharacterStream(int columnIndex) throws SQLException; /** * This method returns the value of the specified column as a character * stream. Note that all the data from this stream must be read before * fetching the value of any other column. Please also be aware that * calling <code>next()</code> or <code>close()</code> on this result set * will close this stream as well. * * @param column The name of the column to return. * @return The column value as an character <code>Reader</code>. * @exception SQLException If an error occurs. */ public Reader getCharacterStream(String columnName) throws SQLException; /** * This method returns the value of the specified column as a Java * <code>BigDecimal</code>. * * @param index The index of the column to return. * @return The column value as a <code>BigDecimal</code>. * @exception SQLException If an error occurs. */ public BigDecimal getBigDecimal(int columnIndex) throws SQLException; /** * This method returns the value of the specified column as a Java * <code>BigDecimal</code>. * * @param column The name of the column to return. * @return The column value as a <code>BigDecimal</code>. * @exception SQLException If an error occurs. */ public BigDecimal getBigDecimal(String columnName) throws SQLException; /** * This method tests whether or not the cursor is before the first row * in the result set. * * @return <code>true</code> if the cursor is positioned before the first * row, <code>false</code> otherwise. * @exception SQLException If an error occurs. */ public boolean isBeforeFirst() throws SQLException; /** * This method tests whether or not the cursor is after the last row * in the result set. * * @return <code>true</code> if the cursor is positioned after the last * row, <code>false</code> otherwise. * @exception SQLException If an error occurs. */ public boolean isAfterLast() throws SQLException; /** * This method tests whether or not the cursor is positioned on the first * row in the result set. * * @return <code>true</code> if the cursor is positioned on the first * row, <code>false</code> otherwise. * @exception SQLException If an error occurs. */ public boolean isFirst() throws SQLException; /** * This method tests whether or not the cursor is on the last row * in the result set. * * @return <code>true</code> if the cursor is positioned on the last * row, <code>false</code> otherwise. * @exception SQLException If an error occurs. */ public boolean isLast() throws SQLException; /** * This method repositions the cursor to before the first row in the * result set. * * @exception SQLException If an error occurs. */ public void beforeFirst() throws SQLException; /** * This method repositions the cursor to after the last row in the result * set. * * @exception SQLException If an error occurs. */ public void afterLast() throws SQLException; /** * This method repositions the cursor on the first row in the * result set. * * @return <code>true</code> if the cursor is on a valid row; * <code>false</code> if there are no rows in the result set. * @exception SQLException If an error occurs. */ public boolean first() throws SQLException; /** * This method repositions the cursor on the last row in the result * set. * * @return <code>true</code> if the cursor is on a valid row; * <code>false</code> if there are no rows in the result set. * @exception SQLException If an error occurs. */ public boolean last() throws SQLException; /** * This method returns the current row number in the cursor. Numbering * begins at index 1. * * @return The current row number, or 0 if there is not current row. * @exception SQLException If an error occurs. */ public int getRow() throws SQLException; /** * This method positions the result set to the specified absolute row. * Positive numbers are row offsets from the beginning of the result * set (numbering starts from row 1) and negative numbers are row offsets * from the end of the result set (numbering starts from -1). * * @param row The row to position the result set to. * * @return <code>true</code> if the current position was changed, * <code>false</code> otherwise. * @exception SQLException If an error occurs. */ public boolean absolute(int row) throws SQLException; /** * This method moves the result set position relative to the current row. * The offset can be positive or negative. * * @param row The relative row position to move to. * @return <code>true</code> if the current position was changed, * <code>false</code> otherwise. * @exception SQLException If an error occurs. */ public boolean relative(int rows) throws SQLException; /** * This method moves the current position to the previous row in the * result set. * * @return <code>true</code> if the previous row exists, <code>false</code> * otherwise. * @exception SQLException If an error occurs. */ public boolean previous() throws SQLException; /** * This method provides a hint to the driver about which direction the * result set will be processed in. * * @param direction The direction in which rows will be processed. (Values?) * @exception SQLException If an error occurs. */ public void setFetchDirection(int direction) throws SQLException; /** * This method returns the current fetch direction for this result set. * * @return The fetch direction for this result set. * @exception SQLException If an error occurs. */ public int getFetchDirection() throws SQLException; /** * This method provides a hint to the driver about how many rows at a * time it should fetch from the database. * * @param rows The number of rows the driver should fetch per call. * @exception SQLException If an error occurs. */ public void setFetchSize(int rows) throws SQLException; /** * This method returns the current number of rows that will be fetched * from the database at a time. * * @return The current fetch size for this result set. * @exception SQLException If an error occurs. */ public int getFetchSize() throws SQLException; /** * This method returns the result set type of this result set. This will * be one of the TYPE_* constants defined in this interface. * * @return The result set type. * @exception SQLException If an error occurs. */ public int getType() throws SQLException; /** * This method returns the concurrency type of this result set. This will * be one of the CONCUR_* constants defined in this interface. * * @return The result set concurrency type. * @exception SQLException If an error occurs. */ public int getConcurrency() throws SQLException; /** * This method tests whether or not the current row in the result set
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -