111,129
社区成员
发帖
与我相关
我的任务
分享 <resultMaps>
<resultMap id="SelectAllResultPerson" class="Person">
<result property="Id" column="PER_ID" />
<result property="FirstName" column="PER_FIRST_NAME" />
<result property="LastName" column="PER_LAST_NAME" />
<result property="BirthDate" column="PER_BIRTH_DATE" />
<result property="WeightInKilograms" column="PER_WEIGHT_KG" />
<result property="HeightInMeters" column="PER_HEIGHT_M" />
</resultMap>
</resultMaps>
<parameterMaps>
<parameterMap id="RoomStatusParameters" class="Hashtable">
<parameter property="Start" column="" direction="Input" />
<parameter property="End" column="" direction="Input" />
</parameterMap>
</parameterMaps>
<statements>
<select id="SelectPersonByPageNo" parameterMap="RoomStatusParameters" resultMap="SelectAllResultPerson">
SELECT
PER_ID,
PER_FIRST_NAME,
PER_LAST_NAME,
PER_BIRTH_DATE,
PER_WEIGHT_KG,
PER_HEIGHT_M
FROM (select ROW_NUMBER() Over(order by PER_ID) as rowNum, *
from PERSON) as t
where rowNum between $Start$ and $End$
</select>