<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=iso-2022-jp" http-equiv=Content-Type> <META name=GENERATOR content="MSHTML 8.00.6001.18783"> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT size=2 face="MS UI Gothic">$B$O$8$a$^$7$F!#(B<BR>$B:{LZ$H?=$7$^$9!#(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B30$@$7#S#Q#L$K$D$$$F<ALd$5$;$F2<$5$$!#(B<BR>$B%Q%i%a!<%?%3%a%s%H$KA43QJ8;z$r;XDj$9$k$H!"(B<BR>$BA[Dj$5$l$k7k2L$r<hF@$G$-$J$$$3$H$,$"$j$^$9!#(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B%Q%i%a!<%?%3%a%s%H$r;HMQ$;$:$K!"D>@\=q$-9~$s$G(B<BR>$B<B9T$7$?>l9g$O!";W$C$?$H$*$j$N7k2L$r<hF@$G$-$^$9!#(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B2?$+@_Dj$,I,MW$J$N$G$7$g$&$+!)(B<BR>$B0J2<!"<B9TFbMF$G$9!#(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B"#3+H/4D6-(B<BR>$B!!(BOS:WindowsXP<BR>$B!!(BVisualStudio2008<BR>$B!!(B.NetFrameWork3.5<BR>$B!!(BOracle11g(OS:Windos2008)<BR>$B!!(BS2Container.NET 1.3.17.0<BR>$B!!(BS2Dao.NET 1.3.17.0</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B"#%F!<%V%k(B<BR>$B!&%F!<%V%kL>(B<BR>$B!!!!(BM_$B%l%C%9%s(B<BR>$B!&%U%#!<%k%I(B<BR>$B!!!!E9J^!!!!!!(BNUMBER(3,0)$B!!!J(BPK$B!K(B<BR>$B!!!!F|IU!!!!!!(BVARCHAR2(8)$B!!!J(BPK$B!K(B<BR>$B!!!!3+;O;~9o!!(BVARCHAR2(4)$B!!!J(BPK$B!K(B<BR>$B!!!!=*N;;~9o!!(BVARCHAR2(4)<BR>$B!!!!%3!<%9!!!!(BVARCHAR2(6)</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B"#>e5-%F!<%V%kFb$N%l%3!<%I(B<BR>$B!!(B1,"20100301","1000","1100","T$B=i5i(B"<BR>$B!!(B1,"20100301","1100","1200","T$BCf5i(B"<BR>$B!!(B1,"20100301","1200","1300","T$B>e5i(B"</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B"#<B9T-!!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ!K(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">SELECT *<BR>  FROM M_$B%l%C%9%s(B<BR> WHERE $B%3!<%9(B >= /*pmb.$B%3!<%9(BFROM*/<BR>   AND $B%3!<%9(B <= /*pmb.$B%3!<%9(BTO*/</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B%Q%i%a!<%?CM(B<BR>$B!!(Bpmb.$B%3!<%9(BFROM$B"*(B'T$B=i5i(B'<BR>$B!!(Bpmb.$B%3!<%9(BTO$B"*(B'T$B>e5i(B'</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B"M8!:w7k2L$O!"%l%3!<%I$J$7$H$J$j$^$9!#(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B!J#S#Q#L%m%0!K(B<BR>Seasar.Extension.ADO.Impl.BasicSelectHandler: 2010-03-17 12:01:30,400 [1] DEBUG Seasar.Framework.Log.Logger Debug - SELECT *<BR>  FROM M_$B%l%C%9%s(B<BR> WHERE $B%3!<%9(B >= 'T$B=i5i(B'<BR>   AND $B%3!<%9(B <= 'T$B>e5i(B'</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B"#<B9T-"!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ$r$7$J$$!K(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">SELECT *<BR>  FROM M_$B%l%C%9%s(B<BR> WHERE $B%3!<%9(B >= 'T$B=i5i(B'<BR>   AND $B%3!<%9(B <= 'T$B>e5i(B'</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B"M8!:w7k2L$O!"%l%3!<%I#27o$H$J$j$^$9!#(B<BR>$B!!(B1,"20100301","1000","1100","T$B=i5i(B"<BR>$B!!(B1,"20100301","1200","1300","T$B>e5i(B"</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B#S#Q#L%D!<%k$G<B9T$7$?>l9g$O!"7k2L-"$HF1$8$G$9!#(B<BR>$B<B9T-!$G!"<B9T-"$HF1$87k2L$r<hF@$9$k$?$a$K$O(B<BR>$B$I$&$$$C$?@_Dj$,I,MW$J$N$G$7$g$&$+!)(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B0J>e!"59$7$/$*4j$$?=$7>e$2$^$9!#(B</FONT></DIV> <DIV><FONT size=2 face="MS UI Gothic"></FONT> </DIV> <DIV><FONT size=2 face="MS UI Gothic">$B:{LZ(B</FONT></DIV></BODY></HTML>