我得到的空间没有为每列值。我怎么能得到不同的列值在每列前面

2024-04-25 13:39:08 发布

您现在位置:Python中文网/ 问答频道 /正文

我没有空间容纳所有列的值。我想为每列显示不同的列值。我怎么能这么做请帮忙。 这是我的密码

    def view():
         c.execute('select * from seat_allocation')
         for row in c.fetchone():
             print(row)
             tree insert("", tk.END, values=row, text="ROOM NO")
         c.close()

共有7栏:房号、行号、板凳号、报名号、试卷编号、考试日期、监考员姓名。值为16、1、B2、16PJ、CORE-5、02-05-19、R。K分别为第一排桌位分配。总共50行。我一次显示一行(学生信息)


Tags: infromview密码forexecutedef空间
1条回答
网友
1楼 · 发布于 2024-04-25 13:39:08

我得到了答案,现在我想分享它,这样它可能会帮助任何人

    def p():
        global screen1

        screen1 = Tk()
        screen1.title("MY HALL")

        screen1.geometry("1500x800")
        screen1.configure(bg='yellow')

        tree = ttk.Treeview(screen1, selectmode='browse')

        conn = sqlite3.connect('TABLE.DB')
        c = conn.cursor()

        def view_my_hall():
            c.execute("SELECT * FROM Seat_Allocation ")
            for row in c.fetchall():

                ROOM_NAME =        row[0]
                LINE_NO =          row[1]
                BENCH_NO =         row[2]
                REGISTRATION_NO =  row[3]
                PAPER_CODE =       row[4]
                EXAM_DATE =        row[5]
                INVIGILATOR_NAME = row[6]

                tree.insert("", tk.END, values=row[0], text="ROOM NAME/ROOM NO")
                tree.insert("", tk.END, values=row[1], text="LINE NO")
                tree.insert("", tk.END, values=row[2], text="BENCH NO")
                tree.insert("", tk.END, values=row[3], text="REGISTRATION NO")    
                tree.insert("", tk.END, values=row[4], text="PAPER CODE")
                tree.insert("", tk.END, values=row[5], text="EXAM DATE")
                tree.insert("", tk.END, values=row[6], text="INVIGILATOR NAME") 
                break

            conn.commit()

        s = ttk.Style()
        s.configure('Treeview', rowheight=48)
        tree = ttk.Treeview(screen1, column=("column1","column2","column3"))

        tree.heading("#1", text="VIEW")
        tree.heading("#2", text="YOUR")
        tree.heading("#3", text="HALL")
        tree.column("#1", width=30, minwidth=0)
        tree.column("#2", width=30, minwidth=0)
        tree.column("#3", width=30, minwidth=0)

        button1 = Button(screen1, text="VIEW", command=view_my_hall, anchor='center', bg='blue', fg='white', width=10)
        button1.pack()
        button2 = Button(screen1, text="BACK", command=screen16.destroy, anchor='center', bg='blue', fg='white', width=10)
        button2.pack()

        tree.pack()

        screen1.mainloop()

相关问题 更多 >