$B5WJ]MM!#(B<br>
<br>
$B$*@$OC$K$J$j$^$9!#6b$G$9!#(B<br>
<br>
$B=PMh$^$7$?!*!*$"$j$,$H$&$4$6$$$^$7$?!#(B<br>
<br>
<b>kimusowha@yahoo.co.jp</b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> $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: 0pt; width: 0pt; height: 5px; clear: both;">&nbsp;</div> <div>     </div><hr size="1"><a href="http://pr.mail.yahoo.co.jp/toolbar/" target="new">Power up the Internet with Yahoo! Toolbar.</a><br>
 </blockquote><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>