Download SQL result into a CSV file.

[pigdogmonster]

I have been informed this is possible but am not sure how to do this.

I basilcally want the person who is logging on to be able to download information about each days work:- e.g.

Download

Todays Loads - Tommorrows loads - Day After thas loads

If they select Todays loads an SQL query will be run for todays date and I want the result to be downloaded into a CSV file.

If 'Tommorrows loads' is selected then a query will be run with tommorrows date and so on.

Any ideas?

Example code would definatly help as I'm a newbie!

Many thanks

 

[sedj]

Take a tutorial on JDBC :

http://java.sun.com/developer/onlineTraining/Database/JDBCShortCourse/