mybaits返回List

  • Post author:
  • Post category:其他



如下:

<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 版权协议,转载请附上原文出处链接和本声明。