How would I list the data from an SQL query in Java?

Question

Here is my code, it does get data and paste it in the Text Area as I want it to do, I was just wondering if I could change it so that I could edit how it gets outputted, and add line breaks etc?

btnLeaderBoardUpdate.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent arg0) {
            String sql3 ="Select * from honscores group by Name order by Kills";
            ResultSet rsz;
            try {
                PreparedStatement stz = conn.prepareStatement(sql3);
                rsz = stz.executeQuery();
                LeaderBoard = rsz.toString();

                while(rsz.next()){
                    ArrayList<String> record = new ArrayList<String>();
                    ResultSetMetaData metaData = rsz.getMetaData();
                    int columns = metaData.getColumnCount();

                    for (int i = 1; i <= columns; i++) {
                            String value = rsz.getString(i);
                            record.add(value);
                }
                    for (int i=1;i<columns;i++) {
                        txtLeaderBoard_1.append(record.toString());
                    }

        }   
            } catch(Exception e) {
                JOptionPane.showMessageDialog(null, e);
            }


        }
    });

Thanks, I will try all the suggestions and see which works best. — AceFire6, Nov 17 '11 at 20:44

score 0 · Accepted Answer · answered Nov 15 '11 at 18:14

0

It sounds like maybe a Java Swing "Listbox" might be a better choice for you than a "TextArea".

answered Nov 15 '11 at 18:14

paulsm4

114,292
17
138
190

How would I go about adding data to the JList? – AceFire6 Nov 20 '11 at 10:04
@PaulTomblin I figured out how to add data but now it is only adding the first row of data and repeating that, any help would be appreciated – AceFire6 Nov 20 '11 at 10:12
Have a look at http://stackoverflow.com/questions/6815726/jlist-and-arraylist-update – Paul Tomblin Nov 20 '11 at 14:40

score 0 · Answer 2 · answered Nov 15 '11 at 18:38

You have to add the separators and any decorators to the "rendering" loop. It's independent from the query. (Eg dummy example:)

    for (int i=1;i<columns;i++) {
       txtLeaderBoard_1.append(record.toString());
       txtLeaderBoard_1.append("\n");
    }

An other approach is what the others suggested, use a different widget.

How would I list the data from an SQL query in Java?

2 Answers2