最开始使用#{ },出现 Parameter index out of range (2 > number of parameters, which is 1) 错误,原因是因为,#{ } 带单引号,${ } 不带单引号,将#换成$即可解决
//模糊查询对象列表
@Select("SELECT * FROM member WHERE ${search_option} LIKE '%" + "${search_key}" + "%'")
List<Member> getMemberListByKey(@Param("search_option")String searchOption,@Param("search_key")String searchKey);