I am working on a project where I need to connect my root.war web application to a MySQL database using Docker. I have already created the Docker images but am unsure how to connect the MySQL database to my web application. I would greatly appreciate any guidance or detailed steps on how to achieve this connection and ensure that the database works correctly when deployed.

Here are the specific details of my setup:

I have a web application packaged as root.war.
I am using Docker to containerize my application and MySQL database.
My database credentials are:
Username: root
Password: BankingSystem@12
Database Name: bankingsystem
What I need help with:

Dockerfile Configuration: How to configure the Dockerfile for my web application.
Docker Compose File: How to set up a docker-compose.yml file to link my web application with the MySQL database.
Database Connection: How to configure the database connection in my web application to ensure it connects to the MySQL database container.

I have tried but its not working