[简体中文] | [English]

Extracting Database Metadata Using JDBC

Extract database metadata based on JDBC connection, including Catalog, Schema, Table, Colum information.

Supported Databases

• MySQL
• MariaDB
• PostgreSQL
• Oracle
• Microsoft SQL Server
• IBM DB2
• Sybase
• Informix
• DMDBMS（武汉达梦数据库）
• KingbaseES（人大金仓数据库）
• OSCAR（神舟通用数据库）

Install

Maven

<dependency>
    <groupId>net.renfei</groupId>
    <artifactId>database-metadata</artifactId>
    <version>1.0.0-SNAPSHOT</version>
</dependency>

Example

package net.renfei.dbmeta;

import org.junit.Test;

import java.sql.SQLException;

/**
 * @author renfei
 */
public class MySqlDatabaseMetadataTest {
    @Test
    public void test() throws SQLException, ClassNotFoundException {
        DatabaseMetadata databaseMetadata = DatabaseMetadataFactory.getDatabaseMetadata(
                "jdbc:mysql://localhost:3306/renfeid?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC",
                "root", "root");
        assert databaseMetadata != null;
        System.out.println(databaseMetadata.getDatabaseProductName());
        System.out.println(databaseMetadata.getDatabaseProductVersion());
        System.out.println(databaseMetadata.getCatalogs());
        System.out.println(databaseMetadata.getSchemas("renfeid"));
        System.out.println(databaseMetadata.getTables("renfeid", null));
        System.out.println(databaseMetadata.getColum("renfeid", null, "kitbox_icp_cache"));
    }
}

Note: MySQL uses catalog instead of schema.