Mybatis参数是一个对象，对象中含有Date[ ]数组，如何按照索引获取值

左手的ㄟ右手 2024-04-08 10:50 53阅读 0赞

> 很多表单查询都会按照时间区间查询，这个时候前端是固定传入长度为2的时间数组参数。后端如果分成2个参数去接受，就显得很麻烦，直接用数组接受会方便很多，但是有坑。

#### 一、在做时间区间查询的时候，前端固定传一个长度为2的时间数组参数。 ####

#### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NjQ4MDI5_size_16_color_FFFFFF_t_70][] ####

#### 二、后端实体类中，用这样的形式接收。 ####

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NjQ4MDI5_size_16_color_FFFFFF_t_70 1][]

#### 三、如果像这样直接按照索引获取，会报错 ####

<if test="checkTimeArray != null and checkTimeArray.length == 2">
         AND  DATE_FORMAT(a.check_time,'%Y-%m-%d') BETWEEN DATE_FORMAT(#{checkTimeArray[0]},'%Y-%m-%d') AND DATE_FORMAT(#{checkTimeArray[1]},'%Y-%m-%d')
     </if>
    
    ### Error querying database.  Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property 'checkTimeArray[0]'. It was either not specified and/or could not be found for the javaType ([Ljava.util.Date;) : jdbcType (null) combination.
    ### Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property 'checkTimeArray[0]'. It was either not specified and/or could not be found for the javaType ([Ljava.util.Date;) : jdbcType (null) combination.

#### 四、只需要在参数后面加上javaType和jdbcType就好了。如 ####

\#\{checkTimeArray\[0\],javaType=java.util.Date,jdbcType=TIMESTAMP\}

<if test="checkTimeArray != null and checkTimeArray.length == 2">
         AND  DATE_FORMAT(a.check_time,'%Y-%m-%d') BETWEEN DATE_FORMAT(#{checkTimeArray[0],javaType=java.util.Date,jdbcType=TIMESTAMP},'%Y-%m-%d') AND DATE_FORMAT(#{checkTimeArray[1],javaType=java.util.Date,jdbcType=TIMESTAMP},'%Y-%m-%d')
    </if>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NjQ4MDI5_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/c59fe7b7ba964676a1c288e1abfa7421.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NjQ4MDI5_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/82350c54cf7e4baa82221ae856266c9e.png