python连接mysql数据库实例

利用python去连接mysql数据库，通引入mysqldb这个第三方库去连接即可。可以写一个DB class，里面涵盖要连接的主机、用户名、密码、数据库name、端口号等信息。

import MySQLdb
import sys
reload(sys)
sys.setdefaultencoding('utf8')
import MySQLdb.cursors


class DB(object):
    def __init__(self, host='', user='', passwd='', dbname='', port='', charset="utf8"):
        self.host = host
        self.port = int(port)
        self.user = user
        self.passwd = passwd
        self.db = dbname

        self.charset = charset
        self.conn = None
        self.cursor = None

    def set(self, host, user, passwd, dbname, port=3306):
        self.host = host
        self.user = user
        self.passwd = passwd
        self.db = dbname
        self.port = int(port)

    def open(self):
#注意，这里的autocommit字段需要指定为None
        self.conn = MySQLdb.connect(host=self.host,