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

[山下 真里]

$B$*@$OC$K$J$C$F$*$j$^$9!#(B

$B;32<(B $B??N$$G$9!#(B

$B860x$,J,$j$^$7$?!#(B
Dao$BB&$H8F$S=P$7$b$H$N(BDate$B7?$r!"(Bjava.util.Date$B7?$+$i(Bjava.sql.Date$B$KJQ49$7$?$i!"(B
$B%G!<%?$,<hF@$G$-$^$7$?!#(B

c1.clear();
c1.set(Calendar.YEAR, 2007);
c1.set(Calendar.MONTH, 8);
c1.set(Calendar.DAY_OF_MONTH, 25);

java.util.Date t1 = c1.getTime();
Date days = new Date(t1.getTime());

Select$B$H$OJL7o$G$9$,!"(BEntry$B%/%i%94XO"$,!"(Bjava.util.Date$B$G!"(B
Dao$B%$%s%?!<%U%'!<%9$,(Bjava.sql.Date$B$G$b(B
Insert$B$r$9$k$3$H$,$G$-$^$7$?!#(B

$B$*;~4V$r$$$?$@$-@?$K$"$j$,$H$&$4$6$$$^$7$?!#(B

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


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

> $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
> > 
>