A console-based Bank Management System built using Python with MySQL as the database.
This project simulates core banking operations and focuses on backend logic, database integration, and clean modular design.
- User Registration and Login
- Account Creation with Unique Account Number
- Deposit and Withdraw Money
- Balance Inquiry
- Customer Data Management
- SQL-based Persistent Storage
- Input Validation and Error Handling
- Language: Python
- Database: MySQL
- Libraries:
- mysql-connector-python
- datetime
- sys
Table: customers
| Column Name | Data Type |
|---|---|
| username | VARCHAR |
| password | VARCHAR |
| age | INT |
| city | VARCHAR |
| account_number | INT |
| balance | FLOAT |
| status | BOOLEAN |
git clone https://github.com/deepUy02/Bank-Python-Project.git cd Bank-Python-Project
pip install mysql-connector-python
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="your_password",
database="bank"
)
python main.py