系统:Windows 7 语言版本:Anaconda3-4.3.0.1-Windows-x86_64 编辑器:pycharm-community-2016.3.2
Part 1:示例说明
数据库各字段信息
数据库内容
Part 2:代码
import sqlite3
import os
import pandas as pd
current_address = os.path.abspath('.')
db_address = os.path.join(current_address, "测试.db")
conn = sqlite3.connect(db_address)
table_name = "gradeTable"
fields_name = "name, course, grade, sex"
sql = "Select {0} From {1} Where (sex='{2}' and " \
"course='{3}' and grade>{4})".format(fields_name, table_name, "女", "语文", 85)
df = pd.read_sql(sql, conn)
print(df)
代码截图
执行结果
Part 3:部分代码解读
sql = "Select {0} From {1} Where (sex='{2}' and course='{3}' and grade>{4})".format(fields_name, table_name, "女", "语文", 85)
,多条件全部放在Where()内sex='{2}'
course='{3}'
grade>{4}
and
连接起来,表示需要同时满足这多个条件本文为原创作品