I have to create a form using JSP/Servlets with the following form fields
Country of Production //Where the product was manufactured
Product Certificate Details
Country of Issue
The purpose of the form is so that the user can enter the customer details, product details and certificate details and submit the form for the data to be saved on to an database. That is ok if it was that simple
The idea is to make the form as easy as possible to complete so the following functionality will be available on the form.
A search icon will be available next to Customer ID which when clicked will display a pop up window with a list of all the customer ids available. The user can then select a customerid from the pop up window and the application will populate the customer details on the parent window based on the ID.
A similar type of popup/lookup window will be available for Productid, product code in product details and certificate id in certificate details.
There will also be a lookup window for all the country elements in the form. I.e Country under customer details, Country of production and country of issue.
Now the bit that i am interested in is what is the best way of implementing this using jsp,servlets and struts. I am mainly interested in knowing how you would implement the following functionality
1 - The database stores nearly 23,000 product codes. If the user selects the search icon to load all the product codes so that they can select one, how would you manage these? Presumabely it wont make sense to display 23,000 product codes for the user to select 1 from the list. I think the best way to do this is to paginate the list on the popup window. Is there anything in JSP to simplify this?
The other question is where/how would you store the product codes on the client? or would you store them at all?
2. The other thing that i would like some advice on is what is the best way to implement the lookup window for Country, Country of Production and Country of issue. Im thinking as all these 3 elements are retrieving the same data i should have a generic component that can be used for all 3. How can you make the generic component to determine which form field of the 3 is to be populated if they have different names?
4. And finally finally, is it better to display the pop window in a "new window" or a hidden css DIV layer?