如下:
<select id="GetNormalOrderIdListByOrderList" resultType="java.lang.String" parameterType="java.util.Map">
select t.order_id from order_unusual_header t
where t.isbarcode_error=0 and t.isaddress_error=0 and t.tenant_id=${tenantId}
<if test="orderList != null and orderList.size > 0">
and t.order_id in
<foreach collection="orderList" open="(" separator="," close=")" item="order">
#{order,jdbcType=VARCHAR}
</foreach>
</if>
</select>
返回类型设置为String,即可:
resultType="java.lang.String"
版权声明:本文为w2ndong原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。