连接数据库语句

# 导入pymysql
import pymysql

def query():
    # 连接数据库
    conn = pymysql.connect(
        host="localhost",
        port=3306,
        database="数据库名字",
        charset="utf8",
        user="自己的用户名",
        passwd="自己的密码"
    )

    # 获得游标，执行sql指令
    cursor = conn.cursor()
    sql = ""UPDATE course set Credit=5 where Cno='00001' and Cname='DataBase'"
    
    #检查异常
    try:
        # 正确顺序
        cursor.execute(sql)
        conn.commit()
    except Exception as e:
        cursor.rollback()
        print('更新数据异常')
        print(e)

    # 关闭游标
    cursor.close()
    # 关闭连接
    conn.close()


if __name__ == '__main__':
    query()