Closed wingfish closed 5 years ago
修改如下,以后再加入更多异常判断
def sqlite_query(db, sql, params):
dir_path = os.path.dirname(os.path.abspath(__file__))
conn = sqlite3.connect(os.path.join(dir_path, 'db', db))
cursor = conn.cursor()
cursor.execute(sql, params)
values = cursor.fetchall()
cursor.close()
conn.close()
return values
功能:将目前 sqlite 查询的代码抽象出来,
函数:sqlite_query()
将其中 sqlite 文件名和 sql 抽象出来