0% found this document useful (0 votes)
6 views3 pages

JSP Servlet MySQL Practical Projects Guide

The document outlines a series of practical exercises focused on web application development using JSP, Servlets, JDBC, MySQL, and Spring Boot. It includes creating employee and student login and registration modules, building RESTful web services, and managing data with H2 database and JPA. Each practical specifies the necessary components like MySQL tables, JSP pages, Servlets, and Tomcat server setup.

Uploaded by

Manish Bhonde
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views3 pages

JSP Servlet MySQL Practical Projects Guide

The document outlines a series of practical exercises focused on web application development using JSP, Servlets, JDBC, MySQL, and Spring Boot. It includes creating employee and student login and registration modules, building RESTful web services, and managing data with H2 database and JPA. Each practical specifies the necessary components like MySQL tables, JSP pages, Servlets, and Tomcat server setup.

Uploaded by

Manish Bhonde
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Practical 1

1. Create an Employee Login Form and validate the employee's username and
password with the database. Using JSP, Servlet, JDBC and MySQL database.
 MySQL Table
 Login Page (JSP)
 Servlet (Java)
 JDBC Connection Utility
 Tomcat Server
*************************************************************************
Practical 2
2. Build a simple employee Registration Module Using JSP, Servlet, JDBC and MySql
Databases
 MySQL Table
 Login Page (JSP)
 Servlet (Java)
 JDBC Connection Utility
 Tomcat Server

*********************************************************************

Practical 3
3. Creating a RESTful web service with Spring boot. Generate the project using
spring initializer and testing API using postman tool.
 Navigate to [Link] For project setup
 Dependencies -Spring Web.
 Create a Resource Controller
 Test The Service using Postman Tool
*************************************************************************
Practical 4
Building an application using spring boot, generate the project using spring initializer
and add spring web dependency.
 Navigate to [Link] For project setup
 Dependencies -Spring Web.
 Create a Resource Controller

Practical 5
Building REST services using spring boot, generating the project using spring
initializer and adding dependencies Spring web, spring data JPA, H2 database.
 Create a simple payroll service that manages the employees of a company.
 employee objects in a (H2 in-memory) database and access them (through something
called JPA).
 Dependencies - Spring web, spring data JPA, H2 database.

***************************************************************************

Practical 6
Create a Student Login Form and validate the student’s username and password
with the database. Using JSP, Servlet, JDBC and MySQL database.
 MySQL Table
 Login Page (JSP)
 Servlet (Java)
 JDBC Connection Utility
 Tomcat Server
**************************************************************************
Practical 7
Build a simple Students Registration Module Using JSP, Servlet, JDBC and MySql
Databases
 MySQL Table
 Login Page (JSP)
 Servlet (Java)
 JDBC Connection Utility
 Tomcat Server
****************************************************************************
Practical 8
Creating a RESTful web service with Spring boot. Generate the project using
spring initializer and testing API using postman tool.
 Navigate to [Link] For project setup
 Dependencies -Spring Web.
 Create a Resource Controller
 Test The Service using Postman Tool

Practical 9
Create a Login Form and validate the username and password with the database.
Using JSP, Servlet, JDBC and MySQL database.

 MySQL Table
 Login Page (JSP)
 Servlet (Java)
 JDBC Connection Utility
 Tomcat Server

****************************************************************************

Practical 10
Create Signup Form using servlet, JSP, MySQL database, write query for storing
the data taking input from user (Signup page), install tomcat server 10.0 version.
 MySQL Table
 Login Page (JSP)
 Servlet (Java)
 JDBC Connection Utility
 Tomcat Server

***************************************************************************

You might also like