Java-Output all the columns and rows of a ResultSet

Question

ta.setText is a TextArea where I want to show all my data from the database, after a button click. But with rs.get("name") I just output one value and it is always the last. How can I print out the whole table from the database, so all the information which are stored there?

            try { String newquery = "SELECT * FROM kunden";
            java.sql.PreparedStatement ps = con.prepareStatement(newquery);
            rs = ps.executeQuery(newquery);


            while (rs.next()){              

            ta.setText(rs.getString("name"));
            ta.setText(rs.getString("nachname"));
            }


        }// try
        catch(Exception e1) {
        JOptionPane.showMessageDialog(null, "fail");


      }
      }//actionperformed

If you have multiple values, then you can't use .setText to display all of them, you would either need to display those values in a table component or concatenate all values before calling .setText on ta. — ernest_k
– ernest_k, Commented May 26, 2018 at 12:10
@ErnestKiwele thx for your answer. Yes there are two rows of data and I want to show them all. How can I handle that with component ? — Lia
– Lia, Commented May 26, 2018 at 12:44
You need to choose a component that displays multiple values... like a table, a list, etc. Seems like a table is your best option as you have also multiple columns... — ernest_k
– ernest_k, Commented May 26, 2018 at 12:56

Joakim Danielson · Accepted Answer · 2018-05-26 14:33:42Z

2

Either you build a string an then set that string using setText()

StringBuilder builder = new StringBuilder();
while (rs.next()) {
   builder.append(rs.getString(“name”));
   builder.append(“ “);
   builder.append(rs.getString(“nachname”));
   builder.append(“\n“);       
}
ta.setText(builder.toString());

Or you use the append method that exists for TextArea

while (rs.next()) {
   ta.append(rs.getString(“name”));
   ta.append(“ “);
   ta.append(rs.getString(“nachname”));
   ta.append(“\n“);
}

edited May 26, 2018 at 14:33

answered May 26, 2018 at 14:12

Joakim Danielson

53.1k5 gold badges36 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lia Over a year ago

thank you @Joakim Danielson. When I try that I get the error " The method getString(int) in the type ResultSet is no ablecable for th arguments ()."

Collectives™ on Stack Overflow

Java-Output all the columns and rows of a ResultSet

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related