How to create an arraylist class that can store multiple data type objects in java

Question

I am using a JDBC query that returns output as following:

Name       Id
A          1
B          2

Then I am trying to generate an arrylist based on the query result using the following java class:

private class GetCompanyInfo implements Work {
    ArrayList<CompanyRelatedInfo> companyRelatedDataList = new ArrayList<CompanyRelatedInfo>();
    private String queryString;

    @Override
    public void execute(Connection connection) throws SQLException {        
        PreparedStatement ps = connection.prepareStatement(queryString);
        ResultSet rs = ps.executeQuery();
        CompanyRelatedInfo ci = new CompanyRelatedInfo();       
        while(rs.next())
        {   
            String name = rs.getString("name");
            Long id = rs.getLong("id");

            ci.setName(name);
            ci.setId(id);
            companyRelatedDataList.add(ci);
        }   
        rs.close();
        ps.close();
    }
}

But the problem is the arraylist returns results as following:

Name       Id
B          2
B          2

How can I generate the arraylist as following:

Name       Id
A          1
B          2

nils · Accepted Answer · 2014-04-30 18:23:37Z

3

Create a new instance of CompanyRelatedInfo instead of using the same. You are just modifying one and the same object for all rows and put it multiple times into the list. So try and use the following:

while(rs.next()) {   
  CompanyRelatedInfo ci = new CompanyRelatedInfo();       
  ...

answered Apr 30, 2014 at 18:23

nils

1,4121 gold badge9 silver badges16 bronze badges

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

1 Comment

Novis Over a year ago

Thanks. I didn't noticed I put the instance outside of the while loop. Thanks again. :-)

Collectives™ on Stack Overflow

How to create an arraylist class that can store multiple data type objects in java

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