[Seasar-user:20358] Re: [Kuina-Dao]Criteriaの例

[Koichi Kobayashi]

小林 (koichik) です．

Date:    Tue, 23 Nov 2010 17:08:29 +0900
From:    Inamine Morihiko <[E-MAIL ADDRESS DELETED]>
To:      [E-MAIL ADDRESS DELETED]
Subject: [Seasar-user:20357] [Kuina-Dao]Criteriaの例

> Kuina-DaoでCriteriaを使いたいのですが
> 使い方が分かりません＞＜

Criteria については Javadoc を参照してください．

http://kuina.seasar.org/apidocs/org/seasar/kuina/dao/criteria/CriteriaOperations.html

>   SQLで書くとこんな感じです
>   ・SELECT * FROM hogoTBL
>      WHERE A LIKE %inpword1%
>         OR A LIKE %inpword2%
>         OR B LIKE %inpword1%
>         OR B LIKE %inpword2%

import static org.seasar.kuina.dao.criteria.CriteriaOperations.*;

 List<Employee> list = 
     select().from(Hogo.class, "h")
         .where(or(contains("h.a", inpword1),
                   contains("h.a", inpword2),
                   contains("h.b", inpword1),
                   contains("h.b", inpword2)))
         .getResultList(em);

のようになります．
# メーラで書いただけで動かしてませんがたぶん．


-- 
<component name="koichik">
    <property name="fullName">"Koichi Kobayashi"</property>
    <property name="email">"[E-MAIL ADDRESS DELETED]"</property>
    <property name="blog">"http://d.hatena.ne.jp/koichik"</property>
    <property name="twitter">"http://twitter.com/koichik"</property>
</component>