public List<MusicMarkVo> getMusicAndGradeByUserId(int id) { String sql = "select m.musicId,m.musicName,mm.musicGrade from " + " music m, music_mark mm, user_account u, user_profile up" + " where m.musicId = mm.musicId and u.userId = mm.userId and up.userId = u.userId" + " and u.userId = ? "; List<MusicMarkVo> l_music_vo = new ArrayList<MusicMarkVo>(); Session session = TribusHibernateSessionFactory.currentSession(); List<Music> l = session.createSQLQuery(sql).setInteger(0, id).list(); if (l != null) { Iterator itr = l.iterator(); while (itr.hasNext()) { Object[] obj = (Object[]) itr.next(); MusicMarkVo bmv = new MusicMarkVo(); // bmv.setMovieId(Integer.parseInt(obj[0].toString())); bmv.setMusicId(Integer.parseInt(obj[0].toString())); bmv.setMusicName(obj[1].toString()); // bmv.setMovieNameAlias(obj[1].toString()); if (obj[2] == null) obj[2] = 1; bmv.setMusicGrade(Integer.parseInt(obj[2].toString())); // bmv.setMovieGrade(Integer.parseInt(obj[2].toString())); l_music_vo.add(bmv); } } return l_music_vo; }
public boolean Tribuscontains(List<MusicMarkVo> m1, MusicMarkVo m2) { for (MusicMarkVo movieMarkVo : m1) { if (m2.compareTo(movieMarkVo) == 0) { return true; } } return false; }