Mybatis in 的使用注意事项及报错

最新推荐文章于 2020-12-30 18:18:39 发布

weixin_33895016

最新推荐文章于 2020-12-30 18:18:39 发布

阅读量452

点赞数 1

文章标签： java python

原文链接：https://my.oschina.net/yZLZkvk6bjiN/blog/510983

版权

2019独角兽企业重金招聘Python工程师标准>>>

<select id="getPurchaseSkuLot" parameterType="java.lang.Long" resultMap="stockOrderSkuPurchaseResultMap">
	  SELECT
	  purchase_id,
	  order_id,
	  sku_id,
	  sku_lot
		FROM
		  stock_order_sku_purchase 
		WHERE order_id IN
	  <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
         #{item}
      </foreach>
  	</select>

item为空会报错形成in （）；的语句

修改以后

<select id="getPurchaseSkuLot" parameterType="java.lang.Long" resultMap="stockOrderSkuPurchaseResultMap">
	  SELECT
	  purchase_id,
	  order_id,
	  sku_id,
	  sku_lot
		FROM
		  stock_order_sku_purchase 
			where 1=1
			<if test="list != null and list.size>0">
				and order_id in
				<foreach item="item" index="id" collection="list" open="("separator="," close=")">
					#{item}
				</foreach>
			</if>
			<if test="list==null or list.size==0">and 1=0</if>
	</select>

但是报错Caused by: org.xml.sax.SAXParseException; lineNumber: 85; columnNumber: 63; Element type "foreach" must be followed by either attribute specifications, ">" or "/>".

后来发现