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

[kubo]

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
>
>