hibernate过滤器的参数配置

LittleLeeZi 2014-02-21 04:03:28

第一次使用hibernate过滤器，对里面的参数有一些不了解



<?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 package="com.ys.store.entity">

    <class name="Staff" table="ms_staff" catalog="mobile_stores">

        <id name="staffNo" type="string">

            <column name="staff_no" length="20" />

            <generator class="assigned"></generator>

        </id>

        <property name="staffName" type="string">

            <column name="staff_name" length="20" not-null="true" />

        </property>

        <set name="atts" lazy="true">

	    <key column="att_staff_no"></key>

	    <one-to-many class="Attendence"/>

            <filter name="myFilter" condition="attTime between :startTime and :endTime"/>

	</set>	

    </class>

    <filter-def name="myFilter">

    	<filter-param name="attTime" type="string"/>

    </filter-def>

</hibernate-mapping>

attTime是Attendence的属性，startTime和endTime是个时间段
我要实现的是过滤出attTime在startTime和endTime时间段内的staff的关联attence集合
dao里如下：



public List<Staff> selectStaffsTodayAtt(String start, String end) {

		Session session=this.getSession();

		session.enableFilter("myFilter");

		

		return session.createQuery("from Staff").setParameter("startTime",start).setParameter("endTime", end).list();

	}

我这样写正确吗？出异常说attTime未赋值，难道我理解错了？

<filter-def name="myFilter">
<filter-param name="attTime" type="string"/>
</filter-def>
这里面的name属性指定的是什么值？
<filter name="myFilter" condition="attTime between :startTime and :endTime"/>
这里面的condition又该如何写

...全文

127 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

LittleLeeZi 2014-02-21

打赏
举报

问题解决了 <filter-def name="myFilter"> <filter-param name="attTime" type="string"/> </filter-def> name指定的是你的程序传递进来的参数 <filter name="myFilter" condition="attTime between :startTime and :endTime"/> condition里除了name指定的外都需要是多的一端的字段名综上，应该改为


<?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 package="com.ys.store.entity">
    <class name="Staff" table="ms_staff" catalog="mobile_stores">
        <id name="staffNo" type="string">
            <column name="staff_no" length="20" />
            <generator class="assigned"></generator>
        </id>
        <property name="staffName" type="string">
            <column name="staff_name" length="20" not-null="true" />
        </property>
        <set name="atts" lazy="true">
            <key column="att_staff_no"></key>
            <one-to-many class="Attendence"/>
            <filter name="myFilter1" condition="att_time>start"/>
            <filter name="myFilter2" condition="att_time<end"/>
        </set>    
    </class>
    <filter-def name="myFilter1">
        <filter-param name="start" type="string"/>
    </filter-def>
    <filter-def name="myFilter2">
        <filter-param name="end" type="string"/>
    </filter-def>
</hibernate-mapping>

LittleLeeZi 2014-02-21