DVR & Dr.

HS MIC College of Technology

(Autonomous) MIC23 (w.e.f. 2023-24)
L T P C
B TECH V Semester Advanced Java
3 0 0 3
Course Objectives:
This course develops programming ability of students to create dynamic web
applications using server side technology with Java Database Connectivity. Students
can learn networking and remote method invocation using Java API and different
Java frameworks like Spring will increase ability of students in web application
development.
Course Outcomes:
CO1: Understand and apply JDBC architecture and driver types to develop basic database
applications using various JDBC statements and manage transactions effectively.
CO2: Comprehend the J2EE multi-tier architecture and utilize appropriate containers and servers
to design structured web applications.
CO3: Develop and deploy Java Servlets by understanding their life cycle, configuration, and
session management techniques to handle dynamic web content.
CO4: Design dynamic web pages using JSP by leveraging its architecture, life cycle, scripting
elements, and tag libraries to build interactive web applications.
CO5: Implement web applications using the Spring MVC framework by understanding its
architecture, dependency injection, and integrating data access objects for efficient database
operations.
COURSE ARTICULATION MATRIX (Correlation between COs, POs &PSOs):
CO/ PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
PO
CO1 3 3 2 2 2 - - - 1 1 - 2
CO2 3 2 3 2 2 - - - 1 1 - 2
CO3 3 3 3 2 2 - - - 1 1 - 2
CO4 3 3 3 2 2 - - - 1 1 - 2
CO5 3 3 3 2 2 - - - 1 1 - 2

Unit I:
JDBC Programming : JDBC Architecture, Types of JDBC Drivers, Introduction to
major JDBC Classes and Interface, Creating simple JDBC Application, Types of
Statement (Statement Interface, Prepared Statement, Callable Statement),
Exploring Result Set Operations, Batch Updates in JDBC, Creating CRUD Application,
Managing Database Transaction.
Unit II:
J2EE and Web Development: J2EE Architecture Types, J2EE Containers, Types of
Servers in J2EE Application, HTTP Protocols and API, Request Processing in Web
Application, Web Application Structure, Web Containers and Web Architecture
Models.
Unit III:
Servlet API and Overview: Servlet Introduction, Servlet Life Cycle(SLC), Types of
Servlet, Servlet Configuration with Deployment Descriptor, Attributes in Servlet,
Response and Redirection using Request Dispatcher and using send Redirect
Method, Filter API, Session Tracking: using Cookies, HTTP Session, Types of
Servlet Event: Context Level and Session Level.
 DVR & Dr. HS MIC College of Technology
(Autonomous) MIC23 (w.e.f. 2023-24)
Unit IV:
Java Server Pages(JSP): Introduction to JSP , Comparison with Servlet, JSP
Architecture, JSP: Life Cycle, Scripting Elements, Directives, Action Tags, Expression
Language(EL),JSP Standard Tag Libraries(JSTL),Exception Handling.
Unit V:
Java Web Frameworks: Spring MVC Spring: Introduction, Architecture, Spring MVC
Module, Life Cycle of Bean Factory, Explore: Constructor Injection, Dependency
Injection, Inner Beans, Aliases in Bean, Spring AOP Module, Spring DAO,CRUD
Operation using DAO and Spring API.

Text Books:
1. Black Book “Java server programming” J2EE, 1 sted., Dream Tech Publishers, 2008.
2. Complete Reference J2EE, James Keogh, McGraw Hill publication
3. Professional Java Server Programming, Subrahmanyam Allamaraju, Cedric Buest,
Wiley Publication
4. Spring in Action, 3rdedition , Craig walls, Manning Publication

Reference Books:
1. Core Java, Volume II: Advanced Features, Cay Horstmann, Gary Cornell
Pearson Publication
2. JDBC™ API Tutorial and Reference, Third Edition, Maydene Fisher, Jon Ellis,
Jonathan Bruce, Addison Wesley
3. Beginning JSP, JSF and Tomcat, Giulio Zambon, Apress
 DVR & Dr. HS MIC College of Technology
(Autonomous) MIC23 (w.e.f. 2023-24)

L T P C
B TECH V Semester Advanced Java Lab
0 0 3 1.5
Course Objectives: the main objectives of the course are
 To make use of Servlet and JSP API in the process of enterprise application
deployment.
 Implement components such as JSTL
 Distinguish Application Server, Web Container, JDBC
 Design and Development of web application having collaboration of Servlets,
JSPs, Spring
Course Outcomes:

CO1: Design and execute complete CRUD workflows on a relational database with
JDBC Statement and Prepared Statement objects.
CO2: Integrate Java applications with database- side stored procedures using Callable
Statement to insert and query data securely.
CO3: Leverage advanced JDBC features—scrollable and updatable Result Set—to navigate
and modify result sets dynamically.
CO4: Develop, deploy and collaborate Java Servlets, including configuration through deployment
descriptors, include actions, and state- management techniques (Cookies, Http Session, URL
rewriting).
CO5: Create dynamic, database- driven web pages with JSP, process user input, employ JSTL core tags,
and integrate JSP with backend data sources.
COURSE ARTICULATION MATRIX (Correlation between COs, POs &PSOs):

CO/ PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO1 PO1 PO1
PO 0 1 2
CO1 3 3 3 2 2 - - - 1 1 - 2
CO2 3 3 2 2 2 - - - 1 1 - 2
CO3 3 2 3 2 2 - - - 1 1 - 2
CO4 3 3 3 2 2 - - - 1 1 - 2
CO5 3 3 3 2 2 1 1 2
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 RollNo, Name, and Address field and insert
few records.
 DVR & Dr. HS MIC College of Technology
(Autonomous) MIC23 (w.e.f. 2023-24)
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

[Link] down the program in which input the two numbers in an html file and
then display the addition in JSP file.

[Link] Database Access through JSP.

[Link] down a program which demonstrates the core tag of JSTL

[Link] down a program which demonstrates the SQL tag of JSTL.

[Link] and Implement MVC using Spring Framework

[Link] Spring Template manage Database and Transaction.

DVR & Dr. HS MIC College of Technology
(Autonomous) MIC23 (w.e.f. 2023-24)