我试图打印这个SQLite查询的结果来检查它是否已经将数据存储在数据库中。目前它只打印None。有没有办法在Microsoft Word或LibreOffice等程序中打开数据库。只是为了看看它是否已将内容保存到数据库中。import tkinter as tk
import sqlite3 as lite
import sys
class GUI(tk.Frame):
def __init__(self, master=None, **kwargs):
tk.Frame.__init__(self, master, **kwargs)
self.var = tk.StringVar()
entry = tk.Entry(self, textvariable=self.var)
entry.pack()
btn = tk.Button(self, text='read', command=self.read_entry)
btn.pack()
btn = tk.Button(self, text='write', command=self.write_entry)
btn.pack()
def read_entry(self):
#print(self.var.get())
def write_entry(self):
self.var.set(self.var.get())
con = lite.connect('RandomThings.db')
cur = con.cursor()
cur.execute("CREATE TABLE jetfighter(Name TEXT)")
cur.execute("INSERT INTO jetfighter VALUES (?)", (self.var.get(),))
#con.commit()
print (cur.fetchone())
cur.close()
def main():
root = tk.Tk()
root.geometry('200x200')
win = GUI(root)
win.pack()
root.mainloop()
if __name__ == '__main__':
main()