PrepZone Logo
PrepZone
Back to AI Coding

AI Coding · Medium

Customers report missing and repeated items when paging. Review the generated code.

AI CodingCode ReviewSenior

The API is 1-based (page=1 is the first page).

java
public List<Item> page(int page, int size) {
    int offset = page * size;
    return jdbcTemplate.query(
        "SELECT * FROM items LIMIT ? OFFSET ?",
        itemMapper, size, offset);
}