本文实例讲述了Python实现一个简单的MySQL类。分享给大家供大家参考。

具体实现方法如下：

复制代码 代码如下:

!/usr/bin/env python

-- coding:utf-8 --

Created on 2011-2-19

@author: xiaoxiao

import MySQLdb
import sys
all = ['MySQL']
class MySQL(object):
'''
MySQL
'''
conn = ''
cursor = ''
def init(self,host='localhost',user='root',passwd='root',db='mysql',charset='utf8'):

    """MySQL Database initialization """  
    try:  
        self.conn = MySQLdb.connect(host,user,passwd,db)  
    except MySQLdb.Error,e:  
        errormsg = 'Cannot connect to server\nERROR (%s): %s' %(e.args[0],e.args[1])  
        print errormsg  
        sys.exit()  

    self.cursor = self.conn.cursor()  

def query(self,sql):  
    """  Execute SQL statement """  
    return self.cursor.execute(sql)  

def show(self):  
    """ Return the results after executing SQL statement """  
    return self.cursor.fetchall()  

def __del__(self):  
    """ Terminate the connection """  
    self.conn.close()  
    self.cursor.close()  

test

if name == 'main':

mysql = MySQL(host=localhost,passwd='test',db='mysql')  
mysql.query('select * from users')  
result = mysql.show()  
print len(result)  
print result[1]

希望本文所述对大家的Python程序设计有所帮助。