本文整理汇总了Java中org.apache.ddlutils.platform.DatabaseMetaDataWrapper.getPrimaryKeys方法的典型用法代码示例。如果您正苦于以下问题:Java DatabaseMetaDataWrapper.getPrimaryKeys方法的具体用法?Java DatabaseMetaDataWrapper.getPrimaryKeys怎么用?Java DatabaseMetaDataWrapper.getPrimaryKeys使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ddlutils.platform.DatabaseMetaDataWrapper
的用法示例。
在下文中一共展示了DatabaseMetaDataWrapper.getPrimaryKeys方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: readPrimaryKeyNames
import org.apache.ddlutils.platform.DatabaseMetaDataWrapper; //导入方法依赖的package包/类
private static Collection<String> readPrimaryKeyNames(DatabaseMetaDataWrapper metaData, String tableName)
throws SQLException {
ResultSet pkData = null;
try {
List<String> pks = new ArrayList<String>();
Map<String, Object> values;
for (pkData = metaData.getPrimaryKeys(tableName); pkData.next(); pks.add(readPrimaryKeyName(metaData,
values))) {
values = readColumns(pkData, initColumnsForPK());
}
return pks;
} finally {
JdbcUtils.closeResultSet(pkData);
}
}
示例2: existsPKWithName
import org.apache.ddlutils.platform.DatabaseMetaDataWrapper; //导入方法依赖的package包/类
/**
* Determines whether there is a pk for the table with the given name.
*
* @param metaData The database metadata
* @param table The table
* @param name The pk name
* @return <code>true</code> if there is such a pk
*/
private boolean existsPKWithName(DatabaseMetaDataWrapper metaData, Table table, String name)
{
try
{
ResultSet pks = metaData.getPrimaryKeys(table.getName());
boolean found = false;
while (pks.next() && !found)
{
if (name.equals(pks.getString("PK_NAME")))
{
found = true;
}
}
pks.close();
return found;
}
catch (SQLException ex)
{
throw new DdlUtilsException(ex);
}
}
示例3: existsPKWithName
import org.apache.ddlutils.platform.DatabaseMetaDataWrapper; //导入方法依赖的package包/类
/**
* Determines whether there is a pk for the table with the given name.
*
* @param metaData The database metadata
* @param table The table
* @param name The pk name
* @return <code>true</code> if there is such a pk
*/
private boolean existsPKWithName(DatabaseMetaDataWrapper metaData, Table table, String name) throws SQLException
{
ResultSet pks = null;
try
{
pks = metaData.getPrimaryKeys(metaData.escapeForSearch(table.getName()));
// GemStone changes BEGIN
//pks = metaData.getPrimaryKeys(metaData.escapeForSearch(table.getName()));
//The underlying DatabaseMetaData.getPrimaryKeys does not take the string pattern,
//so do not need escape the _, see ticket 44911
pks = metaData.getPrimaryKeys(table.getName());
// GemStone changes BEGIN
while (pks.next())
{
if (name.equals(pks.getString("PK_NAME")))
{
return true;
}
}
return false;
}
finally
{
closeResultSet(pks);
}
}
示例4: isInternalPrimaryKeyIndex
import org.apache.ddlutils.platform.DatabaseMetaDataWrapper; //导入方法依赖的package包/类
/**
* {@inheritDoc}
*/
protected boolean isInternalPrimaryKeyIndex(DatabaseMetaDataWrapper metaData, Table table, Index index) throws SQLException
{
// Db2 uses the form "SQL060205225246220" if the primary key was defined during table creation
// When the ALTER TABLE way was used however, the index has the name of the primary key
if (index.getName().startsWith("SQL"))
{
try
{
Long.parseLong(index.getName().substring(3));
return true;
}
catch (NumberFormatException ex)
{
// we ignore it
}
return false;
}
else
{
// we'll compare the index name to the names of all primary keys
// TODO: Once primary key names are supported, this can be done easier via the table object
ResultSet pkData = null;
HashSet pkNames = new HashSet();
try
{
// GemStone changes BEGIN
//pkData = metaData.getPrimaryKeys(metaData.escapeForSearch(table.getName()));
//The underlying DatabaseMetaData.getPrimaryKeys does not take the string pattern,
//so do not need escape the _, see ticket 44911
pkData = metaData.getPrimaryKeys(table.getName());
// GemStone changes BEGIN
while (pkData.next())
{
Map values = readColumns(pkData, getColumnsForPK());
pkNames.add(values.get("PK_NAME"));
}
}
finally
{
closeResultSet(pkData);
}
return pkNames.contains(index.getName());
}
}
示例5: isInternalPrimaryKeyIndex
import org.apache.ddlutils.platform.DatabaseMetaDataWrapper; //导入方法依赖的package包/类
/**
* {@inheritDoc}
*/
protected boolean isInternalPrimaryKeyIndex(DatabaseMetaDataWrapper metaData, Table table, Index index) throws SQLException
{
// Db2 uses the form "SQL060205225246220" if the primary key was defined during table creation
// When the ALTER TABLE way was used however, the index has the name of the primary key
if (index.getName().startsWith("SQL"))
{
try
{
Long.parseLong(index.getName().substring(3));
return true;
}
catch (NumberFormatException ex)
{
// we ignore it
}
return false;
}
else
{
// we'll compare the index name to the names of all primary keys
// TODO: Once primary key names are supported, this can be done easier via the table object
ResultSet pkData = null;
HashSet pkNames = new HashSet();
try
{
pkData = metaData.getPrimaryKeys(table.getName());
while (pkData.next())
{
Map values = readColumns(pkData, getColumnsForPK());
pkNames.add(values.get("PK_NAME"));
}
}
finally
{
if (pkData != null)
{
pkData.close();
}
}
return pkNames.contains(index.getName());
}
}