To be continued

[DyeKuu]

http://localhost:8080/inf553-web/QueryServlet?year=2011

This will result in all the info like this.

Click on the name will pass the pid to the servelet. Note that the URL will be different.

The rest is to

• [x] Complete the SQL query as well as the function in Postgresql.java
• [x] Add feature: throw an exception when the year is bigger than 2050 (find a TODO about it)
• [x] Complete the TODO in the code
• [x] Beautify the HTML

[DyeKuu]

This is how it works: First by entering http://localhost:8080/inf553-web/QueryServlet?year=2011, this will send a request to the QueryServlet.java.

After getting the result by calling the function in Postgresql.java, where there is written the SQL script and connection to the database, it will forward the request to Index.jsp.

Index.jsp will receive the variable and display them as you see in the screenshot. Here each name is input button. By clicking it, you call the servlet InfoDisplay.java passing pid as a variable.

In InfoDisplay.java, it mainly does the same thing. This time it will forward the query result to another jsp file InfoDisplay.jsp. However, the functions at this stage are not completed.