Exercise 1 - JavaBeans, Self-Call

a) a page "MiniAdd.jsp" that carries out simple additions of two numbers. The JSP should:

• present a form where the user can specify two numbers,
• contain a submit button that posts back to the same page (i.e. "miniadd.jsp"),
• show the result of the requested addition, and also
• show the sum of all the additions carried out by the user so far.

and use a JavaBean ("SumBean") to validate user input and to perform the addition. The same bean should also be used to store the sum of all additions. (Consider that the page does not receive input parameters when it is called the first time.)

b)Add a "Reset Button" to the page with which the user can reset the sum of all additions.

Exercise 2 - JDBC, SQL, Address Management Application

a JSP based web application for address management, which allows to register and delete entries and to search for entries based on partial information given.

a)Create the table "addresses" with a structure as follows (in a server database of your choice).

Column Name	Type
#id	INT UNSIGNED
fname	VARCHAR(80)
sname	VARCHAR(80)

telephone	VARCHAR(30)
mobile	VARCHAR(30)
email	VARCHAR(80)
address	VARCHAR(100)
postalnr	VARCHAR(10)
town	VARCHAR(40)
country	VARCHAR(30)

Define "id" as the primary key for the table and set it as automatically incrementing for this column to guarantee a unique identity of "id" (as follows)

create unique sequence MY_ID_SEQUENCE;

(in the table definition: ID integer default next_value of MY_ID_SEQUENCE, ...)

b) a JSP "Register.jsp", which provides a form to insert a new entry for a person into the table, and another JSP "exRegister.jsp", which actually performs the required INSERT statement. Use a JavaBean "AddressBean" to check the validity of a record before inserting it into the database, i.e. check that at least a first name is given (a surname might not always be accessible to you in the case of persons known only by their nickname), and also either the number of a stationary or a mobile phone or an e-mail address was specified. In case of invalid information, redirect the request to "Register.jsp" and make sure that the user does not have to enter valid parts of the record again. Use the "AddressBean" bean to annotate those fields in the registration form, which caused the insertion of the record to fail, with a reasonable error message. If a new record was successfully added to the table using "Register,jsp", redirect the request to the page "DeleteAddress.jsp", which you are going to write in the next subtask.

c)Add JSPs "DeleteAddress.jsp" and "exDelete.jsp". The JSP "DeleteAddress.jsp" presents a list of all entries each followed by a "Delete" button. The "Delete" button is linked to "exDelete.jsp", which carries out the deletion in the database table. Take care not to exchange more information than required between "DeleteAddress.jsp" and "exDelete.jsp".

d)If a new record was successfully added to the table using "Register,jsp", redirect the request to a page "SearchAddress.jsp". This page offers another form where the user can specify partial information concerning arbitrary fields the records in the "addresses" table contain. Carry out the SELECT statement corresponding to the information given in "SearchAddress.jsp" in a JSP "exSearchAddress.jsp" and display the result in "SearchAddressResult.jsp". For selection of an address, combine the fields that specify the search in the way that seems suitable for you.

Exercise 3 - JavaBeans to Encapsulate Application Logic

If not already done so, modify the Address Management application of exercise 2 such that all the application logic, particularly concerning database access is encapsulated in JavaBeans.