32333435363738394041
ResultSet result = statement.executeQuery(); while (result.next()) { bookings.add(getBookingFromResult(result)); } } catch (SQLException e) { throw new DAOException(); } return bookings; }
515253545556575859
707172737475767778
while (result.next()) { bookings.put(result.getInt("Week"), result.getFloat("Ratio")); } } catch (SQLException e) { e.printStackTrace(); throw new DAOException(); } return bookings; }
899091929394959697
115116117118119120121122123
booking.setResourceID(resourceID); booking.setWeek(week); return booking; } } catch (SQLException e) { throw new DAOException(); } return booking; }
190191192193194195196197198199
booking = getBookingFromResult(result); } else { throw new ResourceNotBookedException(); } } catch (SQLException e) { throw new DAOException(); } return booking; }
212213214215216217218219220221
234235236237238239240241242243
booking = getBookingFromResult(result); } else { throw new ProjectNotBookedException(); } } catch (SQLException e) { throw new DAOException(); } return booking; }
256257258259260261262263264265
298299300301302303304305306
} } } con.setAutoCommit(true); } catch (SQLException e1) { throw new DAOException(); } }