PYTHON 使用SQLITE 保存数据

最新推荐文章于 2023-06-15 17:34:11 发布

weixin_51221760

最新推荐文章于 2023-06-15 17:34:11 发布

阅读量392

点赞数

分类专栏： python 文章标签： sqlite 数据库 python

本文链接：https://blog.csdn.net/weixin_51221760/article/details/126170886

版权

import sqlite3
conn = sqlite3.connect("xxx.db")

def sql_insert(conn,entities):
    try:
        sql_str = "INSERT INTO dati (topic,answer1,answer2,answer3,answer4,answer5,da) VALUES  (?, ?, ?, ?, ?, ?, ?)"
        cursor = conn.cursor()
        cursor.execute(sql_str,entities)
        conn.commit()
        cursor.close()
        return True
    except Exception as e:
        print(e)
        return False
#基于题目的查询
def sql_select_by_topic(conn,key_value):
    sql_str = f"SELECT topic from dati where topic ='{key_value}'"
    cursor = conn.cursor()
    cursor.execute(sql_str)
    rows = cursor.fetchall()
    cursor.close()
    return len(rows)
#基于判断答案的查询：词形，发音
def sql_select_by_answer1(conn,key_value):
    sql_str = f"SELECT topic from dati where answer1 ='{key_value}'"
    cursor = conn.cursor()
    cursor.execute(sql_str)
    rows = cursor.fetchal