[seasar-dotnet:1606] Re: 外だしＳＱＬについて
笹木 悠壱
[E-MAIL ADDRESS DELETED]
2010年 3月 18日 (木) 11:08:10 JST
$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$^$$$^$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 メーリングリストの案内