Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void main(String[] args) throws SchemaCrawlerException {
- // Création d'un objet option de SchemaCrawler
- SchemaCrawlerOptions options = new SchemaCrawlerOptions();
- // On autorise les tables et les vues
- TableType[] types = { TableType.table, TableType.view };
- options.setTableTypes(types);
- // On exclue toutes les procédures (inclure rien, exclure tout)
- InclusionRule procedureInclusionRule = new InclusionRule("", ".*");
- options.setProcedureInclusionRule(procedureInclusionRule);
- // On exclue toutes les colonnes des procédures (inclure rien, exclure tout)
- InclusionRule procedureColumnInclusionRule = new InclusionRule("", ".*");
- options.setProcedureColumnInclusionRule(procedureColumnInclusionRule);
- // On inclue toutes les tables
- //mais on exclue les tables commençant par $ (pour éviter les tables système d'Oracle)
- InclusionRule tableInclusionRule = new InclusionRule(".*", ".*[\\x24]+.*");
- options.setTableInclusionRule(tableInclusionRule);
- // On fixe le niveau de détail des métadonnées au minimum
- options.setSchemaInfoLevel(SchemaInfoLevel.minimum());
- // On spécifie le schéma que l'on souhaite crawler
- InclusionRule schemaInclusionRule = new InclusionRule("projet","");
- options.setSchemaInclusionRule(schemaInclusionRule);
- Connection connection = null; Schema nom;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- }
- catch (ClassNotFoundException e) {System.out.println("probleme de pilote "+e.getMessage());
- e.printStackTrace();}
- try {
- connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/projet", "root", "imane");
- System.out.println("BD trouveé "+connection.getCatalog());
- try {
- Database crawlingDatabase = SchemaCrawlerUtility.getDatabase(connection, options);
- nom= crawlingDatabase.getSchema("projet") ;
- System.out.println("SCHEMA "+nom);
- }
- catch (SchemaCrawlerException e) {
- System.out.println(" "+e.getMessage());
- e.printStackTrace();}
- } //fin try
- catch (SQLException e) {
- System.out.println("base de donnée introuvable " +e.getMessage() );
- e.printStackTrace();
- }
- Catalog catalog = SchemaCrawlerUtility.getCatalog(connection, options); // getCatalog () does not work
- for (final Schema schema : catalog.getSchemas())
- {
- System.out.print("c--> " + schema.getCatalogName() + "\n");
- for (final Table table : catalog.getTables(schema))
- {
- System.out.print("o--> " + table);
- if (table instanceof View)
- {
- System.out.println(" (VIEW)");
- } else
- {
- System.out.println();
- }
- for (final Column column : table.getColumns())
- {
- System.out.println(" o--> " + column + " (" + column.getColumnDataType() + ")");// getColumnDataType() does not work
- }
- }
- }
- }//main
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement