@Override public boolean delete(int id) { try { Connection connection = PoolConnection.getConnection(); try { connection.setAutoCommit(false); chtdao.deleteByCategoryId(connection, id); udao.deleteByCatID(connection, id); chpdao.deleteByCategoryId(connection, id); cdao.delete(connection, id); connection.commit(); } catch (SQLTransactionException e) { connection.rollback(); return false; } finally { if (connection != null) { connection.setAutoCommit(true); connection.close(); } } } catch (SQLException e) { e.printStackTrace(); } return true; }
public List<Category> getAllChosenCategories(int userId) { try (Connection connection = PoolConnection.getConnection()) { return udao.getAllChosen(connection, userId); } catch (SQLException e) { e.printStackTrace(); } return null; }
public boolean insertIntoUserHasCategories(UserHasCategory usHas) { try { Connection connection = PoolConnection.getConnection(); try { connection.setAutoCommit(false); udao.insert(connection, usHas.getCategoryID(), usHas.getUserId()); connection.commit(); } catch (SQLTransactionException e) { connection.rollback(); return false; } finally { if (connection != null) { connection.setAutoCommit(true); connection.close(); } } } catch (SQLException e) { e.printStackTrace(); } return true; }