public class test {
public static void main(String[] args) {
test();
}
static void test()
{
SessionFactory sf = new Configuration().configure().buildSessionFactory();
Session session = sf.openSession();
String hql = "from user";
int curpage = 1;//当前页
int pagesize = 5;//每页显示数
List list = findfenye(session, hql, curpage, pagesize);
for(Iterator i = list.iterator();i.hasNext();){
user model = (user) i.next();
System.out.println("username:"+model.getUsername());
}
}
public static List findfenye(Session session,String strHQL, int offset, int pagesize){ //分页方法
List list = null;
try {
Query query = session.createQuery(strHQL);
if (offset != 0 && pagesize != 0) {
query.setFirstResult((offset - 1) * pagesize);
query.setMaxResults(pagesize);
}
list = query.list();
} catch (Exception ex) {
ex.printStackTrace();
}
return list;
}
}
public static void main(String[] args) {
test();
}
static void test()
{
SessionFactory sf = new Configuration().configure().buildSessionFactory();
Session session = sf.openSession();
String hql = "from user";
int curpage = 1;//当前页
int pagesize = 5;//每页显示数
List list = findfenye(session, hql, curpage, pagesize);
for(Iterator i = list.iterator();i.hasNext();){
user model = (user) i.next();
System.out.println("username:"+model.getUsername());
}
}
public static List findfenye(Session session,String strHQL, int offset, int pagesize){ //分页方法
List list = null;
try {
Query query = session.createQuery(strHQL);
if (offset != 0 && pagesize != 0) {
query.setFirstResult((offset - 1) * pagesize);
query.setMaxResults(pagesize);
}
list = query.list();
} catch (Exception ex) {
ex.printStackTrace();
}
return list;
}
}