MySQL into an Array

[vikramlovely4u]

can any one provide me code for retrieving data from mysql to an array

[JosAH]

My question is this, when this block executes exactly what variable is the program sending the words from the file to? Just glancing at it I'm assuming they are all being saved to a string. Which variable is the data going to? I know this might sound elementary to some of you but I am having a time figuring it out and want to make sure I do this correctly!

Also, after that what method is used to convert my string into an array? You could just point me to the method I need to use that is provided by the Java program and I can probably look it up in documentation and it take from there.

Thanks!

If you change this comment line: '// process line of data' to an actual statement, such as:

System.out.println(line);

... you have an executable piece of code and you can see what it does by running it. The instruction wants you to add functionality at the '...' line. Also read the API documentation, you'll need it (sorry, no link, I didn't have my espresso yet ;-)

kind regards,

Jos

[Fubarable]

vikram,
Please don't hijack another's thread but rather ask your new question in its own thread. Hijacked post moved into own thread and old thread locked.

[Tolls]

can any one provide me code for retrieving data from mysql to an array

What have you done so far, and what doesn't work?

The basic structure is:
get connection
create or prepare a statement
execute the statement to get the result set
loop through the result set creating an object that represents the data returned for each row, storing that in a list.
close everything in a finally block.