Assignment No. 03(Non-Graded)
SEMESTER Spring 2014
CS506- Web Design and Development
Total Marks: 20
Due Date: 10/07/2014Instructions
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file corrupt.
The assignment is full or partially copied from (other student or ditto copy from handouts or internet).
Student ID is not mentioned in the assignment File or name of file is other than student ID.
The assignment is not submitted .java format.
Uploading instructions
Your submission must include:
All the source code (.java files), .class file, html files and xml file and other necessary files to compile and run your program.
Must follow directory structure and place each file(s) in their respective directory.
Place all the files in a Zip file and Upload it on VULMS.
Objective
The objective of this assignment is
To give you some practice exercise of web based application (Java Servlets) using Notepad.
Important Requirements and Instructions:
You can use any IDE tool like Netbeans, Dreamweaver etc only for developing GUI for this assignment.
Assignment due date is July 10, 2014.
We will not accept assignment through email in any case. Be Careful
Lectures Covered: This assignment covers Lecture # 25 t0 28
Deadline
Your assignment must be uploaded/submitted at or before 10/07/2014.
For any query about the assignment, contact at cs506@vu.edu.pk
GOOD LUCK
Student Grade Book (SGB) of XYZ Institute is used to store and display student profile information and scores in different semesters. It provide facility to the student to find all the required information like semesters and courses studied, score in each course, Grades and Grade Points etc. at a single point. SGB will provide the functionality like to add Grade Book information and also view this information and also delete specific information.
As we have already practiced desktop based application for the Student Grade Book (SGB). Now it is intended to provide you some practical exercise on web based application.
In this assignment we are going to develop a web based application for the Student Grade Book (SGB) using java servlet.
Solution Guideline
First of all set the directory structure for Apache tomcat
You have to create “index.html” page contains 3 links i.e. Home, Add GradeBook Info and View Grade Book Info.
Then create “addGradeBookinfo.html” and “viewGradeBook.html” file.
After the creation of html files you are required to write Java servlet code.
In java servlet code you have to write the java code that reads entered data from “form” and save it in database table.
This information will be stored in “GradeBook” table of “GradeBookDb” database.
Only use the template database provided with the assignment file and use data source name “GradeBookDSN” only. Make sure that there will be no modification in the database table or fields name.
Following Directory structure for Apache tomcat will be used:
te:
Place all the .java files in “Java files” folder.
Place all the “.class files” in “classes” folder; which is sub folder of WEB-INF folder
Develop the layout of website in html (as show in sample output)
Your Apache tomcat must be installed in a Drive C as a root folder
Use Notepad or Notepad++ for coding
Tomcat installation guidelines kindly consult handouts and lectures
Snapshots of the desired solution are given in the following pages
Sample Output:
Step:1
When user visit the main page:
Step-2:
When user click on Add Grade Book Info link
Stpe-3:
After filling the form, when user click on “submit” button then all the entered values in the form will be saved in “GradeBook” table of “GradeBookDb” database. And database table looks like:
Stpe-4
After filling the form, when user click on “Reset” button then all the entered values in the form will be Cleared(Disappear)
Step-5:
When user click on View Grade Book link
Step-8:
When user enter student ID and Click on “View Record” button.
=====================================Ended=============================
Students Having This Subject.. Must Participate In Assignment Discussion.............
ReplyDelete