DEPARTMENT OF INFORMATION TECHNOLOGY
SWARNANDHRA COLLEGE OF ENGINEERING AND TECHNOLOGY
(AUTONOMOUS)
SEETHARAMPURAM, NARSAPUR-534280. [Link].,
EXTERNAL LABORATORY EXAMINATION
Subject: Advanced Java Lab (R23) Year: 2025-2026
Course Code: 23IT3L01 Class: III [Link] – IT
Faculty: Mrs. R Uma Aruna Devi Semester: V
Date of Exam: 04-12-2025 Timings: 09:00AM To 4:00PM
LIST OF PROGRAMS
1. Write a JDBC application which will interact with Database and perform the following task.
a. Create Student Table with Roll No, Name, and Address field and insert few records.
b. Using Statement Object display the content of Record.
c. Using Statement Object Insert Two Record.
d. Using Statement Object Update One Record.
e. Using Statement Object Delete One Record.
f. Using Statement Object display the content of Record.
2. Write a JDBC application which will interact with Database and perform the following task.
a. Create Student Table with Roll No, Name, and Address field and insert few records.
b. Using Prepared Statement Object display the content of Record.
c. Using Prepared Statement Object Insert Two Record.
d. Using Prepared Statement Object Update One Record.
e. Using Prepared Statement Object Delete One Record.
f. Using Prepared Statement Object display the content of Record
3. Write a JDBC application which will interact with Database and perform the following task.
a. Create a store procedure which will insert one record into employee table.
b. Create a store procedure which will retrieve salary for given employee id.
c. Write a java application which will call the above procedure and display appropriate
information on screen
4. Design a JDBC application which will demonstrate Scrollable Result Set functionality.
5. Design a JDBC application which will demonstrate Updatable Result Set functionality.
6. Write down the Program for testing the Servlet and study deployment descriptor.
7. Write down the program for testing the include action for servlet collaboration.
8. Create login form and perform state management using Cookies, Http Session and URL
Rewriting.
9. Write down the Program which displays the simple JSP file
10. Write down the program in which input the two numbers in an html file and then display the
addition in JSP file.
11. Perform Database Access through JSP.
12. Write down a program which demonstrates the core tag of JSTL.
13. Write down a program which demonstrates the Format tag of JSTL.
14. Write down a program which demonstrates the Function tag of JSTL.
15. Write down a program which demonstrates the SQL tag of JSTL.
16. Study and Implement MVC using Spring Framework
17. Using Spring Template manage Database and Transaction.
SCHEME OF EVALUATION
Description 10M
Program 25M
Execution 15M
Output 10M
Viva-voce 10M
TOTAL 70M
Internal Examiner External Examiner
Name: Name: