class MusicTypeStore {

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

}