org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingExce

最新推荐文章于 2024-08-23 08:17:12 发布

心海非海_

最新推荐文章于 2024-08-23 08:17:12 发布

阅读量383

点赞数 1

分类专栏： # SpringBoot项目文章标签： mybatis

本文链接：https://blog.csdn.net/weixin_46644403/article/details/123834716

版权

SpringBoot项目专栏收录该内容

13 篇文章 2 订阅

订阅专栏

出错愿因：

传入的参数不是基本类型

原写法：

public interface ProductMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Product record);

    int insertSelective(Product record);

    Product selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Product record);

    int updateByPrimaryKey(Product record);

    List<Product> selectByCategoryIdSet(Set<Integer> categoryIdSet);
}

  <select id="selectByCategoryIdSet" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from mall_product
    where status = 1
    <if test="categoryIdSet != null">
      and category_id in
      <foreach collection="collection" item="item" index="index" open="(" separator="," close=")">
        #{item}
      </foreach>
    </if>
  </select>

正确写法

① ：@Param

public interface ProductMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Product record);

    int insertSelective(Product record);

    Product selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Product record);

    int updateByPrimaryKey(Product record);

    List<Product> selectByCategoryIdSet(@Param("categoryIdSet") Set<Integer> categoryIdSet);
}

②：改 Mapper

  <select id="selectByCategoryIdSet" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from mall_product
    where status = 1
    <if test="categoryIdSet != null">
      and category_id in
      <foreach collection="categoryIdSet" item="item" index="index" open="(" separator="," close=")">
        #{item}
      </foreach>
    </if>
  </select>