<div>$B5WJ]$5$s(B</div>
<div>$B2CF#$G$9!%(B</div>
<div> </div>
<div>$B$48!F$$"$j$,$H$&$4$6$$$^$9!%(B<br>$B30$@$7(BSQL$B$NF0E*%P%$%s%IJQ?t8!:w$K$D$$$F$b>/$7;n$7$F$_$?$$$H;W$$$^$9!%(B<br> </div>
<div><span class="gmail_quote">08/04/02 $B$K(B <b class="gmail_sendername">kubo</b> <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> $B$5$s$O=q$-$^$7$?(B:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">$B5WJ]$G$9!#(B<br><br>$B2CF#$5$s!"$3$s$P$s$O(B<br><br>$B$J$k$[$IN;2r$G$9!#(B<br>$B3N$+$K(BLike$B$@$1$OHs>o$KFC<l$J1i;;;R$G!"(B<br>$BDj7?E*$K>r7o$r(BOR$B$G$D$J$2$?$/$J$j$^$9$M!#(B<br>$BCf4V0lCW$@$C$?$i%$%s%G%C%/%9LdBj$b4X78$J$$$G$9$7!#(B<br>
$B$A$g$C$H<B8=2DG=@-$rC5$j$^$9!#(B<br><br>LikeSearchOption$B$N(BsplitByXxx()$B$G2?$+$7$i$G(BOR$B;XDj$G$-$k$h$&$K(B<br>$B$7$h$&$H9M$($F$$$^$9!#(B(xxx like '%a%' or xxx like '%b%' or ...)<br><br><br>> $B$$$C$F30$@$7(BSQL$B$G$O(BLIKE$B$N(BFOR$BJ8$,=q$1$J$$$N$G<BAu$G$-$J$$!#(B<br><br>$B$3$lHs>o$K$h$/$o$+$j$^$9!#(B<br>$B0l1~!"(BDBFlute$B$G$OKd$a9~$_JQ?t%3%a%s%HFb$N%P%$%s%IJQ?t%3%a%s%H$r(B<br>
$BG'<1$G$-$k$h$&$K$9$k%b!<%I$r@_$1$F$$$^$9$N$G$4;29M$^$G$K!#(B<br><a href="http://dbflute.sandbox.seasar.org/contents/outside-sql/dynamic.html">http://dbflute.sandbox.seasar.org/contents/outside-sql/dynamic.html</a><br><br><br>2008/4/1 Junichi Kato <<a href="mailto:j5ik2o@gmail.com">j5ik2o@gmail.com</a>>:<br>
> $B5WJ]$5$s(B<br>> $B2CF#$G$9!#(B<br>><br>> $B$*JV;v$,CY$l$F$9$_$^$;$s#w(B<br>><br>> $B0J2<M}2r$G$-$^$7$?!#(B<br>> $B$,!"(BUNION$B$@$H(BSQL$B$,$V$"!<$C$HA}$($F%G%P%C%0$,BgJQ$J$N$H!"$d$O$j(BCB$B$r9=@.$9(B<br>> $B$k=hM}$,J#;(2=$9$k$N$G(BLIKE$B$N(BOR$B$G$D$J$2$k5!G=$O$[$7$$$H$3$m$G$9!#(B<br>> $B8!:wBP>]$N%+%i%`$NB?$$$N$G$A$g$C$H$3$NJ}K!$O$D$i$$$s$G$9$h$M!#!#!#$+$H(B<br>
> $B$$$C$F30$@$7(BSQL$B$G$O(BLIKE$B$N(BFOR$BJ8$,=q$1$J$$$N$G<BAu$G$-$J$$!#(B<br>> $B$48!F$$$$?$@$1$?$i9,$$$G$9!#(B<br>><br>><br>> kubo $B$5$s$O=q$-$^$7$?(B:<br>><br>><br>> > $B5WJ]$G$9!#(B<br>> ><br>> > $B2CF#$5$s(B<br>> ><br>> > <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example</a><br>
> > MemberCBTest#test_selectList_union_LikeSearch_Tx()<br>> > $B$K(BExample$B<BAu$7$F$_$^$7$?!#(B<br>> ><br>> > 2008/3/29 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>>:<br>> ><br>> >> $B5WJ]$G$9!#(B<br>
> >><br>> >> $B2CF#$5$s!"$3$s$K$A$O(B<br>> >><br>> >> AND$B$H$+(BOR$B$H$$$&46$8$G$O$J$/!"(B<br>> >><br>> >> select ...<br>> >> from XXX<br>> >> where YYY like 'a%'<br>
> >> union<br>> >> select ...<br>> >> from XXX<br>> >> where YYY like 'b%'<br>> >> union<br>> >> select ...<br>> >> from XXX<br>> >> where YYY like 'c%'<br>
> >><br>> >> $B$H$$$&46$8$N(BSQL$B$K$J$k$O$:$G$9$,!"(B<br>> >> $B$=$&$J$i$J$$$G$7$g$&$+!)(B<br>> >><br>> >> # $B$A$J$_$K(BsplitByXxx()$B$OMxMQ$;$:!"(B<br>> >> # $B<+J,$G(Bsplit$B$G!V(Bfor (String keyword : keywordList) {$B!W(B<br>> >> # $B$9$k%$%a!<%8$G$9!#(B<br>
> >><br>> >> 2008/3/28 Junichi Kato <<a href="mailto:j5ik2o@gmail.com">j5ik2o@gmail.com</a>>:<br>> >><br>> >><br>> >><br>> >>> $B5WJ]$5$s!"(B<br>> >>><br>
> >> > $B2CF#$G$9!#(B<br>> >> ><br>> >> > $B0J2<$r;n$7$F$_$?$N$G$9$,!"(BAND$B$G$D$J$,$C$F$7$^$&$h$&$G$9!#(B<br>> >> > OR$B$G$D$J$2$k$N$OL5M}$G$9$+$M!)(B<br>> >> ><br>> >> ><br>> >> > kubo $B$5$s$O=q$-$^$7$?(B:<br>
> >> ><br>> >> ><br>> >> > > $B5WJ]$G$9!#(B<br>> >> > ><br>> >> > > $B2CF#$5$s!"$3$s$P$s$O(B<br>> >> > ><br>> >> > > $BCk$O$A$g$C$H<h$j9~$s$G$F<h$j5^$.%3%a%s%H$G$7$?$,!"(B<br>
> >> > > $B<BAu%$%a!<%8$H$7$F$O0J2<$N$h$&$J46$8$K$J$k$H;W$$$^$9!#(B<br>> >> > > ($BF0$+$7$F$J$$$N$G$"$/$^$G%$%a!<%8$H$$$&$3$H$G(B)<br>> >> > ><br>> >> > > XxxCB cb = new XxxCB();<br>> >> > > cb.setupSelect_...<br>
> >> > > boolean first = true;<br>> >> > > for (String keyword : keywordList) {<br>> >> > > if (first) {<br>> >> > > cb.query().setYyy_LikeSearch(keyword, new Like...);<br>
> >> > > first = false;<br>> >> > > continue;<br>> >> > > }<br>> >> > > XxxCB unionCB = new XxxCB();<br>> >> > > unionCB.query().setYyy_LikeSearch(keyword, new LiKe...);<br>
> >> > > cb.union(unionCB.query())<br>> >> > > }<br>> >> > ><br>> >> > > 2008/3/26 Junichi Kato <<a href="mailto:j5ik2o@gmail.com">j5ik2o@gmail.com</a>>:<br>
> >> > ><br>> >> > >> $B5WJ]$5$s!"(B<br>> >> > >> $B2CF#$G$9!#$I$&$b$G$9!#(B<br>> >> > >><br>> >> > >> $BN;2r$7$^$7$?!#(Bunion$B$G$d$C$F$_$^$9!#(B<br>> >> > >><br>
> >> > >><br>> >> > >> 08/03/26 $B$K(B kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> $B$5$s$O=q$-$^$7$?(B:<br>> >> > >><br>> >> > >><br>
> >> > >><br>> >> > >>> $B5WJ]$G$9!#(B<br>> >> > >>><br>> >> > >>> $B2CF#$5$s!"$3$s$K$A$O(B<br>> >> > >>><br>> >> > >>> $B<h$j5^$.%3%a%s%H$5$;$FD:$-$^$9!#(B<br>
> >> > >>> splitByXxx()$B$r(Bor$B>r7o$H$9$k5!G=$O:#$O$"$j$^$;$s!#(B<br>> >> > >>> OR$B>r7o$K4X$7$F$O!"(BConditionBean.union()$B$r$4MxMQ2<$5$$!#(B<br>> >> > >>> $BC"$7!"(BsplitByXxx()$B$G0lK\$NJ8;zNs$rJ,2r$9$k$N$O<+J,$G(B<br>> >> > >>> $B=hM}$9$k$3$H$K$O$J$C$F$7$^$$$^$9!#(B<br>
> >> > >>><br>> >> > >>><br>> >> > >>> 2008/3/26 Junichi Kato <<a href="mailto:j5ik2o@gmail.com">j5ik2o@gmail.com</a>>:<br>> >> > >>><br>
> >> > >>>> $B2CF#$G$9!#(B<br>> >> > >>>><br>> >> > >>>> $B$*@$OC$K$J$j$^$9!#(B<br>> >> > >>>> DBFlute$B$N<ALd$G$9!#(B<br>> >> > >>>><br>
> >> > >>>><br>> >> > >>>><br>> >> > >> <a href="http://dbflute.sandbox.seasar.org/ja/tips-condition_bean_comparison.html">http://dbflute.sandbox.seasar.org/ja/tips-condition_bean_comparison.html</a><br>
> >> > >><br>> >> > >>>> $B!S(B{Split$B=hM}(B} splitByXxx()$B$r8F$S=P$9$3$H$G!"0z?t$N(Bvalue$B$r(BSplit$B$7$FJ#?t$N(B<br>> >> > >>>> AND$B>r7o$H$7$FIUM?$G$-$^$9!#(B<br>> >> > >>>> $B$H$"$k$N$G$9$,!"(B<br>
> >> > >>>><br>> >> > >>>> LIKE$B$K$FJ#?t$N8!:w>r7o$r(BOR$B$G$D$J$2$k>l9g$O$I$N$h$&$K$9$k$N$,$h$$$N$G$7$g(B<br>> >> > >>>> $B$&$+!)(B<br>> >> > >>>> $B%"%I%P%$%9$r$*4j$$$$$?$7$^$9!#(B<br>
> >> > >>>><br>> >> > >>>><br>> >> > >>>><br>> >> > >>>><br>> >> > >>>><br>> >> > >>>> _______________________________________________<br>
> >> > >>>> Seasar-user mailing list<br>> >> > >>>> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>> >> > >>>> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
> >> > >>>><br>> >> > >>>><br>> >> > >>> _______________________________________________<br>> >> > >>> Seasar-user mailing list<br>
> >> > >>> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>> >> > >>> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
> >> > >>><br>> >> > >>><br>> >> > >> _______________________________________________<br>> >> > >> Seasar-user mailing list<br>> >> > >> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>
> >> > >> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>> >> > >><br>> >> > >><br>> >> > >><br>
> >> > > _______________________________________________<br>> >> > > Seasar-user mailing list<br>> >> > > <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>
> >> > > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>> >> > ><br>> >> ><br>> >> > _______________________________________________<br>
> >> > Seasar-user mailing list<br>> >> > <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>> >> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
> >> ><br>> >><br>> >><br>> > _______________________________________________<br>> > Seasar-user mailing list<br>> > <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>
> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>> ><br>><br>> _______________________________________________<br>> Seasar-user mailing list<br>
> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br>> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>><br>_______________________________________________<br>
Seasar-user mailing list<br><a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a><br><a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a><br>
</blockquote></div><br>