Hibernate提供了对类使用预先定义的过滤器条件的功能,并提供了专门的Filter类.
[list]
[*]首先在需要过滤的model类的hbm.xml中:
[/list]
[list]
[*]其次,在testcase中加上过滤:
[/list]
[list]
[*]查看下hibernate生成的sql语句,证明filter已经加上:
[/list]
[list]
[*]首先在需要过滤的model类的hbm.xml中:
<class name="com.u2map.model.oneToOne.Pwd">
<id name="id" column="id" type="integer">
<generator class="foreign">
<param name="property">member</param>
</generator>
</id>
<property name="pwd" column="pwd" type="string"></property>
<one-to-one name="member" constrained="true" class="com.u2map.model.oneToOne.Member"></one-to-one>
//过滤器配置
<filter name="myFilter" condition="pwd like :myFilterParam"/>
</class>
//过滤器配置
<filter-def name="myFilter">
<filter-param name="myFilterParam" type="string"/>
</filter-def>
[/list]
[list]
[*]其次,在testcase中加上过滤:
//使用过滤器
session.enableFilter("myFilter").setParameter("myFilterParam", "%a%");
Query query = session.createQuery("from Pwd p where p.id = :id");
query.setParameter("id", 3);
Pwd member = null;
try {
member = (Pwd) query.uniqueResult();
} catch (HibernateException e) {
e.printStackTrace();
}
Assert.assertEquals(member.getId(), 3);
Assert.assertEquals(member.getPwd(), "abc");
[/list]
[list]
[*]查看下hibernate生成的sql语句,证明filter已经加上:
Hibernate: select pwd0_.id as id1_, pwd0_.pwd as pwd1_ from Pwd pwd0_ where pwd0_.pwd like ? and pwd0_.id=?
[/list]