class RoleStore {

    public List<Role> findAll() {
        List<Role> result = new ArrayList<>();
        try (Connection connect = CON.getConnect();
             Statement st = connect.createStatement();
             ResultSet rstSet = st.executeQuery(QUERIES.getProperty("findAllRoles"))) {
            while (rstSet.next()) {
                Role role = new Role(rstSet.getString("role"));
                role.setId(rstSet.getInt("id"));
                result.add(role);
            }
        } catch (SQLException e) {
            LOG.error(e.getMessage(), e);
        }
        return result;
    }

}