We are creating a project to calculate analytics from the call data saved for a callcenter, which can connect to the database, process the data and print the output on the console.
This project is designed to demonstrate the use of Core Java programming language to build a call center application that can interact with a database.
The project uses the following technologies:
Core Java || JDBC || MySql Database
This project uses the following libraries:
» MySQL Connector/J - for JDBC driver to connect to MySQL database
The project has the following features:
» This project uses JDBC API to connect to the database and fetch the data.
» It then processes the data using Java streams and prints the output on the console.
» Database connection: The project connects to a database using MySql.
» Data processing: The project retrieves data from the database, processes it, and prints the output on the console.
» Console output: The project prints the processed data on the console.
Each call that is received by the callcenter is saved in a database table shown below:
Sample data is given below:
Table Structure is shown below:
We have to create the following analytics:
1> Hour of the day when the call volume is highest.
2> Hour of the day when the calls are longest.
3> Day of the week when the call volume is highest.
4> Day of the week when the calls are longest.
Based on the provided data the output of the console is as follows:
To get started with the project, follow these instructions:
» Clone the project from GitHub repository.
» Open the project in an IDE such as VS Code.
» Ensure that Java 8 or later is installed on your system.
» Set up the database connection in the project by modifying the application.properties file located in the mrinal_assignment/Dbconnect.java/ directory.
» Update the dbcon, jdbc.username, and jdbc.password properties to match your database configuration.
» Run the project by executing the javac Dbconnect.java file.
Video Explanation for the project: https://drive.google.com/file/d/1VKCyh6VhTiz4-Zkv2khnOeUKHJT5trfg/view?usp=sharing
Thanks!