mybatils批量更改和批量保存

最新推荐文章于 2024-05-28 17:13:03 发布

原创最新推荐文章于 2024-05-28 17:13:03 发布 · 717 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

93 篇文章

订阅专栏

本文介绍了一种批量更新数据库中政策引用次数的方法及批量保存用户与政策关系的策略，通过MyBatis的动态SQL实现高效的数据处理。

1.批量更改

@Update("<script>" +
    "UPDATE POLICY SET REFERENCE_TIMES = REFERENCE_TIMES +" +
    "  <foreach collection=\"map.entrySet()\" item=\"value\" index=\"key\" separator=\" \" open=\"case POLICY_ID\" close=\"end\">" +
    "    WHEN #{key} THEN #{value}" +
    "  </foreach>" +
    "  WHERE POLICY_ID IN" +
    "  <foreach collection=\"map.entrySet()\" index=\"key\" item=\"value\" separator=\",\" open=\"(\" close=\")\">" +
    "    #{key}" +
    "  </foreach>" +
    "</script>")
int updatePolicyRefrenceTimes(@Param("map")Map<String, Integer> map);

2.批量保存

@Insert("<script>" +
    "INSERT INTO USER_POLICY_RELATIONSHIPS (" +
    "USER_ID,"+
    "POLICY_ID"+
    ") VALUES " +
    "<foreach collection=\"list\" item=\"item\" index=\"index\" separator=\",\" >" +
        "(#{item.userId}," +
        "#{item.policyId}"+
    ")" +
    "</foreach>" +
 "</script>")
int addUserPolicys(List<UserGroupPolicyRelation> userPolicyList);