adding multiple rows to a list

[dilip satyaraghava]

i have retrived multiple rows from database and now i want to add each row to a collection.. i dont know the number of rows i retrieved .. so how do i add each row to the list

[Paul Clapham]

You add them one at a time. Each time you read a row from the database, you add it to the list. It isn't necessary to know in advance how many rows you are going to add.

Now if you had chosen an array, you would have had to know in advance. That's why choosing a list instead of an array, as you did, is a good idea.

[Prabhakar Reddy Bokka]

Create your own bean with the attributes present in the row, and set all the results to the bean, and finally add the bean to a list. This iteration is for every record in the result set.

see below link for examples. hope that helps.

Data access using JDBC

[Murad Iqbaal]

1. Create your own bean as Prabhakhar said
2. Create a generic collection for your bean for example ArrayList<YourBean>
3. use the addAll(Collection list) method to pass the retrieved http://docs.oracle.com/javase/1.4.2/docs/api/java/util/ArrayList.html#addAll(java.util.Collection)


Also, if you mean you don't know the number of items you retrieved, then its simple. Get an iterator and use its hasNext method to determine if there is another object after the current pointer. If there is, then use the next() method in a loop to retrieve the object and keep adding in a collection. Also, if you dont want to use iterator, use the resultset.next method, and keep adding the object returned in a Collection till rs.next() returns false i.e. no more records left.

Take this code as a sample:

Bean myBean = null;
ArrayList<Bean> list = new ArrayList<Bean>();
ResultSet rs = stmt.getResultSet();

				while (rs.next()) {

myBean = new Bean();
					myBean.setName((rs.getString("Name")));
					myBean.setAge(rs.getInt("Age"));
					myBean.setDepartment(rs.getString("Department"));

list.add(myBean);
}

//When this loop ends, you will know total number of items u got, and the bean will be ready to use in a list.

System.out.println("Total records fetched: " + list.size());

Hope this makes sense and helps.