为什么建立不了文件储存数据？

from tkinter import *
from tkinter.messagebox import *
import sqlite3
from tkinter import ttk

dbstr = "C:\Windows"

root = Tk()
root.geometry('1000x700')
root.title('图书管理系统')

Label(root, text="序号：").place(relx=0, rely=0.05, relwidth=0.1)
Label(root, text="书名：").place(relx=0.5, rely=0.05, relwidth=0.1)
Label(root, text="作者：").place(relx=0, rely=0.1, relwidth=0.1)
Label(root, text="国籍：").place(relx=0.5, rely=0.1, relwidth=0.1)

no = StringVar()
bookname = StringVar()
writer = StringVar()
country = StringVar()
Entry(root, textvariable=no).place(relx=0.1, rely=0.05, relwidth=0.37, height=25)
Entry(root, textvariable=bookname).place(relx=0.6, rely=0.05, relwidth=0.37, height=25)

Entry(root, textvariable=writer).place(relx=0.1, rely=0.1, relwidth=0.37, height=25)
Entry(root, textvariable=country).place(relx=0.6, rely=0.1, relwidth=0.37, height=25)

Label(root, text='图书管理系统', bg='white', fg='red', font=('宋体', 15)).pack(side=TOP, fill='x')


def showAllInfo():
    x = dataTreeview.get_children()
    for item in x:
        dataTreeview.delete(item)
    con = sqlite3.connect(dbstr)
    cur = con.cursor()
    cur.execute("select * from book")
    lst = cur.fetchall()
    for item in lst:
        dataTreeview.insert("", 1, text="line1", values=item)
    cur.close()
    con.close()


def appendInfo():
    if no.get() == "":
        showerror(title='提示', message='输入不能为空')
    elif bookname.get() == "":
        showerror(title='提示', message='输入不能为空')
    elif writer.get() == "":
        showerror(title='提示', message='输入不能为空')
    elif country.get() == "":
        showerror(title='提示', message='输入不能为空')
    else:
        x = dataTreeview.get_children()
        for item in x:
            dataTreeview.delete(item)
        list1 = [no.get(), bookname.get(), writer.get(), country.get()]
        con = sqlite3.connect(dbstr)
        cur = con.cursor()
        cur.execute("insert into book values(?,?,?,?)", tuple(list1))
        con.commit()
        cur.execute("select * from book")
        lst = cur.fetchall()
        for item in lst:
            dataTreeview.insert("", 1, text="line1", values=item)
        cur.close()
        con.close()


def deleteInfo():
    con = sqlite3.connect(dbstr)
    cur = con.cursor()
    cur.execute("select * from book")
    bookList = cur.fetchall()
    cur.close()
    con.close()
    print(bookList)

    num = no.get()
    flag = 0
    if not num.isnumeric():
        showerror(title='提示', message='删除失败')
    for i in range(len(bookList)):
        for item in bookList[i]:
            if int(num) == item:
                flag = 1
                con = sqlite3.connect(dbstr)
                cur = con.cursor()
                cur.execute("delete from book where no = ?", (int(num),))
                con.commit()
                cur.close()
                con.close()
                break
    if flag == 1:
        showinfo(title='提示', message='删除成功！')
    else:
        showerror(title='提示', message='删除失败')

    x = dataTreeview.get_children()
    for item in x:
        dataTreeview.delete(item)

    con = sqlite3.connect(dbstr)
    cur = con.cursor()
    cur.execute("select * from book")
    lst = cur.fetchall()
    for item in lst:
        dataTreeview.insert("", 1, text="line1", values=item)
    cur.close()
    con.close()


Button(root, text="显示所有图书信息", command=showAllInfo).place(relx=0.2, rely=0.2, width=100)
Button(root, text="追加图书信息", command=appendInfo).place(relx=0.4, rely=0.2, width=100)
Button(root, text="删除图书信息", command=deleteInfo).place(relx=0.6, rely=0.2, width=100)

dataTreeview = ttk.Treeview(root, show='headings', column=('no', 'bookname', 'writer', 'country'))
dataTreeview.column('no', width=150, anchor="center")
dataTreeview.column('bookname', width=150, anchor="center")
dataTreeview.column('writer', width=150, anchor="center")
dataTreeview.column('country', width=150, anchor="center")

dataTreeview.heading('no', text='序号')
dataTreeview.heading('bookname', text='书名')
dataTreeview.heading('writer', text='作者')
dataTreeview.heading('country', text='国籍')

dataTreeview.place(rely=0.4, relwidth=1.0)
root.mainloop()

怎么解决

 

不知道你这个问题是否已经解决, 如果还没有解决的话:

• 看下这篇博客，也许你就懂了，链接：文件的编码问题解决

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^