Example #1
0
  public List<MovieMarkVo> getMovieAndGradeByUserId(int id) {
    String sql =
        "select m.movieId,m.movieNameOriginal,mm.movieGrade from book b, book_mark bb, user_account u, user_profile up"
            + " where b.bookId = bb.bookId and u.userId = bb.userId and up.userId = u.userId"
            + " and u.userId = ? ";

    List<MovieMarkVo> l_movie_vo = new ArrayList<MovieMarkVo>();

    Session session = TribusHibernateSessionFactory.currentSession();
    List l = session.createSQLQuery(sql).setInteger(0, id).list();
    if (l != null) {
      Iterator itr = l.iterator();
      while (itr.hasNext()) {

        Object[] obj = (Object[]) itr.next();
        MovieMarkVo bmv = new MovieMarkVo();

        bmv.setMovieId(Integer.parseInt(obj[0].toString()));

        bmv.setMovieNameAlias(obj[1].toString());

        bmv.setMovieGrade(Integer.parseInt(obj[2].toString()));

        l_movie_vo.add(bmv);
      }
    }
    return l_movie_vo;
  }
Example #2
0
 public boolean Tribuscontains(List<MovieMarkVo> m1, MovieMarkVo m2) {
   for (MovieMarkVo movieMarkVo : m1) {
     if (m2.compareTo(movieMarkVo) == 0) {
       return true;
     }
   }
   return false;
 }