Mybatis常用jdbcType记录

深碍√TFBOYSˉ_ 2023-08-17 15:38 96阅读 0赞

### 前言： ###

Java 常用的数据类型： [https://blog.csdn.net/zhangyong01245/article/details/101310236][https_blog.csdn.net_zhangyong01245_article_details_101310236]

Mysql 常用的数据类型： [https://blog.csdn.net/zhangyong01245/article/details/101157289][https_blog.csdn.net_zhangyong01245_article_details_101157289]

#### 常用数据类型表： ####

<table> 
 <thead> 
  <tr> 
   <th>Mysql</th> 
   <th>jdbcType</th> 
   <th>Java</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>tinyint</td> 
   <td>TINYINT</td> 
   <td>Integer</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>INTEGER</td> 
   <td>Integer</td> 
  </tr> 
  <tr> 
   <td>integer</td> 
   <td>INTEGER</td> 
   <td>Integer</td> 
  </tr> 
  <tr> 
   <td>bigint</td> 
   <td>BIGINT</td> 
   <td>Long</td> 
  </tr> 
  <tr> 
   <td>float</td> 
   <td>FLOAT</td> 
   <td>Float</td> 
  </tr> 
  <tr> 
   <td>double</td> 
   <td>DOUBLE</td> 
   <td>Double</td> 
  </tr> 
  <tr> 
   <td>decimal</td> 
   <td>DECIMAL</td> 
   <td>BigDecimal</td> 
  </tr> 
  <tr> 
   <td>char</td> 
   <td>CHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>varchar</td> 
   <td>VARCHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>varchar</td> 
   <td>VARCHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>datetime</td> 
   <td>TIMESTAMP</td> 
   <td>Date</td> 
  </tr> 
  <tr> 
   <td>timestamp</td> 
   <td>TIMESTAMP</td> 
   <td>Date</td> 
  </tr> 
 </tbody> 
</table>

在接受 Mysql 的结果类型也不是一定的，大类型可以接受小类型，高精度也接受低精度的 。

#### 示例演示： ####

创建一张表 tb\_example：

CREATE TABLE `tb_example` (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
      `tinyint_column` tinyint(4) NOT NULL COMMENT 'tinyint',
      `int_column` int(11) NOT NULL COMMENT 'int',
      `integer_column` int(11) NOT NULL COMMENT 'integer',
      `bigint_column` bigint(20) NOT NULL COMMENT 'bigint',
      `float_column` float(5,2) NOT NULL COMMENT 'float',
      `double_column` double(5,1) NOT NULL COMMENT 'double',
      `decimal_column` decimal(2,1) NOT NULL COMMENT 'decimal',
      `char_column` char(1) NOT NULL COMMENT 'char',
      `varchar_column` varchar(10) NOT NULL COMMENT 'varchar',
      `text_column` text NOT NULL COMMENT 'text',
      `date_column` date NOT NULL COMMENT 'date',
      `datetime_column` datetime NOT NULL COMMENT 'datetime',
      `timestamp_column` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'timestamp',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='测试例子表';

定义 Example：

public class Example  implements Serializable {
    
        private static final long serialVersionUID = 1L;
    
        private Integer id;
    
        private Byte tinyintColumn;
    
        private Integer intColumn;
    
        private Integer integerColumn;
    
        private Long bigintColumn;
    
        private Float floatColumn;
    
        private Double doubleColumn;
    
        private BigDecimal decimalColumn;
    
        private String charColumn;
    
        private String varcharColumn;
    
        private Date dateColumn;
    
        private Date datetimeColumn;
    
        private Date timestampColumn;
    
        private String textColumn;
    
    	//  省略 Get 、Set 方法
    
    }

ExampleMapper.xml 中 result Map 定义：

END !!!

[https_blog.csdn.net_zhangyong01245_article_details_101310236]: https://blog.csdn.net/zhangyong01245/article/details/101310236
[https_blog.csdn.net_zhangyong01245_article_details_101157289]: https://blog.csdn.net/zhangyong01245/article/details/101157289