Hello. First I must excuse myself. I'm a totally new beginner in Java, and could really need some help about an idea I have got. I want to retrieve some data from a table with a recursive sql-statement. Then the retrieved data are to be written to a .js-file. The catch is that the data has to be represented in an array with array's ( the structure of the .js-file have to be an array with arrays). Does anybody have an idea of how to put that kind of code together in an easy way? Thanks for helping me out. I guess I just need an example to really get started on this. ------------------
Anonymous
Ranch Hand
Joined: Nov 22, 2008
Posts: 18944
posted
0
You will probably find more help for SQL problems in the JDBC forum. A rough overview of how I would go about this would be as follows:
Create a JDBC connection to my datasource
Execute a SQL Statement and capture the result in a ResultSet
Step through the ResultSet using the next() method inside of a loop
On each pass, write out one line of my .js file
HTH [This message has been edited by Bodie Minster (edited May 02, 2001).]
0
