将查询语句写在hbm.xml文件中

hbm.xml文件里面的格式：

<query name="Advertisement.GetUserOtherAdvertisementIdList">
??? ??? <![CDATA[
??? ??? ??? select a.advertisementId
??? ??? ??? from Advertisement a,
??? ??? ??? ??? Campaign c
??? ??? ??? where a.campaignId = c.campaignId??? ??? ??? ???
??? ??? ??? ??? and a.statusId = :statusId
??? ??? ??? ??? and c.userId = :userId
??? ??? ??? ??? and a.url <> :targetUrl
??? ??? ]]>
??? </query>

dao层的类：

Query query = getCurrentSession().getNamedQuery("Advertisement.GetUserOtherAdvertisementIdList");
??? ??? query.setInteger("userId", userId);
??? ??? query.setInteger("statusId", statusId);
??? ??? query.setString("targetUrl", targetUrl);

说明：颜色相同是对应的；query.setInteger("userId", userId);“”里面的是配置文件里面的颜色对应的。