Fetching Specific Data From Mysql Database

[iNko]

Hello, i have a problem fetching data from database, ill try explain what i need help with..

 

I got a login frame, that has login textfield, password textfield and a submit button.

When i press the submit button, if the login and password was correct, it switches to new frame, the login frame disappears.

 

In the new frame, i want to put a label, that would take 1 specific data field from the database. Something like this - "Select Surname from Users where Loginid = login".

 

How do i take the login textfield data from login frame, and display it in the new frame?

 

After i do this, can i create a new method in the new frame like this, and then just call it? (i took this from a tutorial where instead of updating a label, it updates the whole table)

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

private void whoslogedinLabel(){

String sql = "select Surname from Users where Loginid = Login texfield";

try {

pst = conn.prepareStatement(sql);

rs = pst.executeQuery();

logininfoLabel.setText(sql);

}

catch (Exception e){

JOptionPane.showMessageDialog(null, e);

}

}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

highlighted the red text where i think is the problem