Workers Management System • Java EE

Manage workers with speed, clarity, and control.

A production‑ready Java EE web app using Servlets, JSP, and JPA, deployed on GlassFish and backed by JavaDB (Derby).

Open App View Repository
Workers Management System – Home Page
CRUD: Create • Read • Update • Delete Servlets + JSP JPA GlassFish JavaDB (Derby) NetBeans IDE

Data model

  • ID Number
  • First Name
  • Last Name
  • Email
  • Gender
  • Job Title
  • Date Hired

Features

  • Create new worker entries
  • View all workers in a structured table
  • Update worker details
  • Delete a worker
  • Automatic JPA persistence to JavaDB

Gallery

Seven screens highlighting the system in action.

Home page
View all workers
Add worker form
Change worker job
Search worker by ID
Remove worker
Hired workers demo

🛠 How to run

Clone the repository 
git clone https://github.com/MhlengweLibertyLees/workers-management-system.git
Open in NetBeans

File → Open Project → select the cloned folder.

Set up JavaDB (Derby)
  • In Services → Databases → JavaDB, Create Database:
Database name: WorkersDb
User name:     app
Password:      123

Right‑click the database → Connect.

Review web.xml

Ensure it is at WEB-INF/web.xml and contains:

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee 
http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">
    <servlet>
        <servlet-name>WorkersServlet</servlet-name>
        <servlet-class>za.ac.tut.web.WorkersServlet</servlet-class>
    </servlet>
    <servlet>
        <servlet-name>ViewWorkersServlet</servlet-name>
        <servlet-class>za.ac.tut.web.ViewWorkersServlet</servlet-class>
    </servlet>
    <servlet>
        <servlet-name>RemoveWorkerServlet</servlet-name>
        <servlet-class>za.ac.tut.web.RemoveWorkerServlet</servlet-class>
    </servlet>
    <servlet>
        <servlet-name>EditWorkerServlet</servlet-name>
        <servlet-class>za.ac.tut.web.EditWorkerServlet</servlet-class>
    </servlet>
    <servlet>
        <servlet-name>SearchWorkerServlet</servlet-name>
        <servlet-class>za.ac.tut.web.SearchWorkerServlet</servlet-class>
    </servlet>

    <servlet-mapping>
        <servlet-name>WorkersServlet</servlet-name>
        <url-pattern>/WorkersServlet.do</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
        <servlet-name>ViewWorkersServlet</servlet-name>
        <url-pattern>/ViewWorkersServlet.do</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
        <servlet-name>RemoveWorkerServlet</servlet-name>
        <url-pattern>/RemoveWorkerServlet.do</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
        <servlet-name>EditWorkerServlet</servlet-name>
        <url-pattern>/EditWorkerServlet.do</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
        <servlet-name>SearchWorkerServlet</servlet-name>
        <url-pattern>/SearchWorkerServlet.do</url-pattern>
    </servlet-mapping>

    <session-config>
        <session-timeout>30</session-timeout>
    </session-config>
</web-app>
Add GlassFish Server

Tools → Servers → Add Server → GlassFish → Next, then point to your installation.

Deploy and run

Right‑click the project → Run/Deploy. Then open:

http://localhost:8080/WorkersManagementSystem