My first full-stack Java application. Allows users to register, login, and logout. Employees can add new reimbursement requests. Finance managers can approve or deny reimbursement tickets.
This project was my first full-stack Java application created during a 2-week period in March 2021. My client requested an application that allows users to register, login, and logout. Employees can add new expense reimbursement requests which will subsequently be reviewed by a finance manager, who will approve or deny a reimbursement request. Finance managers can view reimbursement tickets made by any employee while individual employees can only view their own reimbursement tickets.
A visual representation can be seen below:
- Java 8
- JavaScript
- PostgreSQL
- HTML
- CSS
- Bootstrap
- Apache Tomcat
- Amazon RDS
I first created an AWS RDS instance to host my database, then created the database in PostgreSQL.
Next, I structured and programmed the backend of my application using Java and JDBC to connect to my database.
I created Java beans for each of the tables in my database, including getters and setters for each column. I then created the DAO layer to provide further functionality, including CRUD operations to create new users and reimbursements, retrieve user(s) and reimbursement(s) based on specific criteria, update a user's or reimbursement's information, and delete a user or reimbursement.
In order to manage client requests, I implemented a front controller design pattern with servlets.
