@Override
public Request getRequest(String id) {
logger.debug("Request Id: " + id);
Request request = null;
try {
selectRequestStatement.setString(1, id);
ResultSet rs = selectRequestStatement.executeQuery();
while (rs.next()) {
request = new Request();
request.setId(rs.getString("request_id"));
request.setOn(rs.getTimestamp("request_on"));
request.setOrders(rs.getInt("request_orders"));
request.setItems(rs.getInt("request_items"));
request.setDuration(rs.getLong("request_duration"));
}
} catch (SQLException e) {
logger.error(selectRequestStatement.toString());
logger.error(e.getMessage());
throw new RuntimeException(e);