[Seasar-user:9432] Re: [S2Dao] Javaのデータ型のプロパティでの検索結果について

[山下 真里]

$B$"$j$,$H$&$4$6$$$^$9!#(B

$BK\4VMM!"$42sEz$"$j$,$H$&$4$6$$$^$9!#(B

$B;d$,!"%=!<%9$rE:IU$7$J$$$P$+$j$K$4LBOG$r$*$+$1$7$F$*$j$^$9!#(B
$BK\EDMM$h$j!"$$$?$@$-$^$7$?%3!<%I$H$O0c$$$^$9$,!"(B
$B;d$NJ}$G$b!"2<5-$N$h$&$J%3!<%I$G;n$;$F$$$?$@$$$F$*$j$^$7$?!#(B

final Calendar c = Calendar.getInstance();
c.clear();
c.set(2007, 8, 11);
Date days = c1.getTime();

$BK\EDMM$h$j!"%"%I%P%$%9$7$?%3!<%I$G$b;n$5$;$F$$$?$@$-$^$7$?!#(B

final Calendar c = Calendar.getInstance();
c.clear();
c.set(Calendar.YEAR, 2007);
c.set(Calendar.MONTH, Calendar.JULY);
c.set(Calendar.DAY_OF_MONTH, 25);
final Date days = c.getTime(); // $B$3$N(Bdays$B$r(BselectDaysBetween$B$KEO$9(B

$B7k2L$O!"JQ$o$i$:$KCM$,<hF@$G$-$^$;$s$G$7$?!#(B
$B%"%I%P%$%9$r$$$?$@$-$^$7$?%a!<%k$NCf$G!"(B
(I"(B?(I#$B$X%P%$%s%I$r9T$C$F$$$k$H$$$&$3$H$G$7$?!#(B
$B%m%0$r8+$F$$$F5$$E$$$?$N$G$9$,!"<B:]$K$O!"(B
(Wed Jul 25 00:00:00 JST 2007) $B$,%P%$%s%I$5$l$F$$$k$N$G$O(B
$B$J$$$+$H!"21B,$7$F$7$^$$$^$7$?!#(B

$BBgJQ?=$7Lu$4$6$$$^$;$s$,!"$4;XE&$*4j$$$$$?$7$^$9!#(B

$B;32<!!??N$(B



-- $B%H%l!<%9%m%0(B
DEBUG 2007-07-25 14:53:06,000 [http-8080-3] SELECT control.rd, control.days, control.rnum FR

OM control WHERE days = '2007-07-25'
DEBUG 2007-07-25 14:53:06,000 [http-8080-3] $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B
DEBUG 2007-07-25 14:53:06,000 [http-8080-3] END net.test.ControlDao#selectDays(Wed Jul 25 00
:00:00 JST 2007) : []


----- Original Message ----- 
$BAw?.<T(B: Hirotaka HONMA<[E-MAIL ADDRESS DELETED]>
$[E-MAIL ADDRESS DELETED](B: [E-MAIL ADDRESS DELETED]
$BF|IU(B:Wednesday, July, 25, 2007, 03:47 PM
$B7oL>(B: [Seasar-user:9428] Re:[S2Dao] Java$B$N%G!<%?7?$N%W%m%Q%F%#$G$N8!:w7k2L$K$D$$$F(B

> 
> 
> $BK\4V!w3}>lD.$G$9!#(B
> 
> on 25 Jul 2007 15:21:59 +0900
> in [Seasar-user:9426] [S2Dao] Java$B$N%G!<%?7?$N%W%m%Q%F%#$G$N8!:w7k2L$K$D$$$F(B
> $B;32<!!??N$(B <[E-MAIL ADDRESS DELETED]> wrote:
> 
> > MySQL$B$N(BDate$B7?$N%+%i%`$KBP$7$F!"(B
> > Java$B$N(BDate$B7?$G8!:w$7$?>l9g$K!"(B1$B7o0J>e%R%C%H$9$k%G!<%?$,(B
> > $B%G!<%?$r<hF@$G$-$^$;$s$G$7$?!#(B
> > $B%m%0$K=PNO$5$l$F$$$k(BSQL$B$rMxMQ$7$F!"%3%^%s%I%i%$%s$+$i(B
> > SQL$B$rN.$7$F$_$k$H!"(B1$B7o0J>e%R%C%H$7$F%G!<%?$,<hF@$5$l$^$9!#(B
> 
> selectDaysBetween$B$N0z?t$KEO$7$F$$$k(Bjava.util.Date$B$,!";~J,IC(B
> $B%_%jIC$NCM$r;}$C$F$$$k$N$G$O(B? $B$H?dB,$7$^$9!#(B
> ($B%G!<%?%Y!<%9B&$O!VG/7nF|!W$J$N$K!"(BWHERE$B6g$O!VG/7nF|;~J,IC%_(B
> $B%jIC!W$G$"$k$?$a!"(BWHERE$B$,%R%C%H$7$J$$$N$+$H!#(B)
> 
> $B0z?t(Bdays$B$N!";~J,IC%_%jIC$NCM$r%<%m$K$7$FD:$1$^$9$+(B?
> 
>   final Calendar c = Calendar.getInstance();
>   c.clear();
>   c.set(Calendar.YEAR, 2007);
>   c.set(Calendar.MONTH, Calendar.JULY);
>   c.set(Calendar.DAY_OF_MONTH, 25);
>   final Date days = c.getTime(); // $B$3$N(Bdays$B$r(BselectDaysBetween$B$KEO$9(B
> 
> $B$h$m$7$/$*4j$$$7$^$9!#(B
> 
> > $B;d$NM}2r$,ITB-$7$k$N$+$H;W$$$^$9$,!"%H%l!<%9%m%0$K=PNO$5$l$F$$$k(B
> > SQL$B$H<B:]$K!"<B9T$5$l$F$$$k(BSQL$BJ8$O0l=o$J$N$G$7$g$&$+!)(B
> 
> $B%m%0$K=PNO$7$F$$$k(BSQL$BJ8$O?M4V$,L\$G8+$F3NG'$9$k$?$a$N$b$N(B
> $B$G!"<B:]$KH/9T$5$l$k(BSQL$BJ8$H$O0c$&$b$N$G$9!#(B
> 
> $B<B:]$K$O!"(B
> 
>   SELECT control.rd, control.days, control.rnum FROM control WHERE days = ?
> 
> $B$H$$$&(BSQL$BJ8$+$i(BPreparedStatement$B$r9=C[$7!"(B"?"$B$X0z?t(Bdays$B$r%P(B
> $B%$%s%I$9$k!"$H$$$&F0:n$r$7$F$$$^$9!#(B
> 
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>