select * from employee. So I get dept id also which is a foreign key. Use this dept id to call select name from department where deptid=#value#
So this is your EMP_ID. Just as an example.
On 7/13/06, Bing Lu <[EMAIL PROTECTED]> wrote:
so what does column="EMP_ID" do in here, does it pass
onto the next query as parameter?
--- Debasish Dutta Roy <[EMAIL PROTECTED]>
wrote:
> Yes you can do that.
> In your first resultmap, you are going to provide
> the
>
> --- First resultmap ---
> <result property="empId" column="EMP_ID"
> select="getEmployeeDetails"/>
>
> The select id "getEmployeeDetails" has a
> corresponding resultClass is a
> HashMap.
>
> So this way you will only call one query the first
> one and one of the result
> will be a hash map.
>
> On 7/13/06, Bing Lu < [EMAIL PROTECTED]> wrote:
> >
> > Hi, I have a resultmap that's matching to a class,
> one
> > of the result property is going to be a hashmap
> > populated from the database using another query,
> I'm
> > so sure about how to write this out in the xml
> file.
> > Can anyone help me out here?
> >
> > thanks a bunch
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
