python连接数据库并进行相关操作

如下操作，助你成功！！！

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"))