先上demo:
#!/usr/bin/env python
# -*- coding:utf-8 -*-
# author: Frank time:2020/8/21
import pymysql
class Mysql:
def __init__(self):
self.content = pymysql.Connect(
host='X.X.X.X', # mysql的主机ip
port=3306, # 端口
user='root', # 用户名
passwd='XXXXXX', # 数据库密码
db='XXXX', # 数据库名
charset='utf8', # 字符集
)
self.cursor = self.content.cursor()
def query(self):
sql = "select * from XXX;"
self.cursor.execute(sql)
for row in self.cursor.fetchall():
print('Api_name = %s'%row[0])
print("Api_pwd = %s" %row[1])
#print("name:%s\t url:%s" %row)
print(f"一共查找到:{self.cursor.rowcount}")
def end(self):
self.cursor.close()
self.content.close()
if __name__ == '__main__':
mysql = Mysql()
mysql.query()
mysql.end()