How to use

generateLimitJumpToQuery

method

in

org.springframework.batch.item.database.support.SqlPagingQueryUtils

@Override
public String generateJumpToItemQuery(int itemIndex, int pageSize) {
  int page = itemIndex / pageSize;
  int offset = (page * pageSize) - 1;
  offset = offset<0 ? 0 : offset;
  String limitClause = new StringBuilder().append("LIMIT 1 OFFSET ").append(offset).toString();
  return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause);
}

@Override
public String generateJumpToItemQuery(int itemIndex, int pageSize) {
  int page = itemIndex / pageSize;
  int offset = (page * pageSize) - 1;
  offset = offset<0 ? 0 : offset;
  String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString();
  return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause);
}

@Override
public String generateJumpToItemQuery(int itemIndex, int pageSize) {
  int page = itemIndex / pageSize;
  int offset = (page * pageSize) - 1;
  offset = offset<0 ? 0 : offset;
  String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString();
  return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause);
}

@Test
public void testGenerateLimitJumpToQuery() {
  AbstractSqlPagingQueryProvider qp = new TestSqlPagingQueryProvider("FOO", "BAR", sortKeys);
  assertEquals("SELECT ID FROM BAR ORDER BY ID ASC LIMIT 100, 1", SqlPagingQueryUtils
      .generateLimitJumpToQuery(qp, "LIMIT 100, 1"));
  qp.setWhereClause("BAZ IS NOT NULL");
  assertEquals("SELECT ID FROM BAR WHERE BAZ IS NOT NULL ORDER BY ID ASC LIMIT 100, 1",
      SqlPagingQueryUtils.generateLimitJumpToQuery(qp, "LIMIT 100, 1"));
}

@Test
public void testGenerateLimitJumpQueryDescending() {
  sortKeys.put("ID", Order.DESCENDING);
  AbstractSqlPagingQueryProvider qp = new TestSqlPagingQueryProvider("FOO", "BAR", sortKeys);
  String query = SqlPagingQueryUtils.generateLimitJumpToQuery(qp, "LIMIT 100, 1");
  assertTrue("Wrong query: " + query, query.contains("ID DESC"));
  assertEquals("Wrong query: " + query, 0, StringUtils.countOccurrencesOf(query, "ASC"));
  assertEquals("Wrong query: " + query, 1, StringUtils.countOccurrencesOf(query, "DESC"));
  qp.setWhereClause("BAZ IS NOT NULL");
  assertTrue("Wrong query: " + query, query.contains("ID DESC"));
}

@Override
public String generateJumpToItemQuery(int itemIndex, int pageSize) {
  int page = itemIndex / pageSize;
  int offset = (page * pageSize) - 1;
  offset = offset<0 ? 0 : offset;
  String limitClause = new StringBuilder().append("LIMIT 1 OFFSET ").append(offset).toString();
  return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause);
}

@Override
public String generateJumpToItemQuery(int itemIndex, int pageSize) {
  int page = itemIndex / pageSize;
  int offset = (page * pageSize) - 1;
  offset = offset<0 ? 0 : offset;
  String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString();
  return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause);
}

@Override
public String generateJumpToItemQuery(int itemIndex, int pageSize) {
  int page = itemIndex / pageSize;
  int offset = (page * pageSize) - 1;
  offset = offset<0 ? 0 : offset;
  String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString();
  return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause);
}