mybatis动态sql传参,当有些参数不作为必传条件的时候
mybatis的sql语句写法如下
<select id="policyList" resultMap="BaseResultMap2"
parameterType="com.mingya.invoicesystem.dto.Po_Cus_ProDto">
SELECT
<include refid="Base_Column_List" />
FROM
t2_plc_cust_file f,
t2_plc_p_policy p,
t2_plc_p_product pro
WHERE
f.filekey = p.hfilekey
AND f.filekey = pro.filekey
AND p.salercode = #{SALECODE}
AND f.certicode = #{CUSTOMER_IDNO}
<if test="_parameter != null" >
AND f.certitype = #{CUSTOMER_IDTYPE}
</if>
</select>
如果传入的
<if test="CUSTOMER_IDTYPE!= null" >
则报错!
错误是 There is no getter for property named 'certitype'