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
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