conn = sqlite3.connect('School.db')
c = conn.cursor()
def account_Table(): #Creates the table for user accounts.
c.execute('CREATE TABLE IF NOT EXISTS accounts(datestamp TEXT, u_id INT, username TEXT, password TEXT, classy TEXT, subject TEXT, forename TEXT, surname TEXT)')
def LoginFrame(Frame): #Builds the login/home screen for the program
username_holder = Label(text="Username", bg="#b4c4a1", fg="#000000")
password_holder = Label(text="Password", bg="#b4c4a1", fg="#000000")
username = Entry()
password = Entry(show="*")
username_holder.grid(row=0, column=20)
password_holder.grid(row=1, column=20)
username.grid(row=0, column=40)
password.grid(row=1, column=40)
checkbox = Checkbutton(text="Keep me logged in", bg="#b4c4a1")
checkbox.grid(row=3,column=40)
logbtn = Button(text="Login", bg="#b4c4a1", command = Login_Check)
logbtn.grid(row=3,column=30)
sigup = Button(text="New User", bg="#b4c4a1", command = DataEntry)
sigup.grid(row=3,column=20)
def DataEntry():
datestamp = datetime.datetime.now() #Shows when the account was made
u_id = (random.randrange(0,100)) #Gives the user a unique identifier, I don't really need it as the username is a pretty good identifier for this job.
label_1 = Label(text='Enter A Username', bg="#b4c4a1")
username = Entry()
username.grid(row=4, column=40)
label_1.grid(row=4, column=39)
label_2 = Label(text='Enter A Password', bg="#b4c4a1")
password = Entry(show='*')
label_2.grid(row=5, column=39)
password.grid(row=5, column=40)
label_3 = Label(text='Enter Your Class', bg="#b4c4a1")
classy = Entry()
classy.grid(row=6, column=40)
label_3.grid(row=6, column=39)
subject = Entry()
label_4=Label(text='Enter Your Subject', bg="#b4c4a1")
subject.grid(row=7, column=40)
label_4.grid(row=7, column=39)
label_5=Label(text='Enter Your First Name', bg="#b4c4a1")
forename = Entry()
forename.grid(row=8, column=40)
label_5.grid(row=8, column=39)
surname = Entry()
label_6 = Label(text='Enter Your Second Name', bg="#b4c4a1")
surname.grid(row=9, column=40)
label_6.grid(row=9, column=39)
“DataEntry():”中的所有条目都将作为新记录进入account表。在
^{pr2}$我不知道如何将Tkinter登录框中的条目作为值传递给使用sqlite3的SQL“INSERT INTO”语句,在仅使用控制台作为输入值的方法之前,它确实起到了作用,但这使用户无法使用GUI。在
您可以使用
Entry
小部件的get()
函数来获取输入的内容,然后使用字符串格式来生成SQL命令。在相关问题 更多 >
编程相关推荐