[Seasar-user:17904] Re: [dbflute-Two Tables]

[kubo]

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
https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example

// ConditionBeanBasicTest
https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java

2009/7/2 thomas <[E-MAIL ADDRESS DELETED]>:
> 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 <[E-MAIL ADDRESS DELETED]>
>>
>> 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 <[E-MAIL ADDRESS DELETED]> 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()'.
>>>
>>> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/ConditionBeanBasicTest.java
>>> = = = = = = = = = =/
>>>
>>>
>>> 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()'.
>>>
>>> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-basic-example/src/test/java/com/example/dbflute/basic/dbflute/howto/jp/BehaviorMiddleTest.java
>>> = = = = = = = = = =/
>>>
>>> On Thu, Jun 11, 2009 at 11:56 PM, kubo<[E-MAIL ADDRESS DELETED]> 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.
>>> > http://dbflute.sandbox.seasar.org/view/exampledb/index.html?goto=1
>>> >
>>> > 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 <[E-MAIL ADDRESS DELETED]>:
>>> >> 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
>>> >> [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
>
>