Put resultset values into Collection object then add to ArrayList

Question

I was processing my resultset to get the details. I need to return an ArrayList, so how can I put the key,values from the resultset to any of the collection objects and then put the same to an ArrayList?

Here is the code:

public List<Bike> addBikes() throws ClassNotFoundException, SQLException{
        List<Bike> bikeList = new ArrayList<Bike>();

        Class.forName("com.mysql.jdbc.Driver");
        Connection con  = null;
        Statement  stm = null;
        ResultSet rs = null;
        con=DriverManager.getConnection("jdbc:mysql://localhost:3306/spring_hibernate","root","root"); ;
        stm=con.createStatement(); 
        String qry="Select * from bike"; 
        rs=stm.executeQuery(qry);
        while(rs.next())
        {           
            /* I need to put   
             * rs.getString("name"),rs.getString("model")
             * etc into any of the suitable collection objects 
             * and then need to add those to the ArrayList - bikeList
             * 
             */

        }
        return bikeList;

    }

But you almost have it! I gues you'll have to instantiate a Bike for each row, put name and model in there (Constructor or setters?) and then call bikeList.add(bike) ... that's it. — Fildor
– Fildor, Commented Jun 20, 2013 at 6:21

Andreas Dolk · Accepted Answer · 2013-06-20 06:22:08Z

4

For each result in the result set, create a new Bike() and copy the values from that result to the new bikes fields. At the end, add the bike to the list.

Bike bike = new Bike()
bike.setName(rs.getString("name"));
//...
bikeList.add(bike);

answered Jun 20, 2013 at 6:22

Andreas Dolk

115k20 gold badges185 silver badges275 bronze badges

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

1 Comment

joelc Over a year ago

Is there a way to do this in a class-agnostic way, i.e. without having to go over every property? Can it be cleanly converted to a List<Object>?

Suresh Atta · Accepted Answer · 2013-06-20 06:30:50Z

3

You have Banana in your hand..just eat it :)

Create a empty list and in iteration Create new Bike and add into the List.

 List<Bike> bikes  = new ArrayList<Bikes>();
  while(rs.next())
        {           
           Bike bike = new Bike();
           bike.setname( rs.getString("name"));
           //other properties
           bikes.add(bike);
        }

    return bikes;

edited Jun 20, 2013 at 6:30

answered Jun 20, 2013 at 6:22

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

Comments

Seshadri Sastry · Accepted Answer · 2013-06-20 06:22:22Z

2

you would instantiate a Bike object and set properties that you read from result set, then add the bike object to your arraylist, isnt it what you are looking for?

answered Jun 20, 2013 at 6:22

Seshadri Sastry

3592 silver badges3 bronze badges

Comments

Rob · Accepted Answer · 2013-06-20 06:22:49Z

2

while (rs.next()) {
    Bike bike = new Bike();
    bike.setName(rs.getString("name"));
    bike.setModel(rs.getString("model"));
    bikeList.add(bike);
}

answered Jun 20, 2013 at 6:22

Rob

6,5572 gold badges27 silver badges35 bronze badges

Comments

jtomaszk · Accepted Answer · 2013-06-20 06:25:09Z

2

I don't know how Your Bike class look like, but you should do it like this way:

while(rs.next())
{
    String column1 = rs.getString("column1_name");
    .... and the others columns

    Bike bike = new Bike();

    bike.setColumn1(column1);
    .... and others...

    bikeList.add(bike)
}

answered Jun 20, 2013 at 6:25

jtomaszk

11.6k2 gold badges31 silver badges41 bronze badges

Comments

Masudul · Accepted Answer · 2015-04-02 08:06:15Z

0

You need to instantiate Bike in while loop and add to List.

 List<Bike> bikes  = new ArrayList<>();
 while(rs.next())
    {           
       Bike bike = new Bike();
       bike.setname( rs.getString("name"));
       //other properties
       bikes.add(bike);
    }

  return bikes;

edited Apr 2, 2015 at 8:06

answered Jun 20, 2013 at 9:08

Masudul

22k5 gold badges45 silver badges60 bronze badges

Collectives™ on Stack Overflow

Put resultset values into Collection object then add to ArrayList

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related