<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.User" table="user">
<id name="id" column="id_ID" >
<generator class="increment"></generator>
</id>
<property name="url" column="URL" />
<property name="encoding" column="ENCODING" />
</class>
<sql-query name="user.getUpdated">
<return-scalar column="id" type="integer"/>
<return-scalar column="count" type="long"/>
<![CDATA[
select * from user
]]>
</sql-query>
<query name="Daily.getDailyByIdAndDate">
from Daily
where Id = :Id
and date between :startDate and :endDate
</query>
</hibernate-mapping>
java code
Query query = getSession().getNamedQuery("Daily.getDailyByIdAndDate");
query.setInteger("id", adOrderId);
return (List<AdEntry>) query.list();
这里在代码中getSession().getNamedQuery返回的都是query接口对象, 但在内部回根据映射文件中sql-query 或query返回对应的query实现