sql type—java type数据关系 SQL Data Type JAVA Data Type bigint BIGINT binary BINARY bit BIT char CHAR datetime TIMESTAMP decimal ECIMAL float FLOAT image LONGVARBINARY int INTEGER money DECIMAL nchar CHAR ntext LONGVARCHAR numeric NUMERIC nvarchar VARCHAR real CODER-V 2023/03/04 2960 mybatis常...
private Long bigintColumn; private Float floatColumn; private Double doubleColumn; private BigDecimal decimalColumn; private String charColumn; private String varcharColumn; private Date dateColumn; private Date datetimeColumn; private Date timestampColumn; private String textColumn; // 省略 Get 、Set ...
Associated JDBC type can be specified by two means: Adding a jdbcType attribute to the typeHandler element (for example: jdbcType=”VARCHAR”). Adding a @MappedJdbcTypes annotation to your TypeHandler class specifying the list of JDBC types to associate it with. This annotation will be ignored i...
publicclassTypes{publicfinalstaticintTINYINT=-6;publicfinalstaticintSMALLINT=5;publicfinalstaticintINTEGER=4;} MyBatis包含的JdbcType类型,主要有下面这些,大致了解一下即可: BIT、FLOAT、CHAR 、TIMESTAMP 、 OTHER 、UNDEFINEDTINYINT 、REAL 、VARCHAR 、BINARY 、BLOB NVARCHAR、SMALLINT 、DOUBLE 、LONGVARCHAR...
VARCHAR 或任何兼容的字符串类型,用来存储枚举的名称(而不是索引序数值) EnumOrdinalTypeHandler Enumeration Type 任何兼容的 NUMERIC 或 DOUBLE 类型,用来存储枚举的序数值(而不是名称)。 SqlxmlTypeHandler java.lang.String SQLXML InstantTypeHandler java.time.Instant TIMESTAMP LocalDateTimeTypeHandler java.time.Loca...
LONG VARCHAR JdbcType NCHAR NCHAR JdbcType NCLOB NCLOB JdbcType NULL JdbcType NUMERIC NUMERIC/NUMBER NUMERIC/ JdbcType NVARCHAR JdbcType OTHER JdbcType REAL REAL REAL JdbcType SMALLINT SMALLINT SMALLINT JdbcType STRUCT JdbcType TIME TIME JdbcType TIMESTAMP TIMESTAMP TIMESTAMP/DATETIME JdbcType TINYINT TINY...