static void query(){
Session s=null;
try{
s=HibernateUtil.getSession();
String hql="from User as user";
List<User> list=query.list();//excuptQuery();
for (User user : list) {
System.out.println(user.getId()+"****"+user.getUsername()+"*******"+user.getPassword());
}
}finally{
if(s!=null)
s.close();
}
}
Session s=null;
try{
s=HibernateUtil.getSession();
String hql="from User as user";
Query query=s.createQuery(hql);
//从第五条数据开始
query.setFirstResult(5);
//每页显示十条数据
query.setMaxResults(10);List<User> list=query.list();//excuptQuery();
for (User user : list) {
System.out.println(user.getId()+"****"+user.getUsername()+"*******"+user.getPassword());
}
}finally{
if(s!=null)
s.close();
}
}