Service
public void batchUpdateOrderGoodsPrinted(Integer[] rec_ids, ProductUser productUser) {
String userName = productUser.getUserName();
ArrayList<OrderGoodsProduct> al = new ArrayList<OrderGoodsProduct>();
for(int i = 0; i < rec_ids.length; i++) {
OrderGoodsProduct orderGoodsProduct = new OrderGoodsProduct();
orderGoodsProduct.setRecId(rec_ids[i]);
orderGoodsProduct.setUserName(userName);
al.add(orderGoodsProduct);
}
orderGoodsProductMapper.batchUpdateOrderGoodsPrinted(al);
}
xml
<update id="batchUpdateOrderGoodsPrinted" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" open="" close="" separator=";">
update order_goods_product
<set>
printed = 1,
real_quotas_new = goods_quotas_new,
real_pay_price=goods_pay_price,
user_name=${item.userName},
printedtime=unix_timestamp()
</set>
where id = ${item.recId}
</foreach>
</update>