# 16.2.1\. 使用return-property來明確地指定字段/別名 使用`&lt;return-property&gt;`你可以明確的告訴Hibernate使用哪些字段別名,這取代了使用`{}`-語法 來讓Hibernate注入它自己的別名. ``` <sql-query name="mySqlQuery"> <return alias="person" class="eg.Person"> <return-property name="name" column="myName"/> <return-property name="age" column="myAge"/> <return-property name="sex" column="mySex"/> </return> SELECT person.NAME AS myName, person.AGE AS myAge, person.SEX AS mySex, FROM PERSON person WHERE person.NAME LIKE :name </sql-query> ``` `<return-property>`也可用于多個字段,它解決了使用`{}`-語法不能細粒度控制多個字段的限制 ``` <sql-query name="organizationCurrentEmployments"> <return alias="emp" class="Employment"> <return-property name="salary"> <return-column name="VALUE"/> <return-column name="CURRENCY"/> </return-property> <return-property name="endDate" column="myEndDate"/> </return> SELECT EMPLOYEE AS {emp.employee}, EMPLOYER AS {emp.employer}, STARTDATE AS {emp.startDate}, ENDDATE AS {emp.endDate}, REGIONCODE as {emp.regionCode}, EID AS {emp.id}, VALUE, CURRENCY FROM EMPLOYMENT WHERE EMPLOYER = :id AND ENDDATE IS NULL ORDER BY STARTDATE ASC </sql-query> ``` 注意在這個例子中,我們使用了`&lt;return-property&gt;`結合`{}`的注入語法. 允許用戶來選擇如何引用字段以及屬性. 如果你映射一個識別器(discriminator),你必須使用`&lt;return-discriminator&gt;` 來指定識別器字段