public ArrayList<BEPlaylist> getAllPlaylists() throws SQLException {
        ArrayList<BEPlaylist> result = new ArrayList<BEPlaylist>();

        Statement stm = DBConnection.getConnection().createStatement();
        stm.execute("Select * From Playlist");
        ResultSet res = stm.getResultSet();
        while (res.next()) {
            int id = res.getInt("ID");
            String name = res.getString("Name");
            result.add(new BEPlaylist(id, name));
        }

        return result;
    }