如下操作,助你成功!!!
import pymysql.cursors
class ConnectDatabase():
def __init__(self):
# 连接数据库
self.connect = pymysql.Connect(
host='localhost',
port=3306,
user='root',
passwd='1414141',
db='account_mch',
charset='utf8'
)
def getmembername(self,nid):
# 获取游标
cursor = self.connect.cursor()
# 查询数据
sql = "SELECT * FROM am_member_import WHERE member_id = '%s' "
data = (nid)
cursor.execute(sql % data)
for row in cursor.fetchall():
# print("会员名称:",row[4])
return row[4]
# print('共查找出', cursor.rowcount, '条数据')
def getmemberphone(self, nid):
# 获取游标
cursor = self.connect.cursor()
# 查询数据
sql = "SELECT * FROM am_member_import WHERE member_id = '%s' "
data = (nid)
cursor.execute(sql % data)
for row in cursor.fetchall():
# print("会员名称:",row[4])
return row[5]
# print('共查找出', cursor.rowcount, '条数据')
c = ConnectDatabase()
print(c.getmembername("c301006202109091345260034463"))