[seasar-dotnet:1612] Re: 外だしＳＱＬについて
笹木 悠壱
[E-MAIL ADDRESS DELETED]
2010年 3月 19日 (金) 00:08:05 JST
$BF#0fMM(B
$B$*@$OC$K$J$C$F$*$j$^$9!#:{LZ$G$9!#(B
$[E-MAIL ADDRESS DELETED]!"5WJ]MM$K$4Js9p$5$;$F$$$?$@$$$?FbMF$G(B
$B2?$+$*J,$+$j$K$J$j$^$7$?$i!"9,$$$G$9!#(B
$B0J>e!"59$7$/$*4j$$?=$7>e$2$^$9!#(B
$B:{LZ(B
----- Original Message -----
From: "Hiroaki Fujii" <[E-MAIL ADDRESS DELETED]>
To: <[E-MAIL ADDRESS DELETED]>
Sent: Thursday, March 18, 2010 10:37 PM
Subject: [seasar-dotnet:1610] Re: $B30$@$7#S#Q#L$K$D$$$F(B
> $BF#0f$G$9!#(B
>
> $B2~$a$F!"(BOracle11g$B!"(BS2Container.NET1.3.17$B$G3NG'$$$?$7$^$7$?!#(B
> $B%F!<%V%k$r:FEY:n$jD>$7$F(BSQLPlus$B$G<B9T$9$k$H!"$-$A$s$H(B2$B7o$H(B
> $B%R%C%H$7$^$7$?!#(B
> $B$"$l!"(BOracle10g$B$+$i(B11g$B$K$J$C$F5sF0$,JQ$o$C$?!)2?$+4V0c$($?$+$J!)(B
>
> $B$=$N>e$G!"%a!<%k$NDL$j%3!<%I$b5-=R$7!"30$@$7(BSQL$BJ8$bF1$8$h$&$K(B
> $B:n$C$F$_$^$7$?$,!"$-$A$s$H(BS2DAO.NET$B$O(B2$B7o!"5"$C$F$-$^$7$?!#(B
> $B%a!<%k$N%3%T%Z$G:n$C$?$o$1$G$O$"$j$^$;$s$,!"2?$,1F6A$7$F$&$^$/(B
> $B5"$C$F$3$J$$$N$+!"$o$+$i$J$$>u67$G$9!#(B
>
> $B$5$i$K!"2?$+>pJs$rDs6!$$$?$@$1$?$i!"2?$+$o$+$k$+$b$7$l$^$;$s!#(B
>
>
>
> $B:{LZ!!M*0m(B $B$5$s$O=q$-$^$7$?(B:
>> $BF#0fMM(B
>>
>> $B$*@$OC$K$J$C$F$*$j$^$9!#:{LZ$G$9!#(B
>>
>> $B$43NG'$$$?$@$-!"$"$j$,$H$&$4$6$$$^$9!#(B
>> $B$4;XE&$$$?$@$$$?E@$rF'$^$($F!":FEY8!>Z$7$F$_$^$7$?!#(B
>>
>> $B$^$:!"(BS2Dao.NET$BMQ$N%$%s%?!<%U%'%$%9$N=q$-J}$K8m$j$O$4$6$$$^$;$s$G$7$?!#(B
>> $B$^$?!"%$%s%?!<%U%'%$%9$H%F!<%V%k$K$D$$$F!"(B2$B%P%$%HJ8;z!"4A;zEy$r;HMQ$;$:$K(B
>> $B<B9T$7$F$_$^$7$?$,!"7k2L$OF1$8$G$7$?!#(B
>> $B!J7k2L$O2<5-$NDL$j$G$9!#!K(B
>>
>> $B$=$l$+$i!"(BSQL$BJ8<+BN$O$3$l$GDL$j$^$9!#(B
>> WHERE$B6g$NCf$N(BAND$B$r(BOR$B$KJQ$($F<B9T$7$?>l9g!"(Bsqlplus$B$G(B3$B7o5"$C$F$-$F$7$^$$$^(B
>> $B$9!#(B
>> $B!J7k2L$O2<5-$NDL$j$G$9!#!K(B
>>
>>
>> $B"#%F!<%V%k(B
>> $B!&%F!<%V%kL>(B
>> $B!!!!(BM_LESSON
>> $B!&%U%#!<%k%I(B
>> $B!!!!(BTENPO$B!!!!(BNUMBER(3,0)$B!!!J(BPK$B!K(B
>> $B!!!!(BDATE $B!!!!(BVARCHAR2(8)$B!!!J(BPK$B!K(B
>> $B!!!!(BSTART$B!!!!(BVARCHAR2(4)$B!!!J(BPK$B!K(B
>> $B!!!!(BEND$B!!!!!!(BVARCHAR2(4)
>> $B!!!!(BCOURSE $B!!(BVARCHAR2(6)
>>
>> $B"#>e5-%F!<%V%kFb$N%l%3!<%I(B
>> $B!!(B1,"20100301","1000","1100","T$B=i5i(B"
>> $B!!(B1,"20100301","1100","1200","T$BCf5i(B"
>> $B!!(B1,"20100301","1200","1300","T$B>e5i(B"
>>
>> $B"#<B9T-!!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ!K(B
>>
>> SELECT *
>> FROM M_LESSON
>> WHERE COURSE >= /*pmb.CourseFrom*/
>> AND COURSE <= /*pmb.CourseTo*/
>>
>> $B%Q%i%a!<%?CM(B
>> $B!!(Bpmb.CourseFrom$B"*(B'T$B=i5i(B'
>> $B!!(Bpmb.CourseTo$B"*(B'T$B>e5i(B'
>>
>> $B"M8!:w7k2L$O!"%l%3!<%I$J$7$H$J$j$^$9!#(B
>>
>> $B!J#S#Q#L%m%0!K(B
>> Seasar.Extension.ADO.Impl.BasicSelectHandler: 2010-03-18 10:04:40,480
>> [1] DEBUG Seasar.Framework.Log.Logger Debug - SELECT *
>> FROM M_LESSON
>> WHERE COURSE >= 'T$B=i5i(B'
>> AND COURSE <= 'T$B>e5i(B'
>>
>> $B"#<B9T-"!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ$r$7$J$$!K(B
>>
>> SELECT *
>> FROM M_LESSON
>> WHERE COURSE >= 'T$B=i5i(B'
>> AND COURSE <= 'T$B>e5i(B'
>>
>> $B"M8!:w7k2L$O!"%l%3!<%I#27o$H$J$j$^$9!#(B
>> $B!!(B1,"20100301","1000","1100","T$B=i5i(B"
>> $B!!(B1,"20100301","1200","1300","T$B>e5i(B"
>>
>> $B"#(BDao$B%$%s%?!<%U%'%$%9(B
>>
>> [Bean(typeof(CourseInfo))]
>> public interface ICourseDao
>> {
>> IList<CourseInfo> SelectCourse(CoursePmb pmb);
>> }
>>
>> [System.Serializable]
>> public class CourseInfo
>> {
>> string _Course;
>>
>> public string Course
>> {
>> get { return _Course; }
>> set { _Course = value; }
>> }
>> }
>>
>> [System.Serializable]
>> public class CoursePmb
>> {
>> string _CourseFrom;
>>
>> public string CourseFrom
>> {
>> get { return _CourseFrom; }
>> set { _CourseFrom = value; }
>> }
>>
>> string _CourseTo;
>>
>> public string CourseTo
>> {
>> get { return _CourseTo; }
>> set { _CourseTo = value; }
>> }
>> }
>>
>> $B"#(Bsqlplus$B$G$N<B9T7k2L(B
>> SQL> select * from M_LESSON where COURSE >= 'T$B=i5i(B' and COURSE <= 'T$B>e5i(B';
>>
>> TENPO DATE STAR END COURSE
>> ---------- -------- ---- ---- ------
>> 1 20100301 1000 1100 T$B=i5i(B
>> 1 20100301 1200 1300 T$B>e5i(B
>>
>> SQL> select * from M_LESSON where COURSE >= 'T$B=i5i(B' or COURSE <= 'T$B>e5i(B';
>>
>> TENPO DATE STAR END COURSE
>> ---------- -------- ---- ---- ------
>> 1 20100301 1000 1100 T$B=i5i(B
>> 1 20100301 1100 1200 T$BCf5i(B
>> 1 20100301 1200 1300 T$B>e5i(B
>>
>> $B0J>e!"59$7$/$*4j$$?=$7>e$2$^$9!#(B
>>
>> $B:{LZ(B
>>
>> ----- Original Message ----- From: "Hiroaki Fujii"
>> <[E-MAIL ADDRESS DELETED]>
>> To: <[E-MAIL ADDRESS DELETED]>
>> Sent: Wednesday, March 17, 2010 10:52 PM
>> Subject: [seasar-dotnet:1605] Re: $B30$@$7#S#Q#L$K$D$$$F(B
>>
>>
>>> $BF#0f$G$9!#(B
>>>
>>> $B40A4$K0l=o$G$O$J$$$N$G$9$,!"(BOracle10gXE$B!"(BODP$B!"(BQuill$B$,(B1.3.17$B$N(B
>>> $B4D6-$G<B9T$7$^$7$?$,!":F8=$7$^$;$s$G$7$?!#(B
>>>
>>> $B$b$&>/$7D4$Y$kA0$K!"$*4j$$$J$N$G$9$,!"(BS2Dao.NET$BMQ$N%$%s%?!<%U%'%$%9$N(B
>>> $B=q$-J}$O4V0c$($F$$$k$3$H$O$J$$$G$7$g$&$+!)(B
>>> $B0z?t$d(B2$B%P%$%HJ8;z$N4A;z$d(B1$B%P%$%HJ8;z$r%W%m%Q%F%#$J$I$G:.:_$7$F(B
>>> $B;H$o$l$F$$$k$h$&$G$9$,!"$3$l$i$r4V0c$($F;H$C$F$$$k$3$H$O$J$$(B
>>> $B$G$7$g$&$+!)(B
>>>
>>> $B$=$l$H!"(BSQL$BJ8$b$3$l$GK\Ev$KDL$k$+3NG'$r$*4j$$$7$^$9!#(B
>>> WHERE$B6g$NCf$N(BAND$B$r(BOR$B$KJQ$($?$i(Bsqlplus$B$G(B2$B7o5"$C$F$-$^$7$?!#(B
>>>
>>> $B3NG'$r$*4j$$$$$?$7$^$9!#(B
>>>
>>>
>>> $B-j%M%9%F%#!!:{LZ!!M*0m(B $B$5$s$O=q$-$^$7$?(B:
>>>> $B$O$8$a$^$7$F!#(B
>>>> $B:{LZ$H?=$7$^$9!#(B
>>>>
>>>> $B30$@$7#S#Q#L$K$D$$$F<ALd$5$;$F2<$5$$!#(B
>>>> $B%Q%i%a!<%?%3%a%s%H$KA43QJ8;z$r;XDj$9$k$H!"(B
>>>> $BA[Dj$5$l$k7k2L$r<hF@$G$-$J$$$3$H$,$"$j$^$9!#(B
>>>>
>>>> $B%Q%i%a!<%?%3%a%s%H$r;HMQ$;$:$K!"D>@\=q$-9~$s$G(B
>>>> $B<B9T$7$?>l9g$O!";W$C$?$H$*$j$N7k2L$r<hF@$G$-$^$9!#(B
>>>>
>>>> $B2?$[E-MAIL ADDRESS DELETED]$,I,MW$J$N$G$7$g$&$+!)(B
>>>> $B0J2<!"<B9TFbMF$G$9!#(B
>>>>
>>>> $B"#3+H/4D6-(B
>>>> $B!!(BOS:WindowsXP
>>>> $B!!(BVisualStudio2008
>>>> $B!!(B.NetFrameWork3.5
>>>> $B!!(BOracle11g(OS:Windos2008)
>>>> $B!!(BS2Container.NET 1.3.17.0
>>>> $B!!(BS2Dao.NET 1.3.17.0
>>>>
>>>> $B"#%F!<%V%k(B
>>>> $B!&%F!<%V%kL>(B
>>>> $B!!!!(BM_$B%l%C%9%s(B
>>>> $B!&%U%#!<%k%I(B
>>>> $B!!!!E9J^!!!!!!(BNUMBER(3,0)$B!!!J(BPK$B!K(B
>>>> $B!!!!F|IU!!!!!!(BVARCHAR2(8)$B!!!J(BPK$B!K(B
>>>> $B!!!!3+;O;~9o!!(BVARCHAR2(4)$B!!!J(BPK$B!K(B
>>>> $B!!!!=*N;;~9o!!(BVARCHAR2(4)
>>>> $B!!!!%3!<%9!!!!(BVARCHAR2(6)
>>>>
>>>> $B"#>e5-%F!<%V%kFb$N%l%3!<%I(B
>>>> $B!!(B1,"20100301","1000","1100","T$B=i5i(B"
>>>> $B!!(B1,"20100301","1100","1200","T$BCf5i(B"
>>>> $B!!(B1,"20100301","1200","1300","T$B>e5i(B"
>>>>
>>>> $B"#<B9T-!!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ!K(B
>>>>
>>>> SELECT *
>>>> FROM M_$B%l%C%9%s(B
>>>> WHERE $B%3!<%9(B >= /*pmb.$B%3!<%9(BFROM*/
>>>> AND $B%3!<%9(B <= /*pmb.$B%3!<%9(BTO*/
>>>>
>>>> $B%Q%i%a!<%?CM(B
>>>> $B!!(Bpmb.$B%3!<%9(BFROM$B"*(B'T$B=i5i(B'
>>>> $B!!(Bpmb.$B%3!<%9(BTO$B"*(B'T$B>e5i(B'
>>>>
>>>> $B"M8!:w7k2L$O!"%l%3!<%I$J$7$H$J$j$^$9!#(B
>>>>
>>>> $B!J#S#Q#L%m%0!K(B
>>>> Seasar.Extension.ADO.Impl.BasicSelectHandler: 2010-03-17 12:01:30,400
>>>> [1] DEBUG Seasar.Framework.Log.Logger Debug - SELECT *
>>>> FROM M_$B%l%C%9%s(B
>>>> WHERE $B%3!<%9(B >= 'T$B=i5i(B'
>>>> AND $B%3!<%9(B <= 'T$B>e5i(B'
>>>>
>>>> $B"#<B9T-"!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ$r$7$J$$!K(B
>>>>
>>>> SELECT *
>>>> FROM M_$B%l%C%9%s(B
>>>> WHERE $B%3!<%9(B >= 'T$B=i5i(B'
>>>> AND $B%3!<%9(B <= 'T$B>e5i(B'
>>>>
>>>> $B"M8!:w7k2L$O!"%l%3!<%I#27o$H$J$j$^$9!#(B
>>>> $B!!(B1,"20100301","1000","1100","T$B=i5i(B"
>>>> $B!!(B1,"20100301","1200","1300","T$B>e5i(B"
>>>>
>>>> $B#S#Q#L%D!<%k$G<B9T$7$?>l9g$O!"7k2L-"$HF1$8$G$9!#(B
>>>> $B<B9T-!$G!"<B9T-"$HF1$87k2L$r<hF@$9$k$?$a$K$O(B
>>>> $B$I$&$$$C$?@_Dj$,I,MW$J$N$G$7$g$&$+!)(B
>>>>
>>>> $B0J>e!"59$7$/$*4j$$?=$7>e$2$^$9!#(B
>>>>
>>>> $B:{LZ(B
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> seasar-dotnet mailing list
>>>> [E-MAIL ADDRESS DELETED]
>>>> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>>>
>>>
>>
>>
>> --------------------------------------------------------------------------------
>>
>>
>>
>>> _______________________________________________
>>> seasar-dotnet mailing list
>>> [E-MAIL ADDRESS DELETED]
>>> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> seasar-dotnet mailing list
>> [E-MAIL ADDRESS DELETED]
>> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>
>
--------------------------------------------------------------------------------
> _______________________________________________
> seasar-dotnet mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>
seasar-dotnet メーリングリストの案内