import MySQLdb

no = int(input('编号：'))
name = input('名称：')
location = input('所在地：')

conn = MySQLdb.Connect(host='47.108.143.29', port=3306,
                       user='root',password='Zhaoshunxin.618',
                       database='hrs',charset='utf8mb4')
try:
    with conn.cursor() as cursor:
        affected_rows = cursor.execute(
            f'insert into tb_dept  values (%s,%s,%s)',
        (   no,name,location)
        )

        if affected_rows == 1:
            print(cursor.fetchall())
    conn.commit()
except MySQLdb.MySQLError as err:
    print(err)
    conn.rollback()
finally:
    conn.close()