posted 12 years ago
I am new in spring security. I have to implement login option using spring security (using Hibernate Annotation). I have InnoDB supports for MySQL DB. My employee login tables are..
1. tbl_employee[emp_no bigint primary key, password varchar(20), authority_id int]
2. tbl_authority[authority_id (foreign key of same in tbl_employee), authority_name varchar(50)]
3. tbl_profile[emp_no(foreign key of same in tbl_employee), office_name varchar(100)]
My doubt is how to make one-to-many relation from tbl_employee table towards tbl_profile table to get the proper office_name after the successful login. We are using myeclipse for spring scaffolding to generate mvc and spring security code. On that users, users_authorities, and authorities table on security scaffolding. We have to replace that with above 3 tables. Can anybody help me with sample source code. Sent to my gmail accnt ajesh123.