13. jdbc 类型映射

jdbc 系列文章列表, 请查看目录: 《jdbc学习笔记》

本文来源于: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-type-conversions.html

1. Mybsql&Jdbc&java 类型转换

Mysql 类型JDBC 类型ResultSetMetaData.GetColumnTypeName()java 类型ResultSetMetaData.GetColumnClassName()BIT(1) (new in MySQL-5.0)BITjava.lang.BooleanBIT( > 1) (new in MySQL-5.0)BIT byte[]TINYINTTINYINTjava.lang.Boolean, 设置1为true, 否则返回falseBOOL, BOOLEANTINYINT当前版本相当于TINYINT的别名SMALLINT[(M)] [UNSIGNED]SMALLINT [UNSIGNED]java.lang.IntegerMEDIUMINT[(M)] [UNSIGNED]MEDIUMINT [UNSIGNED]java.lang.IntegerINT,INTEGER[(M)] [UNSIGNED]INTEGER [UNSIGNED]java.lang.Integer, 如果是无符号的UNSIGNED java.lang.LongBIGINT[(M)] [UNSIGNED]BIGINT [UNSIGNED]java.lang.Long, 如果是无符号的UNSIGNED java.math.BigIntegerFLOAT[(M,D)]FLOATjava.lang.FloatDOUBLE[(M,B)]DOUBLEjava.lang.DoubleDECIMAL[(M[,D])]DECIMALjava.math.BigDecimalDATEDATEjava.sql.DateDATETIMEDATETIMEjava.sql.TimestampTIMESTAMP[(M)]TIMESTAMPjava.sql.TimestampTIMETIMEjava.sql.TimeYEAR[(24)]YEARCHAR(M)CHARjava.lang.StringVARCHAR(M) [BINARY]VARCHARjava.lang.StringBINARY(M)BINARYbyte[]VARBINARY(M)VARBINARYbyte[]TINYBLOBTINYBLOBbyte[]TINYTEXTVARCHARjava.lang.StringBLOBBLOBbyte[]TEXTVARCHARjava.lang.StringMEDIUMBLOBMEDIUMBLOBbyte[]MEDIUMTEXTVARCHARjava.lang.StringLONGBLOBLONGBLOBbyte[]LONGTEXTVARCHARjava.lang.StringENUM(‘value1’,‘value2’,…)CHARjava.lang.StringSET(‘value1’,‘value2’,…)CHARjava.lang.String

2. Mysql 自动类型转换

mysql类型可转换java 类型CHAR, VARCHAR, BLOB, TEXT, ENUM, and SETjava.lang.String, java.io.InputStream, java.io.Reader, java.sql.Blob, java.sql.ClobFLOAT, REAL, DOUBLE PRECISION, NUMERIC, DECIMAL, TINYINT, SMALLINT, MEDIUMINT, INTEGER, BIGINTjava.lang.String, java.lang.Short, java.lang.Integer, java.lang.Long, java.lang.Double, java.math.BigDecimalDATE, TIME, DATETIME, TIMESTAMPjava.lang.String, java.sql.Date, java.sql.Timestamp