MyBatis使用foreach遍历

最新推荐文章于 2024-02-02 09:35:42 发布

清风随客

最新推荐文章于 2024-02-02 09:35:42 发布

阅读量819

点赞数

文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/qq_42892856/article/details/125500215

版权

1.MyBatis使用foreach遍历
Service：

   @Override
    public String updateShipmentProducts( List<ShipmentProduct> shipmentProducts) {
        orderMapper.insertShipmentProducts(shipmentProducts);
        return "null";
    }

Mapper：

void insertShipmentProducts(List<ShipmentProduct> shipmentProducts);

Xml：

    <delete id="insertShipmentProducts" parameterType="java.util.List">
        INSERT INTO user_order_shipment_pro (order_no, tracking_no, carrier, catalog_no, size, quantity, id_key)
        VALUES
        <foreach collection="list" open="(" separator="), (" close=")" index="index" item="shipmentProduct">
            #{shipmentProduct.orderNo}, #{shipmentProduct.trackingNo}, #{shipmentProduct.carrier}, #{shipmentProduct.catalogNo},
            #{shipmentProduct.size}, #{shipmentProduct.quantity}, #{shipmentProduct.IDkey}
        </foreach>
    </delete>

2.新增查询添加语句

 <insert id="insertUserIntegralByOrderNo">
        INSERT INTO user_integral(user_id, order_no, integral_change, start_date, end_date, `explain`)
        SELECT user_id, order_no, CONCAT('+',FLOOR(pay_money)) integral_change, NOW() start_date, DATE_ADD(NOW(), INTERVAL +1 year) end_date, '物流发货' as `explain`
        FROM user_order WHERE order_no = #{orderNo};
    </insert>

3.mybatis拼接函数：

       SELECT DISTINCT
            IFNULL( SUM( number ), 0 ) AS number,
            IFNULL( GROUP_CONCAT( CONCAT( city, ':', number ) SEPARATOR ',' ), 0 ) AS stock_info
        FROM
            product_inventory_price_info

结果：
在这里插入图片描述