我正在尝试打印这个SQLite查询的结果,以检查它是否已将数据存储在数据库中。目前,它只打印任何内容。有没有办法在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()
谢谢你帮我解决我的问题。
发布于 2018-05-31 05:39:46
Fetchone只有在跟随查询的情况下才会生成内容。在插入之后,添加
cur.execute("SELECT * FROM jetfighter")
print(cur.fetchone())
https://stackoverflow.com/questions/50613392
复制相似问题