mybatis @select注解中使用 in list 参数查询的写法 - 好文

@Select({ "<script>",
"SELECT * FROM (SELECT A.*, ROWNUM RN FROM (",
"<![CDATA[select pk_flow,cfirstbillbid,cfirstbillhid,vfirstbillcode,vsourcebillcode,vbillcode,vheaduserdef2,dbizdate,cbilltypecode,cmaterialvid,cwarehouseid,ninnum,noutnum,nshouldinnum,nshouldoutnum,vfree1,vfree2 from ic_flow where pk_org = #{pkOrg, jdbcType=VARCHAR} and dbizdate >= #{startDate, jdbcType=VARCHAR} and dbizdate <= #{endDate, jdbcType=VARCHAR}]]>",
"<if test='billCode!=null and billCode!=\"\"'> and vbillcode=#{billCode, jdbcType=VARCHAR}</if>",
"<if test='firstBillCode!=null and firstBillCode!=\"\"'> and vfirstbillcode=#{firstBillCode, jdbcType=VARCHAR}</if>",
"<if test='billTypeCode!=null and billTypeCode!=\"\"'> and cbilltypecode=#{billTypeCode, jdbcType=VARCHAR}</if>",
"<if test='warehouseIds!=null and warehouseIds.size>0'> and cwarehouseid in <foreach collection='warehouseIds' item='item' open='(' separator=',' close=')'>#{item}</foreach></if>",
" order by dbizdate",
"<![CDATA[) A WHERE ROWNUM <= #{endNum, jdbcType=INTEGER} ) WHERE RN >= #{startNum, jdbcType=INTEGER}]]>",
"</script>"})
public List<NCICFlowVO> getICFlows(@Param("pkOrg")String pkOrg,@Param("startDate")String startDate,@Param("endDate")String endDate,@Param("startNum")Integer startNum,@Param("endNum")Integer endNum,@Param("billCode")String billCode,@Param("firstBillCode")String firstBillCode,@Param("billTypeCode")String billTypeCode,@Param("warehouseIds")List<String> warehouseIds);

热门工具换一换