[Seasar-user:9635] [S2Dao-Tiger]Queryアノテーションについて(再送)

tanaka @MSN [E-MAIL ADDRESS DELETED]
2007年 8月 2日 (木) 12:40:28 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

_________________________________________________________________
$BG.$$%i%$%V1GA|$,L5NA!*(BBON JOVI$B!"(BRED HOT CHILI PEPPERS$B!"(BLINKIN PARK$BB>(B 
http://liveearth.jp.msn.com/ 




Seasar-user メーリングリストの案内