@SuppressWarnings("unchecked")
public List<Movie> searchMovieByName(String name) {
// String sql = "from Movie where tags.tagName = :movieTag";
// String[] tags = {"Drama"};
/*String hql = "select m from Movie m "+
"join m.tags t "+
"where t.tagName in (:tags)";*/
String hql = "from Movie";
Session session = TribusHibernateSessionFactory.currentSession();
List<Movie> allMovies = new ArrayList<Movie>();
List<Movie> result = new ArrayList<Movie>();
try {
allMovies = session.createQuery(hql).list();
Iterator<Movie> iterator = allMovies.iterator();
while (iterator.hasNext()) {
Movie m = iterator.next();
if (m.getMovieNameOriginal().indexOf(name) != -1) {
result.add(m);
}
}
System.out.println("success");
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
public List<Movie> getMoviesByCondition(Movie m) {
if (m == null) {
return null;
}
Session session = TribusHibernateSessionFactory.currentSession();
try {
Criteria c = session.createCriteria(Movie.class);
if (m.getMovieId() != 0) {
c.add(Restrictions.eq("movieId", m.getMovieId()));
}
if (m.getMovieNameOriginal() != null) {
c.add(Restrictions.eq("movieNameOriginal", m.getMovieNameOriginal()));
}
List<Movie> mo = c.list();
return mo;
} catch (Exception e) {
System.out.println(e.getMessage());
}
return null;
}
public int updateMovieNameOriginal(Movie movie) {
System.out.println(movie.getMovieId() + "*" + movie.getMovieNameOriginal());
int result = 0;
Session session = TribusHibernateSessionFactory.currentSession();
Transaction tx = session.beginTransaction();
try {
session.update(movie);
// session.flush();
tx.commit();
result = 1;
} catch (Exception e) {
// TODO: handle exception
System.out.println(e.getMessage());
tx.rollback();
}
return result;
}