Start of Tutorial > Start of Trail > Start of Lesson |
Search
Feedback Form |
Because the large table in Retrieving Values from Result Sets can be hard to read (especially with screen readers), this page presents two alternate versions of the table's data. The first version displays the information you can get by looking down each column of the table. The second displays the information for each row of the table. If you have any suggestions for improving this page, please tell us.Version 1: How to read each JDBC type
This section lists the ResultSet.getXXX methods recommended and allowed for retrieving data of each JDBC type.
- TINYINT: getByte (recommended)
- Can also be read using getShort, getInt, getLong, getFloat, getDouble, getBigDecimal, getBoolean, getString, getObject
- SMALLINT: getShort (recommended)
- Can also be read using getByte, getInt, getLong, getFloat, getDouble, getBigDecimal, getBoolean, getString, getObject
- INTEGER: getInt (recommended)
- Can also be read using getByte, getShort, getLong, getFloat, getDouble, getBigDecimal, getBoolean, getString, getObject
- BIGINT: getLong (recommended)
- Can also be read using getByte, getShort, getInt, getFloat, getDouble, getBigDecimal, getBoolean, getString, getObject
- REAL: getFloat (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getDouble, getBigDecimal, getBoolean, getString, getObject
- FLOAT: getDouble (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getBigDecimal, getBoolean, getString, getObject
- DOUBLE: getDouble (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getBigDecimal, getBoolean, getString, getObject
- DECIMAL: getBigDecimal (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getDouble, getBoolean, getString, getObject
- NUMERIC: getBigDecimal (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getDouble, getBoolean, getString, getObject
- BIT: getBoolean (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getDouble, getBigDecimal, getString, getObject
- CHAR: getString (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getDouble, getBigDecimal, getBoolean, getDate, getTime, getTimestamp, getAsciiStream, getUnicodeStream, getObject
- VARCHAR: getString (recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getDouble, getBigDecimal, getBoolean, getDate, getTime, getTimestamp, getAsciiStream, getUnicodeStream, getObject
- LONGVARCHAR: getAsciiStream, getUnicodeStream (both recommended)
- Can also be read using getByte, getShort, getInt, getLong, getFloat, getDouble, getBigDecimal, getBoolean, getString, getDate, getTime, getTimestamp, getObject
- BINARY: getBytes (recommended)
- Can also be read using getString, getAsciiStream, getUnicodeStream, getBinaryStream, getObject
- VARBINARY: getBytes (recommended)
- Can also be read using getString, getAsciiStream, getUnicodeStream, getBinaryStream, getObject
- LONGVARBINARY: getBinaryStream (recommended)
- Can also be read using getString, getBytes, getAsciiStream, getUnicodeStream, getObject
- DATE: getDate (recommended)
- Can also be read using getString, getTimestamp, getObject
- TIME: getTime (recommended)
- Can also be read using getString, getTimestamp, getObject
- TIMESTAMP: getTimestamp (recommended)
- Can also be read using getString, getDate, getTime, getObject
Version 2: Which types each ResultSet.getXXX method can read
This section lists the JDBC types that each ResultSet.getXXX method supports.
- getByte: TINYINT (recommended)
- Can also read SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR
- getShort: SMALLINT (recommended)
- Can also read TINYINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR
- getInt: INTEGER (recommended)
- Can also read TINYINT, SMALLINT, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR
- getLong: BIGINT (recommended)
- Can also read TINYINT, SMALLINT, INTEGER, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR
- getFloat: REAL (recommended)
- Can also read TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR
- getDouble: FLOAT, DOUBLE (both recommended)
- Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR
- getBigDecimal: DECIMAL, NUMERIC (both recommended)
- Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, BIT, CHAR, VARCHAR, LONGVARCHAR
- getBoolean: BIT (recommended)
- Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, VARCHAR, LONGVARCHAR
- getString: CHAR, VARCHAR (both recommended)
- Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, LONGVARCHAR, BINARY, VARBINARY, LONGVARBINARY, DATE, TIME, TIMESTAMP
- getBytes: BINARY, VARBINARY (both recommended)
- Can also read LONGVARBINARY
- getDate: DATE (recommended)
- Can also read CHAR, VARCHAR, LONGVARCHAR, TIMESTAMP
- getTime: TIME (recommended)
- Can also read CHAR, VARCHAR, LONGVARCHAR, TIMESTAMP
- getTimestamp: TIMESTAMP (recommended)
- Can also read CHAR, VARCHAR, LONGVARCHAR, DATE, TIME
- getAsciiStream: LONGVARCHAR (recommended)
- Can also read CHAR, VARCHAR, BINARY, VARBINARY, LONGVARBINARY
- getUnicodeStream: LONGVARCHAR (recommended)
- Can also read CHAR, VARCHAR, BINARY, VARBINARY, LONGVARBINARY
- getBinaryStream: LONGVARBINARY (recommended)
- Can also read BINARY, VARBINARY
- getObject: (no recommended type)
- Can read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR, BINARY, VARBINARY, LONGVARBINARY, DATE, TIME, TIMESTAMP
Start of Tutorial > Start of Trail > Start of Lesson |
Search
Feedback Form |
Copyright 1995-2005 Sun Microsystems, Inc. All rights reserved.