Client-Server Student Registrar

Phase 1 Individual Project

Write a client and server, Java Swing application using socket connections that allows the client to specify a filename to the server in a Textfield and the server send the contents of the text file back to the client if it exists. If the file does not exist, then it should send back an appropriate error message instead. Submit your zipped NetBeans project with all files, essay, and screenshots demonstrating your code runs. In both the Client and the Server a JTextArea must reflect the messages sent and received in both the client and the server in order to give the user feedback.

Task Name: Phase 2 Individual Project

Modify the client server application developed for phase 1 IP2 to be a Multithreaded Server (i.e. the server can handle concurrent requests from more than one client). Submit your zipped NetBeans project and screenshots to demonstrate that you program runs correctly.

Task Phase 2 DB 2

Write the SQL statements to accomplish the following tasks:

• Using either the Derby Database or MySQL database from within NetBeans create an empty database called "registrar".
• Using an editor create a file called "Registrar.sql" which will contain SQL Create Statements for each table structure for each table implied in the provided file: Registrar.sql
• The Registrar.sql file should also contain SQL statements to Insert each row of data from the tables in ExampleDatabase.zip into its appropriate table.
• After Registrar.sql has the Create and Insert Statements, populate the registrar database from it.
• Utilizing the NetBeans Query Tool:
  • Develop a query to select all course rosters by instructor sorted by instructor and course name for fall semester 2009 (F09)
  • Develop a query to select all student schedules sorted by student for fall semester 2009 (F09).

Take screenshots for each step, write explanatory captions for each, and post along with your essay. For your essay, post your SQL statements that you developed and discuss any challenges you had.

Task Name: Phase 2 Individual Project 2

Using the registrar database that you created in the previous task, write a Java Swing application that exercises these queries.

• Develop a query to select all course rosters by instructor sorted by instructor and course name for fall semester 2009 (F09)
• Develop a query to select all student schedules sorted by student for fall semester 2009 (F09).

Hint: The queries can just be typed in utilizing a jTextfield. The result of queries should be shown in a Swing Table.

Task Name: Phase 3 Individual Project

Create a Web application that uses the Java Server Faces framework and either Apache Tomcat or Glassfish as the server. Add a form for user input and the necessary TextFields as well as a table component to the page. Add the students table from the registrar database provided and bind the table component to the STUDENTS table. Take screenshots to demonstrate that your program runs.

Task Name: Phase 3 Individual Project 2

Add form validation to the Web Application created in the Phase 3 IP. Review the code behind the JSP file you created. Add comments at the top of the file that describe what the purpose of the files is. Include your name and date the file was created. Take screenshots and add captions (at least 2 sentences for each) to explain how you modified your code to add form validation. Submit your zipped NetBeans project and screenshots with captions.