Skip to content

KrishnaSingh-bit/Hotel-Management-System-with-UI-Tkinter-CTk-Python-Mysql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

2 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

🏦 Bank Management System | with User Interface

A modern Bank Management System built using Python and MySQL.
It provides a clean UI and essential banking operations like account creation, deposit, withdraw, delete, and data export.

User Interface


πŸš€ Features

  • 🎨 Modern CustomTkinter UI
  • βž• Create new accounts
  • πŸ“„ Display customer details
  • πŸ’° Deposit & Withdraw
  • ❌ Delete accounts
  • πŸ“€ Export data to CSV
  • πŸ—„οΈ MySQL database integration
  • ⚠️ Error handling & confirmation dialogs

πŸ›  Tech Stack

  • Language: Python 3, MySql
  • Library: Tkinter(built-in), Customtkinter, Random, CSV
  • Connectivity: mysql.connector

πŸ“ Project Structure

πŸ“ Bank-Management-System(with UI)/
 ┣ πŸ“„ main.py      # Main app file
 ┣ πŸ“„ README.md          # Project readme (this file)
 ┣ πŸ“· screenshot.png     # UI image
 β”— πŸ“ bank_backup.csv         # Exported backup

πŸ› οΈ Requirements

Install dependencies:

pip install customtkinter mysql-connector-python

πŸ—„οΈ MySQL Setup Start your MySQL server.

Create a database:

CREATE DATABASE bank;
Create a table:
CREATE TABLE customers (
    account_no INT PRIMARY KEY,
    name VARCHAR(255),
    balance INT,
    gender VARCHAR(20),
    city VARCHAR(255)
);

Update your MySQL connection details in the Python file:

mycon = mysql.connector.connect(
    host="localhost",
    user="root",     # change to your username
    passwd="password",       # your MySQL password
    database="bank"
)

πŸ“₯ How to Run

  1. Make sure Python is installed on your system.`

  2. Navigate to the project folder and run:

cd Bank-Management-System(with UI)
python main.py

🀝 Contributing Pull requests, issues, or suggestions are welcome.

πŸ“œ License This project is open-source and free to use.

About

Hotel Management System with UI and a Database.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages