问无法使用tkinter将数据添加到mysql

EN

def add_data():
    name=e1.get()
    rol=e2.get()
    phn=e3.get()
    mth=e4.get()
    eng=e5.get()
    sci=e6.get()

    try:
        if(rad.get()==1):
            cursor.execute('insert into first_year( name,roll_number,phn_no,maths,english,science) values(%s,%s,%s,%s,%s,%s)',(name, rol, phn, mth, eng, sci))
        elif(rad.get()==2):
            cursor.execute('insert into second_year( name,roll_number,phn_no,maths,english,science) values(%s,%s,%s,%s,%s,%s)',(name, rol, phn, mth, eng, sci))

        con.commit()
        con.close()
        confimation.config(text="added succesfully")
        e1.delete(0, END)
        e2.delete(0, END)
        e3.delete(0, END)
        e4.delete(0, END)
        e5.delete(0, END)
        e6.delete(0, END)
    except:
        confimation.config(text="roll number exist")

btn=Button(f,text="ADD",command=add_data)
btn.place(x=600,y=350,height=90,width=90)