Caused by: org.apache.ibatis.binding.BindingException: Parameter ‘name‘ not found. Available paramet

一、问题描述

1. 条件查询的时候出现问题：Caused by: org.apache.ibatis.binding.BindingException: Parameter ‘name’ not found. Available parameters are [arg3, arg2, arg1, arg0, param3, param4, param1, param2]

1、演示根据条件查询

（1）SQL语句

select * from emp where name like'%张%' and gender='' and entrydate between '' and '' order by update_time desc;

（2）Mapper接口

//条件查询
    @Select("select * from emp where name like concat('%',#{name},'%') and gender=#{gender} and " +
            "entrydate between #{begin}  and #{end}  order by update_time desc")
    public List<Emp> list( String name,  Short gender, LocalDate begin, LocalDate end);

（3）测试

@Test
public void testList(){
List list = empMapper.list(“张”, (short) 1, LocalDate.of(2010, 1, 1), LocalDate.of(2020, 1, 1));
System.out.println(list);
}

二、解决方法

1、修改mapper接口中的代码

1. 不知道为什么使用的是2.X也需要加@Param注解，反正加上之后就正常了

//条件查询
    @Select("select * from emp where name like concat('%',#{name},'%') and gender=#{gender} and " +
            "entrydate between #{begin}  and #{end}  order by update_time desc")
    public List<Emp> list(@Param("name") String name, @Param("gender") Short gender, @Param("begin") LocalDate begin, @Param("end") LocalDate end);