ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: More than one parameter class/map for the <select> element ?
Date Fri, 02 Sep 2005 04:49:20 GMT
By creating a composite class, or using a Map.

public class Foo{
  private YourClassA yourClassA;
  private YourClassB yourClassB;
  // getters and setters below...
}

Larry


On 9/1/05, Mathew Samuel <grandarchville@yahoo.com> wrote:
> 
> Is it possible to pass a 2nd custom/standard class
> through a queryForObject() or queryForList() ? Or do I
> have to combine both objects under a Collection before
> sending it in ? I would want to use certain properties
> from the 2nd class to aid the 1st in a join, like
> shown below:
> 
> 
>   <resultMap id="tableAResult" class="objectA">
>    ...
>   </resultMap>
> 
>   <select id="anId" resultMap="tableAResult"
> parameterClass="objectA">
>     select TableA.field1, TableA.field2
>     from TableA, TableB
>     where TableA.field3 = TableB.field1
>     and TableA.field4 = #propertyOfObjectA#
>     and TableB.field2 = #someStringNotPartofObjectA#
>   </select>
> 
> How is this acheived ?
> 
> 
> 
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
> 
>

Mime
View raw message