pymysql

from pymysql import connect, cursors


def insertsql():
    # 建立数据库连接
    connection_sql = connect(
        host='localhost',
        user='root',
        password='123456',
        port=3306,
        db='db0526',
        charset='utf8'
    )
    # 获取游标
    # 输入字典格式
    cursor = connection_sql.cursor(cursors.DictCursor)
    str1 = '1'
    str2 = '80'
    sql = 'select * from product where id>%s and price2>%s'
    # 尝试执行代码
    try:
    	# 防止sql注入
        cursor.execute(sql, [str1, str2])
        # 获取所有数据
        a = cursor.fetchall()
        print(a)
        connection_sql.commit()
    # try有错误的时候执行
    except Exception as e:
        connection_sql.rollback()
        raise e
    # try执行成功后执行
    else:
        pass
    # 最后执行
    finally:
        pass
    # 关闭游标
    cursor.close()
    # 关闭连接
    connection_sql.close()



insertsql()