实现数据库中表结构统计

实现数据库中表结构统计

    public static final String url = "jdbc:mysql://localhost:3306/";
    public static final String username = "root";
    public static final String password = "root";
    public static final String database = "jdbcstudy";
    //默认最大显示字段数量
    public static final String limit = "3";

 /**
  * 数据库连接操作
  * */
    public static ResultSet sendSQL(String SQL) throws  Exception{
   
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection(url, username, password);
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery(SQL);
        statement.close();
        connection.close();
        return resultSet;
    }

/**
 * 统计数据库中出现的字符集类型
 * */