Student Management System using Python and SQLite

[szaffer0]

# student_management_system.py

Project Features

✅ Add New Student
✅ Update Student Details
✅ Delete Student Record
✅ Search Student by ID
✅ View All Students

student_management_system.py

import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3

Database setup

def connect_db():
con = sqlite3.connect("students.db")
cur = con.cursor()
cur.execute("""CREATE TABLE IF NOT EXISTS student (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
roll TEXT,
course TEXT,
gender TEXT,
contact TEXT
)""")
con.commit()
con.close()

Add new student

def add_student():
if name_var.get() == "" or roll_var.get() == "" or course_var.get() == "":
messagebox.showerror("Error", "All fields are required!")
return

con = sqlite3.connect("students.db")
cur = con.cursor()
cur.execute("INSERT INTO student (name, roll, course, gender, contact) VALUES (?, ?, ?, ?, ?)",
            (name_var.get(), roll_var.get(), course_var.get(), gender_var.get(), contact_var.get()))
con.commit()
con.close()
fetch_students()
clear_fields()
messagebox.showinfo("Success", "Student added successfully!")

Fetch all students

def fetch_students():
con = sqlite3.connect("students.db")
cur = con.cursor()
cur.execute("SELECT * FROM student")
rows = cur.fetchall()
student_table.delete(*student_table.get_children())
for row in rows:
student_table.insert("", tk.END, values=row)
con.close()

Clear input fields

def clear_fields():
name_var.set("")
roll_var.set("")
course_var.set("")
gender_var.set("")
contact_var.set("")

Get selected student

def get_selected(event):
selected = student_table.focus()
values = student_table.item(selected, 'values')
if values:
id_var.set(values[0])
name_var.set(values[1])
roll_var.set(values[2])
course_var.set(values[3])
gender_var.set(values[4])
contact_var.set(values[5])

Update student record

def update_student():
if id_var.get() == "":
messagebox.showerror("Error", "Select a record to update!")
return
con = sqlite3.connect("students.db")
cur = con.cursor()
cur.execute("""UPDATE student SET name=?, roll=?, course=?, gender=?, contact=? WHERE id=?""",
(name_var.get(), roll_var.get(), course_var.get(), gender_var.get(), contact_var.get(), id_var.get()))
con.commit()
con.close()
fetch_students()
clear_fields()
messagebox.showinfo("Success", "Student updated successfully!")

Delete student

def delete_student():
if id_var.get() == "":
messagebox.showerror("Error", "Select a record to delete!")
return
con = sqlite3.connect("students.db")
cur = con.cursor()
cur.execute("DELETE FROM student WHERE id=?", (id_var.get(),))
con.commit()
con.close()
fetch_students()
clear_fields()
messagebox.showinfo("Success", "Student deleted successfully!")

Search student by roll number

def search_student():
con = sqlite3.connect("students.db")
cur = con.cursor()
cur.execute("SELECT * FROM student WHERE roll=?", (roll_var.get(),))
rows = cur.fetchall()
student_table.delete(*student_table.get_children())
for row in rows:
student_table.insert("", tk.END, values=row)
con.close()

GUI setup

root = tk.Tk()
root.title("🎓 Student Management System")
root.geometry("900x600")
root.config(bg="#f0f4f7")

Variables

id_var = tk.StringVar()
name_var = tk.StringVar()
roll_var = tk.StringVar()
course_var = tk.StringVar()
gender_var = tk.StringVar()
contact_var = tk.StringVar()

Title

title = tk.Label(root, text="Student Management System", font=("Arial", 20, "bold"), bg="#0047AB", fg="white", pady=10)
title.pack(fill=tk.X)

Frame for form

form_frame = tk.Frame(root, bg="white", padx=20, pady=20)
form_frame.place(x=30, y=80, width=400, height=400)

tk.Label(form_frame, text="Name:", font=("Arial", 12, "bold"), bg="white").grid(row=0, column=0, sticky="w", pady=5)
tk.Entry(form_frame, textvariable=name_var, font=("Arial", 12), width=25).grid(row=0, column=1, pady=5)

tk.Label(form_frame, text="Roll No:", font=("Arial", 12, "bold"), bg="white").grid(row=1, column=0, sticky="w", pady=5)
tk.Entry(form_frame, textvariable=roll_var, font=("Arial", 12), width=25).grid(row=1, column=1, pady=5)

tk.Label(form_frame, text="Course:", font=("Arial", 12, "bold"), bg="white").grid(row=2, column=0, sticky="w", pady=5)
tk.Entry(form_frame, textvariable=course_var, font=("Arial", 12), width=25).grid(row=2, column=1, pady=5)

tk.Label(form_frame, text="Gender:", font=("Arial", 12, "bold"), bg="white").grid(row=3, column=0, sticky="w", pady=5)
ttk.Combobox(form_frame, textvariable=gender_var, values=["Male", "Female", "Other"], font=("Arial", 12), width=23).grid(row=3, column=1, pady=5)

tk.Label(form_frame, text="Contact:", font=("Arial", 12, "bold"), bg="white").grid(row=4, column=0, sticky="w", pady=5)
tk.Entry(form_frame, textvariable=contact_var, font=("Arial", 12), width=25).grid(row=4, column=1, pady=5)

Buttons

btn_frame = tk.Frame(form_frame, bg="white")
btn_frame.grid(row=5, columnspan=2, pady=20)

tk.Button(btn_frame, text="Add", command=add_student, width=8, bg="#28a745", fg="white", font=("Arial", 11, "bold")).grid(row=0, column=0, padx=5)
tk.Button(btn_frame, text="Update", command=update_student, width=8, bg="#007bff", fg="white", font=("Arial", 11, "bold")).grid(row=0, column=1, padx=5)
tk.Button(btn_frame, text="Delete", command=delete_student, width=8, bg="#dc3545", fg="white", font=("Arial", 11, "bold")).grid(row=0, column=2, padx=5)
tk.Button(btn_frame, text="Clear", command=clear_fields, width=8, bg="#6c757d", fg="white", font=("Arial", 11, "bold")).grid(row=0, column=3, padx=5)
tk.Button(btn_frame, text="Search", command=search_student, width=8, bg="#ffc107", fg="black", font=("Arial", 11, "bold")).grid(row=0, column=4, padx=5)

Frame for table

table_frame = tk.Frame(root, bg="white")
table_frame.place(x=460, y=80, width=420, height=400)

scroll_y = tk.Scrollbar(table_frame, orient=tk.VERTICAL)
student_table = ttk.Treeview(table_frame, columns=("id", "name", "roll", "course", "gender", "contact"), yscrollcommand=scroll_y.set)
scroll_y.pack(side=tk.RIGHT, fill=tk.Y)
scroll_y.config(command=student_table.yview)

student_table.heading("id", text="ID")
student_table.heading("name", text="Name")
student_table.heading("roll", text="Roll No")
student_table.heading("course", text="Course")
student_table.heading("gender", text="Gender")
student_table.heading("contact", text="Contact")

student_table["show"] = "headings"
student_table.column("id", width=40)
student_table.column("name", width=100)
student_table.column("roll", width=80)
student_table.column("course", width=80)
student_table.column("gender", width=70)
student_table.column("contact", width=100)

student_table.pack(fill=tk.BOTH, expand=1)
student_table.bind("", get_selected)

connect_db()
fetch_students()

root.mainloop()