private static void printPage()

in example/src/main/java/Pagination.java [10:38]


  private static void printPage(ResultSet res, int start, int count) throws SQLException {
    // 表头
    int columnCount = res.getMetaData().getColumnCount();
    for (int i = 0; i < columnCount; i++) {
      System.out.print(res.getMetaData().getColumnName(i + 1));
      if (i < columnCount - 1) {
        System.out.print(" | ");
      } else {
        System.out.print("\n");
      }
    }
    // 表内容
    res.absolute(start - 1);
    int c = 0;
    while (res.next()) {
      for (int i = 0; i < columnCount; i++) {
        System.out.print(res.getString(i + 1));
        if (i < columnCount - 1) {
          System.out.print(" | ");
        } else {
          System.out.print("\n");
        }
      }
      c++;
      if (c == count) {
        break;
      }
    }
  }