Administration of Student Database-Web Design and Development-Assignment Solution, Exercises of Web Design and Development

This is solution to assignment of Web Design and Development course. Its code in java language. Its main points are: Web, Design, Development, Java, Admin, Login, Interface, Business, Logic, Record, Id

Typology: Exercises

2011/2012

Uploaded on 08/01/2012

ambuja
ambuja 🇮🇳

4.4

(5)

92 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Assignment No.4 Web Design and Development
(CS506)
Marks:
20
Due Date:
27/06/2012
Assignment Solution:
Solution is uploaded in your LMS account.
Assignment Solution Step by Step:
You have to create one java and six jsp files (DbConnection.java, index.jsp, studentinfo.jsp,
projectinfo.jsp, ManageAdmin.jsp, ManageStudent.jsp, ManageProject.jsp).
The reason of creating 7 files is maintainability.
DbConnection.java is used to connect our application with database.
Index.jsp is for admin login interface.
Studentinfo.jsp for student interfaces.
Projectinfo.jsp for project interfaces.
ManageAdmin.jsp for admin login business logic.
ManageStudent.jsf for student business logic.
ManageProject.jsp for project business logic.
Common Mistakes &
Explanation:
Update problem.
For update send record ID in this way to target page.
http://localhost:8080/assignment4/targetpage.jsp?id=1
On target page query the database and get the record which have id=1.
Display retrieved values into boxes.
On submitting send this ID again to new target page which will update the
record.
Update problem.
For update send record ID in this way to target page.
http://localhost:8080/assignment4/targetpage.jsp?id=1
docsity.com
pf2

Partial preview of the text

Download Administration of Student Database-Web Design and Development-Assignment Solution and more Exercises Web Design and Development in PDF only on Docsity!

Assignment No.4 Web Design and Development (CS506)

Marks: 20

Due Date: 27/06/ Assignment Solution:

Solution is uploaded in your LMS account.

Assignment Solution Step by Step: You have to create one java and six jsp files (DbConnection.java, index.jsp, studentinfo.jsp, projectinfo.jsp, ManageAdmin.jsp, ManageStudent.jsp, ManageProject.jsp). The reason of creating 7 files is maintainability. DbConnection.java is used to connect our application with database. Index.jsp is for admin login interface. Studentinfo.jsp for student interfaces. Projectinfo.jsp for project interfaces. ManageAdmin.jsp for admin login business logic. ManageStudent.jsf for student business logic. ManageProject.jsp for project business logic.

Common Mistakes &

Explanation: Update problem.

For update send record ID in this way to target page. http://localhost:8080/assignment4/targetpage.jsp?id= On target page query the database and get the record which have id=1. Display retrieved values into boxes. On submitting send this ID again to new target page which will update the record.

Update problem.

For update send record ID in this way to target page. http://localhost:8080/assignment4/targetpage.jsp?id=

docsity.com

Send record ID to target page which will delete the record.

docsity.com