Request help for retrieving data from Access

[tunali2]

I have 3 text boxes for StudentID, StudentName and ClearanceStatus. I want to retrieve StudentName and ClearanceStatus from an Access database based on the StudentID which should be entered by the user as the user clicks Go button. Please help!

[UJJAL DHAR]

I have 3 text boxes for StudentID, StudentName and ClearanceStatus. I want to retrieve StudentName and ClearanceStatus from an Access database based on the StudentID which should be entered by the user as the user clicks Go button. Please help!

Firstly keep StudentName and ClearanceStatus on a DATABASE,then retrieve them and show them on the GUI when it starts..

More specifically ask your questions.

Regards
Ujjal

[tunali2]

I already created the database in access with all three fields in a table called Status. I need help with the coding for the GO button on the GUI. When the user enters the ID in the text box and clicks GO, the program should check the ID number in the txt_id text box and retrieve the corresponding student name and his status from the database and display. How do I write the code to do that?

[UJJAL DHAR]

I already created the database in access with all three fields in a table called Status. I need help with the coding for the GO button on the GUI. When the user enters the ID in the text box and clicks GO, the program should check the ID number in the txt_id text box and retrieve the corresponding student name and his status from the database and display. How do I write the code to do that?

Let your button name is GO.Then use actionlistener.

Go.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {

//write your code here which will be executed when pressing the button//
Step 1:   String id=checkbox.getText();

Step 2:connect with Database

Step 3:execute "SELECT *from tablename where   columnname=id"

Step 4: here you will get values of the table like
             String  StudentName =statement.getText(columnnumber);

  }}
);

For an example
http://ujjalruet.wordpress.com/2011/...mysql-in-java/

[doWhile]

Suggested reading...How To Ask Questions The Smart Way

We're left guessing about the details of the problem without a more thorough description - asking "how do I do that?" is difficult to answer, as there are typically several ways - providing context, code, etc..will get your question answered much faster. Break the problem down - at what point are you stuck? Gui design? Database access? Listener implementation?

[tunali2]

I have 3 fields; ID, name and status on Java GUI. I am using Access database and there is connection. I want the user to be able to search using ID and retrieve the name and status. Please help!

[UJJAL DHAR]

I have 3 fields; ID, name and status on Java GUI. I am using Access database and there is connection. I want the user to be able to search using ID and retrieve the name and status. Please help!

What do you think I have told you?
Already I have given the answer.

String id=checkbox.getText();
ResultSet result =mysql_query ("Select *from tableName where idcolumn=id ");

String name=result.getString(1);
String status=result.getString(2);
//here 1 and 2 means column name

What do you want now? How can we help you more than this?
I have given a link,did you see this?