``java,Session session = HibernateUtil.getSessionFactory().openSession();,String hql = "FROM Employee WHERE department = :dept";,Query query = session.createQuery(hql);,query.setParameter("dept", "Sales");,List employees = query.list();,session.close();,
``
``java,Session session = HibernateUtil.getSessionFactory().openSession();,Transaction tx = null;,try {, tx = session.beginTransaction();, List users = session.createQuery("from User").list();, for (User user : users) {, System.out.println("User: " + user.getName());, }, tx.commit();,} catch (Exception e) {, if (tx != null) {, tx.rollback();, }, e.printStackTrace();,} finally {, session.close();,},
``