The Expense Reimbursement System (ERS) will manage the process of reimbursing employees for expenses incurred while on company time. All employees in the company can login and submit requests for reimbursement and view their past tickets and pending requests. Finance managers can log in and view all reimbursement requests and past history for all employees in the company. Finance managers are authorized to approve and deny requests for expense reimbursement.
Employees must select the type of reimbursement as: LODGING, TRAVEL, FOOD, or OTHER.
● The application shall employ the DAO design pattern, and properly separate your code into the appropriate layers
● The back-end system shall use JDBC to connect to an PostgreSQL Database.
● Use at least one of each of our three statements – Statement, PreparedStatement, and CallableStatement
● The application shall deploy onto a Tomcat Server
● The middle tier shall use Servlet technology for dynamic Web application development
● The front-end view can use JavaScript and use AJAX to call server-side components. The web pages should look presentable (try using css and bootstrap); I’d rather not see a website from 1995.
● Use Log4J and JUnit.
● Passwords should be encrypted(optional) in Java and securely stored in the database
● Users can upload a document or image of their receipt when submitting reimbursements(optional)
● The application will send an email to employees letting them know that they have been registered as a new user, giving them their temporary password(optional)
● 10/6/2021 start: project 1 specs released
● 10/22/2021 completion: project 1 presentations
**Please take the deadline seriously.
**Do NOT spend too much time stuck on a single blocker without asking a batch-mate for help.
**Lastly, setting up your database shouldn’t take very long (a few days max); and if one third of the time has passed (wednesday 10/13/2021 ish) and you have not completed at least the login functionality then you may want to pick up the pace.