以下是通过仓库+物资来进行查询
@Select("<script>" + "SELECT v.id,v.kfcode,v.kfname,v.kc, p.wzname,p.dw,v.wzgg" + " FROM (select * from y_kc" + " where softdel=0" + "<if test=\"kfcode!=null and kfcode!=''\">" + " and kfcode=#{kfcode}" + "</if>" + "<if test='wzbm!=null'>" + " and wzbm like concat('%',#{wzbm},'%') " + "</if>" + ") v inner join wz p" + " on v.wzbm=p.wzbm" + " order by v.wzbm asc" + "</script>") Page<Kc> getKcswithWz(IPage<Kc> page, @Param("wzbm") String wzbm, @Param("kfcode") String kfcode);
上面是使用转义符来进行进行是不是等于‘’来判断。
标签:kc,判断,String,多个,kfcode,Param,wzbm,mybatis From: https://www.cnblogs.com/jiduoduo/p/17842281.html