Hi,
I am new to iBatis.
I want to
fetch the data from the multiple tables.
How do i specify the
multiple result classes. ?? or give me select query.
These are my
classes:
User
{
private
int id,
private
String name;
}
These details are
stored in USR_DETAILS table.
Also User can have
multiple properties. These are stored in USR_PROPERTIES
table.
UserProperties
{
private
int userId;
private String
name;
private String
value;
}
It is possible that one user can have
multiple properties.
select * from USR_DETAILS
, USR_PROPERTIES where USR_DETAILS
.USR_ID=USR_PROPERTIES
.USR_ID;
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com |
