class UserStore {

    public List<User> findByType(MusicType type) {
        List<User> result = new ArrayList<>();
        try (Connection con = CON.getConnect();
        PreparedStatement st = con.prepareStatement(QUERIES.getProperty("findUsersByType"))) {
            st.setInt(1, TYPE_STORE.findTypeId(type));
            try (ResultSet rstSet = st.executeQuery()) {
                while (rstSet.next()) {
                    result.add(createUserByRstSet(rstSet));
                }
            }
        } catch (SQLException e) {
            LOG.error(e.getMessage(), e);
        }
        return result;
    }

}