#!/usr/bin/python
# -*- coding: UTF-8 -*-
from tkinter import *
import sqlite3
# 導入消息對話框子模塊
import tkinter.messagebox
#import urllib
 #創(chuàng)建主窗口
root = Tk()
root.title('球員查詢')
# 設置窗口大小
root.minsize(500,500)
#定義變量
name = StringVar()
name.set('')
club = StringVar()
club.set('')
nation = StringVar()
nation.set('')
height = StringVar()
height.set('')
position = StringVar()
position.set('')
age = StringVar()
age.set('')
weight = StringVar()
weight.set('')
num = StringVar()
num.set('')
birthday = StringVar()
birthday.set('')
habit = StringVar()
habit.set('')
#name text, club text, nation text, height text, position text, age text, weight text, num text, birthday text, habit text
le_name = Label(root, textvariable = name).place(x = 100, y = 80)  #姓 名
le_club = Label(root, textvariable = club).place(x = 100, y = 110)  #俱樂部
le_nation = Label(root, textvariable = nation).place(x = 100, y = 140)  #國籍
le_height = Label(root, textvariable = height).place(x = 100, y = 170)  #身高
le_position = Label(root, textvariable = position).place(x = 100, y = 200)  #位置
le_age = Label(root, textvariable = age).place(x = 100, y = 230)  #年齡
le_weight = Label(root, textvariable = weight).place(x = 100, y = 260)  #體重
le_num = Label(root, textvariable = num).place(x = 100, y = 290)  #出場數(shù)
le_birthday = Label(root, textvariable = birthday).place(x = 100, y = 320)  #生日
le_habit = Label(root, textvariable = habit).place(x = 100, y = 350)  #慣用腳
#查詢按鈕響應函數(shù)
def select(root, label):
 sname = label.get()
 print('input: ',sname)
 #查詢剛才插入的數(shù)據
 #由于剛才已經關閉了數(shù)據庫連接，需要重新創(chuàng)建Connection對象和Cursor對象
 conn = sqlite3.connect('dongqiudi.db')
 #c = conn.execute('''select * from footballers''')
 #c = conn.execute("select * from footballers where name like?",(sname,))
 print("select * from footballers where name like '%"+sname+"%'")
 c = conn.execute("select * from footballers where name like '%"+sname+"%'")
 #print(c) #<sqlite3.Cursor object at 0x00000000007E25E0>
 list_re = list(c)
 print('result: ', list_re) #[('艾克森', '15', 'ChOxM1xC0BiAe2D7AAAN-qiRteQ443.png')]
 if len(list_re) <= 0:
 tkinter.messagebox.showinfo('提示',sname+'球員不存在，請輸入其他球員姓名！') 
 else:
 print('result_name: ', list_re[0][0])
 #數(shù)據成功提取出來了
 #name text, club text, nation text, height text, position text, age text, weight text, num text, birthday text, habit text
 name.set(list_re[0][0])  #姓 名
 club.set(list_re[0][1])  #俱樂部
 nation.set(list_re[0][2])  #國籍
 height.set(list_re[0][3])  #身高
 position.set(list_re[0][4])  #位置
 age.set(list_re[0][5])  #年齡
 weight.set(list_re[0][6])  #體重
 num.set(list_re[0][7])  #出場數(shù)
 birthday.set(list_re[0][8])  #生日
 habit.set(list_re[0][9])  #慣用腳
 conn.close()
#定義一個返回按鈕調用的返回函數(shù)：callback
def exit_program():
 quit()
def main():
 input_name = Label(root, text = '請輸入球員姓名:').place(x = 30, y = 30)
 label = StringVar()
 entry = Entry(root,bg='#ffffff',width=20,textvariable=label).place(x=130,y=30,anchor='nw')
 #按鈕
 select_button = Button(root,bg='white',text='查詢',width=10,height=1,
    command=lambda :select(root, label)).place(x=280,y=26,anchor='nw')
 exit_button = Button(root,bg='white',text='退出',width=10,height=1,
    command=lambda :exit_program()).place(x=380,y=26,anchor='nw')
 #command是Button中的option項，可以指定點擊button時調用的callback函數(shù)
 #name text, club text, nation text, height text, position text, age text, weight text, num text, birthday text, habit text
 le_name = Label(root, text = '姓 名：').place(x = 40, y = 80)
 le_club = Label(root, text = '俱樂部：').place(x = 40, y = 110)
 le_naion = Label(root, text = '國 籍：').place(x = 40, y = 140)
 le_height = Label(root, text = '身 高：').place(x = 40, y = 170)
 le_positon = Label(root, text = '位 置：').place(x = 40, y = 200)
 le_age = Label(root, text = '年 齡：').place(x = 40, y = 230)
 le_weight = Label(root, text = '體 重：').place(x = 40, y = 260)
 le_num = Label(root, text = '號 碼：').place(x = 40, y = 290)
 le_birthday = Label(root, text = '生 日：').place(x = 40, y = 320)
 le_habit = Label(root, text = '慣用腳：').place(x = 40, y = 350)
 #顯示圖片
 #pilImage = Image.open("imgs/1574777943.3190248.png")
 #tkImage = ImageTk.PhotoImage(image=pilImage)
 #label_nation = Label(root, image=tkImage).place(x=90, y=130, anchor='nw')
 root.mainloop()
main()