# 连接数据库 import sqlite3 conn = sqlite3.connect('test.db') # 创建数据表 cursor = conn.cursor() cursor.execute('CREATE TABLE IF NOT EXISTS user(id integer primary key, name varchar(20))') # 插入数据 cursor.execute('INSERT INTO user(id, name) VALUES (1, "Tom")') # 查询数据 result = cursor.execute('SELECT * FROM user') for row in result: print(row) # 提交操作 conn.commit() # 关闭数据库连接 conn.close()