如何在Python列表框中显示来自Mysql查询的文本

Question

我的代码正在运行，我只想让它看起来更容易

2-12312 Bob Seesaw Active

4-1212 Jim Beene Off

我想把它展开，让它更容易阅读（对不起，用点代替空格）

2-12312......Bob Seesaw.....Active

4-1212.......Jim Beene........ Off

我输入了特定的代码

from tkinter import *
import pymysql as mdb

from tkinter import ttk
from tkinter import Listbox

-------
 def viewroster():
    rosterList.delete(0, "end")
    dbi = mdb.connect("localhost", port=3306, user="user", passwd="pass", db="interactive_db")
    cursor = dbi.cursor()
   cursor.execute("""SELECT number, firstname, surname, available FROM active_roster""")
   rows=cursor.fetchall()
   dbi.close()
print (rows)
for results in rows:
  rosterList.insert("end", results)

rosterList=Listbox(root, height=6,width=65)
rosterList.grid(row=2, column=0, rowspan=9, columnspan=4)

showButt=Button(root, text="Show All", width=12, command=viewroster)
showButt.grid(row=13, column=3)

2-12312 Bob Seesaw Active

4-1212 Jim Beene Off

我想把它展开，让它更容易阅读（对不起，用点代替空格）

2-12312.....Bob Seesaw....Active

4-1212......Jim Beene ....Off

我没有错

Answer 1

可以使用字符串格式

print( "| {:15s} | {:15s} | {:15s} |".format('2-12312', 'Bob', 'Seesaw Active') )
print( "| {:15s} | {:15s} | {:15s} |".format('4-1212', 'Jim', 'Beene Off') )

得到

| 2-12312         | Bob             | Seesaw Active   |
| 4-1212          | Jim             | Beene Off       |

见第PyFormat.info页

但是您必须使用monspaced字体才能在Listbox中正确显示它

维基百科：Monospaced font