Hibernate中HQL语句查询

本篇文章是一次完整的HQL查询过程：

创建对象:

package com.lxy;
/***********************
 * Author ：李新宇     
 * Day ：2018年5月7日
 * Time ：下午11:13:31
 * Functions:    
 **********************/
public class user {
private int id;
private String username;
private String password;
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public boolean equals(Object obj) {
    if(this==obj){
    return true;
    }
    if(!(obj instanceof user)){
    return false;
    }
    final user user = (user) obj;
    if( this.id == user.id &&
    this.username.equals(user.username) &&
    this.password.equals(user.password) 
   
     ){
    return true;
    }
    return false;
    }
   public int hashCode(){
    int result = 0;
    result = this.username.hashCode() + this.password.hashCode();
   
    return result;
   }
@Override
public String toString() {
return "user [id=" + id + ", username=" + username
+ ", password=" + password + ",age="+age+"]";
}
   
public user(String username,String password,int age){
this.username=username;
this.password=password;
this.age=age;
}
public user(){
super();
}

}

测试类:

@Test //查询User里所有数据
public  void querySimpleDatabase() {  
SessionFactory sf = null;
Session session = null;
Transaction ts = null;



try {
sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query=session.createQuery("from user");
List<user> users=query.list();
for(int i=0;i<users.size();i++)
{
user user = users.get(i);
System.out.println(i+" "+user.getUsername()+" "+user.getPassword()+""+user.getAge());
}
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(ts != null)
{
ts.rollback();
}
e.printStackTrace();
}finally{
session.close();
}
}