[seasar-dotnet:1639] Re: 外だしＳＱＬについて
Ryo Miyagi
[E-MAIL ADDRESS DELETED]
2010年 3月 29日 (月) 02:00:47 JST
$B5\>k$G$9!#(B
$B%l%9$NFbMF$rDI$$@Z$l$F$$$J$$$N$H!"LdBj$N2U=j$r8!>Z$G$-$F$$$J$$$N$G(B
$BJ,$+$kItJ,$K$D$$$F2sEz$$$?$7$^$9!#(B
>> $B$=$3$G!":F$S3NG'$5$;$F$$$?$@$-$?$$$N$G$9$,!"30$@$7#S#Q#L$N%P%$%s%IItJ,$NJ8;z%(%s%3!<%I$r(B
>> $B;XDj$9$[E-MAIL ADDRESS DELETED]$O(BSeasar$BB&$K$"$k$N$G$7$g$&$+!)(B
>S2Dao.NET$B$G$O!"(BSeasar.Extension.ADO.Types.BaseValueType
>$B$N(B BindValue() $B$G%P%$%s%I=hM}$r9T$C$F$$$k$O$:$G$9!#(B
$B%P%$%s%I=hM}$NItJ,$O!"5WJ]$5$s$N2sEz$NDL$j$G$9!#(B
s2container.net $B$N%G%U%)%k%H$G$O!"(B
BaseValueType $B$r7Q>5$7$?(B PrimitiveBaseType $B$r7Q>5$7$?(B StringType $B%/%i%9$G(B
$B%P%$%s%I$9$k7?$,(Bstring$B$N>l9g$N%P%$%s%I=hM}$r9T$C$F$$$^$9!#(B
$B=>$C$F!"(BStringType $B%/%i%9$rFH<+$K<BAu$7$F(B
Seasar.Extension.ADO.Types.ValueTypes#RegisterValueType(typeof(String),
new $BFH<+<BAu$7$?(BStringType$B%/%i%9(B);
$B%a%=%C%I$r%"%W%j%1!<%7%g%s$N5/F0;~$K8F$S=P$;$P!"(B
s2container.net$B$N%=!<%9$K=$@5$rF~$l$J$$$G(B
$B%P%$%s%I=hM}$rCV$-49$($k$3$H$,2DG=$G$9!#(B
$B$J$*!"(BSeasar.Extension.ADO.Types.BaseValueType $B%/%i%9$G$O!"(B
"OleDbCommand" $B$+$D(B DbType.String $B$r;HMQ$7$F$$$k$H$-$K(B
$BL@<(E*$K(B OleDbParameter $B$NCM$r(B OleDbType.VarChar $B$[E-MAIL ADDRESS DELETED]$7$F$$$^$9!#(B
($B3N$+!"(BOleDb $B7PM3$G@\B3$7$?$H$-$KLdBj$,H/@8$9$k(BDB Provider$B$,$"$C$?$N$G!"F~$l$?=hM}$@$C$?$H;W$$$^$9(B)
$B$b$7!"(BOleDb $B7PM3$G(BDB$B$K@\B3;XDjCN$k$J$i!"$3$N=hM}$,1F6A$7$F$$$k$+$b$7$l$^$;$s!#(B
$B$^$?!"$3$NLdBj$HD>@\4X78$J$$$H;W$$$^$9$,!"(B
SQL$B%U%!%$%k(B "$BA4BN(B" $B$NJ8;z%3!<%I$r;XDj$9$k$3$H$O2DG=$G$9!#(B
http://s2dao.net.seasar.org/ja/dicon.html#encoding
$BJdB-(B: $BFH<+<BAu$7$?(BStringType $B%/%i%9$N%5%s%W%k(B
$B"(%3%s%Q%$%k$rDL$7$F$$$J$$$N$G!"%(%i!<$,=P$k$+$b$7$l$^$;$s!#(B
public static int Main(string[] args) {
// $B%"%W%j%1!<%7%g%s5/F0;~$K!"FH<+<BAu$7$?(BStringType $B%/%i%9$r;XDj!#(B
Seasar.Extension.ADO.Types.ValueTypes#RegisterValueType(
typeof(String),
new MyApp.ADO.Types.MyStringType()
);
}
namespace MyApp.ADO.Types
{
public class MyStringType : IValueType
{
public virtual object GetValue(IDataReader reader, int index, Type type)
{
return GetValue(reader[index]);
}
public virtual object GetValue(IDataReader reader, string
columnName, Type type)
{
return GetValue(reader[columnName]);
}
public virtual object GetValue(IDataReader reader, int index)
{
return GetValue(reader[index]);
}
public virtual object GetValue(IDataReader reader, string columnName)
{
return GetValue(reader[columnName]);
}
public virtual void BindValue(IDbCommand cmd, string
columnName, object value)
{
BindValue(cmd, columnName, value, DbType.String);
}
public virtual BindValue(IDbCommand cmd, string columnName,
object value, DbType dbType)
{
BindValue(cmd, columnName, value, dbType, ParameterDirection.Input);
}
public virtual void BindValue(
IDbCommand cmd,
string columnName,
object value,
DbType dbType,
ParameterDirection direction
)
{
IDbDataParameter parameter = cmd.CreateParameter();
parameter.ParameterName = columnName;
// TODO: $B$3$3$G!"%P%$%s%I%Q%i%a!<%?$N=hM}$rJQ99$9$k(B
// $B6/@)E*$K(BSJIS$B$KJQ99$9$k$J$i!"(BdbType$B$O!"(BDbType.Object $B$K$9$k!)(B
// ODP.NET $B$r;H$C$F$$$k$J$i!"(BDbType.String $B$G$O$J$/!"(BODP.NET$B8GM-$N(B
OdpNetParameter? $B$r;XDj$7$F$_$k(B
parameter.DbType = dbType;
if ("OleDbCommand".Equals(cmd.GetType().Name) && dbType ==
DbType.String)
{
OleDbParameter oleDbParam = parameter as OleDbParameter;
oleDbParam.OleDbType = OleDbType.VarChar;
}
parameter.Value = GetBindValue(value);
parameter.Direction = direction;
cmd.Parameters.Add(parameter);
}
protected virtual object GetBindValue(object value)
{
if (value == null)
{
return DBNull.Value;
}
return value;
}
protected virtual object GetValue(object value)
{
if (value == DBNull.Value)
{
return null;
}
else if (value is string)
{
return value;
}
else
{
return value.ToString();
}
}
}
}
$B0J>e!#(B
2010$BG/(B3$B7n(B28$BF|(B17:48 kubo <[E-MAIL ADDRESS DELETED]>:
> $B5WJ](B(jflute)$B$G$9!#(B
>
> $B$+$J$j%d%^%+%s$J$N$G$9$,!"(B
> http://ml.seasar.org/archives/seasar-dotnet/2010-February/001556.html
> $B$3$NJU$NOC$,4XO"$7$?$j$7$J$$$+$J$H!#(B
>
> $B$$$:$l$K$;$h!"(BADO.NET$BC1BN$G$N(B
> $B:F8=%W%m%0%i%`$,$"$C$?J}$,NI$$$+$H;W$$$^$9!#(B
> ($B$=$l$r;H$C$F(BDbType$B$NJQ99$J$I$b8!>Z$G$-$k$+$H(B)
>
> 2010/3/28 kubo <[E-MAIL ADDRESS DELETED]>:
>> $B5WJ](B(jflute)$B$G$9!#(B
>>
>>> $B$G$9$N$G!"#D#B$N%(%s%3!<%I$rJQ$($k!"(BNVARCHAR$B$KJQ99(B
>>> $B$9$k$3$H$O!"8=>uFq$7$$$G$9!#$^$?!"$4Ds0F$$$?$@$$$?!"%F!<%V%k$K!V%l%Y%k!W(B
>>> $B$[E-MAIL ADDRESS DELETED]$1$kJ}K!$bFq$7$$$G$9!#(B
>>> $B%G!<%?%W%m%P%$%@$NJQ99$O;n$7$F$_$k2ACM$,$"$k$H;W$$$^$9$,!"(B
>>> $B$^$@8!>Z$7$F$*$j$^$;$s!#(BOracle$B$X$N3NG'$b$^$@9T$C$F$*$j$^$;$s!#(B
>>
>> $BBg5M$a$H$$$&$3$H$J$N$G!"8D?ME*$K$O%G!<%?%W%m%P%$%@$NJQ99$b(B
>> $B8=<BE*$G$O$J$$$G$9$M!#860x$rDO$`$H$$$&0UL#$G;n$92ACM$OBg$$$K$"$j$^$9$,!#(B
>>
>> $B2sHr$N<j$@$F$G$9$,!"$d$O$j860x$N>l=j$rFCDj$5$;$k$?$a$K!"(B
>>
>>> S2Dao.NET$B$H$$$&MW0x$[E-MAIL ADDRESS DELETED]$[E-MAIL ADDRESS DELETED]$K$9$k$?$a$K!"(B
>>> $B30$@$7(BSQL$B$NItJ,$r!V(BADO.NET$BD>@\MxMQ!W$G;n$7$F(B
>>> $B$_$k$HNI$$$G$9!#(B
>>
>> $B$^$:$O!"$3$l$r$r$d$C$F$_$?J}$,NI$$$+$H;W$$$^$9!#(B
>> ($B$b$7$d$C$F$$$?$i7k2L$r65$($FD:$1$P$H(B)
>> $B$$$-$J$j(BS2Dao.NET$B$N$I$3$rD>$9$r9M$($k$h$j!"(B
>> ADO.NET$BD>@\$G:F8=$5$;$F$+$i2sHr%]%$%s%H$,C5$7$?J}$,!"(B
>> S2Dao.NET$B$G$N=$@5%]%$%s%H$[E-MAIL ADDRESS DELETED]$K$J$j$d$9$$$+$H!#(B
>> ($B860x$,A4A38!F$0c$$$@$C$?$i;~4V$,$b$C$?$$$J$$$7(B)
>>
>>> $B$=$3$G!":F$S3NG'$5$;$F$$$?$@$-$?$$$N$G$9$,!"30$@$7#S#Q#L$N%P%$%s%IItJ,$NJ8;z%(%s%3!<%I$r(B
>>> $B;XDj$9$[E-MAIL ADDRESS DELETED]$O(BSeasar$BB&$K$"$k$N$G$7$g$&$+!)(B
>> S2Dao.NET$B$G$O!"(BSeasar.Extension.ADO.Types.BaseValueType
>> $B$N(B BindValue() $B$G%P%$%s%I=hM}$r9T$C$F$$$k$O$:$G$9!#(B
>>
>> $B$A$J$_$K!"%P%$%s%I=hM}$G%(%s%3!<%I$C$F$$$&35G0$,(B
>> $B$A$g$C$H;W$$Ev$?$i$J$$$N$G$9$,(B...
>> http://msdn.microsoft.com/ja-jp/library/system.data.idbdataparameter_members.aspx
>> IDbDataParameter$B$N%a%s%P$K$b%(%s%3!<%G%#%s%0$r(B
>> $B;XDj$9$k$b$N$O8+Ev$?$i$J$$$G$9$M(B...
>> C#$B>e$NJ8;zNs(B(String$B7?(B)$B$O(Bunicode$B$G07$o$l$F$k$O$:$J$N$G!"(B
>> Shift_JIS$B$KJQ493]$1$k$H$J$k$H!"(Bbyte$BG[Ns$G(BADO.NET$B$KEO$9$+!"(B
>> $B$d$O$j!"(BADO.NET$B$KBP$7$F%(%s%3!<%G%#%s%0$r;XDj$9$k(B
>> $B$h$&$J$d$jJ}$K$O$J$k$H;W$$$^$9!#(B($B$"$k$H$9$l$P(B)
>> (ODP$B$N%/%i%9$rD>@\MxMQ$9$l$P;XDj$G$-$?$j$9$k$H$+(B...!?!?)
>>
>> 2010/3/28 $B:{LZ!!M*0m(B <[E-MAIL ADDRESS DELETED]>:
>>> $B5WJ]MM(B
>>>
>>> $B:{LZ$G$9!#$*@$OC$K$J$j$^$9!#(B
>>> $B$9$$$^$;$s!"JV?.$,CY$/$J$j$^$7$?!#(B
>>>
>>> $B$^$:!"$3$N7o$G$9$,!"Hs>o$K%/%j%F%#%+%k$JLdBj$G$9!#(B
>>> $B3+H/$G(BSeasar$B$r;H$o$;$FD:$$$k$N$G$9$,!"8=:_3+H/$,Bg5M$a$r7^$($F$$$k$?$a$G$9!#(B
>>> $B!J$b$C$HAa$/$K5$IU$/$Y$-$G$7$?!#!K(B
>>>
>>> $B$G$9$N$G!"#D#B$N%(%s%3!<%I$rJQ$($k!"(BNVARCHAR$B$KJQ99(B
>>> $B$9$k$3$H$O!"8=>uFq$7$$$G$9!#$^$?!"$4Ds0F$$$?$@$$$?!"%F!<%V%k$K!V%l%Y%k!W(B
>>> $B$[E-MAIL ADDRESS DELETED]$1$kJ}K!$bFq$7$$$G$9!#(B
>>> $B%G!<%?%W%m%P%$%@$NJQ99$O;n$7$F$_$k2ACM$,$"$k$H;W$$$^$9$,!"(B
>>> $B$^$@8!>Z$7$F$*$j$^$;$s!#(BOracle$B$X$N3NG'$b$^$@9T$C$F$*$j$^$;$s!#(B
>>>
>>> $B4uK>$G$9$,!"(BSeasar$BB&$G$3$N8=>]$r2sHr$G$-$l$P$H;W$C$F$*$j$^$9!#(B
>>> $B:#2s!"8!>Z$5$;$F$$$?$@$-!"860x$H$J$C$F$$$k$N$O!"%P%$%s%I;~$KJ8;z%(%s%3!<%I$,(B
>>> $BJQ$o$C$F$7$^$C$F$$$k$3$H$@$HA[A|$G$-$^$9!#$=$3$r(BSeasar$BB&$G2?$H$+=PMh$J$$$+$H8!>Z$7$F$*$j$^$9!#(B
>>> $B$=$N8e$N8!>Z$G!"30$@$7#S#Q#L$N%P%$%s%IItJ,$r(BTO_CHAR$B$G0O$`$3$H$G(B
>>> $B8=>]$,2sHr$G$k$3$H$,$o$+$j$^$7$?!#2<5-$NMM$J#S#Q#L$G$9!#(B
>>>
>>> SELECT *
>>> FROM M_LESSON
>>> WHERE COURSE >= TO_CHAR(/*pmb.CourseFrom*/)
>>> AND COURSE <= TO_CHAR(/*pmb.CourseTo*/)
>>>
>>> $B$^$?!"#S#Q#L%D!<%k$G!"J8;z%j%F%i%kItJ,$r!"(BN'xxxxx'$B$H$7$F!"%f%K%3!<%I$KJQ49$9$k$h$&$K#S#Q#L$r(B
>>> $B5-=R$9$k$H!"A[Dj30$N7k2L$HF1$8%l%3!<%I7o?t$K$J$k$3$H$,$o$+$j$^$7$?!#2<5-$NMM$J#S#Q#L$G$9!#(B
>>>
>>> SELECT *
>>> FROM M_LESSON
>>> WHERE COURSE >= N'T$B=i5i(B'
>>> AND COURSE <= N'T$B>e5i(B'
>>>
>>> $B$=$3$G!":F$S3NG'$5$;$F$$$?$@$-$?$$$N$G$9$,!"30$@$7#S#Q#L$N%P%$%s%IItJ,$NJ8;z%(%s%3!<%I$r(B
>>> $B;XDj$9$[E-MAIL ADDRESS DELETED]$O(BSeasar$BB&$K$"$k$N$G$7$g$&$+!)(B
>>>
>>> $B$^$?!"@_Dj$,L5$1$l$P!"(BSeasar$B$N%*!<%W%s%=!<%9$K<j$r2C$($?$$$H9M$($F$*$j$^$9!#(B
>>> $B%P%$%s%I=hM}$r9T$C$F$$$k2U=j$r6/@)E*$K%7%U%H(BJIS$B$K%(%s%3!<%I$9$k;]$N5-=R$r2C$($^$9!#(B
>>> $B$=$N2U=j$r$*65$($$$?$@$1$J$$$G$7$g$&$+!)(B
>>> $B!J0lEY!"%=!<%9$rGR8+$7$?$N$G$,!"$=$l$,$I$3$J$N$+$o$+$j$^$;$s$G$7$?!#!K(B
>>>
>>> $B$=$b$=$b!"8+Ev0c$$$J$3$H$r?=$7>e$2$F$$$?$i!"2?B4$4MF<O2<$5$$!#(B
>>>
>>> $B0J>e!"59$7$/$*4j$$?=$7>e$2$^$9!#(B
>>>
>>> $B:{LZ(B
>>>
>>> ----- Original Message ----- From: "kubo" <[E-MAIL ADDRESS DELETED]>
>>> To: <[E-MAIL ADDRESS DELETED]>
>>> Sent: Friday, March 19, 2010 10:10 AM
>>> Subject: [seasar-dotnet:1614] Re:$B30$@$7#S#Q#L$K$D$$$F(B
>>>
>>>
>>>> $B5WJ](B(jflute)$B$G$9!#(B
>>>>
>>>> $B8!>Z$"$j$,$H$&$4$6$$$^$9!#(B
>>>> $B$5$i$K$^$H$a$k$H!'(B
>>>>
>>>> .NET-3.5
>>>> Oracle11g (on Windows2008)
>>>> o NLS_CHARACTERSET$B!a(BJA16SJISTILDE
>>>> o NLS_NCHAR_CHARACTERSET$B!a(BAL16UTF16
>>>>
>>>> $B!V4A;z$NBg$J$j>.$J$j8!:w$,A[Dj30$H$J$k!W(B
>>>> $B30$@$7(BSQL + $B%P%$%s%IJQ?t(B = x (HIT$B$7$J$$(B)
>>>> $B30$@$7(BSQL + $BKd$a9~$_JQ?t(B = o
>>>> SQL*Plus + $B%P%$%s%IJQ?t(B = o
>>>> SQL*Plus + $BKd$a9~$_JQ?t(B = o
>>>>
>>>> S2Dao.NET$B$H$$$&MW0x$[E-MAIL ADDRESS DELETED]$[E-MAIL ADDRESS DELETED]$K$9$k$?$a$K!"(B
>>>> $B30$@$7(BSQL$B$NItJ,$r!V(BADO.NET$BD>@\MxMQ!W$G;n$7$F(B
>>>> $B$_$k$HNI$$$G$9!#$G!"$5$i$K7k2L$,JQ$o$i$J$1$l$P!"(B
>>>> $B%G!<%?%W%m%P%$%@$rJL$N$b$N$KJQ$($F;n$7$F$_$^$7$g$&!#(B
>>>> ODP$B$H(BOLE$B$G7k2L$,F1$8$+$I$&$+!*!)(B
>>>> ($B$=$b$=$b2?$r$4MxMQ$G$9$+!)(B)
>>>> $B$3$3$^$G$d$k$H$+$J$j>u67$,%/%j%"$K$J$k$+$H;W$$$^$9!#(B
>>>>
>>>> $B$=$N8e$O!"$A$g$C$H$3$NLdBj$N%/%j%F%#%+%[E-MAIL ADDRESS DELETED]<!Bh$J$N$G$9$,!"(B
>>>> $B$b$7!"6HL3E*$K:$$C$F$J$$$1$I5$$K$J$C$FEj9F$7$F$_$?!"(B
>>>> $B$H$$$&$N$G$"$l$PE,Ev$J$H$3$m$G8!>Z$rBG$[E-MAIL ADDRESS DELETED]$k$N$b%"%j$G$9$,!"(B
>>>> $B=EMW$JLdBj$H$$$&$N$G$"$l$P!"(B
>>>>
>>>> o NVARCHAR$B$rMxMQ$7$F$_$k(B
>>>> o DB$B$N%(%s%3!<%G%#%s%0$r(BUTF-8$B$K$7$F$_$k(B($B$A$g$C$HBgJQ$+$J(B)
>>>> $B$J$I$b$G$-$k$J$i$P$d$C$F$_$k$HNI$$$+$b$7$l$^$;$s!#(B
>>>> ($BK|$,0l!"2sHr$G$-$kA*Br;h$,8+$D$+$l$P$H(B)
>>>>
>>>>
>>>> $B>e5-$N8!>Z7k2L<!Bh$G$O!"$A$g$C$H!V%3%_%C%?$@$+$i$o$+$k!W(B
>>>> $B$H$$$&%l%Y%k$rD6$($A$c$C$F$$$k$N$G!"(BOracle$B$N%5%]!<%H!"(B
>>>> ($B$b$7$/$O%G!<%?%W%m%P%$%@(B)$B$KLd$$9g$o$;$i$l$k$J$i(B
>>>> $BLd$$9g$o$;$F$_$?$[$&$,NI$$$+$b$7$l$^$;$s!#(B
>>>> $B$"$H!"(BOracle$B$N7G<(HD(B(OTN$B$H$+(B)$B$rC5$7$FF1$8$h$&$J8=>]$,(B
>>>> $BJs9p$5$l$F$$$J$$$+!"$J$1$l$P$=$A$i$GEj9F$7$FJ9$$$F$_$k(B
>>>> $B$H$+$bNI$$$+$b$7$l$^$;$s!#(B
>>>>
>>>>
>>>> #
>>>> # $B8D?ME*$K$O!"4A;z%G!<%?$KBP$7$F87L)$JBg$J$j>.$J$j$N(B
>>>> # $B0U<1$,I,MW$K$J$k$3$H$O$[$H$s$I$J$+$C$?$N$G!"(B
>>>> # $B$3$N7o$K4X$9$k>pJs$O2?$b;}$C$F$J$$$G$9!#(B
>>>> # $B$^$?!"<+J,$,#D#[E-MAIL ADDRESS DELETED]$9$k$H$-$K$O$=$&$$$&>r7o$,(B
>>>> # ($B6KNO(B)$BI,MW$K$J$i$J$$$h$&$K$7$^$9!#(B
>>>> # ($B4pK\E*$KJ8;zNs7?$GBg$J$j>.$J$j>r7o$,H/@8$7$J$$$h$&$K(B)
>>>> #
>>>> # $BNc$($P!"%3!<%9$O!"(Bchar(3)$B$N%3!<%I(B(COURSE_CODE$B$H$+(B)
>>>> # $B$K$7$F!"(BFK$B@)Ls$G(BCOURSE$B%^%9%?%F!<%V%k$r;2>H$7$F!"(B
>>>> # $B$=$A$i$N%F!<%V%k$K!V%l%Y%k!W$rI=8=$9$k%+%i%`$rDI2C(B
>>>> # $B$7$F(B($B?tCM$J$I(B)$B!"$=$N%+%i%`$GBg$J$j>.$J$j>r7o$H$9$k$J$I!#(B
>>>> # $B$b$7!"$=$&$$$C$?2sHr$,$G$-$k$N$G$"$l$P!"$=$l$b0l$D$N(B
>>>> # $BA*Br;h$+$H;W$$$^$9(B($B8!>Z:n6H$,BgJQ$@$H;W$&$N$G(B)$B!#(B
>>>> #
>>>>
>>>> 2010/3/19 $B:{LZ!!M*0m(B <[E-MAIL ADDRESS DELETED]>:
>>>>>
>>>>> $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
>>>>>>> M_LESSON
>>>>>>> $B!&%U%#!<%k%I(B
>>>>>>> TENPO$B!!!!(BNUMBER(3,0)$B!!!J(BPK$B!K(B
>>>>>>> DATE VARCHAR2(8)$B!!!J(BPK$B!K(B
>>>>>>> START$B!!!!(BVARCHAR2(4)$B!!!J(BPK$B!K(B
>>>>>>> END$B!!!!!!(BVARCHAR2(4)
>>>>>>> COURSE VARCHAR2(6)
>>>>>>>
>>>>>>> $B"#>e5-%F!<%V%kFb$N%l%3!<%I(B
>>>>>>> 1,"20100301","1000","1100","T$B=i5i(B"
>>>>>>> 1,"20100301","1100","1200","T$BCf5i(B"
>>>>>>> 1,"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
>>>>>>> pmb.CourseFrom$B"*(B'T$B=i5i(B'
>>>>>>> pmb.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
>>>>>>> 1,"20100301","1000","1100","T$B=i5i(B"
>>>>>>> 1,"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
>>>>>>>>> OS:WindowsXP
>>>>>>>>> VisualStudio2008
>>>>>>>>> .NetFrameWork3.5
>>>>>>>>> Oracle11g(OS:Windos2008)
>>>>>>>>> S2Container.NET 1.3.17.0
>>>>>>>>> S2Dao.NET 1.3.17.0
>>>>>>>>>
>>>>>>>>> $B"#%F!<%V%k(B
>>>>>>>>> $B!&%F!<%V%kL>(B
>>>>>>>>> M_$B%l%C%9%s(B
>>>>>>>>> $B!&%U%#!<%k%I(B
>>>>>>>>> $BE9J^!!!!!!(BNUMBER(3,0)$B!!!J(BPK$B!K(B
>>>>>>>>> $BF|IU!!!!!!(BVARCHAR2(8)$B!!!J(BPK$B!K(B
>>>>>>>>> $B3+;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
>>>>>>>>> 1,"20100301","1000","1100","T$B=i5i(B"
>>>>>>>>> 1,"20100301","1100","1200","T$BCf5i(B"
>>>>>>>>> 1,"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
>>>>>>>>> pmb.$B%3!<%9(BFROM$B"*(B'T$B=i5i(B'
>>>>>>>>> pmb.$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
>>>>>>>>> 1,"20100301","1000","1100","T$B=i5i(B"
>>>>>>>>> 1,"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 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 メーリングリストの案内