Pass 6 elements of arraylist to prepared stmt

[divya kundapur]

Hi,

I have an arraylist which for eg has 12 elements but i need to pass just 6 elements each time to prepared statement.. i m not able to figure out the logic.

any help

[Raghavan Muthu]

Are you struck with extracting 6 elements or passing only 6 elements to PreparedStatement?

[divya kundapur]

Raghavan Muthu wrote:Are you struck with extracting 6 elements or passing only 6 elements to PreparedStatement?

i m struck with both... i have an arraylist for which i know i need to pass 6 elements each time to the preparedstatement and then execute the preparedstatement.. then pass another 6 elements repeat the process.

[James Sabre]

Seems straight forwards to me! Loop through the array pulling out six values at a time and feed them to the prepared statement. What is the problem?

[Campbell Ritchie]

Pull out six values, and print them to screen. Then you have six values. Then you can feed them to the statement. Don't try to do everything all in one stage.

[Mohamed Sanaulla]

Looks straight forward- But has a catch because the process has to be continued until the elements of the list have been exhausted- One has to remember the last index, repeat the loop to complete all the elements of the list. You would have to first identify number of iterations so that you can completely traverse the list. And for each iteration you need to use the old index and then get the element from the list, increment the index.

int numberOfIterations //calculate from the size of the list and number of elements you want to retrieve in each iteration
int indexCount;
for(i<numberOfIterations)
{
   for(j><countOfItemsToRetrive and indexCount >< list.size())
   {
     //get the element from the list using indexCount
     //increment indexCount
   }
}

Alternatively- You can create an ArrayList of ArrayList where each ArrayList will have an ArrayList of only 6(what ever number) of elements.

[Raghavan Muthu]

Mohamed Sanaulla wrote:Looks straight forward- But has a catch because the process has to be continued until the elements of the list have been exhausted- One has to remember the last index, repeat the loop to complete all the elements of the list. You would have to first identify number of iterations so that you can completely traverse the list. And for each iteration you need to use the old index and then get the element from the list, increment the index.

int numberOfIterations //calculate from the size of the list and number of elements you want to retrieve in each iteration
int indexCount;
for(i<numberOfIterations)
{
   for(j><countOfItemsToRetrive and indexCount >< list.size())
   {
     //get the element from the list using indexCount
     //increment indexCount
   }
}

Alternatively- You can create an ArrayList of ArrayList where each ArrayList will have an ArrayList of only 6(what ever number) of elements.

Is this all required for doing the OP's problem? It is dependent on "what 6 values" he needs. Then he can set those values to PreparedStatement and get his work done. Isnt it?

[Mohamed Sanaulla]

Raghavan Muthu wrote:
Is this all required for doing the OP's problem? It is dependent on "what 6 values" he needs. Then he can set those values to PreparedStatement and get his work done. Isnt it?

With what information OP has provided- I concluded that the retrieval is sequential

[Campbell Ritchie]

I also thought he meant the first 6 elements. Of course, if you read the List interface documentation, you find there is a much simpler way to do it.

[Mohamed Sanaulla]

Campbell Ritchie wrote:I also thought he meant the first 6 elements. Of course, if you read the List interface documentation, you find there is a much simpler way to do it.

Yeah yeah,got it. Much simpler

[divya kundapur]

Mohamed Sanaulla wrote:

Campbell Ritchie wrote:I also thought he meant the first 6 elements. Of course, if you read the List interface documentation, you find there is a much simpler way to do it.

Yeah yeah,got it. Much simpler

thanks a lot Mohamed Sanaulla ,i used the loop you provided and it worked .. just now checked the list interface as said by Campbell Ritchie n there is subList method ... thanks a lot both of you and to this great javaranch

[Campbell Ritchie]

I had forgotten about subList, until a few hours ago. It shows you need to go through the API and look which methods are available.

[Raghavan Muthu]

Thats great. subList() is a really a great feature