bigint java 对应数据类型_JAVA与DB数据类型对照表

java.sql.Types

Java

IBM DB2

Oracle

Sybase

SQL-SERVER

BIGINT

java.lang.long

BIGINT

NUMBER

(38,

0)

BIGINT

BIGINT

BINARY

byte[]

CHAR

FOR

BIT

DATA

RAW

BINARY

IMAGE

BIT

java.lang.Boolean

N/A

BIT

BIT

BIT

BLOB

byte[]

BLOB

BLOB

BLOB

BLOB

CHAR

java.lang.String

CHAR,

GRAPHIC

CHAR

CHAR

CHAR

CLOB

java.lang.String

CLOB,

DBCLOB

CLOB

CLOB

CLOB

DATE

java.sql.Date

DATE

DATE

DATE

DATE

DECIMAL

java.math.BigDecimal

DECIMAL

NUMBER

DECIMAL,

MON

EY,

SMALLMO

NEY

DECIMAL

DOUBLE

java.lang.Double

DOUBLE

DOUBLE

PRECI

SION

DOUBLE

PREC

ISION

DOUBLE

PR

ECISION

FLOAT

java.lang.Double

FLOAT

FLOAT

FLOAT

FLOAT

INTEGER

java.lang.Integer

INTEGER

INTEGER

INT

INTEGER

JAVA_OBJECT

java.lang.Object

JAVA_OBJECT

JAVA_OBJECT

JAVA_OBJECT

JAVA_OBJEC

T

LONGVARBINAR

Y

byte[]

LONG

VARCHAR

FOR

BIT

DATA

LONG

RAW

IMAGE

IMAGE

LONGVARCHAR

java.lang.String

LONG

VARCHAR,

LONG

V

ARGRAPHIC

LONG

TEXT

TEXT

NUMERIC

java.math.BigDecimal

NUMERIC

NUMBER

NUMERIC

NUMERIC

OTHER

java.lang.Object

OTHER

OTHER

OTHER

OTHER

REAL

java.lang.Float

REAL

REAL

REAL

REAL

SMALLINT

java.lang.Integer

SMALLINT

SMALLINT

SMALLINT

SMALLINT

TIME

java.sql.Time

TIME

DATE

TIME

TIME

TIMESTAMP

java.sql.Timestamp

TIMESTAMP

DATE

DATETIME,

SM

ALLDATETIME

DATETIME

TINYINT

java.lang.Bute

SMALLINT

TINYINT

TINYINT

TINYINT

VARBINARY

byte[]

VARCHAR

FOR

BIT

DATA

RAW

VARBINARY

IMAGE

VARCHAR

java.lang.String

VARCHAR,

VARGRAPHIC

VARCHAR

VARCHAR

VARCHAR