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', '查询语法出错')
