public void ListLecturersNamedFatma () { Session session = HibernateUtil.getSessionFactory().getCurrentSession(); Transaction tx = session.beginTransaction(); Query HQL_SimpleSearch = session.createQuery("from Lecturer where firstName = 'Fatma' "); Query HQL_ParametersSearch = session.createQuery("from Lecturer where firstName = ? "); HQL_ParametersSearch.setString(0, "Fatma"); Query HQL_NamedParametersSearch = session.createQuery("from Lecturer where firstName = :fn "); HQL_NamedParametersSearch.setString("fn", "Fatma"); Criteria CriteriaSearch = session.createCriteria(Lecturer.class); CriteriaSearch.add(Restrictions.eq("firstName", "Fatma")); SQLQuery NativeSQLSearch = session.createSQLQuery("Select * From Lecturer where FName = 'Fatma'"); NativeSQLSearch.addEntity(Lecturer.class); List lecturers = (List)HQL_SimpleSearch.list(); //List lecturers = (List)HQL_ParametersSearch.list(); //List lecturers = (List)HQL_NamedParametersSearch.list(); //List lecturers = (List)CriteriaSearch.list(); //List lecturers = (List)NativeSQLSearch.list(); tx.commit(); // ------------- Printing the lecturers in the list ---------------- System.out.println (" ---- The Lecturers ----"); for (int i = 0; i < lecturers.size() ; i++) { System.out.println( lecturers.get(i).getFirstName() + " " + lecturers.get(i).getLastName()); } System.out.println (" -----------------------"); }