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.