$B$*@$OC$K$J$j$^$9!#6b$H?=$7$^$9!#(B<br>
<br>
Teeda + S2Dao + dbflute$B$G%7%9%F%`$r3+H/$7$F$*$j$^$9!#(B<br>
<br>
SQL $B%U%!%$%k$rMxMQ$7$?(BSQL$BH/9T$GG:$s$G$$$^$9!#(B<br>
SQL$B%3%a%s%H$K$D$$$F!"$&$^$/@_Dj$G$-$F$$$J$$$N$+@5$7$/(BSQL$B$,H/9T(B<br>
$B$5$l$^$;$s!#(B<br>
<br>
$B0J2<$K(BSQL$B%U%!%$%k$r5-:\$$$?$7$^$9!#(B<br>
<br>
-----------------------------------------------------------<br>
SQL$BJ8(B:<br>
-----------------------------------------------------------<br>
-- #Filehistory#<br>
-- !FilehistoryinfoPmb extends SPB!<br>
-- !!String nsccode!!<br>
-- !!String usercode!!<br>
-- !!int dealercount!!<br>
-- !!Date createddate!!<br>
<br>
/*IF pmb.isPaging()*/<br>
select DISTINCT count(*) as "dealercount"<br>
,tfilehistory.nsccode<br>
,tfilehistory.filename<br>
,tfilehistory.usercode<br>
,tfilehistory.createddate<br>
<br>
-- ELSE select count(*)<br>
/*END*/<br>
<br>
from tfilehistory<br>
<br>
/*IF pmb.isPaging()*/<br>
<br>
left outer<br>
join tdealer<br>
on tfilehistory.nsccode = tdealer.nsccode<br>
/*END*/<br>
<br>
//$B$3$3$,!"G'<1$5$l$F$$$J$$!#(B<br>
/*BEGIN*/<br>
where tfilehistory.nsccode =/*pmb.nsccode*/'CHLA'/*END*/<br>
<br>
/*IF pmb.isPaging()*/<br>
group by <br>
tfilehistory.nsccode,tfilehistory.filename,tfilehistory.usercode,tfilehistory.createddate<br>
/*END*/<br>
<br>
----------------------------------------------------------------<br>
Source:<br>
----------------------------------------------------------------<br>
public PagingResultBean&lt;Filehistory&gt; selectPage() {<br>
<br>
&nbsp;&nbsp; Class&lt;Filehistory&gt; FilehistoryEntity = Filehistory.class;<br>
&nbsp;&nbsp; tfilehistoryBhv = behaviorSelector.select(TfilehistoryBhv.class);<br>
&nbsp;&nbsp; FilehistoryinfoPmb pmb = new FilehistoryinfoPmb();<br>
&nbsp;&nbsp; int pageSize = 5;<br>
<br>
&nbsp; // nscname$B$r%-!<$H$7$F;XDj$7$F$$$k(B<br>
 pmb.setNsccode(nscname);<br>
&nbsp;&nbsp; <br>
&nbsp;&nbsp; pmb.fetchFirst(pageSize);<br>
&nbsp;&nbsp; pmb.fetchPage(targetPage);<br>
&nbsp;&nbsp; //pmb.paging(pageSize, targetPage);<br>
&nbsp;&nbsp; return <br>
tfilehistoryBhv.outsideSql().autoPaging().selectPage(filehistoryPath, pmb, <br>
FilehistoryEntity);<br>
<br>
&nbsp;} <br>
<br>
$B$9$_$^$;$s!#2?B4$465<x$/$@$5$$!#(B<br>
<br>

<div style="line-height: 0; width: 0; height: 5px; clear: both;">&nbsp;</div>
<p>&#32;



<hr size=1><a href=http://pr.mail.yahoo.co.jp/toolbar/ target="new">Power up the Internet with Yahoo! Toolbar.</a><br>