获得MySQL数据库所有库的名称

 //数据库端口号   port   查询所有库名返回字符串list集合

public  static  List<String> getMysqlInstance(long port) {
        List<String> databases = new ArrayList<String>();
        String sql = "select table_schema from information_schema.`TABLES` group by table_schema";
        Connection conn = getConn();
        try {
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                String instanceName = rs.getString(1);
                if (instanceName.isEmpty() || instanceName.equals("information_schema")) {
                    logger.debug("sytem instance");
                } else {
                    databases.add(instanceName);
                }
            }
        } catch (SQLException e) {
            logger.error("",e);
        } finally{
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    logger.error("SQL error!", e);
                }
            }
        }
        return databases;
    }