Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What are the common types in MyBatis

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >

Share

Shulou(Shulou.com)06/02 Report--

MyBatis what common types, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this to learn, I hope you can gain something.

1. Mybatis JdbcType and Oracle, MySql data type correspondence list MybatisJdbcTypeOracleMySqlJdbcTypeARRAY

JdbcTypeBIGINT

BIGINTJdbcTypeBINARY

JdbcTypeBIT

BITJdbcTypeBLOBBLOBBLOBJdbcTypeBOOLEAN

JdbcTypeCHARJdbcTypeCLOBCLOB-> modified to TEXTJdbcTypeCURSOR

JdbcTypeDATEDATEDATEJdbcTypeDECIMALDECIMALDECIMALJdbcTypeDOUBLENUMBERDOUBLEJdbcTypeFLOATFLOATFLOATJdbcTypeINTEGERINTEGERINTEGERJdbcTypeLONGVARBINARY

JdbcTypeLONGVARCHARLONG VARCHAR

JdbcTypeNCHARNCHAR

JdbcTypeNCLOBNCLOB

JdbcTypeNULL

JdbcTypeNUMERICNUMERIC/NUMBERNUMERIC/JdbcTypeNVARCHAR

JdbcTypeOTHER

JdbcTypeREALREALREALJdbcTypeSMALLINTSMALLINTSMALLINTJdbcTypeSTRUCT

JdbcTypeTIME

TIMEJdbcTypeTIMESTAMPTIMESTAMPTIMESTAMP/DATETIMEJdbcTypeTINYINT

TINYINTJdbcTypeUNDEFINED

JdbcTypeVARBINARY

JdbcTypeVARCHARVARCHARVARCHAR

Note that part of MyBatis JdbcType does not correspond to Oracle and Mysql data types (perhaps due to their own omissions), but do not worry, we will encounter specific analysis later; at the same time, the above correspondence is not necessarily one-to-one correspondence, please understand.

We mainly master the basic numbers, time, string is enough to deal with daily development.

2. Mybatis JdbcType official documentation

Mybatis JdbcType official documentation

3. JDBCTypeJavaTypeCHARStringVARCHARStringLONGVARCHARStringNUMERICjava.math. BigDecimalDECIMALjava. math. BigDecimalBIT booleanBOOLEANbooleanTINYINTbyteSMALLLINTshortINTEGERintBIGINTlongREALfloatdoubleDOUBLEdoubleBINARYbyte []VARBINARYbyte byte []LONGVARBINARYbyte []DATEjava.sql. DateTIMEjava. sql. TimeSTAMPjava. sql. TimestampCLOBClobBLOBBLOBARRAYArrayDISTINTCTmapping of underlying typeSTRUCTURE StructREFDATALINKjava. net.URL Is it helpful to read all of the above? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Internet Technology

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report