import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.ztools.annotation.BeanTable;
import com.ztools.annotation.BeanTableField;
public class GenerateBatchInsertSQL {
// bean 转为 insert into table() values();
// 需要分批处理
public enum SQL {sql, values}
private static final int BATCH_SIZE = 100;// 每100条数据组成一条插入数据
private static int count = 0;
private static final List<String> properties = new ArrayList<>();// 存储bean属性列表
private static final Map<String, Method> methodMap = new HashMap<>();
// 数据很多时用,分批次处理,每批次100条
public static <T> List<Map<SQL, Object>> largeBatchInsertSQL(Class<T> beanClass, List<T> beans) {
List<Map<SQL, Object>> res = new ArrayList<>();
if (beans == null || beans.size() == 0) {
return
拼接SQL-批量插入语句
于 2024-05-17 00:08:56 首次发布