code: public static <E extends Exception> int importData(final DataSet dataset, final int offset, final int count,
              final Try.Predicate<? super Object[], E> filter, final Connection conn, final String insertSQL, final int batchSize, final int batchInterval,
              final Try.BiConsumer<? super PreparedStatement, ? super Object[], SQLException> stmtSetter) throws UncheckedSQLException, E {
          PreparedStatement stmt = null;
  
          try {
              stmt = prepareStatement(conn, insertSQL);
  
              return importData(dataset, offset, count, filter, stmt, batchSize, batchInterval, stmtSetter);
          } catch (SQLException e) {
              throw new UncheckedSQLException(e);
          } finally {
              JdbcUtil.closeQuietly(stmt);
          }
      }
docs: Imports the data from <code>DataSet</code> to database.
  
  @param dataset
  @param offset
  @param count
  @param filter
  @param conn
  @param insertSQL the column order in the sql must be consistent with the column order in the DataSet. Here is sample about how to create the sql:
  <pre><code>
  List<String> columnNameList = new ArrayList<>(dataset.columnNameList());
  columnNameList.retainAll(yourSelectColumnNames);
  String sql = RE.insert(columnNameList).into(tableName).sql();
  </code></pre>
  @param batchSize
  @param batchInterval
  @param stmtSetter
  @return
  @throws UncheckedSQLException