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.
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.
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.