Hello, Thanks.. <div class="gmail_quote">On Thu, Jul 2, 2009 at 3:48 PM, kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hello, this is jflute You can implement like this: cb.query().queryMemberStatus().setMemberStatusName_Xxx(...); Please watch the "dbflute-basic-example" project. The example will help you use DBFlute. // dbflute-basic-example <div class="im"><a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example</a> </div>// ConditionBeanBasicTest <div class="im"><a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java</a> </div>2009/7/2 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: <div><div></div><div class="h5">> Ha, > > MemberCB cb = new MemberCB(); > cb.setupSelect_MemberStatus(); > > //cb.query.setMemberId("AAA"); > > List<Member> memberList = memberBhv.selectList(cb); > for (Member member : memberList) { >    // columns of MEMBER table >    Integer memberId = member.getMemberId(); >    String memberName = member.getMemberName(); > >    // columns of MEMBER_STATUS table >    MemberStatus memberStatus = member.getMemberStatus(); // *Point! >    String memberStatusName = memberStatus. >> >> getMemberStatusName(); >>    ... >> } > > by using cb.query.setXXXXXX(), i can set conditions only for Member Tabel. > > How can i set the condition for memberstatus table? > Is it Possible in DBFlute ConditionBean? > > Thanks in advance, > トマス > > > > > > > 2009/6/12 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>> >> >> Hai, >> >> Thanks for your reply... >> >> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = >> MemberCB cb = new MemberCB(); >> cb.setupSelect_MemberStatus(); // *Point! >> >> List<Member> memberList = memberBhv.selectList(cb); >> for (Member member : memberList) { >>    // columns of MEMBER table >>    Integer memberId = member.getMemberId(); >>    String memberName = member.getMemberName(); >> >>    // columns of MEMBER_STATUS table >>    MemberStatus memberStatus = member.getMemberStatus(); // *Point! >>    String memberStatusName = memberStatus. >>> >>> getMemberStatusName(); >>>    ... >>> } >> >> >> This is what i want... >> >> Thank you very much. >> >> >> Regards, >> トマス >> >> >> >> >> >> >> On Fri, Jun 12, 2009 at 1:03 AM, kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: >>> >>> Hello, >>> >>> Sorry, it's about time for me to go to bed... >>> I can not make my reply for several hours. >>> (until next morning in Japan) >>> So I'm trying to write what I can write now. >>> >>> >>> If you want to select MEMBER and MEMBER_STATUS, >>> (MEMBER and MEMBER_STATUS : many-to-one) >>> you can implement in condition-bean like this: >>> >>> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = >>> MemberCB cb = new MemberCB(); >>> cb.setupSelect_MemberStatus(); // *Point! >>> >>> List<Member> memberList = memberBhv.selectList(cb); >>> for (Member member : memberList) { >>>    // columns of MEMBER table >>>    Integer memberId = member.getMemberId(); >>>    String memberName = member.getMemberName(); >>> >>>    // columns of MEMBER_STATUS table >>>    MemberStatus memberStatus = member.getMemberStatus(); // *Point! >>>    String memberStatusName = memberStatus.getMemberStatusName(); >>>    ... >>> } >>> - - - - - - - - >>> Please watch the method 'ConditionBeanBasicTest.test_basic_Tx()'. >>> >>> <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java</a> >>> = = = = = = = = = =/ >>> >>> >>> If you want to select MEMBER and PURCHASE, >>> (MEMBER and PURCHASE : one-to-many) >>> you can implement in condition-bean like this: >>> >>> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = >>> MemberCB cb = new MemberCB(); >>> >>> // At first, it selects the list of Member. >>> ListResultBean<Member> memberList = memberBhv.selectList(cb); >>> >>> // And it loads the list of Purchase with its conditions. >>> memberBhv.loadPurchaseList(memberList, new >>> ConditionBeanSetupper<PurchaseCB>() { >>>    public void setup(PurchaseCB cb) { >>>        cb.query().setPurchaseCount_GreaterEqual(2); >>>        cb.query().addOrderBy_PurchaseCount_Desc(); >>>    } >>> }); // *Point! >>> >>> for (Member member : memberList) { >>>    // columns of MEMBER table >>>    Integer memberId = member.getMemberId(); >>>    String memberName = member.getMemberName(); >>> >>>    // list of purchase for current member. >>>    List<Purchase> purchaseList = member.getPurchaseList(); // *Point! >>>    for (Purchase purchase : purchaseList) { >>>        // columns of Purchase table >>>        Integer purchaseId = purchase.getPurchaseId(); >>>        ... >>>    } >>> } >>> - - - - - - - - >>> Please watch the method 'BehaviorMiddleTest.test_loadReferrer_Tx()'. >>> >>> <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/BehaviorMiddleTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/BehaviorMiddleTest.java</a> >>> = = = = = = = = = =/ >>> >>> On Thu, Jun 11, 2009 at 11:56 PM, kubo<<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: >>> > Hello, this is jflute >>> > >>> > I'm sorry that I can not accurately understand your question. >>> > What does it mean "more than one table"? >>> > >>> > Let me show this example database for our communication. >>> > <a href="http://dbflute.sandbox.seasar.org/view/exampledb/index.html?goto=1" target="_blank">http://dbflute.sandbox.seasar.org/view/exampledb/index.html?goto=1</a> >>> > >>> > Does it means, for example, >>> > "MEMBER and MEMBER_STATUS"? >>> > (related two tables) >>> > >>> > select mbr.MEMBER.MEMBER_ID >>> >          mbr.MEMBER.MEMBER_NAME >>> >          mstat.MEMBER_STATUS_NAME >>> >  from MEMBER mbr >>> >    left outer join MEMBER_STATUS mstat >>> >      on mbr.MEMBER_STATUS_CODE = mstat.MEMBER_STATUS_CODE >>> > >>> > >>> > 2009/6/11 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: >>> >> hai, >>> >> >>> >> I want to clarify one thing. >>> >> Is there any other way to select values from more than one table >>> >> without >>> >> using outside SQL? >>> >> >>> >> If there is any way how can i get the values from more than one table? >>> >> >>> >> Regards, >>> >> トマス >>> >> >>> >> _______________________________________________ >>> >> Seasar-user mailing list >>> >> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> >>> >> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> >>> >> >>> >> >>> > >>> _______________________________________________ >>> Seasar-user mailing list >>> <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> >>> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> >> > > > _______________________________________________ > Seasar-user mailing list > <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> > > _______________________________________________ Seasar-user mailing list <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> </div></div></blockquote></div>