· 7 years ago · Oct 04, 2018, 05:00 AM
1STUDENT NOTE SYSTEM
2
3import sqlite3
4import sys
5from tkinter import *
6import time
7import messagebox
8
9window1 = Tk()
10window1.geometry("450x200")
11window1.configure(background="coral")
12window1.title("LOGIN")
13
14var1= StringVar()
15var2= StringVar()
16
17def reset():
18 var1.set("")
19 var2.set("")
20
21def login():
22 if var1.get()=="123456789":
23 if var2.get()=="987654321":
24 window1.destroy()
25 window2 = Tk()
26 window2.geometry("500x600")
27 window2.configure(background="coral")
28 var3 = StringVar()
29 var4 = StringVar()
30 var5 = StringVar()
31 var6 = StringVar()
32
33 def loginsystem():
34 con = sqlite3.connect("notes.db")
35 cursor = con.cursor()
36
37 def createTable():
38 cursor.execute(
39 "CREATE TABLE IF NOT EXISTS students(name TEXT,surname TEXT,number INT,students note INT)")
40
41 def addStudents(name, surname, number, note):
42 cursor.execute(
43 "INSERT INTO students VALUES('{} ','{}','{}','{}')".format(name, surname, number, note))
44 con.commit()
45 con.close()
46
47 createTable()
48 name = var3.get()
49 surname = var4.get()
50 number = var5.get()
51 note = var6.get()
52 addStudents(name, surname, number, note)
53
54 def quitsystem():
55 qExit = messagebox.askyesno("QUÄ°T", "Do you want to quit?")
56 if qExit > 0:
57 sys.exit()
58
59 def reset():
60 var3.set("")
61 var4.set("")
62 var5.set("")
63 var6.set("")
64
65
66
67 titleFrame1 = Frame(window2, bg="coral4", width=350, height=80, relief="raise", bd=7)
68 titleFrame1.place(relx=0.15, rely=0.03)
69 title1 = Label(window2, text="STUDENT NOTE SYSYEM", bg="coral4", fg="black",
70 font=("Times New Roman", 19, "bold"))
71 title1.place(relx=0.2, rely=0.06)
72
73 max = Label(window2, text="""
74,¤°´'`°·.¸O¸.·°´'`°¤,
75(*SCHOOL*)
76(_¸.·*´'`°¤¸'¸¤°´'`*·.¸_)
77---ENG---""", font=("Times New Roman", 17, "bold"), bg="coral")
78 max.place(relx=0.28, rely=0.18)
79
80 name = Label(window2, text="NAME", font=("Times New Roman", 16, "bold"), bg="coral", fg="black")
81 name.place(relx=0.23, rely=0.45)
82 entryname = Entry(window2, width=25, bg="coral3",
83 font=("Times New Roman", 15, "bold"),textvariable=var3)
84 entryname.place(relx=0.41, rely=0.45)
85
86 surname = Label(window2, text="SURNAME",
87 font=("Times New Roman", 16, "bold"), bg="coral", fg="black")
88 surname.place(relx=0.15, rely=0.525)
89 entrysurname = Entry(window2, width=25, bg="coral3",
90 font=("Times New Roman", 15, "bold"),textvariable=var4)
91 entrysurname.place(relx=0.41, rely=0.525)
92
93 number = Label(window2, text="NUMBER", font=("Times New Roman", 16, "bold"),
94 bg="coral", fg="black")
95 number.place(relx=0.17, rely=0.6)
96 entrynumber = Entry(window2, width=25, bg="coral3",
97 font=("Times New Roman", 15, "bold"),textvariable=var5)
98 entrynumber.place(relx=0.41, rely=0.6)
99
100 note = Label(window2, text="NOTE", font=("Times New Roman", 16, "bold"),
101 bg="coral", fg="black")
102 note.place(relx=0.24, rely=0.675)
103 entrynote = Entry(window2, width=25, bg="coral3",
104 font=("Times New Roman", 15, "bold"),textvariable=var6)
105 entrynote.place(relx=0.41, rely=0.675)
106
107 loginstudent = Button(window2, text="SAVE",
108 font=("Times New Roman", 15, "bold"),
109 bg="coral3",
110 relief="raise", bd=4,command=loginsystem)
111 loginstudent.place(relx=0.65, rely=0.8)
112
113 reset = Button(window2, text="RESET", font=("Times New Roman", 15, "bold"),
114 bg="coral3",command=reset,
115 relief="raise", bd=4)
116 reset.place(relx=0.45, rely=0.8)
117
118 quit = Button(window2, text="QUIT ", font=("Times New Roman", 15, "bold"),
119 bg="coral3",command=quitsystem,
120 relief="raise", bd=4)
121 quit.place(relx=0.26, rely=0.8)
122
123 window2.mainloop()
124
125 else:
126 messagebox.showinfo("WARNING","""
127 WRONG INTRODUCTION""")
128 var1.set("")
129 var2.set("")
130 else:
131 messagebox.showinfo("WARNING", """
132 WRONG INTRODUCTION""")
133 var1.set("")
134 var2.set("")
135
136# butons
137loginbutton = Button(text="LOGIN",command=login,bg="coral3",
138 font=("Times New Roman",14, "bold"))
139loginbutton.place(relx=0.5,rely=0.7)
140
141resetbuton = Button(text="RESET",bg="coral3",font=("Times New Roman",14, "bold"),command=reset)
142resetbuton.place(relx=0.25,rely=0.7)
143
144# Label
145frame1 = Frame(window1,bg="coral3",width=300,height=40,relief="raise",bd=5)
146frame1.place(relx=0.175,rely=0.05)
147
148text1 = Label(window1,bg="coral3",text=" STUDENT NOTE SYSTEM",font=("Times New Roman",16, "bold"))
149text1.place(relx=0.2,rely=0.07)
150
151text2 = Label(window1,bg="coral",text="USERNAME",font=("Times New Roman",14, "bold"))
152text2.place(relx=0.05,rely=0.35)
153entry1 = Entry(window1,bg="coral4",width=25,font=("Times New Roman",14, "bold"),textvariable=var1)
154entry1.place(relx=0.37,rely=0.35)
155
156text3 = Label(window1,bg="coral",text="PASSWORD",font=("Times New Roman",14, "bold"))
157text3.place(relx=0.05,rely=0.5)
158entry1 = Entry(window1,bg="coral4",width=25,font=("Times New Roman",14, "bold"),show="*",textvariable=var2)
159entry1.place(relx=0.37,rely=0.5)
160
161
162window1.mainloop()