转自:http://42087743.iteye.com/blog/305219
Hibernate提供了对类使用预先定义的过滤器条件的功能,并提供了专门的Filter类.
[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=?