Array Concept

[sandeep43]

Hi all,

I Have a sql which will retrieve many rows,

all i want is how to store these each and every value what is retrieved at each loop in an array and later use each and value in array that is stored in different loop.

only thing i know is i have to use global array. in this concept array is off type String.

How to accomplish this?

Regards
Sandeep

[pbrockway2]

only thing i know is i have to use global array.

First think seriously about whether you really should make an array in the first place - after all the information already exists and is accessible in the database and you would be making a second copy. This may be useful, or it may not.

Another thing to think about is whether you should use an array or some implementation of the List interface.

The array need not be global. Rather it should available to whatever method needs it. If both the method populating the array and the one accessing it are methods of the same class, then an instance variable is enough. If they are in different classes then the class that populates the array should provide a getter method.

[JosAH]

only thing i know is i have to use global array. in this concept array is off type String.

Can you tell us why you think it has to be 'global' (there are no global variables in Java). Also, why do you think you have to use an array?

kind regards,

Jos

edit: even early in the morning I'm too slow, *sigh* ...

[sandeep43]

Hi guys,

i am already using variable as pbrockway2 said, since i could not accomplish the task i wanted to use array concept and

@josAh: since i was closing the loop and later also i want to use same values i think my array should be global

So how can i do it guys, help me out?

Regards
Sandeep

[JosAH]

Hi guys,
@josAh: since i was closing the loop and later also i want to use same values i think my array should be global

So how can i do it guys, help me out?

I think you're misunderstanding some of the very basic concepts of the Java language. For one thing: reading a ResultSet and storing its values in an array is tricky: you have to know the number of values in advance; another thing: you can return those values from a method and the caller of the method has to know how to handle them; there is no need for anything 'global'.

kind regards,

Jos

[sandeep43]

ok JOsAh

If thats the case how else can i handle the situation.

Regards
Sandeep

[JosAH]

ok JOsAh

If thats the case how else can i handle the situation.

Use a List of some sort to store the values of the ResultSet and return it from the method that iterates over the ResultSet and fills the List. The caller of that method should know what to do with that List.

kind regards,

Jos

[Tolls]

Your requirements are a bit thin here.
What are you trying to achieve?
Where is this data going?
How much data is it?

[sandeep43]

ok JosAh i will give a shot for it

@tolls: i have a sql which will retrieve data and later this data has to be processed based on few condts and data size is unknown, we cant identify how much client has data in his database.

Sandeep

[Tolls]

If there's a lot of data you might hit a memory problem trying to get it all into objects in a List.
Worht bearing in mind, though we are talking probably in the 10s of thousands of rows here at least.

[sandeep43]

Hi JosAH,

I used a variable and solved thnks for it.

@tolls i am able to handle 40,000 tables and more also as of now, in real time it will be less than that i am pretty dam sure about it.
Thnks guys

Regards
Sandeep

[JosAH]

Hi JosAH,

I used a variable and solved thnks for it.

@tolls i am able to handle 40,000 tables and more also as of now, in real time it will be less than that i am pretty dam sure about it.
Thnks guys

I simply don't understand how you solved it; a variable for what? 40000 tables? But never mind; I'm glad you solved your issue ...

kind regards,

Jos