@Override public ArrayList<User> getAll(int limit, int offset) { ArrayList<User> result = new ArrayList<>(); String sql = "select * from user limit ? offset ?"; Connection con = new ConnectionPool().getConnection(); PreparedStatement ps; try { ps = con.prepareStatement(sql); ps = con.prepareStatement("select * from user limit ? offset ?"); ps.setInt(1, limit); ps.setInt(2, offset); ResultSet rs = ps.executeQuery(); while (rs.next()) { User user = new User(); user.setIdUser(rs.getString("idUser")); user.setFullName(rs.getString("fullName")); user.setEmail(rs.getString("email")); user.setUserName(rs.getString("userName")); user.setPhone(rs.getString("phone")); user.setAddress(rs.getString("address")); user.setImg(rs.getString("img")); user.setActive(rs.getInt("active")); result.add(user); } rs.close(); } catch (SQLException e) { e.printStackTrace(); } return result; }