java 批量更新方法

最新推荐文章于 2024-08-05 02:38:14 发布

yangyw.

最新推荐文章于 2024-08-05 02:38:14 发布

阅读量1.2k

点赞数

文章标签： java 批量更新

本文链接：https://blog.csdn.net/qq_41564405/article/details/103584353

版权

public Boolean batchOperationPublic(List<String> rule, String tableName, List<Map<String, Object>> allData) throws Exception {
        //rule 更新的条件字段
        //tableName 更新的表名
        //allData结果集
        //取结果集的第一条数据的字段
        Set<String> allColum = allData.get(0).keySet();
        //取条件字段和第一条数据的字段的差集
        List<String> updateColumns = (List<String>) CollectionUtils.subtract(allColum, rule);
        //拼接sql
        String q = "";
        for (String uColum : updateColumns) {
            q = q + "`" + uColum + "` =case ";
            for (Map<String, Object> data : allData) {
                q = q + " when ";
                Integer i = 0;
                for (String item : rule) {
                    if (i == 0) {
                        q = q + item + "= '" + data.get(item) + "' ";
                    } else {
                        q = q + " and " + item + "= '" + data.get(item) + "' ";
                    }
                    i++;
                }
                if (data.get(uColum) != null) {
                    q = q + " then '" + data.get(uColum) + "' ";
                } else {
                    q = q + " then null ";
                }
            }
            q = q + " else `" + uColum + "` end, ";
        }
        q = q.substring(0, q.length() - 2);
        try {
            batchOperationDao.updateBatchByColumns(tableName, q);
            return true;
        } catch (ParseException e) {
            return false;
        }