349350351352353354355356357
} } } con.setAutoCommit(true); } catch (SQLException e1) { throw new DAOException(); } }
369370371372373374375376
return result.getFloat("sum"); } else { throw new BookingNotFoundException(); } } catch (SQLException e) { throw new DAOException(); } }
387388389390391392393394395
ResultSet result = statement.executeQuery(); while (result.next()) { bookings.add(getBookingFromResult(result)); } } catch (SQLException e) { throw new DAOException(); } return bookings; }
262728293031323334
group = getGroupFromResult(result); } else { throw new GroupNotFoundException(); } } catch (SQLException e) { throw new DAOException(); } return group; }
464748495051525354
8788899091929394
PreparedStatement statement = JdbcConnection.getConnection() .prepareStatement(command); statement.setInt(1, group.getGroupID()); statement.executeUpdate(); } catch (SQLException e) { throw new DAOException(); } }
109110111112113114115116117
ResultSet result = statement.executeQuery(); while (result.next()) { groups.add(getGroupFromResult(result)); } } catch (SQLException e) { throw new DAOException(); } return groups; }
282930313233343536
request = getRequestFromResult(result); } else { throw new RequestNotFoundException(); } } catch (SQLException e) { throw new DAOException(); } return request; }
ResultSet result = statement.executeQuery(); while (result.next()) { requests.add(getRequestFromResult(result)); } } catch (SQLException e) { throw new DAOException(); } return requests; }
116117118119120121122123124125
} catch (SQLException e) { try { con.setAutoCommit(true); } catch (SQLException e1) { throw new DAOException(); } throw new DAOException(); } }