I am using Rational Application Developer 220.127.116.11 to develop a web application that allows the user to read/write to a table (let's call it Table X) on a server-side database. I am not a Java programmer (I come from the C++ world), but I have completed the part described above by adapting the tutorial that came with RAD's documentation, "Display dynamic information on web pages with JavaServer Faces", for my purposes.
Here's my problem. As of now, the data administrators update Table X manually by comparing it against an Excel file that the administrators periodically receive. If there is a record in the Excel file that isn't in Table X, they add it to Table X.
My problem is I need to automate this process.
Therefore, I need to have a JSP in my web app that does this:
(1) uploads an Excel file, then
(2) checks the Excel file's contents against Table X in my database, and then
(3) displays on a JSP the records in that Excel file that are not in Table X, and
(4) for each displayed record, provides a check box next to it, such that the user can check it if they want to add that record to Table X, or leave it unchecked if they don't want to add that record;
(5) finally, provides a button that adds all the checked records to Table X.
I imagine that Jakarta POI (or possible JExcel?) will be used to read the Excel spreadsheet.
Now comes the unusual part. I don't simply want to receive the completed project from you. I want you to describe to me, step by step (rather in the style of the tutorials that come with RAD), how to do this. Even though Java isn't my area of expertise, I would like to learn it eventually, and this is a good opportunity.
(The tutorials and how-tos I've seen online that might've helped me with this problem have presumed more Java experience than I have, and therefore I have been at a loss.)
This should be a piece of cake for an experienced user of RAD.