import pymysql

host = 'localhost'
port = 3306
db = 'db'
user = 'username'
password = 'password'

# ---- 用pymysql 操作数据库
def get_connection():
    conn = pymysql.connect(host=host, port=port, db=db, user=user, password=password)
    return conn

def check_it():

    conn = get_connection()
     # 使用 cursor() 方法创建一个 dict 格式的游标对象 cursor
    cursor = conn.cursor(pymysql.cursors.DictCursor)

    # 使用 execute()  方法执行 SQL 查询
    cursor.execute("select * from table")

    # 使用 fetchone() 方法获取单条数据.
    data = cursor.fetchall()

    # 关闭数据库连接
    cursor.close()
    conn.close()

    return data

if __name__ == '__main__':
    data=check_it()

    for row in data:
        id = row['id']
        name = row['name']

        # 打印结果
        print (id,name )