def is_exist(self, sql): res = False try: res = (self.con.cursor().execute(sql) != 0) except MySQLdb.MySQLError, e: try: #检查是否超时 self.con.ping() except MySQLdb.InterfaceError: #如果是数据库连接超时,重新进行连接 self.con = MySQLdb.connect(db = self.dbname, user = self.user, passwd = self.passwd) res = (self.con.cursor().execute(sql) != 0) else: res = False log.log('database.py/is_exist', '查询语法出错') print e
def query(self, sql): res = True try: self.con.query(sql) except MySQLdb.MySQLError, e: try: #检查是否超时 self.con.ping() except MySQLdb.InterfaceError: #如果是数据库连接超时,重新进行连接 self.con = MySQLdb.connect(db = self.dbname, user = self.user, passwd = self.passwd) self.con.query(sql) else: res = False log.log('database.py/query', '查询语法出错') print e
def execute(self, sql): cursor = '' try: cursor = self.con.cursor() cursor.execute(sql) except MySQLdb.MySQLError, e: print e self.clear_execute(cursor) try: #检查是否超时 self.con.ping() except MySQLdb.InterfaceError: #如果是数据库连接超时,重新进行连接 self.con = MySQLdb.connect(db = self.dbname, user = self.user, passwd = self.passwd) cursor = self.con.cursor() cursor.execute(sql) else: cursor = '' log.log('database.py/execute', '查询语法出错')