python数据库操作

#!/usr/bin/python
#coding=utf-8
import MySQLdb
class 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 ret
	def 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 None
		else:
			return row[0]
	def __del__(self):
		self.cur.close()
		self.conn.close()