[Seasar-user:9632] S2Dao-TigerにおけるQueryアノテーションについて
tanaka @MSN
[E-MAIL ADDRESS DELETED]
2007年 8月 2日 (木) 12:16:00 JST
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
_________________________________________________________________
$B?&>l$G$N%a%C%;%s%8%c!<3hMQ=Q$rA4(B5$BOC$G$4>R2p(B
http://messenger.live.jp/oshigoto/index.htm
Seasar-user メーリングリストの案内