is it possible to do this with servlets?

[Nicole Jones]

i have an excel spreadsheet with almost 1000 rows of data that I plan to import into a database. Is it possible to dynamically generate a detail page for each row or record based off a unique id (a column in the xls)? Or would I have to manually create a page (or jsp in this case) for each record? any input will be greatly appreciated.

[Ulf Dittmer]

There would be only one page, and it would take the record ID as a parameter. The logic to retrieve the data based on that parameter would be part of a servlet, and it would then dispatch to the JSP that generates the HTML.

You can use the Apache POI library to read the Excel file.

[Nicole Jones]

thank you for your response.

so i don't necessarily need the database. we have one so i was thinking we might as well use it.

Ulf Dittmer wrote:There would be only one page, and it would take the record ID as a parameter. The logic to retrieve the data based on that parameter would be part of a servlet, and it would then dispatch to the JSP that generates the HTML.

You can use the Apache POI library to read the Excel file.