List＜Map＞转sql的Insert语句

package com.cheche365.dictonary.datatrans.datatrans.until;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * @author sunyan
 * @date 2022/12/19 17:13
 * @description
 */
public class ObjectUntil {
    //插入数据 传进来需要插入数据库的Map类型和数据库表名
    public static String insertFromMap(List<Map<String,Object>> map, String tablename){

        //存入key的字符串数组
        ArrayList<Object> arrKey = new ArrayList<>();

        //拼接sql
        for (String key : map.get(0).keySet()) {
            arrKey.add(key);
        }

        StringBuffer strKey = new StringBuffer();
        //遍历存的key字符串数组拼接sql
        for (int j = 0; j < arrKey.size(); j++) {
            strKey.append(arrKey.get(j));
            if (j != arrKey.size() - 1) {//拼上","最后一个不拼
                strKey.append(",");
            }
        }

        String stringEntryKey = strKey.toString();

        StringBuilder sb = new StringBuilder();
        map.forEach(mapitem->{
            StringBuilder strVal = new StringBuilder();
            for (String keys : mapitem.keySet()) {
                //存入value的字符串数组
                ArrayList<Object> arrValue = new ArrayList<>();
                if(mapitem.get(keys) instanceof String){
                    mapitem.put(keys,((String) mapitem.get(keys)).replaceAll("\\\\","\\\\\\\\").replaceAll("\'","\\\\"+"\'"));
                }
                arrValue.add(mapitem.get(keys));
                //遍历存的value字符串数组拼接sql
                for (int j = 0; j < arrValue.size(); j++) {
                    if (null != arrValue.get(j) && !"".equals(arrValue.get(j))) {
                        strVal.append("'" + arrValue.get(j) + "'");//拼接单引号
                    } else if ("".equals(arrValue.get(j))) {
                        strVal.append("" + null + "");
                    } else {
                        strVal.append(arrValue.get(j));
                    }
                    strVal.append(",");

                }

            }
            String stringEntryVal = "("+strVal.substring(0,strVal.length()-1)+"),";
            sb.append(stringEntryVal);
        });

        //插入sql语句
        String sqlEntry = "INSERT INTO " + tablename + " (" + stringEntryKey + ") VALUES "+sb.substring(0,sb.length()-1)+";\n";
        //使用entityManager执行sql语句
        return sqlEntry;
    }

}