The primary aim of this project is to provide users with an intuitive and efficient platform where
they can maintain a digital record of their financial transactions. The system allows users to
add new expenses by specifying details such as expense title, amount, category (e.g., food,
travel, shopping, bills), and date. These records are stored in a structured database, enabling
easy access, modification, and deletion whenever required.
This application is developed using Java Server Pages (JSP) technology, which enables
dynamic web page generation and seamless interaction between the user interface and the
backend. The backend database is implemented using Microsoft Access, connected through
the UCanAccess JDBC driver, ensuring smooth data storage and retrieval operations.
One of the key features of the system is its dynamic dashboard, which provides a quick
overview of the user's financial status. It displays important metrics such as total expenses,
total number of transactions, and the number of expense categories used. Additionally, the
system includes a reports module that summarizes expenses based on categories, helping users
identify their spending patterns and make informed financial decisions.
HOW TO SETUP:
- Install JDK, Tomcat 9 and UCanAccess JDBC Driver.
- Make database containing tables expenses and users in MS ACCESS ( Here file expensedb.accdb is the database).
- Make a folder of given files and name it as Expense_Tracker and place it in Tomcat 9> Webapps folder.
- Place installed ucanaccess JDBC Driver file in Tomcat 9> lib.
- Use IDE such as VS Code and install extensions Java for Developers as well as Tomcat.
- Open folder Expense_Tracker in VS Code.
- Keep opening database (expensedb.accdb), VS Code and startup.bat file which is placed in Tomcat 9> bin> startup.bat.
- Open Chrome browser and run http://localhost:8080/Expense_Tracker/login.jsp
DATABASE IN MS ACCESS:
