python获取数据库信息

#亲测可用

import pymysql
import sys

# 导入pymysql模块
import pymysql

# 获取连接
coon = pymysql.connect(host="localhost",
                       db="test",
                       user="root",
                       password="root",
                       port=3306,
                       charset="utf8")
# 获取游标
cursor = coon.cursor()
sql = "select * from table where name=%s"
try:
    username=sys.argv[1]
    print("----------",username)
    # 返回值是影响的行数
    count = cursor.execute(sql, (username,))
    data = cursor.fetchall()
    # 手动提交事务
    coon.commit()
except Exception as e:
    print("----异常信息:",e)
    # 回滚数据
    coon.rollback()
print("返回信息",data)
print("同步推送信息完成!")