java实体类型与数据库类型对应关系
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
java.sql.
Ty p e s 值Java 类型
IBM DB
2
Oracle Sybase SQL Informix IBM Content Manager
BIGINT ng.long BIGINT NUMB
ER (3
8, 0)
BIGINT BIGINT INT8 DK_CM_BIGINT
BINARY byte[] CHAR F
OR BIT
DATA
RAW BINARY IMAGE BYTE DK_CM_BLOB
BIT ng.Boole
an
N/A BIT BIT BIT BIT DK_CM_SMALLINT
BLOB byte[] BLOB BLOB BLOB BLOB BLOB DK_CM_BLOB
CHAR ng.String CHAR,
GRAPHI
C
CHAR CHAR CHAR CHAR DK_CM_CHAR
CLOB ng.String C L OB,
DBCLOB
CLOB CLOB CLOB CLOB DK_CM_CLOB
DATE java.sql.Date DATE DATE DATE DATE DATE DK_CM_DATE
D E C I M AL java.math.BigD
ecimal
DECIMA
L
NUMB
ER
DECIMA
L, MON
EY, SM
A L L M O
NEY
D E C I M
AL
DECIMA
L
DK_CM_DECIMAL
DOUBL E ng.Doubl
e
DOUBLE
DOUB
LE PR
E C I S I
ON
DOUBL
E P R E
CISION
DOUBL
E P R E
CISION
DOUBLE
PRECIS
ION
DK_CM_DOUBLE
FLOAT ng.Doubl
e
FLOAT FLOAT FLOAT FLOAT FLOAT DK_CM_DOUBLE
INTEGE R ng.Intege
r
INTEGE
R
INTEG
ER
INT
INTEGE
R
INTEGE
R
DK_CM_INTEGER
JAVA_O BJECT ng.Object
JAVA_O
BJECT
JAVA_
O B J E
CT
JAVA_O
BJECT
JAVA_O
BJECT
OPAQUE N/A
LONGV
ARBINA RY byte[]
LONG V
A R C H A
R FOR
BIT DAT
A
LONG
RAW
IMAGE IMAGE BYTE DK_CM_BLOB
LONGV
ARCHA R ng.String
LONG V
A R C H A
R, L ON
G VARG
RAPHIC
LONG TEXT TEXT TEXT
DK_CM_VARCHAR(350
0)
NUMER IC java.math.BigD
ecimal
NUMERI
C
NUMB
ER
NUMER
IC
NUMER
IC
NUMERI
C
DK_CM_DECIMAL
OTHER ng.Object OTHER O T H E
R
OTHER OTHER OTHER N/A
REAL ng.Float REAL REAL REAL REAL REAL DK_CM_DOUBLE
SMALLI NT ng.Intege
r
S M AL L I
NT
S M A L
LINT
SMALLI
NT
SMALLI
NT
S M A L L I
NT
DK_CM_INTEGER
TIME java.sql.Time TIME DATE TIME TIME D AT E T I
ME HOU
R TO S
ECOND
DK_CM_TIME
TIMEST AMP java.sql.Timesta
mp
TIMEST
AMP
DATE
DATETI
ME, SM
ALLDAT
ETIME
DATETI
ME
D AT
E T I
ME YEA
R TO F
RACTIO
N (5)
DK_CM_TIMESTAMP
TINYIN T ng.Bute
S M AL L I
NT
TI
NYINT
TIN
YINT
TINYIN
T
TINYINT DK_CM_INTEGER
VARBIN ARY byte[]
VARCHA
R FOR
BIT DAT
A
RAW
VARBIN
ARY
IMAGE BYTE DK_CM_BLOB
VARCH AR ng.String
VARCHA
R,VA R
GRAPHI
C
VA R C
HAR
VARCH
AR
VARCH
AR
VARCHAR