Python实现一个简单的MySQL类
本文实例讲述了Python实现一个简单的MySQL类。分享给大家供大家参考。
具体实现方法如下:
#!/usr/bin/envpython #-*-coding:utf-8-*- #Createdon2011-2-19 #@author:xiaoxiao importMySQLdb importsys __all__=['MySQL'] classMySQL(object): ''' MySQL ''' conn='' cursor='' def__init__(self,host='localhost',user='root',passwd='root',db='mysql',charset='utf8'): """MySQLDatabaseinitialization""" try: self.conn=MySQLdb.connect(host,user,passwd,db) exceptMySQLdb.Error,e: errormsg='Cannotconnecttoserver\nERROR(%s):%s'%(e.args[0],e.args[1]) printerrormsg sys.exit() self.cursor=self.conn.cursor() defquery(self,sql): """ ExecuteSQLstatement""" returnself.cursor.execute(sql) defshow(self): """ReturntheresultsafterexecutingSQLstatement""" returnself.cursor.fetchall() def__del__(self): """Terminatetheconnection""" self.conn.close() self.cursor.close() #test if__name__=='__main__': mysql=MySQL(host=localhost,passwd='test',db='mysql') mysql.query('select*fromusers') result=mysql.show() printlen(result) printresult[1]
希望本文所述对大家的Python程序设计有所帮助。