报错写法
interface如下:
List<ConfigureBusinessList> getConfigureBusinessList(int business_type);
Mapper如下:
<select id="getConfigureBusinessList" resultMap="configureBusinessList" >
SELECT business_type,business_main_key,business_main_table
FROM configure_business_type
WHERE 1=1
<if test="business_type!=0">
AND business_type=#{0}
</if>
;
</select>
更正后如下
List<ConfigureBusinessList> getConfigureBusinessList(@Param("business_type")int business_type);
<select id="getConfigureBusinessList" resultMap="configureBusinessList" >
SELECT business_type,business_main_key,business_main_table
FROM configure_business_type
WHERE 1=1
<if test="business_type!=0">
AND business_type=#{business_type}
</if>
;
</select>
Mybatis默认采用ONGL解析参数,所以会自动采用对象树的形式取 (封装类型)Integer.xxx 值,如果没在在方法中定义,则就会抛异常报错。