Hinbernate中使用Filter过滤一对多中的选项

实体类

package com.test.hibernate.entity;

/** * TblStreet entity. * * @author MyEclipse Persistence Tools */

public class TblStreet implements java.io.Serializable {

// Fields

private Integer id; private TblArea tblArea; private String street; private Integer display;

// Constructors

/** default constructor */ public TblStreet() { }

/** full constructor */ public TblStreet(Integer id, TblArea tblArea, String street, Integer display) {    this.id = id;    this.tblArea = tblArea;    this.street = street;    this.display = display; }

// Property accessors

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

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

public TblArea getTblArea() {    return this.tblArea; }

public void setTblArea(TblArea tblArea) {    this.tblArea = tblArea; }

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

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

public Integer getDisplay() {    return this.display; }

public void setDisplay(Integer display) {    this.display = display; }

}

package com.test.hibernate.entity;

import java.util.HashSet; import java.util.Set;

/** * TblArea entity. * * @author MyEclipse Persistence Tools */

public class TblArea implements java.io.Serializable {

// Fields

private Integer id; private String area; private Set tblStreets = new HashSet(0);

// Constructors

/** default constructor */ public TblArea() { }

/** minimal constructor */ public TblArea(Integer id, String area) {    this.id = id;    this.area = area; }

/** full constructor */ public TblArea(Integer id, String area, Set tblStreets) {    this.id = id;    this.area = area;    this.tblStreets = tblStreets; }

// Property accessors

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

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

public String getArea() {    return this.area; }

public void setArea(String area) {    this.area = area; }

public Set getTblStreets() {    return this.tblStreets; }

public void setTblStreets(Set tblStreets) {    this.tblStreets = tblStreets; }

}

 

两个关联类的映射文件

<?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="com.test.hibernate.entity.TblStreet" table="Tbl_Street" schema="dbo" catalog="mx_lee">         <id name="id" type="java.lang.Integer">             <column name="id" />             <generator class="assigned" />         </id>         <many-to-one name="tblArea" class="com.test.hibernate.entity.TblArea" fetch="select">             <column name="AreaId" not-null="true" />                     </many-to-one>                 <property name="street" type="java.lang.String">             <column name="street" length="50" not-null="true" />         </property>         <property name="display" type="java.lang.Integer">             <column name="display" not-null="true" />         </property>             </class>     </hibernate-mapping>

<?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="com.test.hibernate.entity.TblArea" table="Tbl_Area" schema="dbo" catalog="mx_lee">                 <id name="id" type="java.lang.Integer">             <column name="id" />             <generator class="assigned" />         </id>         <property name="area" type="java.lang.String">             <column name="Area" length="50" not-null="true" />         </property>         <set name="tblStreets" inverse="true">             <key>                 <column name="AreaId" not-null="true" />             </key>             <one-to-many class="com.test.hibernate.entity.TblStreet"/>             <!-- 为一对多访问设置过滤器，首先指定过滤器名字，然后指定过滤器变量displayCondition与TblStreet内的display属性匹配 -->             <filter name="test" condition="display= :displayCondition"></filter>         </set>     </class>     <!-- 设置名字为test的过滤器，并为过滤器添加Integer类型的属性displayCondition -->     <filter-def name="test">        <filter-param name="displayCondition" type="java.lang.Integer"/>     </filter-def> </hibernate-mapping>

测试类： package com.test.hibernate.dao;

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

import com.test.hibernate.entity.TblArea; import com.test.hibernate.entity.TblStreet;

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

import com.test.hibernate.HibernateSessionFactory;

public class TestFilter {

/** * @param args */ public static void main(String[] args) {    // TODO Auto-generated method stub    String sql = "from TblArea";    Session session = HibernateSessionFactory.getSession();    //根据XML内设置的过滤器，通过enableFilter（）方法加载，并为属性displayCondition赋值；    //这项当查询进行时Filter就会将赋值带入与XML内指定的对应属性进行对皮，并且起到过滤作用    session.enableFilter("test").setParameter("displayCondition", new Integer(1));    Transaction tx = session.beginTransaction();    tx.begin();    try{     Query query = session.createQuery(sql);     List<TblArea> list = query.list();     for(int i=0;i<list.size();i++){           TblArea ta = list.get(i);      Set set = ta.getTblStreets();      Iterator streetIt = set.iterator();      while(streetIt.hasNext()){       TblStreet ts = (TblStreet)streetIt.next();       System.out.println(ts.getStreet());            }     }     tx.commit();    }catch(Exception ex){     tx.rollback();     ex.printStackTrace();    }

}

}