using JDBC and JavaServlets!
Your are to create the necessary xhtml pages and javaSerlvets so you can now register a student for classes. Using your existing database you must now add the capability to register each student in the database for classes. Your registration program must be a Java Servlet. This requires you to add and update the registration tables in your database. This will require retrieving and modifying data from multiple tables in your MYSQL database.
1. Using the student-id (or name), select a student and display all the courses the student is currently registered for.
2. Include the capability to register each student for classes. The classes must be selected from the courses in your database.
3. Automatically redisplay the courses the student is registered for.
4. Add the capability to remove a course from the specified student's schedule.
Setting up your development environment:
1. Your java class name must assign08 (assign08.java).
(Remember you class name must match your filename)
a. You must place the servlet program in the directory I created for you in the following directory:
b. set the permissions on your java source file to rwx for owner only: (e.g. chmod 700 myfile.java)
c. you must include a package statement in the beginning for your java source file as follows:
2. To compile your servlet program: javac6 -classpath ../../j2ee.jar assign08.java
3. You will use the tomcat application server running on Jordan (184.108.40.206) to run your servlets
4. To test your servlet - from the browser enter: http://220.127.116.11/~yourNetId/assign08.html
or execute it directly by: http://18.104.22.168:8080/cs313/servlet/s13.yourNetId.assign08
Warning: If your assign08.html uses AJAX to request the execution of the servlet, you must use the tomcat web server
instead of the apache web server. (i.e. http://22.214.171.124:8080/~yourNedId/assign08.html)
If you request your assign08.html using the default port 80 it will use apache web server and you will
get an access denied from your ajax request.
5. Once your servlet is finished, you will need to "submit" your java file so I can grade your java servlet
Your .java and .class files need to remain in WEB-INF/classes. However, I need a copy of your java source file
submitted to me, so I can view it. You can run submit from this directory and submit your java source file.
Be sure you have the proper heading comment block in your java source file so the submit will work properly.
* Assignment 08, Java Servlet
* Brother Ercanbrack, cs313
:Note: Tomcat will check your servlet (java class file) and if it has been modified within the last 15 to 30 seconds it will reload your servlet. So with about 20 seconds after compiling your servlet, you should be able to see the changes through the browser.