Sql中的类型 | Java注解 | Java类型 | 备注 |
VARCHAR(32) | VARCHAR | String |
|
NUMERIC(12), | INTEGER | long/double/Integer/String | NUMERIC(12), |
TIMESTAMP | TIMESTAMP、DATE | Date |
|
JSON | StringJsonObject | String | 注解要用@Type |
TEXT |
LONGVARCHAR | String |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
某些类型使用方法说明:
NUMERIC(12),
NUMERIC(12,2), :总共12位,小数点两位
用法说明:
type VARCHAR(100), data JSON,
@Column(name = "type") private String type;
@Column(name ="deploy_status", columnDefinition ="VARCHAR")
private StringdeployStatus;
动态字段比较特殊
@Column(name = "data") @Type(type = "StringJsonObject") private String data;
java注解中TIMESTAMP、DATE区别
目前看没区别:
@Column(name = "created_time", columnDefinition = "TIMESTAMP",updatable=false)