<select id="queryment" parameterClass="map" resultMap="queryResult" >
select
rownum rn,
t.c_id as businessKey,
t2.hypertension_id as specialNo,
t.gr_id as personId,
t.name as name,
to_char(t.create_file_date, 'yyyy-mm-dd') as registerDate,
t.org_code as registerOrgCode,
t.c_id as registerDoctorCode,
t.create_file_person as registerDoctorName,
to_char(t.confirmed_date,'yyyy-mm-dd') as diagnoseDate,
t.org_code as diagnoseOrgCode,
t2.c_id as diagnoseDoctorCode,
t.resp_dr as diagnoseDoctorName,
t2.sbp as SBP,
t2.dbp as DBP,
t.blood_pres_mana_class as bloodPressureLevel,
to_char(t2.next_follow_visit_date,'yyyy-mm-dd')as nextFlupDate
from T_HYPERTENSION_REG t,T_HYPERTENSION_FOLLOW_VISIT t2
where t.c_id = t2.HYPERTENSION_ID
t.health_record_id in (select c_id from T_PERSON_BASE_INFO o where o.nc_code=#areCode#)
where rn between 1 and 3
上述的语句Java 后台能查出数据,显示3条,但是把分页去了的话 查询数据就无法显示,这是什么原因,请各位大神帮忙看看