How to view data from SQL to GUI on Java?

So, the program will be like this:
There is a menu that called "REGISTER" and we input the member id there (then it is stored to SQL database).
Then there is a menu that called "HISTORY" to view what is the member history (it could be purchase items, etc).
My questions is, How to check their history with just the user input his/her member id on the HISTORY menu and then the result shows it based from that input?

And I have several questions :
1. How to input data to 2 different table at the same time? Like at the image 1 "INPUT MOVIE DATA". I'm using twice executeUpdate (One to film table, and one to history table).
I'm doing it like this :

And I have several questions :
1. How to input data to 2 different table at the same time? Like at the image 1 "INPUT MOVIE DATA". I'm using twice executeUpdate (One to film table, and one to history table).
I'm doing it like this :

What error?
"It gives me an error" tells us nothing.
Exception and stack trace so we know which line the exception is coming from, anything less will result in guess work on our part...however I wouldn't be surprised if it's down to you concatenating your queries rather than using a PreparedStatement.

Originally Posted by BluXit

2. How to make my delete data working? So I'm just input my movie code (in the database its called filmcode) and the program will scan the code and then delete it from my database.

What does it do at the moment?
And again, use a PreparedStatement.
Until you do that there's no point continuing since I would lay odds that that's where your problems are occurring...and always printStackTrace() for exceptions.

Originally Posted by BluXit

3. In History menu, I'd like to show what is my latest inputted movie, registered member, and If could last deleted data. How to do that?

The only way you can do any of these is to put a timestamp on each table for a creation_date. For deleted data you can only do it by not actually deleting the data but putting in a deleted_date column, and anything with a non-NULL deleted_date is deleted and therefore ignored by the rest of the system...well, it would be once you include the deleted_date in the WHERE clause.