tk.mybatis+oracle批量插入

最新推荐文章于 2024-07-24 14:08:06 发布

奔波儿灞与灞波儿奔-

最新推荐文章于 2024-07-24 14:08:06 发布

阅读量688

点赞数

文章标签： mybatis oracle 数据库

本文链接：https://blog.csdn.net/liaohuaheng/article/details/125790753

版权

  @InsertProvider(type = InsertOrUpdateListProvider.class, method = "dynamicSQL")
    int insertList(@Param("list")List<? extends T> list,@Param("seq") String seq);

public String insertList(MappedStatement ms) {
        Class entityClass = getEntityClass(ms);
        //开始拼sql
        StringBuilder sql = new StringBuilder();
        sql.append(SqlHelper.insertIntoTable(entityClass, tableName(entityClass)));
        sql.append(SqlHelper.insertColumns(entityClass, true, false, false));
        String sqlStr = sql.toString();
        sqlStr = sqlStr.replace("(", "(id,");
        sql = new StringBuilder();
        sql.append(sqlStr);
        sql.append(" select ${seq}, T.* from ( ");
        sql.append("<foreach collection=\"list\" item=\"record\" index=\"index\" separator=\"union all\" >");
        sql.append("select ");
        sql.append("<trim  suffixOverrides=\",\">");
        //获取全部列
        Set<EntityColumn> columnList = EntityHelper.getColumns(entityClass);
        for (EntityColumn column : columnList) {
            if (column.isInsertable()) {
                //出现类型com.microsoft.sqlserver.jdbc.SQLServerException: 操作数类型冲突: varbinary
                if (!"ID".equals(column.getColumn()) && !column.isId()) {
                    if (column.getJavaType() == Double.class) {
                        String record = column.getColumnHolder("record");
                        record = record.substring(0, record.length() - 1) + ",jdbcType=DECIMAL" + "}";
                        sql.append(record + ",");
                    } else {
                        sql.append(column.getColumnHolder("record") + ",");
                    }
                }
            }
        }
        sql.append("</trim>");
        sql.append(" from dual");
        sql.append("</foreach>");
        sql.append(" ) T");
        return sql.toString();
    }