ross_liu
ross_liu
采纳率88.9%
2019-06-03 21:26

如何将之前弹出的message清空只显示一条信息,OK或者Fail?

已采纳

import xlwt
import pymssql
import tkinter as tk

window = tk.Tk()
window.title('my window')
window.geometry('300x300')
e = tk.Entry(window, show=None)
e.pack()
def set_style(name, height, bold=False):
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = name
font.bold = bold
font.color_index = 4
font.height = height
style.font = font
return style
def write_excel(d):
f = xlwt.Workbook()
sheet1 = f.add_sheet('学生',cell_overwrite_ok=True)
row0 = ["id","username","age"]
#写第一行
for i in range(0,len(row0)):
sheet1.write(0,i,row0[i],set_style('Times New Roman',220,True))
#从第二行开始写从数据库里面捞出来的数据
for i in range(0,len(d)):
for m in range(0, len(d[i])):
sheet1.write(i + 1, m, d[i][m], set_style('Times New Roman', 220, True))
f.save('F:/'+tt+'.xls',)

def insert_point():
conn = pymssql.connect(host="localhost", user='sa', password='@eecvs', database='master')
cur = conn.cursor()
cur.execute('select * from temp_ross where id=%s', (e.get()))
global tt
tt=e.get()
data = cur.fetchall()
if len(data) !=0:
t = []
d = []
for i in range(len(data)):
t.append(data[i][0])
t.append(data[i][1].rstrip())
t.append(data[i][2])
d.append(t)
t = []
write_excel(d)
cur.close()
show_eff(True)
else:
show_eff(False)

def show_eff(e):
Mes1 = tk.Message(text='OK' if e else'Fail' ,width = 60)
Mes1.pack()
def windowset():
b1 = tk.Button(window, text='insert point', width=15,
height=2, command=insert_point)
b1.pack()
window.mainloop()
windowset()
图片说明

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • caozhy 从今以后生命中的每一秒都属于我爱的人 2年前
    Mes1 = None
    def show_eff(e):
      if  Msg1 is None:
        Mes1 = tk.Message(text=text='OK' if e else'Fail',width = 60)
        Mes1.pack()
      else:
        Mes1.pack_forget()
        Mes1 = tk.Message(text=text='OK' if e else'Fail',width = 60)
        Mes1.pack()
    
    
    
    点赞 评论 复制链接分享
  • A1342389854 A1342389854 2年前

    Mes1 = None
    def show_eff(e):
    if Msg1 is None:
    Mes1 = tk.Message(text=text='OK' if e else'Fail',width = 60)
    Mes1.pack()
    else:
    Mes1.pack_forget()
    Mes1 = tk.Message(text=text='OK' if e else'Fail',width = 60)
    Mes1.pack()...

    点赞 评论 复制链接分享

相关推荐