JSP Programs and Project: Build a Product Management System

Set up a gsb project, create a hello world page, declare a string variable, and display it with a gsb expression to render hello world on screen.

Learn to write a simple program that checks whether a given number is even or odd using modulo 2 and displays the corresponding message.

Prints the multiplication table of a number in a table using a for loop and sets num to 5, iterating i from 1 to 10 to show each product.

Map a number to a month with a switch-case, printing January through December for 1–12 and invalid entries for out-of-range numbers. Build familiarity with the GSB syntax.

Learn how to display request information on a jsp page using jsp expressions, printing the root context, server name, request url, and parameters via query strings.

Build a simple button click counter within a JSP-like page, using a GSB declaration for static variables and functions, and update the counter on each button click.

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.

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.

Navigate between pages by selecting an account type from a dropdown and submitting a form, then redirect to the savings or current account page based on the choice.

Create a simple header and footer, apply styling with background colors and centered text, and include these reusable components across the three pages (home, header, footer) of the project.

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.

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.

Learn to read data from an Oracle database by creating a statement, executing a select query, iterating the resultset, and printing id and name to the console.

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.

Learn how statement and prepared statement differ in query processing; prepared statements bind parameters at runtime, reuse a single execution plan, and boost efficiency for inserts, updates, and deletes.

Insert records into the employee table using the insert into employee values syntax, handling string and numeric values, optionally specifying columns, and ordering by employee ID.

Use prepared statements in jsp to insert records into the employee table by binding parameters for employee id, name, and salary, executing the update, and checking rows affected.

Read all employees from an Oracle 11g database using a data access object and a plain old Java object in a JSP app, then display results on a JSP page.

Add employee records from a JSP page using a prepared statement to insert into the employee table, handling form input and routing to success or error pages.

Program 13 demonstrates building a dynamic, database-driven navigation menu loaded from a dao and pojo, rendering links to home, view products, and manage products.

Explore a product management system project with login via session, and create, read, update, delete operations on login and product data, plus its DAO and POJO structure and database schema.

Explore login and logout in the product management app by building a login POJO with username and password, validating credentials against a database, and implementing a login form.

Capture username and password, validate credentials, and establish a session with a 30-second timeout; redirect to home on success or show invalid credentials with a retry link on failure.

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 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 a product in a JSP-based product management system using a parameterized insert to store id, name, category, and price, then display the updated product list.

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.

Learn how the delete product function removes a product by its id, returning a status that redirects to the products page upon successful deletion.

Demonstrates a search product flow using a form to enter a product ID, display results on the same page, and show 'no record to display' for empty or invalid IDs.

Run and test the product management app by validating login, performing create, read, update, and delete operations, testing search, and ensuring session invalidation after logout.

Conclude this course by encouraging practical practice of all programs and exploring variations. Add new functionalities to your product management system and undertake projects to boost confidence.