java & mysql connectivity..

hello everyone,
I am supposed to create an application which connects database named 'student' in mysql storing student's record & marks; with NetBeans IDE & work out & display the record & marks as per user's choice in java windows. For this, I'm required to use total of 8 frames alongwith many buttons & other swing controls. The details are in the attached images...
Attachment 1014Attachment 1015Attachment 1016

Upon clicking Ok button in Frame1 (considered password entered is valid), Frame1 hides & Frame2 should open up.
When user clicks any of the buttons in Frame2 on either StudentRecord panel or StudentMarks panel, then accordingly Frames3,4,5,6,7 & 8 should be opened.

Somebody plz help me in linking all the frames together..
Thank you.

Hi, I would suggest a solution like this:
- Have a main program that manages all the frames.
- Each frame should have a loop that exits until OK/Cancel is pressed, and have a public method that gives some output for the main program.
- The main program displays a frame, gets output from it, then shows the next frame...

Hope you get the idea.

thank u so much..
But can u plz let me know the statements needed to establish connection b/w the frames & mysql database.. Also where & in which frame do i need to write those statements.??
Thanks again..