ibatis里查询select语句写法带分页.doc

ibatis 里查询select语句写法带分页 分类： ibatis 2012-06-04 17:37 307人阅读 评论(0) 收藏 举报 ibatishashmapstringexceptiondateinteger startDate?endDate?06传如为日期类型 ? select id=queryProceduresTop parameterClass=java.util.HashMap resultClass=java.util.HashMap??dynamic prepend=????isNotNull prepend= property=end?????Select * From (?????? /isNotNull??/dynamic????Select * From (???SELECT rownum as rowIndex,?????? t.requestid,?????? t.requcode,????????? pkg_bshis_common.F_GET_ADD(dictoffice,t.requoffice,officename) as sqdw,????????? pkg_bshis_common.F_GET_ADD(dictoper,t.inputor,opername) as sqr,????????? t.requdate as sqrq,????????? case t.retu when 1 then 已汇总 else 未汇总 end as hzzt, ????????? pkg_bshis_common.F_GET_ADD(dictoper,t.retuoperid,opername) as hzr,????????? t.retudate as hzrq??? from request_total t???where t.forgid = #FORGID#???? and t.frcode = #FRCODE#???![CDATA[and substr(t.requcode,1,1) F ]]???? and t.stage = 1???? dynamic prepend=????isNotNull prepend=AND property=REQUCODE?????t.requcode = #REQUCODE#???????? /isNotNull????isNotNull prepend=AND property=RETU?????t.retu = #RETU#???????? /isNotNull?????? isNotNull prepend=AND property=startDate ?????![CDATA[ t.requdate = #startDate# ]]????????? /isNotNull????isNotNull prepend=AND property=endDate?????![CDATA[ t.requdate = #endDate# ]]????/isNotNull????? /dynamic? ??? ??)??dynamic prepend=WHERE???isNotNull prepend=AND property=end????![CDATA[ rowIndex=#end#) where rowIndex=#start# ]] ??????? /isNotNull?? /dynamic? ?/select??select id=queryProcedureTopCount parameterClass=java.util.HashMap resultClass=int??SELECT count(*)??????? from request_total t??where t.forgid = #FORGID#??? and t.frcode = #FRCODE#??![CDATA[and substr(t.requcode,1,1) F ]]??? and t.stage = 1??? dynamic prepend=???isNotNull prepend=AND property=REQUCODE????t.requcode = #REQUCODE#??????? /isNotNull???isNotNull prepend=AND property=RETU????t.retu = #RETU#??????? /isNotNull??? isNotNull prepend=AND property=star