1
2
3
4
5
6
7

import sqlite3

# 连接数据库(如果不存在会自动创建)
conn = sqlite3.connect('example.db')  # (ﾉ◕ヮ◕)ﾉ*:･ﾟ✧

# 获取游标对象
cursor = conn.cursor()

1
2
3
4
5
6

cursor.execute('''CREATE TABLE IF NOT EXISTS users
               (id INTEGER PRIMARY KEY, 
               name TEXT NOT NULL, 
               age INTEGER)''')

conn.commit()  # 别忘记提交哦！(｀・ω・´)ゞ

1

cursor.execute("INSERT INTO users (name, age) VALUES ('Alice', 25)")

1

cursor.execute("INSERT INTO users (name, age) VALUES (?, ?)", ('Bob', 30))

1
2

users = [('Charlie', 45), ('David', 29), ('Eve', 33)]
cursor.executemany("INSERT INTO users (name, age) VALUES (?, ?)", users)

1

conn.commit()  # 重要的提交要重复三遍！✧(≖ ◡ ≖✿)

1
2

cursor.execute("SELECT * FROM users")
print(cursor.fetchall())  # 获取所有结果 ٩(◕‿◕｡)۶

1
2

cursor.execute("SELECT * FROM users WHERE name=?", ('Alice',))
print(cursor.fetchone())  # 获取一条结果

1
2
3

cursor.execute("SELECT name, age FROM users WHERE age > ?", (30,))
for row in cursor:
    print(f"{row[0]} 今年 {row[1]} 岁啦~")  # 迭代获取结果

1
2

cursor.execute("UPDATE users SET age = ? WHERE name = ?", (26, 'Alice'))
conn.commit()  # 提交是必须的！(＞ω＜)

1
2

cursor.execute("DELETE FROM users WHERE name = ?", ('Eve',))
conn.commit()  # 最后再说一次，不要忘记提交！(╯°□°）╯︵ ┻━┻

1
2

cursor.close()  # 关闭游标
conn.close()   # 关闭连接

1
2
3
4
5

with sqlite3.connect('example.db') as conn:
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM users")
    print(cursor.fetchall())
# 不需要手动关闭，with会自动处理哦！(ノ◕ヮ◕)ノ*:･ﾟ✧