python for mysql

#encoding: utf8
import MySQLdb

class MyDB():
  def connect(self, host, user, passwd, db, charset = 'utf8'):
    self.host = host
    self.user = user
    self.passwd = passwd
    self.db = db
    self.charset = charset
    self.conn = MySQLdb.connect(host = self.host, user = self.user, passwd = self.passwd, db = self.db, charset = self.charset)
    self.cur = self.conn.cursor()
  def insert(self, sql, para):
    self.cur.execute(sql, para)
    self.conn.commit()
  def execute(self, sql, flg=0):
    if 0 == flg:
      self.cur.execute(sql)
      return self.cur.fetchall()
    elif 1 == flg:
      sql_escape = MySQLdb.escape_string(sql)
      #sql_escape = self.cur.escape_string(sql)
      self.cur.execute(sql)
      self.conn.commit()
  def commit(self):
    self.conn.commit()
  def exitConnect(self):
    self.cur.close()
    self.conn.close()