利用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,