python-连接数据库的公用方法

1、创建数据库连接方法：以mysql为例，连接成功之后输出特定表结构

# ==============================================================
# -*- coding: utf-8 -*-
# ==============================================================
import json
import pymysql

def conn_mysql(con):
    db = pymysql.connect(con[0], con[1], con[2], con[3])
    cursor = db.cursor()
    sql_dict = input("请输入表名，按回车结束：\n")
    table_sql = "SELECT TABLE_NAME FROM `INFORMATION_SCHEMA`.`TABLES` WHERE table_schema = '"+con[3]+"' and table_name = '"+sql_dict+"'"
    cursor.execute(table_sql)
    table_data = cursor.fetchall()
    table_len = len(table_data)
    if table_len == 0:
        print("输入的表名在指定数据库中不存在,请重新输入表！")
        pr