Python创建自己的邮箱应用(2)

从已有的数据库中取出邮箱的smtp信息(手动录入)
PythonSQLite的基本使用

sqlitec = sqliteC()
emailserver = sqlitec.query('SELECT * FROM EmailServer')
emailname = []
for item in emailserver:
    emailname.append(item[2])

# 数组传元组
tuple(emailname)

创建登录窗口

from tkinter import *
from tkinter import ttk
from controller.sqliteC import sqliteC



def login():
    sql = "INSERT INTO User VALUES ('%s','%s',%s)" % (addressE.get(), paddE.get(), emailtype.get())
    print(sql)

sqlitec = sqliteC()
emailserver = sqlitec.query('SELECT * FROM EmailServer')
emailname = []
for item in emailserver:
    emailname.append(item[2])

# 数组传元组
tuple(emailname)

loginview = Tk()
loginview.title('登录')
loginview.geometry('400x200')
loginview.minsize(400,200)
loginview.maxsize(400,200)

frame = Frame(loginview)

address = StringVar()
address.set('邮箱账号')
password = StringVar()
password.set('邮箱密码')

addressE = Entry(frame, textvariable=address)
paddE = Entry(frame, textvariable=password)
paddE.focus()

loginButton = Button(frame, text='登录', command=login)

emailtype = StringVar()
#state='readonly' 只读
emailCombox = ttk.Combobox(frame, width=12, textvariable=emailtype, state='readonly')
emailCombox['values'] = emailname
emailCombox.current(0)

checktype = StringVar()
def checkB():
    print(checktype.get())

agreeCheckB = Checkbutton(frame, text='记住密码', variable=checktype, command=checkB)

addressE.grid(row=1)
paddE.grid(row=2)

emailCombox.grid(row=1, column=1)

loginButton.grid(row=2, column=1)
#文字右
agreeCheckB.grid(row=3, columnspan=2, sticky=W)
#居中
frame.pack(expand='yes')

loginview.mainloop()