<HTML dir=ltr><HEAD> <META http-equiv=Content-Type content="text/html; charset=unicode"> <META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD> <BODY> $B$O$8$a$^$7$F!"JR2,$H$$$$$^$9!#(B $B<+J,$N%W%m%8%'%/%H$G(BSeasar2$B$r;H$($J$$$+8!F$$r;O$a$F$_$?$N$G$9$,!"(B DB$B%"%/%;%9$^$o$j$O!"(BS2JDBC$B$,:#$^$G$N%W%m%8%'%/%H$N$d$jJ}$N1dD9@~>e$G(B $B<B;\$G$-$=$&$J$N$G!"5$$KF~$C$F$$$^$9!#(B $B$?$@!"!V(BSQL$B<+F0@8@.!W5!G=$K4X$7$F!"$A$g$C$HD4$Y$F$o$+$i$J$+$C$?$N$G!"(B 2$BE@$[$I!"5!G=$,B8:_$9$k$+$I$&$+65$($F$[$7$$$G$9!#$=$&$$$C$?5!G=$,$J$$(B $B$h$&$G$"$l$P!":#8e$N%(%s%O%s%9$GBP1~$r8!F$$$$?$@$-$?$$$N$G$9$,!#(B $B#1!K%Z!<%8%s%0A0$N7o?t<hF@$K4X$7$F(B $B%&%'%V%Z!<%8$J$I$G!"Am7o?t$rI=<($7$F!"$&$A#1!]#2#07oI=<($H$$$&$h$&$J(B $B%Z!<%8$r$h$/8+$+$1$^$9!#KM$i$,$d$C$F$$$k<BAu$H$7$F$O!"(BSELECT COUNT(*) $B$G$^$:7o?t$r<hF@$7$F!"$[$\F1MM$N(BSQL$B!J%Z!<%8%s%0<B;\!K$G!"(BSELECT$B0J2<$r(B $B%+%i%`L>$rJQ$($?7A$G$N(BSQL$B$rH/9T$9$k$H$$$&<jCJ$r$H$j$^$9!#(B $B$?$@!"!V(BSQL$B<+F0@8@.5!G=!W$G$O!"8!:w7o?t$r$+$($9$h$&$J%a%=%C%I$,$I$&$7$F$b(B $B8+Ev$?$j$^$;$s$G$7$?!#(B $B!!$H$j$"$($:!"<+F0@8@.$r$D$+$o$:$KBP1~$G$-$J$/$O$J$$$N$G$9$,!"7o?t%+%&%s%H(B $B$b<+F0@8@.$GBP1~$G$-$l$P!"$h$j3Z$J$N$K!"$H;W$o$:$K$J$j$^$;$s!#(B getCount()$B$N$h$&$J%+%&%s%H$,$H$l$k$h$&$J%a%=%C%I$,$"$l$P!"Hs>o$K3Z$@$H;W$&$7!"(B SELECT$BG[2<$r=q$-49$($k$@$1$J$N$G!"<BAu$b$=$l$[$IFq$7$/$J$$5$$,$9$k$N$G$9$,(B...$B!#(B Integer count = jdbcManager          .from(Employee.class)         .getCount(); List<Employee> results =     jdbcManager         .from(Employee.class)         .getResultList(); $B#2!K%R%s%H6g$NDI2C(B $B2q<R$N%W%m%8%'%/%H$G$O(BORACLE$B$r;H$&$3$H$,B?$$$N$G$9$,!"$I$&$7$F$b!"Bg$-$JI=$N(B $B8!:w$N>l9g!"<B9T7W2h$,0BDj$7$J$$%1!<%9$b$"$j!"%R%s%H6g$rB?MQ$7$F$$$^$9!#(B $B!!(B $B!V%R%s%H6g$,I,MW$J$b$N$J$s$F!"30$@$7(BSQL$B$8$c$J$-$c=q$1$J$$$h$&$JJ#;($J(BSQL $B$8$c$J$$$N!)!W$H$$$o$l$=$&$G$9$,!"%a%$%s$G;H$&$h$&$JBg$-$J%F!<%V%k$K$O(B $B$$$C$Q$$(BINDEX$B$,$O$i$l$F$$$F!"$3$A$i$N;W$$DL$j$N(BINDEX$B$r;H$C$F$b$i$($:$K!"(B INDEX$B$N%R%s%H$r$$$l$k$H$$$&%1!<%9$,BgBN$N%Q%?!<%s$G$9!#(B $B$3$l$b30$@$7(BSQL$B$K$9$l$P$G$-$k$H;W$&$N$G$9$,!"$@$$$?$$!"%R%s%H6g$r$O$k$N$O(B $B%+%C%H!&%*!<%P!<$7$F1?MQ%U%'%$%:$KF~$C$F$7$^$C$?8e$G$9$+$i!"$;$C$+$/<+F0@8(B $B@.$G:n$C$F$$$?(BSQL$B$r30$@$7%U%!%$%k$K$+$($J$1$l$P$J$i$J$$$H$+!"7k9=LLE]$/$5(B $B$$$J!<$H;W$C$?<!Bh$G$9!#(B ORACLE$B%f!<%6$N;kE@$G$O!"%R%s%H6g$O(BSQL$BJ,$N%3%a%s%H$G$7$+$J$$$N$G!"(BSQL$B%3%a%s%H(B $BDI2C5!G=!J(BSELECT$BJ8$ND>8e$K(B/*    */$B$r$$$l$F$b$i$($k(B)$B$5$($"$l$P!"$=$l$GHFMQ(B $BE*$KMxMQ$G$-$k5$$,$7$^$9!#(B $B!J(BMySQL$B$H$+$G$O%@%a$G$9$M!)!!(BSQL$BJ8Fb$K$-$A$s$H%R%s%H6g$r$+$+$J$-$c$$$1$J$$(B $B$h$&$J$N$G(B...$B!K(B $B%$%a!<%8$O0J2<$G$9!#(B List<Employee> results =     jdbcManager         .from(Employee.class)         .comment("+ index(T1_  index1) ")         .getResultList(); $B$3$l$G(B  select /*+ index(T1_  index1) */ COLUMN1 from employee$B!!$H$$$&(BSQL$B$,H/9T$5$l$k!#(B     <DIV> </DIV></BODY></HTML>