Untitled

public List<Object[]> showSongsOfUser (String username) { //отчет 1
        List list = em.createNativeQuery(
                "SELECT Song.SongName, Artist.ArtistName, Album.AlbumName"
                + " FROM Users, Playlist, SongList, Songs, Song, Album, Artist"
                + " WHERE Users.ID_User = Playlist.ID_User"
                + " AND Playlist.ID_Playlist = SongList.ID_Playlist"
                + " AND SongList.ID_File = Songs.ID_File"
                + " AND Songs.ID_Album = Album.ID_Album"
                + " AND Songs.ID_Song = Song.ID_Song"
                + " AND Song.ID_Artist = Artist.ID_Artist"
                + " AND Users.UserName = '"+username+"'").getResultList();
        saveToTextFile(list, "report1.txt");
        return list;
    }

    public void saveToTextFile(List<Object[]> list, String filename){

        try {
            FileWriter os = new FileWriter(filename);
            BufferedWriter bw = new BufferedWriter(os);
            PrintWriter out = new PrintWriter(bw);

            for (Object[] items : list){
                    for (Object item : items){
                            out.print(item.toString()+"   d ");
                    }
             out.println();
            }

            out.flush();
            out.close();
            os.flush();
            os.close();
        } catch (IOException ex) {
            Logger.getLogger(MusicFacade.class.getName()).log(Level.SEVERE, null, ex);
        }
    }