[Seasar-user:9640] Re: [S2Dao-Tiger]Queryアノテーションについて(再送）
JUNDU
[E-MAIL ADDRESS DELETED]
2007年 8月 2日 (木) 12:57:19 JST
JUNDU$B$G$9!#(B
$B!!$*$=$i$/$G$9$,!"([E-MAIL ADDRESS DELETED]$B%"%N%F!<%7%g%s$,5-=R$5$l$F$$$J$$$?$a$H;W$o$l(B
$B$^$9!#(BSQL$B%3%a%s%H$N%P%$%s%IJQ?t%3%a%s%H!J(B/*calcdate*/$B$J$I!K$rMxMQ$9$k>l9g!"(B
$B%a%=%C%I$KJ#?t$N0z?t$,$"$k;~$O!"([E-MAIL ADDRESS DELETED]$B%"%N%F!<%7%g%s$,I,MW$K$J$j$^$9!#(B
$B!!$b$&>/$7>\$7$/=q$/$H!"%a%=%C%I$N0z?t$,J#?t$"$k>l9g!"([E-MAIL ADDRESS DELETED]$B%"%N%F!<%7%g(B
$B%s$NCf$K=q$+$l$F$$$k(B/*aaa*/$B$H(B/*bbb*/$B$H$"$C$F!"%a%=%C%I$,(BgetOne(int, int)
$B$N$h$&$J%a%=%C%I$N$H$-$K(Baaa$B$,Bh#10z?t$J$N$+Bh#20z?t$J$N$+$,<h$l$^$;$s!#(B
$B$3$l$O(BJava$B$,%3%s%Q%$%k8e$K0z?t$NL>A0!J(Baaa$B$H$+(Bbbb$B!K$r(Bclass$B%U%!%$%k$K4^$a$F(B
$B$/$l$J$$$+$i$@$=$&$G$9!#(B
$B!!$H$$$&$o$1$G!"#1EY([E-MAIL ADDRESS DELETED]$B%"%N%F!<%7%g%s$rDI5-$7$F;n$7$F$_$F$/$@$5$$!#(B
$B%I%-%e%a%s%H$G8@$&$H!"0J2<$N$H$3$m$K=q$-J}$,=q$$$F$"$j$^$9!#(B
$B!!!!(Bhttp://s2dao.seasar.org/ja/s2dao-tiger.html#ArgsAnnotation
"tanaka @MSN" wrote:
> noy$B$H?=$7$^$9!#(B
>
> Dolteng(Teeda+S2Dao)$B$rMxMQ$7$F3+H/$r9T$C$F$$$^$9!#(B
> S2DaoTiger$B$N(BQuery$B%"%N%F!<%7%g%s$r;HMQ$7$F!"(BWHERE$B6g$r<[E-MAIL ADDRESS DELETED]@.$r9T$*$&$H$7$F$$(B
>
> $B$^$9!#(B
>
> $B-!(B @Query(" nUserNo = ? AND LEFT(vcCalc_YYMMDD,6) = ? ORDER BY
> vcCalc_YYMMDD")
> public TTimecard[] selectByUserNo(Integer nuserno,String calcdate);
>
> $B-"(B @Query("nUserNo = /*nuserno*/315 /*IF calcdate != null*/AND
> LEFT(vcCalc_YYMMDD,6) = /*calcdate*/'200607'/*END*/")
> public TTimecard[] selectByUserNo(Integer nuserno,String calcdate);
>
> $B-!$N;~$O!"4|BT7k2L$I$*$j(BWHERE$B6g$[E-MAIL ADDRESS DELETED]@.$,$5$l$^$9!#(B
> $B!J-!$N<B9T;~!"H4?h%m%0!K(B
> DEBUG 2007-08-02 11:58:31,375 [http-8080-Processor25] $B%H%i%s%6%/%7%g%s$r3+;O(B
>
> $B$7$^$7$?(B
> DEBUG 2007-08-02 11:58:31,375 [http-8080-Processor25] BEGIN
> tms.dao.TTimecardDao#selectByUserNo(315, 200708)
> DEBUG 2007-08-02 11:58:31,415 [http-8080-Processor25] $BJ*M}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 11:58:31,425 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 11:58:31,425 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 11:58:31,425 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 11:58:31,425 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 11:58:31,425 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 11:58:31,615 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 11:58:31,635 [http-8080-Processor25] SELECT
> tmsdev.T_TimeCard.nuserno, tmsdev.T_TimeCard.vcnote,
> tmsdev.T_TimeCard.ntimecardno, tmsdev.T_TimeCard.dtstarttime,
> tmsdev.T_TimeCard.dtfinishtime, tmsdev.T_TimeCard.nrest,
> tmsdev.T_TimeCard.dtlatetime, tmsdev.T_TimeCard.dtleavetime,
> tmsdev.T_TimeCard.vccalc_yymmdd FROM tmsdev.T_TimeCard WHERE nUserNo = 315
> AND LEFT(vcCalc_YYMMDD,6) = '200708' ORDER BY vcCalc_YYMMDD
> DEBUG 2007-08-02 11:58:31,635 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 11:58:31,635 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 11:58:31,635 [http-8080-Processor25] END
> tms.dao.TTimecardDao#selectByUserNo(315, 200708) :
> [tms.entity.TTimecard$$EnhancedByS2AOP$$[E-MAIL ADDRESS DELETED],
> tms.entity.TTimecard$$EnhancedByS2AOP$$[E-MAIL ADDRESS DELETED]]
> DEBUG 2007-08-02 11:58:31,635 [http-8080-Processor25] $B%H%i%s%6%/%7%g%s$r%3(B
> $B%_%C%H$7$^$7$?(B
>
> $B-"$N;~$O!"(BSQL$B%3%a%s%H$NJQ?t$KCM$,>e<j$/F~$i$:(BNull$B$G=hM}$5$l$F$7$^$$$^$9!#(B
> $BCM$O4V0c$$$J$/EO$C$F$-$F$$$k$H$O;W$&$N$G$9$,!"$J$<$+(BSQL$B%3%a%s%H$G=hM}$5$l$J(B
>
> $B$$$N$G$9!#(B
> $B!J-"$N<B9T;~!"H4?h%m%0!K(B
> DEBUG 2007-08-02 12:00:33,711 [http-8080-Processor25] $B%H%i%s%6%/%7%g%s$r3+;O(B
>
> $B$7$^$7$?(B
> DEBUG 2007-08-02 12:00:33,711 [http-8080-Processor25] BEGIN
> tms.dao.TTimecardDao#selectByUserNo(315, 200708)
> DEBUG 2007-08-02 12:00:33,711 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:00:33,711 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 12:00:33,711 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:00:33,711 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:00:33,711 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 12:00:33,871 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> WARN 2007-08-02 12:00:33,881 [http-8080-Processor25] $B0z?t(B(nuserno)$B$,8+$D$+(B
>
> $B$j$^$;$s(B
> WARN 2007-08-02 12:00:33,881 [http-8080-Processor25] $B0z?t(B(nuserno)$B$,8+$D$+(B
>
> $B$j$^$;$s(B
> WARN 2007-08-02 12:00:33,881 [http-8080-Processor25] $B0z?t(B(calcdate)$B$,8+$D$+(B
>
> $B$j$^$;$s(B
> DEBUG 2007-08-02 12:00:33,881 [http-8080-Processor25] SELECT
> tmsdev.T_TimeCard.nuserno, tmsdev.T_TimeCard.vcnote,
> tmsdev.T_TimeCard.ntimecardno, tmsdev.T_TimeCard.dtstarttime,
> tmsdev.T_TimeCard.dtfinishtime, tmsdev.T_TimeCard.nrest,
> tmsdev.T_TimeCard.dtlatetime, tmsdev.T_TimeCard.dtleavetime,
> tmsdev.T_TimeCard.vccalc_yymmdd FROM tmsdev.T_TimeCard WHERE nUserNo = null
>
>
> DEBUG 2007-08-02 12:00:33,891 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:00:33,901 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 12:00:33,901 [http-8080-Processor25] END
> tms.dao.TTimecardDao#selectByUserNo(315, 200708) : []
> DEBUG 2007-08-02 12:00:33,901 [http-8080-Processor25] $B%H%i%s%6%/%7%g%s$r%3(B
> $B%_%C%H$7$^$7$?(B
>
> $B8x<0$N%j%U%!%l%s%9$K$O!"(BQuery$B%"%N%F!<%7%g%s$G$b(B
> SQL$B%3%a%s%H$,;HMQ$G$-$k$H$"$C$?$N$G$9$,!"2?$+%"%N%F!<%7%g%s(BorSQL$B%3%a%s%H$N5-(B
>
> $B=R$KITHw$,$"$k$N$G$7$g$&$+!)!)(B
> $B$A$J$_$K!"(B
>
> $B-#(B @Query("nUserNo = /*ent.nuserno*/315 /*IF ent.vccalcYymmdd != null*/AND
> LEFT(vcCalc_YYMMDD,6) = /*ent.vccalcYymmdd*/'200607'/*END*/")
> public TTimecard[] selectByUserNo(TTimecard ent);
>
> $B$3$N$h$&$K(Bentity$B$r;H$&%1!<%9$@$H4|BTDL$j!"-!$N$h$&$KCM$,E,MQ$5$l$F$$$k$N$,%m(B
>
> $B%0$+$i3NG'$G$-$^$7$?!#(B
>
> $B!J-#$N<B9T;~!"H4?h%m%0!K(B
> DEBUG 2007-08-02 12:07:55,957 [http-8080-Processor25] $B%H%i%s%6%/%7%g%s$r3+;O(B
>
> $B$7$^$7$?(B
> DEBUG 2007-08-02 12:07:55,957 [http-8080-Processor25] BEGIN
> tms.dao.TTimecardDao#selectByUserNo([E-MAIL ADDRESS DELETED])
> DEBUG 2007-08-02 12:07:55,957 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:07:55,957 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 12:07:55,957 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:07:55,957 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:07:55,957 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 12:07:56,117 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 12:07:56,127 [http-8080-Processor25] SELECT
> tmsdev.T_TimeCard.nuserno, tmsdev.T_TimeCard.vcnote,
> tmsdev.T_TimeCard.ntimecardno, tmsdev.T_TimeCard.dtstarttime,
> tmsdev.T_TimeCard.dtfinishtime, tmsdev.T_TimeCard.nrest,
> tmsdev.T_TimeCard.dtlatetime, tmsdev.T_TimeCard.dtleavetime,
> tmsdev.T_TimeCard.vccalc_yymmdd FROM tmsdev.T_TimeCard WHERE nUserNo = 315
> AND LEFT(vcCalc_YYMMDD,6) = '200708'
> DEBUG 2007-08-02 12:07:56,127 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $B<hF@$7$^$7$?(B
> DEBUG 2007-08-02 12:07:56,137 [http-8080-Processor25] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r(B
>
> $BJD$8$^$7$?(B
> DEBUG 2007-08-02 12:07:56,137 [http-8080-Processor25] END
> tms.dao.TTimecardDao#selectByUserNo([E-MAIL ADDRESS DELETED]) :
> [tms.entity.TTimecard$$EnhancedByS2AOP$$[E-MAIL ADDRESS DELETED],
> tms.entity.TTimecard$$EnhancedByS2AOP$$[E-MAIL ADDRESS DELETED]]
> DEBUG 2007-08-02 12:07:56,137 [http-8080-Processor25] $B%H%i%s%6%/%7%g%s$r%3(B
> $B%_%C%H$7$^$7$?(B
>
>
> $B$J$<$3$N$h$&$J0c$$$,5/$3$k$N$G$7$g$&$+!)!)(B
> $B$465<xD:$1$l$P$H;W$$$^$9!#(B
>
> S2Dao$B$N%P!<%8%g%s$O(BS2Dao 1.0.45$B!"(BS2DaoTiger$B$O(B1.0.40$B$G$9!#(B
> $B$A$J$_$K!"(BS2Dao 1.0.40$B$G$bF1MM$N8=>]$K$J$j$^$7$?!#(B
>
> $B$h$m$7$/$*4j$$CW$7$^$9!#(B
>
> $B0J>e$G$9!#(B
>
> _________________________________________________________________
> $BG.$$%i%$%V1GA|$,L5NA!*(BBON JOVI$B!"(BRED HOT CHILI PEPPERS$B!"(BLINKIN PARK$BB>(B
>
> http://liveearth.jp.msn.com/
>
>
Seasar-user メーリングリストの案内