public RiderModel getOneRider(String id)
throws SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException,
ParseException {
ResultSet result = DB.getResultSet("SELECT * FROM riders WHERE riders.id = " + id + ";");
RiderModel rider = this.fillModel(result).get(0);
DB.closeCon();
return rider;
}
public List<RiderModel> getRiderByCount(String id, String count)
throws SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException,
ParseException {
ResultSet result =
DB.getResultSet(
"select * from riders where id != " + id + " order by id desc limit " + count + ";");
List<RiderModel> riderList = new LinkedList<>();
while (result.next()) {
RiderModel temp = new RiderModel();
temp.setId(result.getInt("id"));
temp.setText(result.getString("text"));
riderList.add(temp);
}
DB.closeCon();
return riderList;
}