Mybatis JdbcType与Oracle、MySql,javaType数据类型对应列表

2023-09-06 阅读 20 评论 0

摘要：Mybatis JdbcType与Oracle、MySql数据类型对应列表 MybatisJdbcTypeOracleMySqlJdbcTypeARRAYJdbcTypeBIGINTBIGINTJdbcTypeBINARYJdbcTypeBITBITJdbcTypeBLOBBLOBBLOBJdbcTypeBOOLEANJdbcTypeCHARCHARCHARJdbcTypeCLOBCLOBCLOBJdbcTypeCURSORJdbcTypeDATEDATEDATEJdbcTypeDE

Mybatis JdbcType与Oracle、MySql数据类型对应列表

Mybatis	JdbcType	Oracle	MySql
JdbcType	ARRAY
JdbcType	BIGINT		BIGINT
JdbcType	BINARY
JdbcType	BIT		BIT
JdbcType	BLOB	BLOB	BLOB
JdbcType	BOOLEAN
JdbcType	CHAR	CHAR	CHAR
JdbcType	CLOB	CLOB	CLOB
JdbcType	CURSOR
JdbcType	DATE	DATE	DATE
JdbcType	DECIMAL	DECIMAL	DECIMAL
JdbcType	DOUBLE	NUMBER	DOUBLE
JdbcType	FLOAT	FLOAT	FLOAT
JdbcType	INTEGER	INTEGER	INTEGER
JdbcType	LONGVARBINARY
JdbcType	LONGVARCHAR	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
JdbcType	TINYINT		TINYINT
JdbcType	UNDEFINED
JdbcType	VARBINARY
JdbcType	VARCHAR	VARCHAR	VARCHAR

Mybatis中javaType和jdbcType对应关系

JDBCType	JavaType
CHAR	String
VARCHAR	String
LONGVARCHAR	String
DECIMAL	java.math.BigDecimal
BIT	boolean
BOOLEAN	boolean
TINYINT	byte
SMALLINT	short
INTEGER	int
BIGINT	long
REAL	float
FLOAT	double
DOUBLE	double
BINARY	byte[]
VARBINARY	byte[]
LONGVARBINARY	byte[]
DATE	java.sql.Date
TIME	java.sql.Time
TIMESTAMP	java.sql.Timestamp
CLOB	Clob
BLOB	Blob
ARRAY	Array
DISTINCT	mapping of underlying type
STRUCT	Struct
REF	Ref
DATALINK	java.net.URL[color=red][/color]

摘自：
https://www.cnblogs.com/qingqing-919/p/9414863.html

原文链接：https://hbdhgg.com/2/8898.html

上一篇：redis主从复制和哨兵机制

下一篇：mysql 8 免安装版下载及配置

标签：oracle中number类型对应JAVA 基本数据类型对应的类 8大基本数据类型的范围 java基本数据类型长度 java简单数据类型元素类型为mapper的内容必须匹配 javasql 引用类型的数据类型

oracle中number类型对应JAVA

2023-09-15jdk的selector(1)
2023-09-06Mybatis JdbcType与Oracle、MySql,javaType数据类型对应列表

发表评论: