Why is it not displaying data from the table?

Question

MySQL

I want to display a row with the user id from the table

public static void getUserId(Label label) throws SQLException {
        Statement st = null;
        ResultSet rs = null;

        String selectId = "SELECT user_id FROM users;";

        try {
            st = conn.createStatement();
            rs = st.executeQuery(selectId);
            while(rs.last()) label.setText("ID: " + rs.getString(1));
        }
        catch (SQLException e){
            e.printStackTrace();
        }
    }

and then I call the method in the controller, but the label still remains empty. What am I doing wrong?

Answer 1

Check:

• Is the request in progress
  
• Get the count of the returned collection and throw an Exception if it is less than the expected value
  
• Handle exceptions in a loop (at a glance, the dragon is hiding there)