Getting a value from one method that is in a 'while' , to another method

[iNko]

Hey, i need to get a value from my database and define it as a variable so i can use it later.

Heres an example of what im trying to do:

Got this method where im taking a specific 'Surname' from a database table, where 'Login' matches. It writes the Surname in a label.

private void whoslogedinLabel(){       
    try {
       String sql = "SELECT Surname FROM Users WHERE login='" + whosloggedin + "'"; 
       pst = conn.prepareStatement(sql);    
       rs = pst.executeQuery(sql);
       while (rs.next())
       {
           logininfoLabel.setText(rs.getString("Surname"));   
       } 
}
    catch (Exception e){
        JOptionPane.showMessageDialog(null, e);
    } 
    }

After this, i want to take that Surname data (logininfoLabel) and define it as a variable so i could use it later on to get data from other database tables.

Heres an example on how i want to use it (it doesnt work because 'logininfoLabel' isnt defined i think):

private void Update_Table(){
    try{
     String sql = "SELECT * FROM Group where Surname = '" + logininfoLabel + "'";
     pst = conn.prepareStatement(sql);
     rs = pst.executeQuery(sql);
     Table1.setModel(DbUtils.resultSetToTableModel(rs));
    } 
    catch (Exception e){
        JOptionPane.showMessageDialog(null, e);
    }
}

In this code i cant take the 'logininfoLabel' value, how do i take it? or do i need to make a new String sql somehow? please help.

[Zyril]

Can you perhaps pass it as a parameter to your Update_Table method?

Where do you define String logininfoLabel?

[iNko]

Can you perhaps pass it as a parameter to your Update_Table method?

Where do you define String logininfoLabel?

whosloggedin - value from the login textfield.
logininfoLabel - label that i write in the Surname value from Users table, where login = value from login textfield (whosloggedin).
This logininfoLabel is only used in whoslogedinLabel() method, and only defined here - "private javax.swing.JLabel logininfoLabel;" (no more code with 'logininfoLabel ').

I want to take the Surname value that i just wrote into the 'logininfoLabel' and use it in other methods to find specific data from other database tables. I dont know how to do this..

As for passing it as a parameter, im not sure how to do this..

Having a hard time forming my questions in english :(

[iNko]

I think i got it working..

Made a new public static String Surname

public static String Surname;

Created a new method to find Surname

private void findSurname(){ 
    try {
       String sql = "SELECT Surname FROM Users WHERE login='" + whosloggedin + "'";
       pst = conn.prepareStatement(sql);    
       rs = pst.executeQuery(sql);
       while (rs.next()){
       Surname= rs.getString("Surname");    
       }    
    } catch (Exception e) {
        JOptionPane.showMessageDialog(null, e);
    }  
}