Advance Java Programming Lab
SEMESTER – IV
Course Code: 23CSE3002 Course Credits: 2
Teaching Hours / 4 (0:0:4) CA Marks: 25
Week (L: T: P):
Total Number of 60 END-SEM Marks: 25
Teaching Hours:
Prerequisites: BASIC JAVA PROGRAMMING
Companion Course : ---
Course Objectives:
The main objectives of the course are to:
1. To understand the JDBC architecture and different JDBC drivers, and effectively connect Java
applications to databases.
2. To develop the ability to design and implement interactive graphical user interfaces using Java
Swing components, event handling mechanisms, and layout managers.
3. To familiarize students with server-side programming concepts by developing dynamic web
applications using Servlets and JavaServer Pages.
4. To impart knowledge of the MVC design pattern and enable students to build structured,
scalable web applications with proper session and user management.
5. To introduce Spring and Hibernate frameworks fundamentals.
Course Outcomes:
At the end of the course students will be able to:
1. Demonstrate proficiency in Java Database Connectivity (JDBC) by establishing database
connections, executing SQL queries using Prepared Statement and Callable Statement, and
implementing batch processing for improved database interaction.
2. Design and implement user-friendly Java GUI applications using Swing components, event
listeners, and layout managers.
3. Develop dynamic web applications by handling client requests, form data, and server-side
processing using Servlets and JSP technologies.
4. Implement MVC-based Java web applications with effective session management,
authentication, and cookie handling mechanisms.
5. Develop enterprise-level applications using Spring and Hibernate frameworks.
Course Contents
UNIT I Java Database Connectivity (JDBC)
Overview of JDBC: JDBC architecture, JDBC drivers
Connecting to Databases: Establishing database connections, Connection pooling
Executing SQL Queries: PreparedStatement and CallableStatement, Batch processing.
Pedagogy ICT Teaching / Power Point Presentation and Videos: PPT + Videos
Self-study / Do it yourself : Creation of database, table using MYSQL
Experiential Learning Topics: Configure and test different JDBC drivers
(MySQL, PostgreSQL, Oracle).
Case Study / PBL - Project Based Learning : Design a student database
system using JDBC.
UNIT II Java GUI Programming
Java GUI Programming: Swing framework fundamentals, Event handling and listeners, Layout
managers, Custom components and painting.
Pedagogy ICT Teaching / Power Point Presentation and Videos: PPT + Videos
Self-study / Do it yourself : Study differences in Swing vs AWT
Experiential Learning Topics: Design Swing-based GUI forms and integrate
them with a backend database.
Case Study / PBL - Project Based Learning : Design any simple game
using Swing
UNIT III Java Servlets and JavaServer Pages (JSP)
Introduction to Servlets: Servlet life cycle, Servlet containers
Servlet Configurations and Parameters: Initialization parameters, Context parameters
Handling Form Data: GET and POST methods, HTML forms and servlets
Introduction to JSP: JSP life cycle, JSP expressions and declarations
Directives and Actions: Page directives, JSP actions and implicit objects
JSP Tag Libraries: Standard and Custom Tag Libraries, Expression Language (EL)
Pedagogy ICT Teaching / Power Point Presentation and Videos: Guest lecture + PPT
+ Videos
Self-study / Do it yourself : Understand fundamentals of web and create pages
using HTML
Experiential Learning Topics: Create interactive web applications using
Servlets and JSP by implementing session handling to maintain user state and
personalize responses.
Case Study / PBL - Project Based Learning : Develop a dynamic
e-commerce web application using Servlets and JSP, integrating JDBC-based
database connectivity for persistent data storage and retrieval.
UNIT IV Model-View-Controller (MVC) Architecture
MVC Design Pattern: Separation of concerns, Implementing MVC in Java web applications, Session
management and authentication, HTTPSession and Cookies: Managing user sessions, Cookie handling.
Pedagogy ICT Teaching / Power Point Presentation and Videos: PPT + Videos
Self-study / Do it yourself : Study of MVC vs Traditional Web Design
Experiential Learning Topics: Implement MVC Architecture in a Java Web
Application
Case Study / PBL - Project Based Learning : MVC-Based Student
Management System
UNIT V Introduction to Spring and Hibernate Framework
Introduction to Spring: Dependency Injection (DI) and Inversion of Control (IoC), Spring AOP
(Aspect-Oriented Programming)
Introduction to Hibernate: Object-Relational Mapping (ORM), Hibernate architecture
Mapping in Hibernate: Mapping Java classes to database tables, HQL (Hibernate Query Language)
Pedagogy ICT Teaching / Power Point Presentation and Videos: PPT + Videos +
Guest lecture
Self-study / Do it yourself : Dependency Injection (DI) and Inversion of
Control (IoC), Spring AOP (Aspect-Oriented Programming)
Experiential Learning Topics: Create a Spring-Boot application using
Annotation-based DI
Case Study / PBL - Project Based Learning : Student Management System
using Spring & Hibernate
Learning Resources
Text Books:
1. Herbert schildt (2010), The complete reference, 7th edition, Tata Mc graw Hill, New Delhi
Reference Books:
1. Head First Java, 2nd edition O‟rielly publications
2. "Java EE 8 Development with Eclipse" by Ram Kulkarni
3. Y. Daniel Liang (2010), Introduction to Java programming, 7th edition, Pearson
education, India.
4. "Java Server Programming Java EE6 (J2EE 1.6) Black Book" by Kogent Learning Solutions
Inc.
5. "RESTful Java with JAX-RS" by Bill Burke
MIT School of
Computing
Sr. Name of Experiment/Assignment CO
No
.
Create a Java program using JDBC (Java Database Connectivity) to connect to a
database, retrieve data from a table, and display the results. Let's consider a scenario
where we have a MySQL database named "example_db" with a table named
1 CO1
"employees". The "employees" table has three columns: "id", "name", and "salary". We
want to retrieve all records from this table and display them using JDBC in a Java
program. (JDBC)
Create a Java-based GUI application that includes a user login page with full database
connectivity. The application should allow users to enter their username and password,
2 CO2
validate the credentials against a connected database, and display appropriate success or
failure messages.
Create a Java GUI application to calculate the simple interest based on user input for
CO2
3 principal amount, rate of interest, and time period. (Java GUI)
Create a Java servlet that takes input from a web form, calculates the area of a circle CO3
4 based on the provided radius, and displays the result on a web page. (Servlet )
Create a Java web application using JSP (Java Server Pages) that takes input from a
user, calculates the factorial of the provided number, and displays the result on a web CO3
5
page. (JSP)
Implement a simple Model-View-Controller (MVC) architecture for a Java application
that simulates a basic online bookstore. The application should allow users to view a list CO4
6
of available books, add books to their cart, and view the contents of their cart. (MVC)
Create a basic Java project using Apache. Follow the standard Maven directory structure.
7 CO5
Add at least one dependency in the [Link] file.
Create a simple web application using the Spring Framework that allows users to
8 manage a list of tasks. The application should provide functionality to view existing CO5
tasks, add new tasks, mark tasks as completed, and delete tasks. (Spring Boot)
Create a Java application using Hibernate framework to manage a simple database of
students. The application should allow users to perform CRUD operations (Create,
CO5
9 Read, Update, Delete) on the student records stored in the database.
(Hibernate framework)
Create a REST API to add employees to the employee list and get the list of
10 employees. In order to do this, first create a simple Spring Boot project in any of the CO5
IDE’s
MIT School of Computing
ASSESSMENT AND
EVALUATION PATTERN
End Semester
WEIGHTAGE Continuous Assessment (CA)
Assessment (ESA)
CA - Assignments (PBL / Case Study / Presentation / Seminar / Group Discussions / Quiz / Test
ESA - Bloom’s Taxonomy Levels: Remembering, Understanding, Applying, Analyzing, Evaluating,
and Creating
Experiential Learning - Internship (Summer / Winter) / Industry Visit / Site Visit / Field Trips
Project Based Learning – Mini (Minor) Project / Major Project
Course Articulation Matrix (CO-PO Mapping) [Java Programming Lab – 23CSE3002]
Relevant to
PSO National/
COs PO- PO- PO- PO- PO- PO- PO- PO- PO- PO- PO- PO- PSO PSO- - Global/Regiona
1 2 3 4 5 6 7 8 9 10 11 12 -1 2
3 l
CO-
1 3 2 2 - 3 1 1 3 3 2 National/Global
CO-
2 3 2 2 - 3 1 1 3 3 2 National/Global
CO-
1 1 National/Global
3 3 2 2 - 3 3 3 2
CO-
4 3 2 2 - 3 1 1 3 3 2 National/Global
CO- National/Global
5 3 2 2 - 3 1 1 3 3 2
3 – HIGH, 2 – MEDIUM, 1 - LOW