@SuppressWarnings("unchecked") public List<MusicComment> getCommentByMusicIdAndRating(int musicId, int rating) { List<MusicComment> mcs = new ArrayList<MusicComment>(); List<MusicComment> result = new ArrayList<MusicComment>(); try { Session session = TribusHibernateSessionFactory.currentSession(); String hql = "from MusicComment mc where mc.music.musicId=:musicId"; mcs = session.createQuery(hql).setInteger("musicId", musicId).list(); MusicMarkDao mmd = new MusicMarkDao(); Iterator<MusicComment> iterator = mcs.iterator(); while (iterator.hasNext()) { MusicComment mc = iterator.next(); if (mmd.getGradeByMusicIdAndUseId(mc.getMusic().getMusicId(), mc.getUser().getUserId()) == rating) { result.add(mc); } } } catch (Exception e) { // TODO: handle exception System.out.println(e.getMessage()); } return result; }