java 中getxxx的用法大全2006-09-28 11:11Version 1: How to read each JDBC typeThis 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, getObjectSMALLINT: getShort (recommended)Can also be read using getByte, getInt, getLong, getFloat,getDouble, getBigDecimal, getBoolean, getString, getObjectINTEGER: getInt (recommended)Can also be read using getByte, getShort, getLong, getFloat,getDouble, getBigDecimal, getBoolean, getString, getObjectBIGINT: getLong (recommended)Can also be read using getByte, getShort, getInt, getFloat,getDouble, getBigDecimal, getBoolean, getString, getObjectREAL: getFloat (recommended)Can also be read using getByte, getShort, getInt, getLong,getDouble, getBigDecimal, getBoolean, getString, getObjectFLOAT: getDouble (recommended)Can also be read using getByte, getShort, getInt, getLong,getFloat, getBigDecimal, getBoolean, getString, getObjectDOUBLE: getDouble (recommended)Can also be read using getByte, getShort, getInt, getLong,getFloat, getBigDecimal, getBoolean, getString, getObjectDECIMAL: getBigDecimal (recommended)Can also be read using getByte, getShort, getInt, getLong,getFloat, getDouble, getBoolean, getString, getObjectNUMERIC: getBigDecimal (recommended)Can also be read using getByte, getShort, getInt, getLong,getFloat, getDouble, getBoolean, getString, getObjectBIT: getBoolean (recommended)Can also be read using getByte, getShort, getInt, getLong,getFloat, getDouble, getBigDecimal, getString, getObjectCHAR: getString (recommended)Can also be read using getByte, getShort, getInt, getLong,getFloat, getDouble, getBigDecimal, getBoolean, getDate, getTime, getTimestamp, getAsciiStream, getUnicodeStream, getObjectVARCHAR: getString (recommended)Can also be read using getByte, getShort, getInt, getLong,getFloat, getDouble, getBigDecimal, getBoolean, getDate, getTime, getTimestamp, getAsciiStream, getUnicodeStream, getObjectLONGVARCHAR: getAsciiStream, getUnicodeStream (both recommended) Can also be read using getByte, getShort, getInt, getLong,getFloat, getDouble, getBigDecimal, getBoolean, getString,getDate, getTime, getTimestamp, getObjectBINARY: getBytes (recommended)Can also be read using getString, getAsciiStream,getUnicodeStream, getBinaryStream, getObjectVARBINARY: getBytes (recommended)Can also be read using getString, getAsciiStream,getUnicodeStream, getBinaryStream, getObjectLONGVARBINARY: getBinaryStream (recommended)Can also be read using getString, getBytes, getAsciiStream,getUnicodeStream, getObjectDATE: getDate (recommended)Can also be read using getString, getTimestamp, getObjectTIME: getTime (recommended)Can also be read using getString, getTimestamp, getObjectTIMESTAMP: getTimestamp (recommended)Can also be read using getString, getDate, getTime, getObject Version 2: Which types each ResultSet.getXXX method can readThis 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, LONGVARCHARgetShort: SMALLINT (recommended)Can also read TINYINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE,DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHARgetInt: INTEGER (recommended)Can also read TINYINT, SMALLINT, BIGINT, REAL, FLOAT, DOUBLE,DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHARgetLong: BIGINT (recommended)Can also read TINYINT, SMALLINT, INTEGER, REAL, FLOAT, DOUBLE,DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHARgetFloat: REAL (recommended)Can also read TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHARgetDouble: FLOAT, DOUBLE (both recommended)Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHARgetBigDecimal: DECIMAL, NUMERIC (both recommended)Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT,DOUBLE, BIT, CHAR, VARCHAR, LONGVARCHARgetBoolean: BIT (recommended)Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT,DOUBLE, DECIMAL, NUMERIC, CHAR, VARCHAR, LONGVARCHARgetString: CHAR, VARCHAR (both recommended)Can also read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT,DOUBLE, DECIMAL, NUMERIC, BIT, LONGVARCHAR, BINARY, VARBINARY,LONGVARBINARY, DATE, TIME, TIMESTAMPgetBytes: BINARY, VARBINARY (both recommended)Can also read LONGVARBINARYgetDate: DATE (recommended)Can also read CHAR, VARCHAR, LONGVARCHAR, TIMESTAMPgetTime: TIME (recommended)Can also read CHAR, VARCHAR, LONGVARCHAR, TIMESTAMPgetTimestamp: TIMESTAMP (recommended)Can also read CHAR, VARCHAR, LONGVARCHAR, DATE, TIMEgetAsciiStream: LONGVARCHAR (recommended)Can also read CHAR, VARCHAR, BINARY, VARBINARY, LONGVARBINARYgetUnicodeStream: LONGVARCHAR (recommended)Can also read CHAR, VARCHAR, BINARY, VARBINARY, LONGVARBINARYgetBinaryStream: LONGVARBINARY (recommended)Can also read BINARY, VARBINARYgetObject: (no recommended type)Can read TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR, LONGVARCHAR, BINARY,VARBINARY, LONGVARBINARY, DATE, TIME, TIMESTAMP。