pymysql连接

#!/user/bin/env/python
# -*- coding:utf-8 -*-
# Time : 2022/7/5-17:10
# Desc :

import  pymysql
import  traceback

try:
    connection = pymysql.connect(host='192.168.100.140',
                                 port=3306,
                                 user='root',
                                 passwd='root',
                                 database='mysql',
                                 charset='utf8')
except Exception:
    print('数据库连接失败！')
else:
    try:
        with  connection.cursor() as cursor:
            sql = 'select user_name,password,age from user_t where user_name = %(user_name)s ;'
            data = {'user_name':'zhangsan'}
            result = cursor.execute(sql,data)
            print(result)
            for row in cursor.fetchall():
                print(row)
    except Exception:
        print('数据库操作失败！')
        #traceback.print_exc()
    finally:
        connection.close()
        print('关闭数据库连接！')