Java Table.getColumn方法代码示例

import org.hibernate.mapping.Table; //导入方法依赖的package包/类
/**
 * @param tableName
 * @param columnName
 * @param changeNotNull
 * @param nullable Pass in null to use the annotation on the column. This is
 *            not always possible (see Redmine #3329).
 * @param changeType
 * @return
 */
public List<String> getModifyColumnSQL(String tableName, String columnName, boolean changeNotNull,
	boolean changeType)
{
	List<String> sqlStrings = new ArrayList<String>();

	Table table = findTable(tableName);
	Column column = table.getColumn(new Column(columnName));

	StringBuffer alter = new StringBuffer("alter table ")
		.append(table.getQualifiedName(dialect, defaultCatalog, defaultSchema)).append(' ')
		.append(extDialect.getModifyColumnSql(mapping, column, changeNotNull, changeType));

	sqlStrings.add(alter.toString());
	return sqlStrings;
}
 

import org.hibernate.mapping.Table; //导入方法依赖的package包/类
public List<String> getDropColumnSQL(String tableName, String... columns)
{
	List<String> sqlStrings = new ArrayList<String>();

	Table table = findTable(tableName);
	for( String columnName : columns )
	{
		Column column = table.getColumn(new Column(columnName));
		if( column == null )
		{
			throw new RuntimeException("Could not find column " + columnName + " on table " + tableName);
		}
		sqlStrings.add(extDialect.getDropColumnSql(table.getQualifiedName(dialect, defaultCatalog, defaultSchema),
			column));
	}
	return sqlStrings;
}
 

import org.hibernate.mapping.Table; //导入方法依赖的package包/类
public List<String> getAddNotNullSQL(String tableName, String... columns)
{
	List<String> sqlStrings = new ArrayList<String>();

	Table table = findTable(tableName);
	for( String columnName : columns )
	{
		Column column = table.getColumn(new Column(columnName));

		StringBuffer alter = new StringBuffer("alter table ")
			.append(table.getQualifiedName(dialect, defaultCatalog, defaultSchema)).append(' ')
			.append(extDialect.getAddNotNullSql(mapping, column));
		sqlStrings.add(alter.toString());
	}
	return sqlStrings;
}
 

import org.hibernate.mapping.Table; //导入方法依赖的package包/类
public List<String> getAddColumnsSQL(String tableName, String... columnNames)
{
	List<String> sqlStrings = new ArrayList<String>();

	Table table = findTable(tableName);
	for( String columnName : columnNames )
	{
		Column column = table.getColumn(new Column(columnName));

		StringBuffer alter = new StringBuffer("alter table ")
			.append(table.getQualifiedName(dialect, defaultCatalog, defaultSchema)).append(' ')
			.append(dialect.getAddColumnString());
		alter.append(' ').append(column.getQuotedName(dialect)).append(' ')
			.append(column.getSqlType(dialect, mapping));

		boolean useUniqueConstraint = extDialect.supportsModifyWithConstraints() && column.isUnique()
			&& dialect.supportsUnique() && (!column.isNullable() || dialect.supportsNotNullUnique());
		if( useUniqueConstraint )
		{
			alter.append(" unique");
		}
		if( column.hasCheckConstraint() && dialect.supportsColumnCheck() )
		{
			alter.append(" check(").append(column.getCheckConstraint()).append(")");
		}

		String columnComment = column.getComment();
		if( columnComment != null )
		{
			alter.append(dialect.getColumnComment(columnComment));
		}
		sqlStrings.add(alter.toString());
	}
	return sqlStrings;
}
 

import org.hibernate.mapping.Table; //导入方法依赖的package包/类
public List<String> getRenameColumnSQL(String tableName, String columnName, String newColumnName)
{
	List<String> sqlStrings = new ArrayList<String>();

	Table table = findTable(tableName);

	Column column = table.getColumn(new Column(columnName));
	String alter = null;
	alter = extDialect.getRenameColumnSql(table.getQualifiedName(dialect, defaultCatalog, defaultSchema), column,
		newColumnName);
	sqlStrings.add(alter);

	return sqlStrings;
}
 

import org.hibernate.mapping.Table; //导入方法依赖的package包/类
@SuppressWarnings({"unchecked"})
public List<String> getAddIndexesAndConstraintsForColumns(String tableName, boolean includeForeignKeyConstraints,
	String... columnNames)
{
	Set<Column> colSet = new HashSet<Column>();
	for( String columnName : columnNames )
	{
		colSet.add(new Column(columnName));
	}
	List<String> sqlStrings = new ArrayList<String>();

	Table table = findTable(tableName);
	if( !extDialect.supportsModifyWithConstraints() )
	{
		for( Column col : colSet )
		{
			Column realCol = table.getColumn(col);
			if( realCol.isUnique() )
			{
				table.createUniqueKey(Collections.singletonList(realCol));
			}
		}
	}
	Iterator<UniqueKey> keyIter = table.getUniqueKeyIterator();
	if( dialect.supportsUniqueConstraintInCreateAlterTable() )
	{
		while( keyIter.hasNext() )
		{
			UniqueKey uk = keyIter.next();
			if( !Collections.disjoint(uk.getColumns(), colSet) )
			{
				StringBuilder buf = new StringBuilder("alter table ");
				buf.append(table.getQualifiedName(dialect, defaultCatalog, defaultSchema));
				buf.append(" add constraint ");
				buf.append(extDialect.getRandomIdentifier());
				buf.append(' ');
				String constraint = uk.sqlConstraintString(dialect);
				if( constraint != null )
				{
					buf.append(constraint);
					sqlStrings.add(buf.toString());
				}
			}
		}
	}
	else
	{
		while( keyIter.hasNext() )
		{
			UniqueKey ukey = keyIter.next();
			if( !Collections.disjoint(ukey.getColumns(), colSet) )
			{
				sqlStrings.add(ukey.sqlCreateString(dialect, mapping, defaultCatalog, defaultSchema));
			}
		}
	}

	addIndexSQL(sqlStrings, table, colSet);

	// Caller may opt to skip foreign key constraints
	if( includeForeignKeyConstraints )
	{
		Iterator<ForeignKey> fkeyIter = table.getForeignKeyIterator();
		while( fkeyIter.hasNext() )
		{
			ForeignKey fkey = fkeyIter.next();
			if( !Collections.disjoint(fkey.getColumns(), colSet) )
			{
				sqlStrings.add(fkey.sqlCreateString(dialect, mapping, defaultCatalog, defaultSchema));
			}
		}
	}

	return sqlStrings;
}