I have a SQL procedure that generates a util file as its output depending on the input parameters that are passed to it.
I have to pass these parameters from an HTML page from 3 text boxes. There will also be a button, on clicking which, the procedure will be called and the util will be generated.
I thought of doing it in jsp and writing the full procedure there itself. But I want the util file to be opened in WORD the moment it is generated.
I want to know how to call a procedure using button and how to show the util after its generated.
A few guidelines:
GETpreferably) in order to do processing on the server-side
.doc, you can use Apache POI.
If you are not familiar with JDBC or POI, you will need to go up a steep learning curve. There is no magical way to generate a file in a desired format.