python链接mysql

# -*- coding: utf-8 -*-

import MySQLdb
import ConfigParser

def mysqlConn():
    cf = ConfigParser.ConfigParser()
    cf.read('dataconf/activityDegree.conf')
    host = cf.get("mysqlconf", "host")
    port = cf.getint("mysqlconf", "port")
    username = cf.get("mysqlconf", "username")
    password = cf.get("mysqlconf", "password")
    database = cf.get("mysqlconf", "database")

    conn= MySQLdb.connect(
        host=host,
        port = port,
        user=username,
        passwd=password,
        db =database,
        )
    return conn

def test():
    conn = mysqlConn()
    conn.cursor()
    cur = conn.cursor()
    sql = 'select * from label_info'
    result = cur.execute(sql)
    print(result)#输出总记录数

    #打印表中的多少数据
    info = cur.fetchmany(result)
    for ii in info:
        print ii
    cur.close()
    conn.commit()
    conn.close()

if  __name__ =='__main__':
    test()

[mysqlconf]
host = localhost
port = 3306
username = root
password = fengbo
database = label_lifecycle_poc