jdbcType类型:
数据库类型与JDBC TYPE 和Java类型对应关系
SQLDatatypes | JDBC Typecodes | Standard Java Types | Java取值范围 |
NUMBER | java.sql.Types.NUMERIC | java.math.BigDecimal | 无限制 |
NUMBER | java.sql.Types.DECIMAL | java.math.BigDecimal | 无限制 |
NUMBER | java.sql.Types.BIT | boolean | true,false |
NUMBER | java.sql.Types.TINYINT | byte | from –128 to 127 |
NUMBER | java.sql.Types.SMALLINT | short | from –32768 to 32767 |
NUMBER | java.sql.Types.INTEGER | int | From –2147483648 to 2147483647 |
NUMBER | java.sql.Types.BIGINT | long | From –9223372036854775808 to 9223372036854775807 |
NUMBER | java.sql.Types.REAL | float | From 1.4E-45 To 3.4028235E38 |
NUMBER | java.sql.Types.FLOAT | double | From 4.9E-324 to 1.7976931348623157E308 |
NUMBER | java.sql.Types.DOUBLE | double |