I am creating a database to store our client's information at work (a heritage center specializing in DNA based genealogy). Once the results of a test come back, we have people that use the information generated on sites such as 23andMe to find relatives and send out invitations for relatives to connect with our clients. This is done with the client's permission. The accounts belong to the clients, they just give us permission to use them. This is why we do not use our own user names and passwords (the client needs to be able to log in to the websites too).
I have the database entry program mostly done, but one thing I need to be able to do is pull up their username and passwords (in plain text) so we can log onto the 3 different websites we use.
What I want to do is create an overall password that when applied to what is entered into the password field in the data entry program (to save the password) or pulled from the DB (retrieve password), it is convertible to plain text (be able to go back and forth from plain to encrypted using 1 key).
Then each of our employees with permission to view the plain text password has their own unique password that when entered make the key mentioned above.
The database I am working with is MySQL and the program our workers are using to manipulate the MySQL DB is being written in Java. Any Java based examples or links to examples would be great.