Account Management System in Python with Source Code
This Account Management System in Python with Source Code is free to download. The Account Management System in Python is design using tkinter and graphical user interface(GUI). Account Management System is a simple desktop application.
The Account Management System is created using python programming language. Account Management System file contains a python script(account-system.py and database-account.py).
Talking approximately the system, it includes all of the required features which consist of adding, viewing, deleting, updating, searching and looking a person account lists. While including the account information of a person, he/she has to offer first name, last name, username, password, position, and date.
The Database used in this project is SQLite3, In this tutorial, I will teach you on how to create Account Management System in Python.
Before you start creating this Account Management System in Python, make sure that you have PyCharm IDE and SQLite3 installed in your computer.
By the way if you are new to python programming and you don’t know what would be the the Python IDE to use, I have here a list of Best Python IDE for Windows, Linux, Mac OS that will suit for you. I also have here How to Download and Install Latest Version of Python on Windows.
Steps on how to create Account Management System in Python
Account Management System in Python with Source Code
- Step 1: Create a project name.
First when you finished installed the Pycharm IDE in your computer, open it and then create a “project name” after creating a project name click the “create” button.
- Step 2: Create a python file.
Second after creating a project name, “right click” your project name and then click “new” after that click the “python file“.
- Step 3: Name your python file.
Third after creating a python file, Name your python file after that click “enter“.
- Step 4: The actual code.
This is the actual coding on how to create Account Management System in Python, and you are free to copy this code and download the full source code given below.
Importing Tkinter Module
Tkinter is the standard GUI library for Python. Python when combined with Tkinter provides a fast and easy way to create GUI applications.(Account Management System in Python)
from tkinter import * from tkinter import messagebox
In the code above, which is for importing tkinter just write 2 line of code.
Importing the Sqlite3 Module
SQLite is a C library that provides a lightweight disk-based database that doesn’t require a separate server process and allows accessing the database using a nonstandard variant of the SQL query language. (Account Management System in Python)
import sqlite3
In the code above, which is for importing sqlite just write one line of code.
This Module for the Database
def create():
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS tableAccount(id INTEGER PRIMARY KEY,firstname TEXT, lastname TEXT, username TEXT, password TEXT,position TEXT, date TEXT)")
con.commit()
con.close()
In the code above, which is for the creating a database name “accountdb.db” and have 1 table created. This is the “tableAccount“.(Account Management System in Python)
This Module for the View Account List
def viewall():
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("SELECT * FROM tableAccount")
rows = cur.fetchall()
con.close()
return rows
In the code above, which is for viewing all the account list in the database. (Account Management System in Python)
This Module for the Search
def search(firstname="", lastname="", username="", password="", position=""):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("SELECT * FROM tableAccount WHERE firstname=? or lastname=? OR username=? OR password=? OR position=?", (firstname, lastname, username, password, position))
rows = cur.fetchall()
con.close()
return rows
In the code above, which is for the searching or finding a name of new account added in the database. (Account Management System in Python)
This Module for the Add Account
def add(firstname,lastname, username, password, position, date):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("INSERT INTO tableAccount VALUES(NULL,?,?,?,?,?,?)", (firstname, lastname, username, password, position, date))
con.commit()
con.close()
In the code above, which is for the adding a new account in the database.(Account Management System in Python)
This Module for the Update Account
def update(id, firstname, lastname, username, password, position, date):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("UPDATE tableAccount SET firstname=?,lastname=?, username=?,password=?,position=?,date=? WHERE id=?", (firstname, lastname, username, password, position, date, id))
con.commit()
con.close()
In the code above, which is for the updating an account in the database.(Account Management System in Python)
This Module for the Delete Account
def delete(id):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("DELETE FROM tableAccount WHERE id=?",(id,))
con.commit()
con.close()
In the code above, which is for the deleting an account in the database.(Account Management System in Python)
This Module for the Design Main Screen Window
window = Tk()
window.title("Account Management System")
window.config(bg="navajo white")
window.geometry('1350x750')
lblfirstname = Label(window, text="First Name", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblfirstname.grid(row=0, column=0, columnspan=2)
lbllastname = Label(window,text="Last Name", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lbllastname.grid(row=1,column=0,columnspan=2)
lblusername = Label(window,text="Username", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblusername.grid(row=2,column=0,columnspan=2)
lblpassword = Label(window, text="Password", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblpassword.grid(row=3, column=0, columnspan=2)
lblposition = Label(window,text="Position", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblposition.grid(row=4,column=0,columnspan=2)
lbldate = Label(window,text="Date", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lbldate.grid(row=5,column=0,columnspan=2)
firstname=StringVar()
EntryFirstName = Entry(window,textvariable=firstname, font=("Calibri", 14, "italic"), width=30)
EntryFirstName.grid(row=0,column=0,columnspan=10)
lastname=StringVar()
EntryLastName = Entry(window,textvariable=lastname, font=("Calibri", 14, "italic"), width=30)
EntryLastName.grid(row=1,column=0,columnspan=10)
username=StringVar()
EntryUsername = Entry(window,textvariable=username, font=("Calibri", 14, "italic"), width=30)
EntryUsername.grid(row=2,column=0,columnspan=10)
password=StringVar()
EntryPassword = Entry(window,textvariable=password, font=("Calibri", 14, "italic"), width=30)
EntryPassword.grid(row=3,column=0,columnspan=10)
position=StringVar()
EntryPosition = Entry(window,textvariable=position, font=("Calibri", 14, "italic"), width=30)
EntryPosition.grid(row=4,column=0,columnspan=10)
date = StringVar()
EntryDate = Entry(window,textvariable=date, font=("Calibri", 14, "italic"), width=30)
EntryDate.grid(row=5,column=0,columnspan=10)
AddButton = Button(window,text="Add",width=12,command=add, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
AddButton.grid(row=6,column=0)
UpdateButton = Button(window,text="Update",width=12,command=update, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
UpdateButton.grid(row=6,column=1)
SearchButton = Button(window,text="Search",width=12,command=search, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
SearchButton.grid(row=6,column=2)
ViewAllButton = Button(window,text="View All",width=12,command=view, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
ViewAllButton.grid(row=6,column=3)
DeleteButton = Button(window,text="Delete",width=12,command=delete, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
DeleteButton.grid(row=6,column=4)
ClearAllButton = Button(window,text="Clear All",width=12,command=clear, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
ClearAllButton.grid(row=6,column=5)
lb=Listbox(window,height=20,width=94)
lb.grid(row=7,column=0,columnspan=6)
sb=Scrollbar(window)
sb.grid(row=7,column=6,rowspan=6)
lb.configure(yscrollcommand=sb.set)
sb.configure(command=lb.yview)
lb.bind('<<ListboxSelect>>',get_selected_row)
In the code above , which is first of all you have to design the main screen window. This display screen have a buttons of add, update, delete, view all, search and clear all. Then the label has first name, last name, username, password, position, date and the title.(Account Management System in Python)
Complete Source Code of Account Management System in Python
account-system.py
from tkinter import *
from tkinter import messagebox
import database_account
def view():
lb.delete(0,END)
for row in database_account.viewall():
lb.insert(END, row)
def search():
lb.delete(0, END)
for row in database_account.search(firstname=firstname.get(), lastname=lastname.get(), username=username.get(), password=password.get(), position=position.get()):
lb.insert(END, row)
def add():
database_account.add(firstname.get(), lastname.get(), username.get(), password.get(), position.get(), date.get())
messagebox.showinfo("Add", "New Account Added Successfully")
lb.delete(0, END)
lb.insert(END, firstname.get(), lastname.get(), username.get(), password.get(), position.get(), date.get())
def get_selected_row(event):
try:
global selected_tuple
index = lb.curselection()[0]
selected_tuple = lb.get(index)
EntryFirstName.delete(0,END)
EntryFirstName.insert(END,selected_tuple[1])
EntryLastName.delete(0,END)
EntryLastName.insert(END,selected_tuple[2])
EntryUsername.delete(0,END)
EntryUsername.insert(END,selected_tuple[3])
EntryPassword.delete(0,END)
EntryPassword.insert(END,selected_tuple[4])
EntryPosition.delete(0,END)
EntryPosition.insert(END,selected_tuple[5])
EntryDate.delete(0, END)
EntryDate.insert(END, selected_tuple[6])
except IndexError:
pass
def update():
database_account.update(selected_tuple[0], firstname.get(), lastname.get(), username.get(), password.get(), position.get(), date.get())
messagebox.showinfo("Update", "Account Has Been Updated Successfully")
view()
def delete():
database_account.delete(selected_tuple[0])
messagebox.showinfo("Delete Account", 'Account Has Been Deleted Successfully')
view()
#lb.delete(END,get_selected_row.selected_tuple)
def clear():
lb.delete(0,END)
EntryFirstName.delete(0,END)
EntryLastName.delete(0,END)
EntryUsername.delete(0,END)
EntryPassword.delete(0,END)
EntryPosition.delete(0,END)
EntryDate.delete(0, END)
window = Tk()
window.title("Account Management System")
window.config(bg="navajo white")
window.geometry('1350x750')
lblfirstname = Label(window, text="First Name", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblfirstname.grid(row=0, column=0, columnspan=2)
lbllastname = Label(window,text="Last Name", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lbllastname.grid(row=1,column=0,columnspan=2)
lblusername = Label(window,text="Username", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblusername.grid(row=2,column=0,columnspan=2)
lblpassword = Label(window, text="Password", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblpassword.grid(row=3, column=0, columnspan=2)
lblposition = Label(window,text="Position", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblposition.grid(row=4,column=0,columnspan=2)
lbldate = Label(window,text="Date", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lbldate.grid(row=5,column=0,columnspan=2)
firstname=StringVar()
EntryFirstName = Entry(window,textvariable=firstname, font=("Calibri", 14, "italic"), width=30)
EntryFirstName.grid(row=0,column=0,columnspan=10)
lastname=StringVar()
EntryLastName = Entry(window,textvariable=lastname, font=("Calibri", 14, "italic"), width=30)
EntryLastName.grid(row=1,column=0,columnspan=10)
username=StringVar()
EntryUsername = Entry(window,textvariable=username, font=("Calibri", 14, "italic"), width=30)
EntryUsername.grid(row=2,column=0,columnspan=10)
password=StringVar()
EntryPassword = Entry(window,textvariable=password, font=("Calibri", 14, "italic"), width=30)
EntryPassword.grid(row=3,column=0,columnspan=10)
position=StringVar()
EntryPosition = Entry(window,textvariable=position, font=("Calibri", 14, "italic"), width=30)
EntryPosition.grid(row=4,column=0,columnspan=10)
date = StringVar()
EntryDate = Entry(window,textvariable=date, font=("Calibri", 14, "italic"), width=30)
EntryDate.grid(row=5,column=0,columnspan=10)
AddButton = Button(window,text="Add",width=12,command=add, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
AddButton.grid(row=6,column=0)
UpdateButton = Button(window,text="Update",width=12,command=update, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
UpdateButton.grid(row=6,column=1)
SearchButton = Button(window,text="Search",width=12,command=search, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
SearchButton.grid(row=6,column=2)
ViewAllButton = Button(window,text="View All",width=12,command=view, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
ViewAllButton.grid(row=6,column=3)
DeleteButton = Button(window,text="Delete",width=12,command=delete, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
DeleteButton.grid(row=6,column=4)
ClearAllButton = Button(window,text="Clear All",width=12,command=clear, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
ClearAllButton.grid(row=6,column=5)
lb=Listbox(window,height=20,width=94)
lb.grid(row=7,column=0,columnspan=6)
sb=Scrollbar(window)
sb.grid(row=7,column=6,rowspan=6)
lb.configure(yscrollcommand=sb.set)
sb.configure(command=lb.yview)
lb.bind('<<ListboxSelect>>',get_selected_row)
window.mainloop()
database_account.py
import sqlite3
def create():
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS tableAccount(id INTEGER PRIMARY KEY,firstname TEXT, lastname TEXT, username TEXT, password TEXT,position TEXT, date TEXT)")
con.commit()
con.close()
def viewall():
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("SELECT * FROM tableAccount")
rows = cur.fetchall()
con.close()
return rows
def search(firstname="", lastname="", username="", password="", position=""):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("SELECT * FROM tableAccount WHERE firstname=? or lastname=? OR username=? OR password=? OR position=?", (firstname, lastname, username, password, position))
rows = cur.fetchall()
con.close()
return rows
def add(firstname,lastname, username, password, position, date):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("INSERT INTO tableAccount VALUES(NULL,?,?,?,?,?,?)", (firstname, lastname, username, password, position, date))
con.commit()
con.close()
def update(id, firstname, lastname, username, password, position, date):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("UPDATE tableAccount SET firstname=?,lastname=?, username=?,password=?,position=?,date=? WHERE id=?", (firstname, lastname, username, password, position, date, id))
con.commit()
con.close()
def delete(id):
con = sqlite3.connect("accountdb.db")
cur = con.cursor()
cur.execute("DELETE FROM tableAccount WHERE id=?",(id,))
con.commit()
con.close()
create()
How To Run The Account Management System in Python with Source Code?
To run this project, you must have installed a Pycharm on your PC (for Windows). This Account Management System in Python is for educational purposes only!
After downloading the project you must follow the steps below:
Step 1: Unzip the file or Extract the file
Step 2: Double click the account-system
Step 3: Project is ready to run
Downloadable Source Code
I have here the list of Best Python Project with Source code free to download for free, I hope this can help you a lot.
Conclusion
In this Account Management System in Python with Source Code is free to download. Account Management System contains the admin side, The person also can replace the account listing if he/she needs to.This project is good for the student who want to learn python programming because this project contains a Graphical User Interface (GUI) and a users friendly. It is easy to understand and manipulate this project and use for education purpose only.
Related Articles
- Python MySQL UPDATE Query: Step-by-Step Guide in Python
- Bank Management System Project in Python With Source Code
- Python MySQL INSERT Query: Step by Step Guide in Python
- How To Make Game In Python With Source Code
- Complaint Management System Source Code In PHP
Inquiries
If you have any questions or suggestions about Account Management System in Python with Source Code , please feel free to leave a comment below.
