mybatis，的mapper中这样写，为啥报错？

Question

   <select id="get_cases" resultType="News" >
        SELECT * FROM `case` WHERE state=0 and `type`=#{type}
        order by create_time desc limit #{num}
        
    </select>

org.apache.ibatis.binding.BindingException: Parameter 'type' not found. Available parameters are [1, 0, param1, param2]

Answer 1

你可以看看你的Mapper的接口定义中方法，是否通过@Param("type")设置参数名？