$B$O$8$a$^$7$F!#9b66$H?=$7$^$9!#(B<br>
<br>
Seasar2$B$N(BSQL$B%$%s%8%'%/%7%g%s$K$D$$$FD4::Cf$G$9!#(B<br>
$B%I%-%e%a%s%H$d2a5n$N%a!<%j%s%0%j%9%H$r;2>H$5$;$F$$$?$@$-$^$7$?!#(B<br>
$B$G$9$,!"=i?4<T$N$?$a!":G8e$N3N?.$,;}$F$:<ALd$5$;$F$$$?$@$-$^$7$?!#(B<br>
<br>
$B8=:_!"(BJava, Struts, Seasar2$B$H$$$&4D6-$K$*$$$F!"(B<br>
Dao$BFb$G!"(B@Query,@Sql, @SqlFile, @Arguments, @Query $B%"%N%F!<%7%g%s$r<g$K;H$C$F$*$j$^$9!#(B<br>
<br>
SQL$B%$%s%8%'%/%7%g%sBP:v$,$J$5$l$F$$$k$N$O!"(B<br>
<br>
$BNc$($P(B<br>
&nbsp;&nbsp;&nbsp; @S2Dao(bean = sample.class)$B$r;H$&(BDAO$B%U%!%$%kFb$K$*$$$F$N(B<br>
&nbsp;&nbsp;&nbsp; @Query(&quot;DirectoryName = /*directoryName*/&quot;)<br>
$B$d(B<br>
&nbsp;&nbsp;&nbsp; @Sql(&quot;SELECT Number, LineNumber FROM NumberTable WHERE Number = /*Number*/&quot;)<br>
$B$d(B<br>
&nbsp;&nbsp;&nbsp; @SqlFile$B$G;XDj$5$l$?30It%U%!%$%k$K$*$$$F(B<br>
&nbsp;&nbsp;&nbsp; select * from employee<br>
&nbsp;&nbsp;&nbsp; where<br>
&nbsp;&nbsp;&nbsp; salary &gt;= /*salaryMin*/<br>
$B$G$O(BPreparedStatement$B$,;H$o$l!"(BSQL$B%$%s%8%'%/%7%g%sBP:v$,$J$5$l$F$$$^$9(B(OK)$B$,!"(B<br>
<br>
@Sql$BFb$K$*$$$F!"(B<br>
&nbsp;&nbsp;&nbsp; @Sql(&quot;SELECT count(NoteNumber) FROM NOTETABLE&quot;)<br>
$B$G$O(B,NoteNumber$B$K4X$7$F(BSQL$B%$%s%8%'%/%7%g%sBP:v$,$J$5$l$F$$$J$$(B(NG)$B$H$$$&$3$H$G$7$g$&$+!#(B<br>
<br>
$B$^$?!"(B<br>
&nbsp;&nbsp;&nbsp; @Arguments( { &quot;Number&quot;, &quot;LineNumber&quot; })<br>
&nbsp;&nbsp;&nbsp; public Sample select(String Number, long LineNumber);<br>
$B$J$I$O!"(BSQL$B$r<+F0@8@.$9$k$?$a!"(BSQL$B%$%s%8%'%/%7%g%sBP:v$O;vA0$K$J$5$l$F$$$k(B(OK)<br>
$B$H$$$&$3$H$G$h$m$7$$$G$7$g$&$+!#(B<br>
<br>
$B9M$(0c$$$d!"$=$NB>2?$+9MN8$9$k$3$H$,$"$l$P!"$*65$($$$?$@$1$l$P$&$l$7$/;W$$$^$9!#(B<br>
<br>
$B9b66(B