Help with how to present the resultset...

[Peter Hammar]

Hi, all!

I'm trying to display my result from my SQL-query below.

I know that I'm connected to the DB (Oracle). I have found my query in EM.

I will, in the end, have 9 fields, not only one. I would like to present this output in one (nine later one) labels/something.

I don't get any errors, but the label is not displaying NAME.

How to proceed?

  

              Statement stmt = conn.createStatement();
              ResultSet rs = stmt.executeQuery("SELECT * from test.table");
              while (rs.next()){
                namn = rs.getString("NAME");
             //  System.out.println (rset.getString(1));   // Print col 1
             label1 = new JLabel(name);
             panel.add(label1);
              stmt.close();
              }
  
  
    }

  

[Jan Cumps]

You assigned to the variable namn, and later use the variable name.

[Peter Hammar]

Well....thanks for pointing that out for

Now it works!