<div dir="ltr">$B>.NS(B (koichik) $B$G$9!#(B<div><br></div><div>$B2q<R$N(B PC $B$K$O(B Eclipse $B$,F~$C$F$J$$$N$GF0$+$7$F$$$^$;$s$,!"(B</div><div style>$B%=!<%9$r8+$?46$8$G$O(B scaffold $B$,@8@.$9$k%3!<%I$,4V0c$C$F$k$h$&$G$9$M!#!#!#(B</div><div style>$B=5Kv$J$I;~4V$,$"$k$H$-$K=$@5$7$^$9!#(B</div><div style>$BJs9p$"$j$,$H$&$4$6$$$^$7$?!#(B</div></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">2013$BG/(B7$B7n(B5$BF|(B 4:55 Koichi Kobayashi <span dir="ltr"><<a href="mailto:koichik@improvement.jp" target="_blank">koichik@improvement.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
$B>.NS(B (koichik) $B$G$9!%(B<br>
<div class="im"><br>
> action$B%/%i%9$N%3!<%I(B<br>
><br>
> empItems = jdbcManager.from(Emp.class).where(swh)<br>
> .orderBy("EMP_NO")<br>
<br>
</div>$B$3$N%3!<%I$O(B scaffold $B$G@8@.$5$l$?%3!<%I$G$9$+!)(B<br>
$B$=$l$H$bGO>l$5$s$,=q$$$?%3!<%I$G$7$g$&$+!)(B<br>
<br>
$B$b$78e<T$J$i!"(BorderBy() $B$G;XDj$9$k$N$O%+%i%`L>$G$O$J$/(B<br>
$B%(%s%F%#%F%#%/%i%9$KDj5A$7$?%W%m%Q%F%#L>$G$9!#(B<br>
<br>
<a href="http://s2container.seasar.org/2.4/ja/s2jdbc_manager_auto.html#%E3%82%BD%E3%83%BC%E3%83%88%E9%A0%86" target="_blank">http://s2container.seasar.org/2.4/ja/s2jdbc_manager_auto.html#$B%=!<%H=g(B</a><br>
<br>
$B!V(BorderBy() $B$K=q$/$3$H$N$G$-$k>r7o$O!"(BSQL$B$HF1$8$G$9!#(B SQL$B$H$N0c$$$O!"(B<br>
$B%+%i%`L>$NBe$o$j$K%W%m%Q%F%#L>$r=q$/$3$H$G$9!#!W(B<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
On Fri, 5 Jul 2013 00:38:09 +0900 (JST), <a href="mailto:hiroaki381@mbr.nifty.com">hiroaki381@mbr.nifty.com</a> wrote:<br>
<br>
> $B$*@$OC$K$J$j$^$9!#GO>l$H?=$7$^$9!#(B<br>
><br>
> $B8=:_!"(BS2JDBC$B$rMxMQ$7$?3+H/$r$*$3$J$C$F$*$j$^$9$,!"7oL>$N8=>]$,H/@8$7$F$*$j$^$9(B<br>
> $B!#(B<br>
><br>
> $B"#8=>](B<br>
> Dolteng$B$N(BScaffold$B5!G=$rMxMQ$7$F(BSaStruts+S2JDBC$B$G(BScaffold $B%"%W%j%1!<%7%g%s$N@8(B<br>
> $B@.$r9T$$!"(B<br>
> $B0J2<$N=hM}$N(BSQL$B<+F0@8@.$G%+%i%`L>$,JLL>$KJQ99$5$l$J$$$?$a(B<br>
> SQL$B%(%i!<$,H/@8$7$^$9!#@hF,%G!<%?$G$OL5$/!"<!%Z!<%8%G!<%?<hF@;~$KH/@8$7$^$9!#(B<br>
><br>
> .orderBy("EMP_NO") $B$r(B.orderBy("C1_")$B$KJQ99$7$^$9$H(BSQL$B%(%i!<$OH/@8$7$^$;$s!#(B<br>
><br>
> action$B%/%i%9$N%3!<%I(B<br>
><br>
> empItems = jdbcManager.from(Emp.class).where(swh)<br>
> .orderBy("EMP_NO")<br>
> .limit(limit).offset(Integer.valueOf(empForm.off<br>
> set))<br>
> .getResultList();<br>
><br>
> $B<+F0@8@.$N(BSQL<br>
><br>
> select<br>
> *<br>
> from<br>
> (<br>
> select<br>
> temp_.*<br>
> , row_number() over(order by EMP_NO) as rownumber_<br>
> from<br>
> (<br>
> select<br>
> T1_.EMP_NO as C1_<br>
> , T1_.EMP_NAME as C2_<br>
> , T1_.CREATE_DATE as C3_<br>
> , T1_.CREATE_USER_CD as C4_<br>
> , T1_.UPDATE_DATE as C5_<br>
> , T1_.UPDATE_USER_CD as C6_<br>
> from<br>
> EMP_MST T1_<br>
> where<br>
> (T1_.EMP_NO like ? )<br>
> ) as temp_<br>
> ) as temp2_<br>
> where<br>
> rownumber_ >= 11<br>
> and rownumber_ <= 20<br>
><br>
> $B"#4D6-(B<br>
> JDK 6<br>
> Tomcat 6<br>
> S2Container 2.4.45<br>
> S2Tiger 2.4.45<br>
> SA Struts 1.0.4 sp9<br>
> Dolteng 0.39.0<br>
> SQL Server 2008 R2 Express<br>
><br>
> $B0J>e!"$h$m$7$/$*4j$$$7$^$9!#(B<br>
><br>
> _______________________________________________<br>
> Seasar-user mailing list<br>
> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>
> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
{<br>
name: "Koichi Kobayashi",<br>
mail: "<a href="mailto:koichik@improvement.jp">koichik@improvement.jp</a>",<br>
blog: "<a href="http://d.hatena.ne.jp/koichik/" target="_blank">http://d.hatena.ne.jp/koichik/</a>",<br>
twitter: "@koichik"<br>
</font></span><div class="HOEnZb"><div class="h5">}<br>
<br>
_______________________________________________<br>
Seasar-user mailing list<br>
<a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>
<a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
</div></div></blockquote></div><br></div>