JSP Programs and Project: Build a Product Management System

Build a JSP Database Application in around 3 hours

Created byAbhay Redkar

Last updated 12/2018

English

What you'll learn

Understand some basic concepts of JSP with the help of examples.
Understand the concepts required to build a JSP application
Build a complete JSP project with database operations.

Course content

6 sections • 36 lectures • 2h 39m total length

Installation of Eclipse IDE and JDK1:36
Installation of Oracle Database1:36
Introduction and Course Overview1:57
Setup Tomcat Server3:07

Program 1: Hello World in JSP3:37
Program 2: Even Odd4:57
Program 3: Multiplication Table3:59
Program 4: Month of the year3:07
Program 5: Print Request Info3:24
Program 6: Click Counter3:38
Program 7: Factorial Calculator4:40
Build a factorial calculator in JSP using a form to capture user input, convert it to an integer, and display the factorial result on the same page.
Program 8: Registration Application4:24
Build a two-page registration app with a form for first name, last name, and gender, and a welcome page that displays values via JSP, using post to hide data.
Program 9: Page Redirection3:49
Program 10: Simple Header Footer2:34

JDBC Connectivity Steps4:36
Learn how to connect to an Oracle database using JDBC: load the driver, establish a connection, create a statement, execute a query, and close the connection.
Establishing connection with the database4:40
Establish a database connection to an Oracle server using JDBC in eclipse by loading the Oracle driver, registering it, and creating a connection to localhost:1521/xe with the system user.
Reading data from database5:20
Create Table using Statement5:21
Create a table in your database using a statement by loading the driver, establishing a connection, and executing a create table query for employee_id, employee_name, and employee_salary, using executeUpdate.
Statement Vs PreparedStatement5:16
Insert using Statement4:34
Insert using PreparedStatement4:22

Introduction2:42
Login/Logout: Part 15:17
Login/Logout: Part 24:46
Creating Header5:07
Create and include a reusable header in a jsp-based product management system, validating user sessions, rendering a navigation menu, and greeting the logged-in user with their username.
View Products5:53
View products demonstrates fetching all products from the database, building product objects with id, name, category, and price, and displaying them in a table with edit and delete actions.
Add Product4:20
Edit Product8:25
Learn to edit a product by retrieving it by ID, pre-populating an edit form, and updating the product through the management layer's update operation.
Delete Product2:14
Learn how the delete product function removes a product by its id, returning a status that redirects to the products page upon successful deletion.
Search Product4:24
Running the application3:03

Requirements

Basic knowledge of Core Java is required
Basic theoretical knowledge of JSP and Servlets would be helpful as this course contains only practicals

Description

JavaServer Pages(JSP) is a server-side web technology which is used to create dynamic web pages. This course is designed to help you build your first JSP application in a short time. This course will cover all necessary concepts which are required for building your first project.

This course is suitable for anyone who has some basic knowledge about Core Java and wants to build a JSP project in less time. The course expects the students to have some theoretical knowledge about JSP and Servlets. It has several programming examples which will cover some basic JSP concepts. This course is highly practical-base and main focus is on practicals rather than the theory.

Apart from JSP concepts, this course also covers some basic JDBC concepts which will be helpful for building a database CRUD application. A CRUD application is basically a database application which performs basic operations like Create/Insert(C),Read(R), Update(U), Delete(D). It also has a project at the end which is a Product Management System.

This project has the following functionalities:-

Login/Logout
View Products
Add Product
Edit Product
Delete Product
Search Product

The above project is explained line by line in the video lectures and the source code will available for students to download.(Check Conclusion and Source Code section)

Some of the key points regarding this course:-

Total hands-on programming experience.
JSP programming examples explained.
Basic JDBC concepts covered.
Project: Product Management System
Requires 2-3 hours of your time.

As it’s a short course, it won’t be boring at all. You need to invest only around 2-3 hours of your time. I believe you will enjoy this course and learn a lot. Happy Coding :)

Who this course is for:

Anyone who wants to learn plain JSP with examples.
Anyone who wants to build a JSP project in a less time

JSP Programs and Project: Build a Product Management System

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 8min

JSP Basic Programs10 lectures • 38min

JDBC Basics7 lectures • 34min

JSP Database Programs3 lectures • 31min

JSP Project: Product Management System10 lectures • 46min

Conclusion and Source Code2 lectures • 1min

Requirements

Description

Who this course is for: