This is Bank Management Web Application similar to application used by employees in the bank.
Use the package manager npm to install modules. Run this command where you have cloned the project.
npm iOpen MySQL Workbench and import database from 'bank.sql' file stored in 'Database' directory.
In project directory make '.env' file to store environment variables. Copy the following text and paste in '.env' file you just created. Replace the content where specified.
DB_HOST=sql12.freemysqlhosting.net
DB_USER=sql12377987
DB_PASS=f4sxmeRXJ4
DB_SCHEMA=sql12377987
CUST_SERVER=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Customer
CUST_LOAD="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Customer/
CUST_MOVE_FROM=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Customer/
EMP_SERVER=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Employee
EMP_LOAD="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Employee/
EMP_RENAME=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Employee/
MOVE_TO=<Path to directory where you cloned project>/bank-management/public/pdfs/
Example :- Don't copy this. Just for reference.
DB_HOST=sql12.freemysqlhosting.net
DB_USER=sql12377987
DB_PASS=f4sxmeRXJ4
DB_SCHEMA=sql12377987
CUST_SERVER=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Customer
CUST_LOAD="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Customer/
CUST_MOVE_FROM=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Customer/
EMP_SERVER=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Employee
EMP_LOAD="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Employee/
EMP_RENAME=C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Employee/
MOVE_TO=D:/Web Development/College Project/DBE-Bank/public/pdfs/
- Run this command on the terminal in the project directory to start the local server.
node index.js- Open your browser and paste this into the URL field.
localhost:3000
- Use 1001 as Employee ID and admin@123 as a Password to log in as a manager. You can add a new employee, the default password is admin@123.