[seasar-dotnet:1610] Re: 外だしＳＱＬについて

2010年 3月 18日 (木) 22:37:23 JST

$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