oracle decimal类型java类型与jdbc类型对应表
java.sql.Types 值Java 类型IBM DB2Oracle Sybase SQL Informix IBM Content Manager BIGINT java.lang.long BIGINT NUMBER (38,
0)
BIGINT BIGINT INT8DK_CM_BIGINT
BINARY byte[]CHAR FOR BIT
DATA
RAW BINARY IMAGE BYTE DK_CM_BLOB
BIT java.lang.Boolean N/A BIT BIT BIT BIT DK_CM_SMALLINT BLOB byte[]BLOB BLOB BLOB BLOB BLOB DK_CM_BLOB CHAR java.lang.String CHAR,
GRAPHIC
CHAR CHAR CHAR CHAR DK_CM_CHAR
CLOB java.lang.String CLOB,
DBCLOB
CLOB CLOB CLOB CLOB DK_CM_CLOB DATE java.sql.Date DATE DATE DATE DATE DATE DK_CM_DATE DECIMAL java.math.BigDecimal DECIMAL NUMBER DECIMAL,
MONEY,
SMALLMONEY
DECIMAL DECIMAL DK_CM_DECIMAL
DOUBLE java.lang.Double DOUBLE DOUBLE
PRECISION DOUBLE
PRECISION
DOUBLE
PRECISION
DOUBLE
PRECISION
DK_CM_DOUBLE
FLOAT java.lang.Double FLOAT FLOAT FLOAT FLOAT FLOAT DK_CM_DOUBLE INTEGER java.lang.Integer INTEGER INTEGER INT INTEGER INTEGER DK_CM_INTEGER JAVA_OBJECT java.lang.Object JAVA_OBJECT JAVA_OBJECT JAVA_OBJECT JAVA_OBJECT OPAQUE N/A LONGVARBINARY byte[]LONG
VARCHAR
FOR BIT DATA
LONG RAW IMAGE IMAGE BYTE DK_CM_BLOB
LONGVARCHAR java.lang.String LONG
VARCHAR,
LONG
VARGRAPHIC
LONG TEXT TEXT TEXT DK_CM_VARCHAR(3500)
NUMERIC java.math.BigDecimal NUMERIC NUMBER NUMERIC NUMERIC NUMERIC DK_CM_DECIMAL OTHER java.lang.Object OTHER OTHER OTHER OTHER OTHER N/A
REAL java.lang.Float REAL REAL REAL REAL REAL DK_CM_DOUBLE SMALLINT java.lang.Integer SMALLINT SMALLINT SMALLINT SMALLINT SMALLINT DK_CM_INTEGER
TIME java.sql.Time TIME DATE TIME TIME DATETIME
HOUR TO
SECOND
DK_CM_TIME
TIMESTAMP java.sql.Timestamp TIMESTAMP DATE DATETIME,
SMALLDATETIME DATETIME DATETIME
YEAR TO
FRACTION
(5)
DK_CM_TIMESTAMP
TINYINT java.lang.Bute SMALLINT TINYINT TINYINT TINYINT TINYINT DK_CM_INTEGER VARBINARY byte[]VARCHAR
FOR BIT DATA
RAW VARBINARY IMAGE BYTE DK_CM_BLOB
VARCHAR java.lang.String VARCHAR,
VARGRAPHIC
VARCHAR VARCHAR VARCHAR VARCHAR DK_CM_VARCHAR

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。