python操作mysql也需要jdbc,一直呐没有分享,今天分享一下
下期精彩预告:python自动化巡检邮件通知脚本
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# @Time : 2021/6/8 23:13
# @Author : 闭关苦炼内功
# @Describe: python操作mysql数据库之jdbc
import pymysql
conn = pymysql.connect(
host="xxx",port=3306,
user="xxx",password="xxx",
database="xxx",charset="utf8")
cursor = conn.cursor()
sql = "select version()"
try:
cursor.execute(sql) # 执行sql语句
results = cursor.fetchall() # 获取查询结果
# 遍历结果
for row in results:
print(row[0])
except Exception as e:
raise e
finally:
cursor.close() # 关闭游标
conn.close() # 关闭连接