宜配屋

Python实现一个简单的MySQL类

yipeiwu_com7年前 (2020-03-06)Python基础

本文实例讲述了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]