pymysql单步连接、with方式连接

s_con = pymysql.connect(**db_config)  
s_cur = s_con.cursor() # 数据库游标,能依次执行多个sql语句,有且只能有一个
s_cur.execute('select count(*) as c from ' + tb_name) 
all_rows = s_cur.fetchone()['c']

# 最后全关闭两者
s_cur.close()
s_con.close()

db_config = {
            'host': host,
            'port': port,
            'user': user,
            'password': passwd,
            'db': db,
            'charset': 'utf8',
            'cursorclass': pymysql.cursors.DictCursor  # 直接with ... as cur, cur.execute() [不用再创建cursor了]
             # 如果是pymysql.cursors.Cursor,就需要 with .. as conn, cur = conn.cursor(), cur.execute() [需要创建cursor]
             }