mybatis jdbc java 字段类型转换

在 spring mvc + mybatis + mysql

数据表

CREATE TABLE `test_jdbc_java_type` ( `id` int(11) NOT NULL, `_char` char(50) DEFAULT NULL, `_varchar` varchar(200) DEFAULT NULL, `_numeric` decimal(10,2) DEFAULT NULL, `_decimal` decimal(10,2) DEFAULT NULL, `_bit` bit(1) DEFAULT NULL, `_tinyint` tinyint(4) DEFAULT NULL, `_smallint` smallint(6) DEFAULT NULL, `_integer` int(11) DEFAULT NULL, `_bigint` bigint(20) DEFAULT NULL, `_real` double DEFAULT NULL, `_float` float DEFAULT NULL, `_double` double DEFAULT NULL, `_binary` binary(255) DEFAULT NULL, `_varbinary` varbinary(255) DEFAULT NULL, `_date` date DEFAULT NULL, `_time` time DEFAULT NULL, `_timestamp` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `_blob` blob, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 数据

INSERT INTO `test_jdbc_java_type` VALUES (1, 'char类型', 'varchar类型', 11.00, 22.00, '', 1, 1, 1, 1, 1, 1, 1, NULL, NULL, '2017-4-14', '11:17:43', '2017-4-14 11:17:33', NULL);

xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="com.hqpe.itm.dao.user.UserDao"> <select id="getData" resultType="Map"> SELECT (SELECT 1 ) _num ,1 _num2,t.* FROM `test_jdbc_java_type` t </select> </mapper>

java代码

package com.hqpe.itm.controller.account; import java.math.BigDecimal; import java.sql.Timestamp; import java.sql.Time; import java.util.Date; import java.util.List; import java.util.Map; import javax.annotation.Resource; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import com.hqpe.itm.dao.user.UserDao; @Controller @RequestMapping("/jdbcjava") public class TestJdbcJavaType { @Resource private UserDao userDao; @RequestMapping("test") public void test(Model model) { List<Map<String,Object>> list = userDao.getData(); for(Map<String,Object> map: list){ int id = (Integer)map.get("id"); long _num = (Long)map.get("_num"); long _num2 = (Long)map.get("_num2"); String _char= (String)map.get("_char"); String _varchar= (String)map.get("_varchar"); BigDecimal _numeric= (BigDecimal)map.get("_numeric"); BigDecimal _decimal= (BigDecimal)map.get("_decimal"); boolean _bit= (Boolean)map.get("_bit"); int _tinyint= (Integer)map.get("_tinyint"); int _smallint= (Integer)map.get("_smallint"); int _integer= (Integer)map.get("_integer"); long _bigint= (Long)map.get("_bigint"); double _real= (Double)map.get("_real"); float _float= (Float)map.get("_float"); double _double= (Double)map.get("_double"); //Byte[] _binary= (Byte[])map.get("_binary"); //Byte[] _varbinary= (Byte[])map.get("_varbinary"); Date _date= (Date)map.get("_date"); Time _time= (Time)map.get("_time"); Timestamp _timestamp= (Timestamp)map.get("_timestamp"); //Blob _blob= (Blob)map.get("_blob"); System.out.println(id); System.out.println(_num); System.out.println(_num2); System.out.println(_char); System.out.println(_varchar); System.out.println(_numeric); System.out.println(_decimal); System.out.println(_bit); System.out.println(_tinyint); System.out.println(_smallint); System.out.println(_integer); System.out.println(_bigint); System.out.println(_real); System.out.println(_float); System.out.println(_double); //System.out.println(_binary); //System.out.println(_varbinary); System.out.println(_date); System.out.println(_time); System.out.println(_timestamp); //System.out.println(_blob); System.out.println(); System.out.println(); System.out.println(); System.out.println(); System.out.println(); } } }