数据库类型与JDBC TYPE 和Java类型对应关系

SQLDatatypes

JDBC Typecodes

Standard Java Types

Java取值范围

NUMBER

java.sql.Types.NUMERIC

java.math.BigDecimal

无限制

NUMBER

java.sql.Types.DECIMAL

java.math.BigDecimal

无限制

NUMBER

java.sql.Types.BIT

boolean

true,false

NUMBER

java.sql.Types.TINYINT

byte

from –128 to 127

NUMBER

java.sql.Types.SMALLINT

short

from –32768 to 32767

NUMBER

java.sql.Types.INTEGER

int

From –2147483648 to 2147483647

NUMBER

java.sql.Types.BIGINT

long

From –9223372036854775808 to 9223372036854775807

NUMBER

java.sql.Types.REAL

float

From 1.4E-45

To 3.4028235E38

NUMBER

java.sql.Types.FLOAT

double

From 4.9E-324 to

1.7976931348623157E308

NUMBER

java.sql.Types.DOUBLE

double