python连接mysql

Gavin3110

于 2021-01-08 14:20:10 发布

阅读量122

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/qq_30960005/article/details/112360249

版权

python 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

def save_mysql(title, date, source, content, tech_code, info_code):
    print(title, date, source, content, tech_code, info_code, 'jjjjjjjjjjjjj')
    db = pymysql.Connect(
        host='localhost',
        port=3306,
        user='root',
        passwd='123456',
        db='gc_test',
        charset='utf8'
    )

    cursor = db.cursor()

    sql = 'INSERT INTO information_stock (title,date,source,content,tech_code,info_code) VALUES ("%s","%s","%s","%s",%s,%s)' % (
        title, date, source, content, tech_code, info_code)

    try:
        cursor.execute(sql)
        db.commit()
        print("write success")
    except Exception as e:
        db.rollback()
        print("write fail")
        print(e)

    db.close()