《java中getxxx的用法大全》由会员分享,可在线阅读,更多相关《java中getxxx的用法大全(5页珍藏版)》请在金锄头文库上搜索。
1、java 中getxxx的用法大全2006-09-28 11:11Version 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, g
2、etBoolean, 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,
3、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, getB
4、oolean, 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, getBool
5、ean, 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, getBool
6、ean, 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, get
7、Boolean, 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
8、 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, getAsciiS
9、tream, 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, getUnicodeStre
10、am, 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: Whi
11、ch 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)
12、 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 TI
13、NYINT, 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 T
14、INYINT, 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, SM
15、ALLINT, 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)