I have used hibernate, I have a CUSTOMER table, and a USER table.
I have a Customer_user table and a user_customer table used for one to one mapping between other tables.
When an admin registers a user, he selects which customers are to be added to the SHOW_CUSTOMER_LIST of that user.
For ex, user 1 is authorized to view customer 1 and 2, while user 2 is authorized to view customer 2 and 3. These two are mapped by the ID in their respective CUSTOMER and USER tables.
Cust_user looks something like this :
userID | customerID
1 | 1
1 | 2
2 | 2
2 | 3 and similarly the user_customer table
Now what I want is, that the admin can update these tables, for example if a new customer is added to the database, the admin can update any user to have access to that customer from the
jsp page itself, either using multiple select drop down menu or checkbox. What approach should I use for this. Any help would be appreciated.
Thanks in advance.