This project is an online banking application that allows users to:
- Register and open an account with an initial balance
- Login to check their balance
- Withdraw and deposit money from their account
- User Registration: Create a new account with a username, password, and initial balance.
- User Authentication: Login with username and password to access account details.
- Account Management: Deposit and withdraw funds from the account.
- Balance Inquiry: Check the current balance.
- Frontend: React
- Backend: Node.js, Express.js
- Database: MySQL
-
Installations:
-
Build Database:
- Set up MySQL Workbench:
- Open MySQL Workbench and connect to local instance 3306.
- Create schema:
- Use the SQL script provided in
bankSchema.sql
to create the database and table.
- Use the SQL script provided in
- Set up MySQL Workbench:
-
Clone the repository:
git clone https://github.com/yuehcw/BankApp.git cd BankApp
-
Set up the database account:
Open the `db.js` file, replace the `username` and `password` with yours
-
Install main directory dependencies:
npm install
-
Install server dependencies:
cd server npm install
-
Install client dependencies:
cd ../client npm install
-
Run the server:
cd ../server npm start
-
Run the client:
cd ../client npm start