Hibernate 命名查询NamedQuery (二)

public String getType_id() {
return type_id;
}
public void setType_id(String type_id) {
this.type_id = type_id;
}
public String getStreet_id() {
return street_id;
}
public void setStreet_id(String street_id) {
this.street_id = street_id;
}
public Date getStart_date() {
return start_date;
}
public void setStart_date(Date start_date) {
this.start_date = start_date;
}
public Date getEnd_date() {
return end_date;
}
public void setEnd_date(Date end_date) {
this.end_date = end_date;
}
public Integer getSmall_floorage() {
return small_floorage;
}
public void setSmall_floorage(Integer small_floorage) {
this.small_floorage = small_floorage;
}
public Integer getBig_floorage() {
return big_floorage;
}
public void setBig_floorage(Integer big_floorage) {
this.big_floorage = big_floorage;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}

}

4测试代码

Test.java

import java.util.Iterator;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import cn.jbit.hibernate.entity.House;
import cn.jbit.hibernate.entity.QueryProperties;
import cn.jbit.hibernate.entity.User;
import cn.jbit.hibernate.util.HibernateUtil;

public class Test {

/**
* @param args
*/
public static void main(String[] args) {
HibernateUtil u= new HibernateUtil();
SessionFactory sf = null;
Session session =null;
Transaction tx=null;
try{
session=u.getSession();
tx=session.beginTransaction();

Query query =session.getNamedQuery("queryHouse");//获取命名查询语句

//给封装参数类添加参数值
QueryProperties qp = new QueryProperties();
qp.setTitle("豪放");
qp.setLow_price(new Integer(10000));
qp.setHigh_price(new Integer(25000));
qp.setStreet_id(1001);
qp.setType_id(1001);
qp.setSmall_floorage(new Integer(90));
qp.setBig_floorage(new Integer(180));
query.setProperties(qp);
List result =query.list();
Iterator it = result.iterator();
if(it.hasNext()){
House house=(House)it.next();
System.out.println(house.getTitle()+" "+house.getPrice());
}*/
//String hql = "from User u left join fetch u.house h ";
String hql="from District d inner join d.street s";
Query query = session.createQuery(hql);
List list=query.list();
}catch(HibernateException e){
e.printStackTrace();
}

}

}

注意：这里没有写出配置文件和创建工厂会话等代码