• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

is it possible to do this with servlets?

 
Nicole Jones
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic