SQL to Java array

[Patrick Mallahan]

I am wanting to take several large databases from an SQL server and put them in arrays in my Java code. I know I will use java.sql.* but i dont know how I would go about pulling the info and putting it in.

[K Riaz]

Search google for a JDBC tutorial.
[ June 20, 2005: Message edited by: Bill Rushmore ]

[Patrick Mallahan]

what about taking a string of:

Ball|Red|soccer|Yes

that exists in a Vector row and taking all the values and putting it into a Vector with seperate colums.

[John Martinson]

I've had success using the ResultSet class in java.sql. in the API specs on the java.sun page there are some examples and what not.

basicly what you do is
in psudo code*
// set Result rs = statemant.executeQuerry("SQL Querry");
//rs.next() will let you go through the rows
//String s = rs.getString(columnNo.);

that's a really simple and ugly overview, but once you start looking at the Java docs on http://java.sun.com/reference/api/index.html you'll get the idea on what to do.

John Martinson