Python：dbcur.执行AttributeError:“NoneType”对象没有属性“execute”

Question

我正在尝试执行以下代码：

def getServerSetting(self, setting):
    self.dbcur.execute('select value from settings where setting = ?', [str(setting)])
    rrf = self.dbr.fetchone()
    if rrf is None:
        return False
    else:
        return rrf[0]

但是，我在运行python脚本时遇到以下错误：

^{pr2}$

Answer 1

试着这样写你的函数。如果还有错误，给我看看。在

def getServerSetting(self, setting):

    if not self.dbcon:
        self.dbcon = MySQLdb.connect(host='localhost', user='removed', passwd='removed', db='removed', port=21)
    self.dbcur = self.dbcon.cursor()

    self.dbcur.execute('select value from settings where setting = ?', [str(setting)])
    rrf = self.dbr.fetchone()
    if rrf is None:
            return False
    else:
            return rrf[0]