I have a screen consisting of four fields namely, first name, last name, birth date (MM/DD/YYYY) format, date received (MM/DD/YY) format and an Add button.
On the top of the screen I have a Sequence=Initial(its not a drop down list or anything like that).
In the Oracle 9i , I have a table named FORM, and columns are FIRST_NAME, LAST_NAME, BIRTH_DATE (stored in MM/DD/YY format), and DATE_RECEIVED(in MM/DD/YY format), SEQUENCE, FOLLOW_UP and ADDITIONAL_INFO.
User enters the data and it gets stored in the database.
I have another screen called Search People corresponds to the table SEARCH_TABLE in the database. This screen has two fields namely (last name, and date of birth), one drop down list called Sort by ( option 1= last name, option 2 = date of birth), and the search button. When the user hits the search button, it will display the results in a table in the same JSP page. The displayed names will have hyperlinks. The user clicks one of the link and the editable first screen will be displayed with all the fields populated. Now the Sequence will be Follow Up1 instead of Initial. If the user doesnt change anything, this form will be saved in the FOLLOW_UP column as follow up1. But if the user changes or adds some values in the editable fields, this form will be saved in the database in additional_info column. So when the user fetches the same time next time, it will be stored as follow up 2, follow up 3, with or without additional info 1 , additional info2 etc.
Note: I have all the getters and setters for all the columns. You can use dummy variable in your solution code.
My problems are:
1) Java Code for the search button(to search with one of the two criterias).
2) To display the results in a table in the same JSP page.
3) Code to do the Follow up and additional info business logic.
4) Code to pop up(via hyperlink) the editable already populated fields.
Since this is very urgent, your speedy solution will be greatly appreciated.
