python 操作mysql 入门

# -*- coding: utf-8 -*-
"""
Created on Fri Oct 30 10:39:23 2015
@author: zenwan
"""
import MySQLdb
from pprint import pprint


class SQLdb:
    def __init__(self):
        self.sql0 = 'SELECT  bigtopic FROM user_topic'

    def Conn(self):
        try:
            conn = MySQLdb.connect(host='10.10.20.165',
                                   user='user',
                                   passwd='@user123',
                                   db='userdata',
                                   charset='utf8',
                                   port=3306)
            cur = conn.cursor()
            cur.execute(self.sql0)
            result0 = cur.fetchall()
            pprint(result0)
            print type(result0)
            cur.close()
            conn.close()
            return result0

        except MySQLdb.Error, e:
            print "MySQLdb ERROR :%s" % (e)

if __name__ == '__main__':
    s = SQLdb()
    s.Conn()