[Seasar-user:17660] Re: [dbflute-ignoreCase in conditionBean]使い方法

kubo [E-MAIL ADDRESS DELETED]
2009年 6月 9日 (火) 18:00:12 JST


Hello,

Sorry! I mistook your DBFlute version.
The method and class are supported since 0.9.5.
So please upgrade DBFlute to 0.9.5 if possible.

2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
> hai,
>
> cb.query().setMemberName_
>>
>> LikeSearch("s", new LikeSearchOption() {
>>    @Override
>>    public ExtensionOperand getExtensionOperand() {
>>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
>>    }
>> }.likePrefix());
>
> import org.seasar.dbflute.dbway.ExtensionOperand;//Error
>
> there is no class in org.seasar.dbflute.dbway like ExtensionOperand
>
>
>
> 2009/6/9 kubo <[E-MAIL ADDRESS DELETED]>
>>
>> Hello,
>>
>> Please watch this test case:
>> The method is 'test_likeSearch_caseInsensitive_Tx()'.
>>
>>
>> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java
>>
>> cb.query().setMemberName_LikeSearch("s", new LikeSearchOption() {
>>    @Override
>>    public ExtensionOperand getExtensionOperand() {
>>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
>>    }
>> }.likePrefix());
>>
>> This code uses 'ilike' in the SQL.
>> (But this way is only available at PostgreSQL)
>>
>> If you have many many points that must be without case sensitive,
>> you should create CaseInsensitiveLikeSearchOption as your original class.
>> Like this:
>>
>> public class CaseInsensitiveLikeSearchOption extends LikeSearchOption {
>>    @Override
>>    public ExtensionOperand getExtensionOperand() {
>>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;
>>    }
>> }
>>
>> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
>> > Hai,
>> >
>> > I am using PostgresQL 8.3
>> >
>> >
>> >
>> >
>> > 2009/6/9 kubo <[E-MAIL ADDRESS DELETED]>
>> >>
>> >> Hello, this is jflute.
>> >>
>> >> For starters, there is one thing I want to confirm.
>> >> What kind of database do you use?
>> >> Oracle? MySQL? PostgreSQL? ...
>> >>
>> >> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
>> >> > Hai,
>> >> >
>> >> > I want to retrieve data without case sensitive using condition Bean.
>> >> >
>> >> > dbflute version 0.9.4.1
>> >> >
>> >> > empCB.query().setEmployeecode_LikeSearch(empcodes,new
>> >> > LikeSearchOption());
>> >> >
>> >> > How to change this code to get case sensitive result?
>> >> >
>> >> > Please give steps to achieve this...
>> >> >
>> >> > Thanks in advance.
>> >> > トマス
>> >> >
>> >> >
>> >> > _______________________________________________
>> >> > Seasar-user mailing list
>> >> > [E-MAIL ADDRESS DELETED]
>> >> > https://ml.seasar.org/mailman/listinfo/seasar-user
>> >> >
>> >> >
>> >> _______________________________________________
>> >> Seasar-user mailing list
>> >> [E-MAIL ADDRESS DELETED]
>> >> https://ml.seasar.org/mailman/listinfo/seasar-user
>> >
>> >
>> > _______________________________________________
>> > Seasar-user mailing list
>> > [E-MAIL ADDRESS DELETED]
>> > https://ml.seasar.org/mailman/listinfo/seasar-user
>> >
>> >
>> _______________________________________________
>> Seasar-user mailing list
>> [E-MAIL ADDRESS DELETED]
>> https://ml.seasar.org/mailman/listinfo/seasar-user
>
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
>


Seasar-user メーリングリストの案内