@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;
}
