Access Values from an ArrayList That is inside another ArrayList

Question

java.util.List records = new java.util.ArrayList();
java.sql.ResultSet rs = selectestatement.executeQuery(query1);

 while (rs.next()) {

     java.util.List record = new java.util.ArrayList();

     record.add(rs.getString("WHLO").trim());
     record.add("888509018579");                            
     record.add(rs.getString("ITEM_CODE").trim());
     record.add(rs.getString("ARRIVAL_DATE").trim());
     record.add(rs.getString("PAIRS_PER_CASE").trim());  
     record.add(rs.getString("ATS").trim());
     records.add(record);   
 }

In this code, Final arraylist is the "records array". This records arraylist contents few record arrays.

How can i access the 1st element of record arraylist from the records arraylist?

Note that it's a pretty bad idea to store each row as a List; create a class to store it in and create instances from the record data, then store those. — daniu
– daniu, Commented May 28, 2018 at 8:48

Eran · Accepted Answer · 2018-05-28 08:46:35Z

3

Don't use raw types:

List<List<String>> records = new ArrayList<>();
List<String> record = new ArrayList<>();
...
records.add(record);

This way records.get(i) will return a List<String> instead of an Object, so you can access the elements of the inner List:

String first = records.get(0).get(0);

answered May 28, 2018 at 8:46

Eran

395k57 gold badges726 silver badges793 bronze badges

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

Comments

Lino · Accepted Answer · 2018-05-28 08:56:09Z

What you really want is a class containing your row data.

class RecordData {
    public String whlo;
    public long someNumber = 888509018579;
    public String itemCode;
    public String arrivalDate;
    public String pairsPerCase;
    public String ats;
}

and then do

java.util.List<RecordData> records = new java.util.ArrayList<>();
while (rs.next()) {

    RecordData record = new RecordData();
    record.whlo = rs.getString("WHLO").trim();
    record.itemCode = rs.getString("ITEM_CODE").trim();
    record.arrivalDate = rs.getString("ARRIVAL_DATE").trim();
    record.pairsPerCase = rs.getString("PAIRS_PER_CASE").trim();
    record.ats = rs.getString("ATS").trim();

    records.add(record);    
}

In fact, you want to make the members private and accessible via getters and setters, and use LocalDate for the arrivalDate and int for the pairsPerCase member, but the first point is not using a List to store the retrieved values but wrap it in a business-oriented class.

Averroes · Accepted Answer · 2018-05-28 09:09:30Z

0

You can do something like this

((ArrayList)records.get(0)).get(0) to access the first element of the array list that is in the first position of the records array list.

Please note that if you specify what does the records contains (in this case records will contains array lists) then you won't need to cast the element to array list.

List<List<String>> records = new ArrayList<ArrayList>();
{...}
records.get(0).get(0); //You don't need the cast because Java already knows that what it is inside records are Lists

edited May 28, 2018 at 9:09

answered May 28, 2018 at 8:46

Averroes

4,2386 gold badges53 silver badges64 bronze badges

1 Comment

Lino Over a year ago

use generics not just halfway through: List<List<String>> records = new ArrayList<>();

Collectives™ on Stack Overflow

Access Values from an ArrayList That is inside another ArrayList

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related