【数据库】JDBC课设（4） DatabaseMetaData 获得数据库信息

声明DatabaseMetaData 获得数据库元信息；

  //获得数据库的元信息
            DatabaseMetaData dbmd = null;
            try {
                dbmd = conn.getMetaData();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }

            String [] tableTypes = {"TABLE", "VIEW"};


            rs = dbmd.getTables(null, null, "%",tableTypes);
            System.out.println("元信息为：");
            while (rs.next()) {
                String s = rs.getString(1);
                System.out.println("\nCatalog Name: " + s + " Schema Name: " + rs.getString(2) +
                        " Table Name: " + rs.getString(3) );

        }  // End try