This is my insert query~~ i need to get the next MemberID and display it in textfield(memberID_a).

query = "INSERT INTO Membership VALUES ('" +memberID_a.getText() + "','" +memberName_a.getText()...