mybatis 动态sql之if接参是字符串 +swagger（丝袜哥）怎么往后端传null

点击关注即可查看，对博主不感兴趣，看完之后即可取消关注。

    <select id="selectContractManagementOneDesigns" resultType="com.cmtt.atom.pmis.beans.ContractAndDesignDo">select m.id,m.contract_id as contractId,m.contract_name as contractName,d.status ,m.create_type ascreateType,m.start_date as startDate,m.end_date as endDatefrom gj_contract_management mJOIN gj_contract_design d on m.id = d.contract_id wher<if test='contractId !=null and contractId!=" "'>and m.contract_id like CONCAT('%',#{contractId},'%')</if><if test='contractName !=null and contractName != " "'>and m.contract_name like CONCAT('%',#{contractName},'%')</if><if test='status !=null and status!= " " '>and d.status = #{status}</if></select>

    <if test='contractId !=null and contractId!=" "'>and m.contract_id like CONCAT('%',#{contractId},'%')</if>

仔细看test 后面的写法 test='contractId !=null and contractId!=" " ’

第二 看contractId!="有空格"有空格’

这样就可以映射到 ，前端传过来的 空串 如图：
丝袜哥：

后端 断点调试