Mini Project (Banking Systems)
Introduction :- This mini project the of Banking system made using command line programming.In this project we have covered following topics :
- Creating Account
- Login Section using Captcha Support
- View Balance
- Deposit Fund
- Withdrawal Fund
- Transfer Fund
Prerequisite
a) Random Module
b) Getpass Module
c) Conditional Statement(If Else)
d) Loop
e) Functions
f) Database (Mysql)
Programs
import random import getpass import mysql.connector mycon=mysql.connector.connect(host="localhost",user="root",password="1234",database="netbanking") mycur=mycon.cursor() def create_account(): cmd="insert into info(Name,Address,Mobile,Password,account,balance)values(%s,%s,%s,%s,%s,%s)" print("*********************************************************") Name=input("Name :-") Address=input("Address :-") Mobile=input("Mobile :-") bal=input("Amount:-Rs.") password=getpass.getpass() cpassword=getpass.getpass("Re-Enter Password") if(password==cpassword): acc_number=random.randint(1111,9999) value=(Name,Address,Mobile,password,acc_number,bal) mycur.execute(cmd,value) mycon.commit() print("Successfull Account Created") print("Account No :-",acc_number) login() def blank(): print("\n"*50) def login(): cap=random.randint(2222,99999) print("*******************Salesforcedillers Bank of India*********************") global user user=input("Account Number :- ") pas=getpass.getpass() print("**********",cap,"************") captcha=int(input("Captcha:-")) mycur.execute("select Name,account,Password from info where account={} and Password={}".format(user,pas)) result=mycur.fetchall() if(cap==captcha): if(not result): print("Sorry Account No or Password Not Match") print("Try Again") login() else: print("\n\n\n***********************Successfull Login**************************") print("Hello",result[0][0],"\t\t\t\t\t\t\tAccount Number",result[0][1]) allinfo() else: print("Invalid Captcha") login() def allinfo(): while True: print("*******************************************************************") print("1 View Balance\n2 Deposit Fund\n3 Withdrawal\n4 Fund Transfer\n5 Logout") print("*******************************************************************") ch=int(input("Choice :-")) if(ch==1): view() elif(ch==2): deposit() elif(ch==3): withdrawal() elif(ch==4): transfer() elif(ch==5): print("Successfully Logout") exit() def view(): mycur.execute("select balance from info where account={}".format(user)) result=mycur.fetchall() print("Account Balance ",result[0][0]) def deposit(): mycur.execute("select balance from info where account={}".format(user)) result=mycur.fetchall() balance1=int(result[0][0]) dbal=int(input("Enter Balance")) balance1=balance1+dbal mycur.execute("update info set balance={} where account={}".format(balance1,user)) mycon.commit() def withdrawal(): mycur.execute("select balance from info where account={}".format(user)) result=mycur.fetchall() balance1=int(result[0][0]) print("Balance",balance1) wbal=int(input("Enter Balance")) if(balance1>=wbal): balance1=balance1-wbal mycur.execute("update info set balance={} where account={}".format(balance1,user)) mycon.commit() else: print("Insufficient Fund") def transfer(): tacc=int(input("Account No:-")) mycur.execute("select name,account,balance from info where account={}".format(tacc)) result1=mycur.fetchall() if(not result1): print("No Account Found") transfer() else: print("Name is",result1[0][0],"\t\t\t\t\t","Account No is",result1[0][1]) print() mycur.execute("select balance from info where account={}".format(user)) result=mycur.fetchall() balance1=int(result[0][0]) wbal=int(input("Enter Transfer Balance")) if(balance1>=wbal): balance1=balance1-wbal mycur.execute("update info set balance={} where account={}".format(balance1,user)) mycon.commit() balance2=int(result1[0][2])+wbal mycur.execute("update info set balance={} where account={}".format(balance2,tacc)) mycon.commit() print("Your Account is Debit from",wbal,"and credited to",result1[0][0]) else: print("Insufficient Fund") print("\t\t\tSalesforcedrillers of India") print("1 Create Account\n2 Login") ch=int(input("Enter Choice:-")) if(ch==1): create_account() elif(ch==2): login()
Output
1. Front Page
2. Registration Page
3. Mysql Database
4. Login Page
5. After Login Main Page
6. View Balance
7. Deposit Balance
8. Withdrawal Balance
9. Transfer Fund
10. Logout