Two Laptop Bag*
The moose likes Servlets and the fly likes is it possible to do this with servlets? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "is it possible to do this with servlets?" Watch "is it possible to do this with servlets?" New topic
Author

is it possible to do this with servlets?

Nicole Jones
Greenhorn

Joined: Mar 18, 2011
Posts: 21
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
Marshal

Joined: Mar 22, 2005
Posts: 39549
    
  27
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.


Ping & DNS - updated with new look and Ping home screen widget
Nicole Jones
Greenhorn

Joined: Mar 18, 2011
Posts: 21
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: is it possible to do this with servlets?
 
Similar Threads
how to scroll data to view other records
Disable reord One by one in jsp
Navigate back and forth in JSP pages
How to link different buttons to different action methods
displaying database records rowwise in the table