python3.7 SQLite Tk.listbox

Connection Sqlite3
Python software: Https://www.python.org/ftp/python/3.7.0/python-3.7.0.exe

Pytho comes with sqlite3, so only import is required
Simple example:
Import Sqlite3
db = Sqlite3.connect ("./db") #在调用connect函数并指定库名称, if not present, is automatically created by the specified library name.
CU = Db.cursor () #游标
#cu. Execute ("CREATE TABLE LJ (ID integer primary KEY,LJ text not NULL)") #执行sql语句
#cu. Execute ("INSERT into LJ (LJ) VALUES (' C:\python27 ')")
Db.commit () #事务提交
Cu.execute ("select * from LJ;") #查询
Print Cu.fetchall () #打印查询结果, the result is {1 {c:\python27}}
Cu.close () #关闭游标
Db.close () #关闭数据库连接
Official ultra-detailed description: https://docs.python.org/3.7/library/sqlite3.html

python3.7 SQLite Tk.listbox