Scribd Logo
Upload

Welcome to Scribd!

  • 82 views

    Fee Management

    Uploaded by

    amansingh20022006
    The document describes a student management system using Python and MySQL. It defines tables to store student and fee payment data, then provides functions to insert, view, update, and delete student and fee records through a menu-driven interface. The functions connect to a MySQL database called School and allow the user to add students, view student details, deposit fees, view fees for a student, and remove a student as needed.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Fee Management

    Uploaded by

    amansingh20022006
    82 views8 pages
    The document describes a student management system using Python and MySQL. It defines tables to store student and fee payment data, then provides functions to insert, view, update, and delete student and fee records through a menu-driven interface. The functions connect to a MySQL database called School and allow the user to add students, view student details, deposit fees, view fees for a student, and remove a student as needed.

    Original Description:

    This project is based on class 12 science

    Original Title

    FEE-MANAGEMENT

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes a student management system using Python and MySQL. It defines tables to store student and fee payment data, then provides functions to insert, view, update, and delete student and fee records through a menu-driven interface. The functions connect to a MySQL database called School and allow the user to add students, view student details, deposit fees, view fees for a student, and remove a student as needed.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    82 views8 pages

    Fee Management

    Uploaded by

    amansingh20022006
    The document describes a student management system using Python and MySQL. It defines tables to store student and fee payment data, then provides functions to insert, view, update, and delete student and fee records through a menu-driven interface. The functions connect to a MySQL database called School and allow the user to add students, view student details, deposit fees, view fees for a student, and remove a student as needed.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 8

    FEE - MANAGEMENT:

    DBMS: MySQL
    Host : localhost
    User: root
    Pass: root
    DataBase: School
    Table Structure:

    SQL Commands to create both the tables:

    Student table:
    mysql> CREATE TABLE student (roll int(5) Primary key, name varchar(20)
    NOT NULL, age int(2) NOT NULL, class varchar(3), City varchar(10));
    Fee table:
    mysql> CREATE TABLE fee (roll int(5) references Student(roll), FeeDeposit
    int(6) NOT NULL, month varchar(10));
    PYTHON CODE :

    import os
    import platform
    import mysql.connector
    import pandas as pd
    mydb=mysql.connector.connect(host=”localhost”,\
    user=”root”,\
    password=”root”,\
    database=”School”)
    mycursor=mydb.cursor()

    def stuInsert():
    L=[]
    Roll=int(input(“Enter the roll number:”))
    L.append(roll)
    name=input(“Enter the Name:”)
    L.append(name)
    age=int(input(“Enter Age of Student:”))
    L.append(age)
    Class=input(“Enter the Class:”)
    L.append(Class)
    City=input(“Enter the City of the Student:”)
    L.append(City)
    stud=(L)
    sql=”insert into student(roll,name,age,class,city)
    values(%s,%s,%s,%s,%s)”
    mycursor.execute(sql,stud)
    mydb.commit()

    def stuView():
    print("Select the search criteria : ")
    print("1. Roll")
    print("2. Name")
    print("3. Age")
    print("4. City")
    print("5. All")
    ch=int(input("Enter the choice : "))
    if ch==1:
    s=int(input("Enter roll no : "))
    rl=(s,)
    sql="select * from student where roll=%s"
    mycursor.execute(sql,rl)
    elif ch==2:
    s=input("Enter Name : ")
    rl=(s,)
    sql="select * from student where name=%s"
    mycursor.execute(sql,rl)
    elif ch==3:
    s=int(input("Enter age : "))
    rl=(s,)
    sql="select * from student where age=%s"
    mycursor.execute(sql,rl)
    elif ch==4:
    s=input("Enter City : ")
    rl=(s,)
    sql="select * from student where City=%s"
    mycursor.execute(sql,rl)
    elif ch==5:
    sql="select * from student"
    mycursor.execute(sql)
    res=mycursor.fetchall()
    print("The Students details are as follows : ")
    print("(ROll, Name, Age, Class, City)")
    for x in res:
    print(x)
    def feeDeposit():
    L=[]
    roll=int(input("Enter the roll number : "))
    L.append(roll)
    feedeposit=int(input("Enter the Fee to be deposited : "))
    L.append(feedeposit)
    month=input("Enter month of fee : ")
    L.append(month)
    fee=(L)
    sql="insert into fee (roll,feeDeposit,Month) values (%s,%s,%s)"
    mycursor.execute(sql,fee)
    mydb.commit()
    def feeView():
    print("Please enter the details to view the fee details :")
    roll=int(input("Enter the roll number of the student whose fee is to
    be viewed : "))
    sql="Select Student.Roll, Student.Name, Student.Class,
    sum(fee.feeDeposit), fee.month from Student
    INNER JOIN fee ON Student.roll=fee.roll and fee.roll = %s"
    rl=(roll,)
    mycursor.execute(sql,rl)
    res=mycursor.fetchall()
    for x in res:
    print(x)

    def removeStu():
    roll=int(input("Enter the roll number of the student to be deleted :
    "))
    rl=(roll,)
    sql="Delete from fee where roll=%s"
    mycursor.execute(sql,rl)
    sql="Delete from Student where roll=%s"
    mycursor.execute(sql,rl)
    mydb.commit()

    def MenuSet(): #Function For The Student Management System


    print("Enter 1 : To Add Student")
    print("Enter 2 : To View Student ")
    print("Enter 3 : To Deposit Fee ")
    print("Enter 4 : To Remove Student")
    print("Enter 5 : To View Fee of Any Student")

    try: #Using Exceptions For Validation


    userInput = int(input("Please Select An Above Option: "))

    #Will Take Input From User


    except ValueError:
    exit("\nHy! That's Not A Number") #Error Message
    else:
    print("\n") #Print New Line
    if(userInput == 1):
    stuInsert()
    elif (userInput==2):
    stuView()
    elif (userInput==3):
    feeDeposit()
    elif (userInput==4):
    removeStu()
    elif (userInput==5):
    feeView()
    else:
    print("Enter correct choice. . . ")
    MenuSet()
    def runAgain():
    runAgn = input("\nwant To Run Again Y/n: ")
    while(runAgn.lower() == 'y'):
    if(platform.system() == "Windows"):
    print(os.system('cls'))
    else:
    print(os.system('clear'))
    MenuSet()
    runAgn = input("\nwant To Run Again Y/n: ")
    runAgain()

    Output: (Adding Students)


    (Viewing Students)

    (Fee Depositing)
    (Fee Viewing)

    (Deleting Student)

    After deletion the records are:

    You might also like