Arquivo: formulatio.py |
from tkinter import * import sqlite3 root = Tk() root.geometry('600x500') root.title("Registro") Fullname=StringVar() Email=StringVar() var = IntVar() c=StringVar() var1= IntVar() def database(): nome1=Fullname.get() email=Email.get() gender=var.get() country=c.get() prog=var1.get() conn = sqlite3.connect('Form_py.db') cursor=conn.cursor() cursor.execute('CREATE TABLE IF NOT EXISTS Student (Fullname TEXT,Email TEXT,Gender TEXT,Country TEXT,Programming TEXT)') cursor.execute('INSERT INTO Student (Fullname,Email,Gender,Country,Programming) VALUES(?,?,?,?,?)',(nome1,email,gender,country,prog,)) conn.commit() label_0 = Label(root, text= "Registro", width=20, font=("bold", 20)) label_0.place(x=90,y=53) label_1 = Label(root, text= "Name", width=20, font=("bold", 10)) label_1.place(x=80,y=130) entry_1 = Entry(root,textvar=Fullname) entry_1.place(x=240,y=130) label_2 = Label(root, text= "Email", width=20, font=("bold", 10)) label_2.place(x=68,y=180) entry_2= Entry(root,textvar=Email) entry_2.place(x=240,y=180) label_3 = Label(root, text= "Gender", width=20, font=("bold", 10)) label_3.place(x=70,y=230) Radiobutton(root, text= "male",padx = 5,variable=var, value=1).place(x=235,y=230) Radiobutton(root, text= "Female",padx = 20,variable=var, value=2).place(x=290,y=230) label_4 = Label(root, text= "country", width=20, font=("bold", 10)) label_4.place(x=70,y=280) list1 =['Brasil', 'coreia', 'EUA', 'Canada','argentina', 'china'] droplist=OptionMenu(root,c, *list1) droplist.config(width=15) c.set('selecione seu pais') droplist.place(x=240,y=280) label_4 = Label(root, text= "Programa", width=20, font=("bold", 10)) label_4.place(x=70,y=280) var2= IntVar() Checkbutton(root, text="java",variable=var1).place(x=235,y=330) Checkbutton(root, text="pyton",variable=var2).place(x=290,y=330) Button(root, text='SUbimit',width=20,bg='brown',fg= 'white',command=database).place(x=180,y=380) root.mainloop() |