Mysql table

1 acct could many person(different login_id)

Create table accts (
Acct varchar(5) primary key,
Company _name varchar(50)
)

Create table accts_security
Login_id varchar(20),
Acct varchar(5)
Person_name varhcar(20)
Foreign key(acct) reference accts(acct)
);




Java class

Class person {
Login_id varchar(20),
Acct varchar(5),
Company varchar(50)
}

For the given login_id, I need to retrieve the combine info from both table accts and acct_security into PO class person, how can I do?

Hi

Do you want to create an object releation between accts and accts_security or do do you just want to join the tables and put the result into a list of Person objects?

join the table first if possible

or

inside the person.hbm.xml , indicate join.

thanks in advance

john

Create an empty constructor and a contructor for all fields in Person(String loginId, String accts, String company)

Asuming that you have mapped accts and accts_security to Entity classes you can do something like this:


HQL: