fix 修复 insertAll sql拼接无主键问题

疯狂的狮子li

2021-06-21 f48d708e2846e8730c81577e6233bce5e44e28f0

 ruoyi-common/src/main/java/com/ruoyi/common/core/mybatisplus/methods/InsertAll.java

@@ -1,5 +1,6 @@
package com.ruoyi.common.core.mybatisplus.methods;

import cn.hutool.core.util.StrUtil;
import org.apache.ibatis.executor.keygen.NoKeyGenerator;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.SqlSource;
@@ -26,7 +27,9 @@

   private String prepareFieldSql(TableInfo tableInfo) {
      StringBuilder fieldSql = new StringBuilder();
      fieldSql.append(tableInfo.getKeyColumn()).append(",");
      if (StrUtil.isNotBlank(tableInfo.getKeyColumn())) {
         fieldSql.append(tableInfo.getKeyColumn()).append(",");
      }
      tableInfo.getFieldList().forEach(x -> fieldSql.append(x.getColumn()).append(","));
      fieldSql.delete(fieldSql.length() - 1, fieldSql.length());
      fieldSql.insert(0, "(");
@@ -37,7 +40,9 @@
   private String prepareValuesSqlForMysqlBatch(TableInfo tableInfo) {
      final StringBuilder valueSql = new StringBuilder();
      valueSql.append("<foreach collection=\"list\" item=\"item\" index=\"index\" open=\"(\" separator=\"),(\" close=\")\">");
      valueSql.append("#{item.").append(tableInfo.getKeyProperty()).append("},");
      if (StrUtil.isNotBlank(tableInfo.getKeyColumn())) {
         valueSql.append("#{item.").append(tableInfo.getKeyProperty()).append("},");
      }
      tableInfo.getFieldList().forEach(x -> valueSql.append("#{item.").append(x.getProperty()).append("},"));
      valueSql.delete(valueSql.length() - 1, valueSql.length());
      valueSql.append("</foreach>");