H2数据的字段类型与Java类型映射对应关系

最新推荐文章于 2023-02-11 13:38:31 发布

abckingaa

最新推荐文章于 2023-02-11 13:38:31 发布

阅读量973

点赞数 1

分类专栏： Bee ORM DB

本文链接：https://blog.csdn.net/abckingaa/article/details/108682480

版权

Bee 同时被 3 个专栏收录

290 篇文章 5 订阅

订阅专栏

ORM

205 篇文章 0 订阅

订阅专栏

127 篇文章 1 订阅

订阅专栏

INT | INTEGER | MEDIUMINT | INT4 | SIGNED
java.lang.Integer.

BOOLEAN | BIT | BOOL
java.lang.Boolean.

TINYINT
Possible values are: -128 to 127.

Mapped to java.lang.Byte.

SMALLINT | INT2 | YEAR
Possible values: -32768 to 32767.

Mapped to java.lang.Short.

BIGINT | INT8
Possible values: -9223372036854775808 to 9223372036854775807.

Mapped to java.lang.Long.
IDENTITY
Auto-Increment value. Possible values: -9223372036854775808 to 9223372036854775807.

Mapped to java.lang.Long.

{ DECIMAL | NUMBER | DEC | NUMERIC } ( precisionInt [ , scaleInt ] )
Data type with fixed precision and scale. This data type is recommended for storing currency values.

Mapped to java.math.BigDecimal.

{ DOUBLE [ PRECISION ] | FLOAT [ ( precisionInt ) ] | FLOAT8 }
A floating point number. Should not be used to represent currency values, because of rounding problems. If precision value is specified for FLOAT type name, it should be from 25 to 53.

Mapped to java.lang.Double.

{ REAL | FLOAT ( precisionInt ) | FLOAT4 }
A single precision floating point number. Should not be used to represent currency values, because of rounding problems. Precision value for FLOAT type name should be from 0 to 24.

Mapped to java.lang.Float.

TIME
TIME [ ( precisionInt ) ] [ WITHOUT TIME ZONE ]
The time data type. The format is hh:mm:ss[.nnnnnnnnn]. If fractional seconds precision is specified it should be from 0 to 9, 0 is default.

Mapped to java.sql.Time. When converted to a java.sql.Date, the date is set to 1970-01-01. java.time.LocalTime is also supported on Java 8 and later versions.

{ BINARY | VARBINARY | BINARY VARYING
| LONGVARBINARY | RAW | BYTEA }
[ ( precisionInt ) ]

Mapped to byte[].

OTHER
Mapped to java.lang.Object (or any subclass).

{ VARCHAR | CHARACTER VARYING | LONGVARCHAR | VARCHAR2 | NVARCHAR
| NVARCHAR2 | VARCHAR_CASESENSITIVE} [ ( precisionInt ) ]

VARCHAR_IGNORECASE [ ( precisionInt ) ]
{ CHAR | CHARACTER | NCHAR } [ ( precisionInt ) ]
Mapped to java.lang.String.

{ BLOB | BINARY LARGE OBJECT
| TINYBLOB | MEDIUMBLOB | LONGBLOB | IMAGE | OID }
[ ( precisionInt [K|M|G|T|P]) ]
Mapped to java.sql.Blob (java.io.InputStream is also supported).

{ CLOB | CHARACTER LARGE OBJECT
| TINYTEXT | TEXT | MEDIUMTEXT | LONGTEXT | NTEXT | NCLOB }
[ ( precisionInt [K|M|G|T|P] [CHARACTERS|OCTETS]) ]
Mapped to java.sql.Clob (java.io.Reader is also supported).

ARRAY
An array of values. Mapped to java.lang.Object[]

{ ENUM (string [, ... ]) }
A type with enumerated values. Mapped to java.lang.Integer.

GEOMETRY
[({ GEOMETRY |
{ POINT
| LINESTRING
| POLYGON
| MULTIPOINT
| MULTILINESTRING
| MULTIPOLYGON
| GEOMETRYCOLLECTION } [Z|M|ZM]}
[, sridInt] )]
Mapped to org.locationtech.jts.geom.Geometry if JTS library is in classpath and to java.lang.String otherwise.