python数据库操作

#!/usr/bin/python#coding=utf-8import MySQLdbclass MySQL():def __init__(self,host,user,passwd,db,port=3306):try:self.conn=MySQLdb.connect(host,user,passwd,db,port,charset='utf8') self.cur=self.conn.cursor() except MySQLdb.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])def runSql(self,sql):try:ret = self.cur.execute(sql)self.conn.commit()except:db.rollback()return retdef getResult(self,sql):self.runSql(sql)return self.cur.fetchall()def getOne(self,sql):self.runSql(sql)return self.cur.fetchone()def getValue(self,sql):row = self.getOne(sql)if (row == None):return Noneelse:return row[0]def __del__(self):self.cur.close()self.conn.close()