mybatis,sql 批量更新

<update id="update81OrderStatus" parameterType="java.util.Map">
    update 表名
　　set 字段名=#{code}
　　where sodoco in
　　<foreach item="item" index="index" collection="bigs"
　　open="(" separator="," close=")">
　　　#{item}
　　</foreach>
</update>

=====================dao

 void update81OrderStatus(Map<String,Object> param);

=====================service

List<BigDecimal> bigs=new ArrayList<BigDecimal>();
for (F554281 f554281 : findAll81Order) {
sodoco = f554281.getSodoco();
bigs.add(sodoco);
}

Map<String,Object> param = new HashMap<String,Object>();
param.put("code",1);
param.put("bigs",bigs);
f554281Mapper.update81OrderStatus(param);

mybatis,sql 批量更新

原文：http://www.cnblogs.com/21heshang/p/6245807.html