Thread: How to delete data from php through GUI in Java?

so I have create a program that connects to phpmyadmin and it looks like this :






I have 3 table from phpmyadmin (film,member,history)

film table consist of 2 collum :
*filmcode
*filmname

member table consist of 2 collum :
*idmember
*name

history table consist of 4 collums :
*idmember
*name
*filmcode
*filmname

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 :

Statement stat = null;
Statement stat2 = null;
 
stat.executeUpdate("INSERT INTO film VALUES(\"" + temp3 + "\",\"" + temp4 + "\") ");
stat2.executeUpdate("INSERT INTO history(filmcode,filmname) VALUES (\"" + temp3 + "\", \"" +temp4 + "\")");

but it gives me an error. Same problem goes on INPUT MEMBER DATA..

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.

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?

Really Really needs Help.....
Thank You So Much!

it gives me an erro

Please copy and paste full text of error here

@Norm
Never mind, I'm already solved it myself..
Another question, I want to make a menu that check is the member already registered with the same name or not.
For example : in the database, there's already have "Robert" in the query. And if new people wants to input their name "Robert" the program will not allow it.
How to do that?

The logic seems simple: When a new member enters a name, check if that name is already registered and if so, do not allow that name.