1. (25 pts) Java Application GUI and JDBC
Create a Java Application GUI SimpleGUI.java using Netbeans/Eclipse IDE to query author names from the book database (the same database used in the assignments). The Java Application GUI should consist of a JList, a JComboBox, JTextArea, and a JButton. The application will display all the author names of the books in a JTextArea if the book’s copyright year is 2005 or later (the book names are selected by the user in the JList, the copyright year is selected from the drop-down list of the JComboBox).

The JDBC code should be in a separate class. The SimpleGUI will call the JDBC functions in the JDBC class.

Submit your java application project files and a Microsoft word report with the full screen shots (with the date and time stamps) of the major steps of your GUI program development in Netbeans/Eclipse, and run results. You must test your program with a selection of multiple books.

2. (25 pts) HTML GUI and Servlet
Write a HTML5 form SimpleServlet.html and a Java Servlet SimpleServlet.java to query the author names same as in the problem 1. The Servlet should call the JDBC function from a separate JDBC class.
Host the Servlet in an external Java Web Server (Don’t run it inside Netbeans/Eclipse IDE.)
Submit your SimpleServlet.html and Java Servlet project files and a Microsoft word report with full screen shots (with the date and time stamps) of the major steps of developing and deploying your Servlet program, and run results.

4. (30 pts) HTML GUI and JSP
Write a Java JSP SimpleJSP.jsp to query author names same as in the problem 1. The JSP page will use a custom Tag to get book names and copyright year, and list all the authors of the book with the query condition same as in the Problem 1.
The custom Tag should call the JDBC function from a separate JDBC class.
Host the JSP in an external Java Web Server (Don’t run it inside Netbeans.)
Submit your Java JSP and tag project files and a Microsoft word report with full screen shots (with the date and time stamps) of the major steps of developing and deploying your JSP page and Custom Tag, and run results.

5. (10 pts) JSF
Develop and run a HelloPeoria JSF page in NetBeans/Eclipse IDE.
Submit your JSF project files and a Microsoft word report with full screen shots (with the date and time stamps) of the major steps of developing and test your HelloPeoria JSF page.

6. (10 pts) Web Service
Develop and run a HelloPeoria SOAP web service in NetBeans/Eclipse IDE.
Submit your web service project files and a Microsoft word report with full screen shots (with the date and time stamps) of the major steps of developing and test your HelloPeoria web service.