How do I retrieve data based on user input?
I have a java GUI form in Java. There are three text boxes; StudentID, StudentName, FinancialStatus. I created the database with these fields and established a connection. My question is this; I want the user to enter a student ID and click "Check" button. Then the program should check the database for that ID and display the corresponding StudentName and FinancialStatus. ID, Name and Status are all in one Access table. I require the coding to retrieve the name and the status based on the ID entered by the user. Any help will be highly appreciated...