public ArrayList<BESong> getAll() throws SQLException {
        ArrayList<BESong> result = new ArrayList<BESong>();

        Statement stm = DBConnection.getConnection().createStatement();
        stm.execute("select * from song inner join Artist on Song.artistID = artist.id inner join Category on Category.ID = song.CategoryID");
        ResultSet res = stm.getResultSet();
        while (res.next()) {
            int id = res.getInt("ID");
            String title = res.getString("Title");
            String artist = res.getString("Name");
            String categoryID = res.getString("Category");
            String filename = res.getString("FileName");

            result.add(new BESong(id, title, artist, categoryID, filename));
        }

        return result;
    }