hibernate 过滤器

查询过滤器

  <?xml version="1.0" ?> 
  <!DOCTYPE hibernate-mapping (View Source for full doctype...)> 
- <hibernate-mapping default-cascade="none" default-access="property" default-lazy="true" auto-import="true">
- <class name="com.bjsxt.hibernate.Student" table="t_student" mutable="true" polymorphism="implicit" dynamic-update="false" dynamic-insert="false" select-before-update="false" optimistic-lock="version">
- <id name="id">
  <generator class="native" /> 
  </id>
  <property name="name" unique="false" optimistic-lock="true" lazy="false" generated="never" /> 
  <property name="createTime" unique="false" optimistic-lock="true" lazy="false" generated="never" /> 
  <many-to-one name="classes" column="classesid" unique="false" update="true" insert="true" optimistic-lock="true" not-found="exception" embed-xml="true" /> 
  <filter name="filtertest" condition="id < :myid" /> 
  </class>
- <query name="searchStudents" cacheable="false">
- <![CDATA[ 			SELECT s FROM Student s where s.id<?
		
  ]]> 
  </query>
- <filter-def name="filtertest">
  <filter-param name="myid" type="integer" /> 
  </filter-def>
  </hibernate-mapping>

package com.bjsxt.hibernate;

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

import org.hibernate.Session;

import junit.framework.TestCase;

/**
 * 查询过滤器
 * @author Administrator
 *
 */
public class FilterQueryTest extends TestCase {

	public void testQuery1() {
		Session session = null;
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			
			session.enableFilter("filtertest")
				    .setParameter("myid", 10);	
			
			List students = session.createQuery("from Student").list();
			for (Iterator iter=students.iterator(); iter.hasNext();) {
				Student student = (Student)iter.next();
				System.out.println(student.getName());
			}
			session.getTransaction().commit();
		}catch(Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}	
}