本文整理汇总了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);
}
}
示例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);
}
}