/Expense-Tracker

Primary LanguageJava

# Expense Tracker

## Project Overview
The Expense Tracker is a web application that allows users to track their income and expenses. It helps users manage their budgets, monitor spending patterns, and generate financial reports.

## Features
- User Authentication (Registration and Login)
- Add, Edit, Delete Expenses
- Categorize Expenses (Food, Transport, Bills, etc.)
- View Expenses by Date Range
- Generate Reports (Monthly, Yearly)
- Dashboard with Summary and Charts

## Technologies Used
- **Backend**: Java (JSP, Servlets)
- **Frontend**: HTML, CSS, JavaScript
- **Database**: MySQL (or PostgreSQL)
- **Server**: Apache Tomcat
- **Libraries**: JFreeChart (for charts)

## Prerequisites
- Java Development Kit (JDK) 8 or higher
- Apache Tomcat 9 or higher
- MySQL (or PostgreSQL) Database
- IDE (Eclipse, IntelliJ IDEA, or similar)

## Project Structure

ExpenseTracker/
├── src/
│   ├── main/
│   │   ├── java/
│   │   │   ├── com/
│   │   │   │   ├── example/
│   │   │   │   │   ├── controllers/
│   │   │   │   │   ├── dao/
│   │   │   │   │   ├── model/
│   │   │   │   │   ├── services/
│   │   │   ├── web/
│   │   │   │   ├── servlets/
│   ├── webapp/
│   │   ├── WEB-INF/
│   │   │   ├── web.xml
│   │   ├── assets/
│   │   ├── views/
│   │   │   ├── index.jsp
│   │   │   ├── login.jsp
│   │   │   ├── register.jsp
│   │   │   ├── dashboard.jsp
│   │   │   ├── addExpense.jsp
│   │   │   ├── editExpense.jsp
│   │   │   ├── reports.jsp
├── README.md
├── pom.xml (if using Maven)

Setup Instructions

1. Clone the Repository

git clone https://github.com/yourusername/expensetracker.git
cd expensetracker

2. Configure the Database

  • Create a database named expense_tracker.
  • Execute the SQL scripts in src/main/resources/sql/ to create the necessary tables.

3. Update Database Configuration

Update the database connection settings in your project. You can usually find these settings in a configuration file like db.properties or directly in your DAO classes.

# db.properties example
jdbc.url=jdbc:mysql://localhost:3306/expense_tracker
jdbc.username=root
jdbc.password=yourpassword

4. Build and Deploy the Project

  • Using Maven: If you are using Maven, build the project using the following command: 
    mvn clean install
    This will generate a WAR file in the target directory.
  • Manually: If you are not using Maven, compile the project and package it as a WAR file using your IDE.

5. Deploy to Apache Tomcat

  • Copy the generated WAR file to the webapps directory of your Apache Tomcat installation.
  • Start (or restart) Apache Tomcat.

6. Access the Application

  • Open a web browser and navigate to http://localhost:8080/ExpenseTracker (or the appropriate URL based on your Tomcat configuration).

Project Implementation

User Authentication

  • JSP Pages: register.jsp, login.jsp
  • Servlets: RegisterServlet, LoginServlet
  • Database Tables: users

Expense Management

  • JSP Pages: addExpense.jsp, editExpense.jsp
  • Servlets: AddExpenseServlet, EditExpenseServlet, DeleteExpenseServlet
  • Database Tables: expenses

Viewing and Reporting

  • JSP Pages: dashboard.jsp, reports.jsp
  • Servlets: ViewExpensesServlet, GenerateReportServlet
  • Libraries: JFreeChart for generating charts

Contributing

  1. Fork the repository
  2. Create your feature branch (git checkout -b feature/YourFeature)
  3. Commit your changes (git commit -m 'Add some feature')
  4. Push to the branch (git push origin feature/YourFeature)
  5. Open a pull request

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgments

  • Thanks to all the open-source contributors whose libraries and tools were used in this project.