In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.