python连接mysql并插入数据（网摘）

def insert_data(dbName,data_dict):

    try:

        data_values = "(" + "%s," * (len(data_dict)) + ")"
        data_values = data_values.replace(',)', ')')

        dbField = data_dict.keys()
        dataTuple = tuple(data_dict.values())
        dbField = str(tuple(dbField)).replace("'",'')
        conn = pymysql.connect(host="IP地址", user="用户名", passwd="密码", db="数据库名", charset="utf8")
        cursor = conn.cursor()
        sql = """ insert into %s %s values %s """ % (dbName,dbField,data_values)
        params = dataTuple
        cursor.execute(sql, params)
        conn.commit()
        cursor.close()

        print ("=====  插入成功  =====")
        return 1

    except Exception as e:
        print("********  插入失败    ********")
        print(e)
        return 0

# 数据库的名称
dbName = "newsURL"
# 插入的数据
data_dict = {

            "news_url": urlList[],
            "acreate_time": now,
            "last_edit_time": now

        }

result11 = insert_data(dbName, data_dict)

print(result11)