Hibernate Study Notes and hibernate Study Notes
Hibernater HqlHibernater failed to query by page. The query result is all because:
Package com. tenni. test; import java. util. list; import org. hibernate. query; import org. hibernate. session; import org. hibernate. transaction; import org. junit. test; import com. tenni. entity. account; import com. tenni. entity. service; import com. tenni. util. hibernateUtil; public class testHql {private Session session = HibernateUtil. getSession (); private Transaction ts = session. getTransaction (); @ Test // public void testPaging () {int page = 1, pageSize = 3, totalRows, from; String hql = "select count (*) from Service "; Query qry = session. createQuery (hql); totalRows = Integer. valueOf (qry. uniqueResult (). toString (); System. err. println ("all count totalRows =" + totalRows); hql = "from Service order by id ";Qry=Session. createQuery (hql); // It must be before the start and capacity settingsFrom = (page-1) * pageSize;Qry. setFirstResult (from );// Set the start point and qry. setMaxResults (pageSize) from 0; // set the page sizeList <Service> list = qry. list (); for (Service a: list) {System. out. println (. getId () + "" +. getOsUserName () + "" +. getLoginPassword ());}}}