시소당

[db2] 페이징 & 리스트 쿼리...

<sql id="1">
<query>
SELECT CASE mod(count(a.mbsid),?*1) WHEN 0 THEN trunc(count(a.mbsid)/?*1,0)
ELSE trunc(count(a.mbsid)/?*1,0)+1
END
,?*(?-1)+1,count(a.mbsid)
FROM mbs_list a
$srch
</query>
<mapping>
<setProperty>pageSize,pageSize,pageSize,pageSize,pageVal!</setProperty>
<getProperty>totalpage,idx,totalnum</getProperty>
</mapping>
</sql>

<sql id="2"><!--/*+ INDEX_DESC(article article_seq_idx) *//*+ INDEX_DESC(b_article sys_c001464) */-->
<query>
SELECT mbsid,mbs_name,create_date,gesi_gongsi,gesi_anne
FROM (
SELECT mbsid,mbs_name,create_date,gesi_gongsi,gesi_anne,ceil(rownum/double($pageSize*1.0)) page FROM (
SELECT a.mbsid,a.mbs_name,a.create_date,a.gesi_gongsi,a.gesi_anne,rownumber() over (order by a.create_date desc) as rownum
FROM mbs_list a
$srch
ORDER BY a.create_date DESC, a.mbsid DESC
) as aa
) as bb
WHERE page=?
</query>
<mapping>
<setProperty>pageVal!</setProperty>
<getProperty>mbsid,mbs_name,create_date,gesi_gongsi,gesi_anne</getProperty>
</mapping>
</sql>