Hibernate 命名查询NamedQuery

例子：  使用命名查询实现多条件对租房信息进行模糊查询

1.房屋实体类

House.java

  package cn.jbit.houserent.bean;
import java.util.Date;

public class House implements java.io.Serializable {

    private Integer id;
    private User user;
    private Type type;
    private Street street;
    private String title;
    private String description;
    private Double price;
    private Date date;
    private Integer floorage;
    private String contact;

    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public User getUser() {
        return this.user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    public Type getType() {
        return this.type;
    }

    public void setType(Type type) {
        this.type = type;
    }

    public Street getStreet() {
        return this.street;
    }

    public void setStreet(Street street) {
        this.street = street;
    }

    public String getTitle() {
        return this.title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getDescription() {
        return this.description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public Double getPrice() {
        return this.price;
    }

    public void setPrice(Double price) {
        this.price = price;
    }

    public Date getDate() {
        return this.date;
    }

    public void setDate(Date date) {
        this.date = date;
    }

    public Integer getFloorage() {
        return this.floorage;
    }

    public void setFloorage(Integer floorage) {
        this.floorage = floorage;
    }

    public String getContact() {
        return this.contact;
    }

    public void setContact(String contact) {
        this.contact = contact;
    }

}

2.配置映射文件

House.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="cn.jbit.houserent.bean.House" table="house" lazy="false" schema="jbit">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="sequence" >
                <param name="sequence">SEQ_ID</param>
            </generator>
        </id>
        <many-to-one name="user"  class="cn.jbit.houserent.bean.User" cascade="none" fetch="join">
            <column name="user_id" />
        </many-to-one>
        <many-to-one name="type" class="cn.jbit.houserent.bean.Type" cascade="none" fetch="join">
            <column name="type_id" />
        </many-to-one>
        <many-to-one name="street" class="cn.jbit.houserent.bean.Street" cascade="none" fetch="join">
            <column name="street_id" />
        </many-to-one>
        <property name="title" type="java.lang.String">
            <column name="title" length="50" not-null="false" />
        </property>
        <property name="description" type="text" lazy="false">
            <column name="description" />
        </property>
        <property name="price" type="java.lang.Double">
            <column name="price" precision="10" scale="4" not-null="false" />
        </property>
        <property name="date" type="java.util.Date">
            <column name="pubdate" length="23" />
        </property>
        <property name="floorage" type="java.lang.Integer">
            <column name="floorage" length="10" />
        </property>
        <property name="contact" type="java.lang.String">
            <column name="contact" length="10" />
        </property>
        
    </class>

<---在映射文件中.<query>元素用于定义一个HQL查询语句，它和<class>元素并列。给HQL语句命名"queryHouse"，以<![CDATA[ HQL ]]>方式保存HQL语句，在程序中通过Session对象的getNamedQuery()方法获取该查询语句 -->

    <query name="queryHouse">
        <![CDATA[
            from House where (title like :title) and
            (price between :low_price and :high_price) and
            (street_id like :street_id) and (type_id like :type_id) and
            (floorage between :small_floorage and :big_floorage)
        ]]>
        </query>
</hibernate-mapping>

3。封装查询参数

QueryProperties.java

package cn.jbit.houserent.util;

import java.util.Date;

public class QueryProperties {
    private String title;
    private Double high_price;
    private Double low_price;

    private Date start_date;
    private Date end_date;
    private String type_id;
    private String street_id;
    private Integer small_floorage;
    private Integer big_floorage;

    public Double getHigh_price() {
        return high_price;
    }
    public void setHigh_price(Double high_price) {
        this.high_price = high_price;
    }
    public Double getLow_price() {
        return low_price;
    }
    public void setLow_price(Double low_price) {
        this.low_price = low_price;
    }

    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();
        }

    }

}

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