中文字幕理论片,69视频免费在线观看,亚洲成人app,国产1级毛片,刘涛最大尺度戏视频,欧美亚洲美女视频,2021韩国美女仙女屋vip视频

import from tkinter import *

import sqlite3

# 導入消息對話框子模塊

import tkinter.messagebox

#import urllib

#創(chuàng)建主窗口

root = Tk()

root.title('任國寶的股票監(jiān)測模型')

# 設置窗口大小

root.minsize(500,500)

#定義變量

code=StringVar()

code.set("")

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)

le_birthday = Label(root, textvariable = birthday).place(x = 100, y = 320)

le_habit = Label(root, textvariable = habit).place(x = 100, y = 350)

#查詢按鈕響應函數

def select(root, label):

    sname = label.get()

    print('input: ',sname)

    #查詢剛才插入的數據

    #由于剛才已經關閉了數據庫連接，需要重新創(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])

        #數據成功提取出來了

        #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])

        birthday.set(list_re[0][8])

        habit.set(list_re[0][9])

        conn.close()

#定義一個返回按鈕調用的返回函數：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函數  #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)

    root.mainloop()

main()