136137138139140141142143
statement.setInt(5, request.getProjectID()); statement.setBoolean(6, request.isRejected()); statement.setInt(7, request.getRequestID()); statement.executeUpdate(); } catch (SQLException e) { throw new DAOException(); } }
172173174175176177178179180181
} catch (SQLException e) { try { con.rollback(save1); con.setAutoCommit(true); } catch (SQLException e1) { throw new DAOException(); } throw new DAOException(); } }
191192193194195196197198199
ResultSet result = statement.executeQuery(); while (result.next()) { requests.add(getRequestFromResult(result)); } } catch (SQLException e) { throw new DAOException(); } return requests; }
207208209210211212213214
statement.setBoolean(1, visible); statement.setInt(2, resourceID); statement.setInt(3, requestID); statement.executeUpdate(); } catch (SQLException e) { throw new DAOException(); } }
227228229230231232233234235
} else { return false; } } } catch (SQLException e) { throw new DAOException(); } return false; }
272829303132333435
resourceType = getResourceTypeFromResult(result); } else { throw new ResourceTypeNotFoundException(); } } catch (SQLException e) { throw new DAOException(); } return resourceType; }
5758596061626364
PreparedStatement statement = JdbcConnection.getConnection() .prepareStatement(command); statement.setInt(1, resourceType.getResourceTypeID()); statement.executeUpdate(); } catch (SQLException e) { throw new DAOException(); } }
9596979899100101102103
ResultSet result = statement.executeQuery(); while (result.next()) { resourceTypes.add(getResourceTypeFromResult(result)); } } catch (SQLException e) { throw new DAOException(); } return resourceTypes; }
115116117118119120121122123
status = getStatusFromResult(result); } else { throw new StatusNotFoundException(); } } catch (SQLException e) { throw new DAOException(); } return status; }