Displaying duplicate results in arraylist java

Question

I am using JDBC to run a SQL query in Java. I want to take the result of the query and store it in an arraylist so that I can display the data in a graph of some sort. I'm getting the same line printing out the same number of times as columnCount. Here is my code.

ArrayList <String[]> result = new ArrayList<String[]>();
int columnCount = rset.getMetaData().getColumnCount();
        if(rset!=null)
        {
            while(rset.next())
            {
                found=true;

                String[] row = new String[columnCount];
                for (int i = 0; i < columnCount; i++) {
                    row[i] = rset.getString(i + 1);                    
                    row[i] = rset.getString("Date") + " "
                            + rset.getString("Hour");
                    System.out.println(row[i]);
                }
                result.add(row); 
        }

Why the String[]? Wouldn't it be better with a class? class Row { private String value; private Date date; /* getters and setters */}. Why also getting date and hour for each column? — Arthur Noseda
– Arthur Noseda, Commented Jul 29, 2016 at 16:37

Andrew Lygin · Accepted Answer · 2016-07-29 17:01:48Z

1

Your second row[i] rewrites the value of the column. Just remove it and you'll see your records:

...
for (int i = 0; i < columnCount; i++) {
    row[i] = rset.getString(i + 1);                    
}
System.out.println(Arrays.toString(row));
result.add(row);
...

answered Jul 29, 2016 at 17:01

Andrew Lygin

6,2271 gold badge36 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Displaying duplicate results in arraylist java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related