New Microsoft Excel Worksheet
New Microsoft Excel Worksheet
New Microsoft Excel Worksheet
#Student table:
#mysql> CREATE TABLE student (roll int(5) Primary key, name varchar(20) NOT NULL, age int(2) NOT
#Fee table:
#mysql> CREATE TABLE fee (roll int(5) references Student(roll), FeeDeposit int(6) NOT NULL, month
#varchar(10));
import os
import platform
import mysql.connector
import pandas as pd
mydb = mysql.connector.connect(host='localhost',\
user='root',\
passwd='root',\
database='School')
mycursor=mydb.cursor()
def stuInsert():
L=[]
L.append(roll)
L.append(name)
L.append(age)
L.append(classs)
L.append(city)
stud=(L)
mycursor.execute(sql,stud)
mydb.commit()
def stuView():
print("1. Roll")
print("2. Name")
print("3. Age")
print("4. City")
print("5. All")
if ch==1:
rl=(s,)
mycursor.execute(sql,rl)
elif ch==2:
rl=(s,)
mycursor.execute(sql,rl)
elif ch==3:
rl=(s,)
mycursor.execute(sql,rl)
elif ch==4:
rl=(s,)
mycursor.execute(sql,rl)
elif ch==5:
mycursor.execute(sql)
res=mycursor.fetchall()
for x in res:
print(x)
def feeDeposit():
L=[]
L.append(roll)
L.append(feedeposit)
L.append(month)
fee=(L)
mycursor.execute(sql,fee)
mydb.commit()
def feeView():
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=
rl=(roll,)
mycursor.execute(sql,rl)
res=mycursor.fetchall()
for x in res:
print(x)
def removeStu():
rl=(roll,)
mycursor.execute(sql,rl)
mycursor.execute(sql,rl)
mydb.commit()
userInput = int(input("Please Select An Above Option: ")) #Will Take Input From User
except ValueError:
else:
if(userInput == 1):
stuInsert()
elif (userInput==2):
stuView()
elif (userInput==3):
feeDeposit()
elif (userInput==4):
removeStu()
elif (userInput==5):
feeView()
else:
MenuSet()
def runAgain():
while(runAgn.lower() == 'y'):
if(platform.system() == "Windows"):
print(os.system('cls'))
else:
print(os.system('clear'))
MenuSet()
runAgain()
INNER JOIN fee ON Student.roll=fee.roll and fee.roll = %s"