MySQL第三天
class MYSQL: def __init__(self,host,port=3306,db,user,passwd,charset='uft8'):self.host = host
self.port = port
self.db = db
self.user = user
self.passwd = passwd
self.charset = charset
def open(self):
self.connection = connect(host=self.host,port=self.port,db=self.db,user=self.user,passwd=self.passwd,.charset)
self.cursor = self.connection.cursor()
def close(self):
self.cursor.close()
self.connection.close()
def curd(self):
try:
self.open()
self.cursor(sql,param)
self.commit()
self.close()
except Exception,e:
print(e.message)
def all(self,sql,param=[]):
try:
self.open()
self.cursor(sql,param)
result = self.cursor.fetchall()
self.commit()
self.close()
return result
except Exception,e:
print(e.message)
页:
[1]