db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Allen <...@mojavelinux.com>
Subject peer design to generate list
Date Mon, 10 Mar 2003 22:09:10 GMT
Assume that I have a member database with 3 different tables, one
for members, one for companies and one for addresses.  I want to
display a list that is something like

Member Name     Company     Phone/Fax   E-mail

Naturally I would want to prepare an ArrayList of member objects to
be iterated on in my view.  I would start with (using torque's
DAO model)

List members = MemberPeer.doSelectAll();

Naturally in my view I could so something like:

<logic:iterate id="member" name="members">
    <bean:write name="employee" property="fullName"/>
    <bean:write name="employee" property="???"/>
    <bean:write name="employee" property="???"/>
    <bean:write name="employee" property="emailAddress"/>
</logic:iterate>

But as you can see, I am stuck on something.  How would I reach into
the Company table to get the company information and how could I be
sure I wasn't having to requery the database for every single member
to get this information (naturally the getCompany() method in the
member would get the link, but then it would have to requery for
that one member)?

I would start by adding a join I guess in the doSelectAll().  I
guess my question is, people say to leave the implementation of the
business logic out of the Action (assuming we are using struts),
which would mean no Criteria objects in the Action.  So who owns
this criteria to add the depenencies on the company table (or
address if we choose to show it?)

Dan

-- 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Daniel Allen, <dan@mojavelinux.com>
http://www.mojavelinux.com/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Microsoft's Law of Software Engineering: 
Don't worry if it doesn't work right. 
If everything did, we'd be out of a job.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

Mime
View raw message