当前位置: 首页>>代码示例>>Java>>正文


Java DatabaseMetaDataWrapper.setMetaData方法代码示例

本文整理汇总了Java中org.apache.ddlutils.platform.DatabaseMetaDataWrapper.setMetaData方法的典型用法代码示例。如果您正苦于以下问题:Java DatabaseMetaDataWrapper.setMetaData方法的具体用法?Java DatabaseMetaDataWrapper.setMetaData怎么用?Java DatabaseMetaDataWrapper.setMetaData使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在org.apache.ddlutils.platform.DatabaseMetaDataWrapper的用法示例。


在下文中一共展示了DatabaseMetaDataWrapper.setMetaData方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: determineSchemaOf

import org.apache.ddlutils.platform.DatabaseMetaDataWrapper; //导入方法依赖的package包/类
/**
 * {@inheritDoc}
 */
public String determineSchemaOf(Connection connection, String schemaPattern, Table table) throws SQLException
{
    ResultSet tableData  = null;
    ResultSet columnData = null;

    try
    {
        DatabaseMetaDataWrapper metaData = new DatabaseMetaDataWrapper();

        metaData.setMetaData(connection.getMetaData());
        metaData.setCatalog(getDefaultCatalogPattern());
        metaData.setSchemaPattern(schemaPattern == null ? getDefaultSchemaPattern() : schemaPattern);
        metaData.setTableTypes(getDefaultTableTypes());

        String tablePattern = table.getName();

        if (getPlatform().isDelimitedIdentifierModeOn())
        {
            tablePattern = tablePattern.toUpperCase();
        }

        tableData = metaData.getTables(metaData.escapeForSearch(tablePattern));

        boolean found  = false;
        String  schema = null;

        while (!found && tableData.next())
        {
            Map    values    = readColumns(tableData, getColumnsForTable());
            String tableName = (String)values.get("TABLE_NAME");

            if ((tableName != null) && (tableName.length() > 0))
            {
                schema = (String)values.get("TABLE_SCHEM");
                found  = true;

                if (getPlatform().isDelimitedIdentifierModeOn())
                {
                    // Jaybird has a problem when delimited identifiers are used as
                    // it is not able to find the columns for the table
                    // So we have to filter manually below
                    columnData = metaData.getColumns(getDefaultTablePattern(), getDefaultColumnPattern());
                }
                else
                {
                    columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());
                }

                while (found && columnData.next())
                {
                    values = readColumns(columnData, getColumnsForColumn());

                    if (getPlatform().isDelimitedIdentifierModeOn() &&
                        !tableName.equals(values.get("TABLE_NAME")))
                    {
                        continue;
                    }

                    if (table.findColumn((String)values.get("COLUMN_NAME"),
                                         getPlatform().isDelimitedIdentifierModeOn()) == null)
                    {
                        found = false;
                    }
                }
                closeResultSet(columnData);
                columnData = null;
            }
        }
        return found ? schema : null;
    }
    finally
    {
        closeResultSet(columnData);
        closeResultSet(tableData);
    }
}
 
开发者ID:gemxd,项目名称:gemfirexd-oss,代码行数:80,代码来源:FirebirdModelReader.java

示例2: determineSchemaOf

import org.apache.ddlutils.platform.DatabaseMetaDataWrapper; //导入方法依赖的package包/类
/**
 * {@inheritDoc}
 */
public String determineSchemaOf(Connection connection, String schemaPattern, Table table) throws SQLException
{
    ResultSet tableData  = null;
    ResultSet columnData = null;

    try
    {
        DatabaseMetaDataWrapper metaData = new DatabaseMetaDataWrapper();

        metaData.setMetaData(connection.getMetaData());
        metaData.setCatalog(getDefaultCatalogPattern());
        metaData.setSchemaPattern(schemaPattern == null ? getDefaultSchemaPattern() : schemaPattern);
        metaData.setTableTypes(getDefaultTableTypes());

        String tablePattern = table.getName();

        if (getPlatform().isDelimitedIdentifierModeOn())
        {
            tablePattern = tablePattern.toUpperCase();
        }

        tableData = metaData.getTables(metaData.escapeForSearch(tablePattern));

        boolean found  = false;
        String  schema = null;

        while (!found && tableData.next())
        {
            Map    values    = readColumns(tableData, getColumnsForTable());
            String tableName = (String)values.get("TABLE_NAME");

            if ((tableName != null) && (tableName.length() > 0))
            {
                schema = (String)values.get("TABLE_SCHEM");
                found  = true;

                if (getPlatform().isDelimitedIdentifierModeOn())
                {
                    // Jaybird has a problem when delimited identifiers are used as
                    // it is not able to find the columns for the table
                    // So we have to filter manually below
                    columnData = metaData.getColumns(getDefaultTablePattern(), getDefaultColumnPattern());
                }
                else
                {
                    columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());
                }

                while (found && columnData.next())
                {
                    values = readColumns(columnData, getColumnsForColumn());

                    if (getPlatform().isDelimitedIdentifierModeOn() &&
                        !tableName.equals(values.get("TABLE_NAME")))
                    {
                        continue;
                    }

                    if (table.findColumn((String)values.get("COLUMN_NAME"),
                                         getPlatform().isDelimitedIdentifierModeOn()) == null)
                    {
                        found = false;
                    }
                }
                columnData.close();
                columnData = null;
            }
        }
        return found ? schema : null;
    }
    finally
    {
        closeResultSet(columnData);
        closeResultSet(tableData);
    }
}
 
开发者ID:gemxd,项目名称:gemfirexd-oss,代码行数:80,代码来源:InterbaseModelReader.java


注:本文中的org.apache.ddlutils.platform.DatabaseMetaDataWrapper.setMetaData方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。