Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Entity штука описывающая какая сужность будет возвращена (должна быть замаплена)
- Также внизу испоьзуется переменная в запросе
- public Genre getFavoriteGenre(Long id) throws SQLException {
- Session session = null;
- List genre = null;
- try {
- session = HibernateUtil.getSessionFactory().getCurrentSession();
- session.beginTransaction();
- genre = session.createSQLQuery("select genres.* from genres, (select count(id_genre) as genresNumber, id_genre from usersandbooks "INNER JOIN genresandbooks on genresandbooks.id_book = usersandbooks.id_book where usersandbooks.id_user = :userID group by id_genre order by genresNumber DESC limit 0,1 ) as result
- where genres.id = result.id_genre").addEntity(Genre.class).setParameter("userID", id).list();
- session.getTransaction().commit();
- } finally {
- if (session != null && session.isOpen()) {
- session.close();
- }
- }
- Iterator it = genre.iterator();
- return (Genre)it.next();
- }
Advertisement
Add Comment
Please, Sign In to add comment