使用带有游标的"between“查询sqlite数据库

SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;

import sqlite3

# 连接到SQLite数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建一个示例表
cursor.execute('''CREATE TABLE IF NOT EXISTS employees
                  (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)''')

# 插入一些示例数据
cursor.execute("INSERT INTO employees (name, age) VALUES ('John', 25)")
cursor.execute("INSERT INTO employees (name, age) VALUES ('Jane', 30)")
cursor.execute("INSERT INTO employees (name, age) VALUES ('Bob', 35)")
cursor.execute("INSERT INTO employees (name, age) VALUES ('Alice', 40)")

# 使用带有游标的"between"查询
cursor.execute("SELECT * FROM employees WHERE age BETWEEN 30 AND 40")
result = cursor.fetchall()

# 打印查询结果
for row in result:
    print(row)

# 关闭游标和数据库连接
cursor.close()
conn.close()