hibernate sql 放到 hbm.xml中

<?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实现