CODEWITHSUNDEEP
javajdbcarraylist
littlemisschik
littlemisschik

Reputation: 139

Displaying duplicate results in arraylist java

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); 
        }

Upvotes: 0

Views: 58

Answers (1)

Andrew Lygin
Andrew Lygin

Reputation: 6197

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);
...

Upvotes: 1

Related Questions