Java DatabaseMeta.getAttributes方法代碼示例

import org.pentaho.di.core.database.DatabaseMeta; //導入方法依賴的package包/類
/**
 * Saves the database information into a given repository.
 * 
 * @param databaseMeta The database metadata object to store
 * @param rep The repository to save the database into.
 * 
 * @throws KettleException if an error occurs.
 */
public static void saveDatabaseMeta(DatabaseMeta databaseMeta, Repository rep) throws KettleException
{
	try
	{
           // If we don't have an ID, we don't know which entry in the database we need to update.
		// See if a database with the same name is already available...
		if (databaseMeta.getID()<=0)
		{
			databaseMeta.setID(rep.getDatabaseID(databaseMeta.getName()));
		}
		
		// Still not found? --> Insert
		if (databaseMeta.getID()<=0)
		{
			// Insert new Note in repository
			databaseMeta.setID(rep.insertDatabase(	databaseMeta.getName(), 
										DatabaseMeta.getDatabaseTypeCode(databaseMeta.getDatabaseType()), 
										DatabaseMeta.getAccessTypeDesc(databaseMeta.getAccessType()), 
										databaseMeta.getHostname(), 
										databaseMeta.getDatabaseName(), 
										databaseMeta.getDatabasePortNumberString(), 
										databaseMeta.getUsername(), 
										databaseMeta.getPassword(),
										databaseMeta.getServername(),
										databaseMeta.getDataTablespace(),
										databaseMeta.getIndexTablespace()
									)
				); 
		}
		else // --> found entry with the same name...
		{
			// Update the note...
			rep.updateDatabase(	databaseMeta.getID(),
					databaseMeta.getName(), 
										DatabaseMeta.getDatabaseTypeCode(databaseMeta.getDatabaseType()), 
										DatabaseMeta.getAccessTypeDesc(databaseMeta.getAccessType()), 
										databaseMeta.getHostname(), 
										databaseMeta.getDatabaseName(), 
										databaseMeta.getDatabasePortNumberString(), 
										databaseMeta.getUsername(), 
										databaseMeta.getPassword(),
										databaseMeta.getServername(),
										databaseMeta.getDataTablespace(),
										databaseMeta.getIndexTablespace()
									);
		}
           
           // For the extra attributes, just delete them and re-add them.
           rep.delDatabaseAttributes(databaseMeta.getID());
           
           // OK, now get a list of all the attributes set on the database connection...
           // 
           Properties attributes = databaseMeta.getAttributes();
           Enumeration<Object> keys = databaseMeta.getAttributes().keys();
           while (keys.hasMoreElements())
           {
               String code = (String) keys.nextElement();
               String attribute = (String)attributes.get(code);
               
               // Save this attribute
               rep.insertDatabaseAttribute(databaseMeta.getID(), code, attribute);
           }
	}
	catch(KettleDatabaseException dbe)
	{
		throw new KettleException("Error saving database connection or one of its attributes to the repository.", dbe);
	}
}
 

import org.pentaho.di.core.database.DatabaseMeta; //導入方法依賴的package包/類
/**
 * Saves the database information into a given repository.
 * 
 * @param databaseMeta The database metadata object to store
 * 
 * @throws KettleException if an error occurs.
 */
public void saveDatabaseMeta(DatabaseMeta databaseMeta) throws KettleException
{
	try
	{
           // If we don't have an ID, we don't know which entry in the database we need to update.
		// See if a database with the same name is already available...
		if (databaseMeta.getObjectId()==null)
		{
			databaseMeta.setObjectId(getDatabaseID(databaseMeta.getName()));
		}
		
		// Still not found? --> Insert
		if (databaseMeta.getObjectId()==null)
		{
			// Insert new Note in repository
			//
			databaseMeta.setObjectId(insertDatabase(databaseMeta.getName(), 
										databaseMeta.getPluginId(), 
										DatabaseMeta.getAccessTypeDesc(databaseMeta.getAccessType()), 
										databaseMeta.getHostname(), 
										databaseMeta.getDatabaseName(), 
										databaseMeta.getDatabasePortNumberString(), 
										databaseMeta.getUsername(), 
										databaseMeta.getPassword(),
										databaseMeta.getServername(),
										databaseMeta.getDataTablespace(),
										databaseMeta.getIndexTablespace()
									)
				); 
		}
		else // --> found entry with the same name...
		{
			// Update the note...
			updateDatabase(	databaseMeta.getObjectId(),
					databaseMeta.getName(), 
										databaseMeta.getPluginId(), 
										DatabaseMeta.getAccessTypeDesc(databaseMeta.getAccessType()), 
										databaseMeta.getHostname(), 
										databaseMeta.getDatabaseName(), 
										databaseMeta.getDatabasePortNumberString(), 
										databaseMeta.getUsername(), 
										databaseMeta.getPassword(),
										databaseMeta.getServername(),
										databaseMeta.getDataTablespace(),
										databaseMeta.getIndexTablespace()
									);
		}
           
           // For the extra attributes, just delete them and re-add them.
           delDatabaseAttributes(databaseMeta.getObjectId());
           
           // OK, now get a list of all the attributes set on the database connection...
           // 
           Properties attributes = databaseMeta.getAttributes();
           Enumeration<Object> keys = databaseMeta.getAttributes().keys();
           while (keys.hasMoreElements())
           {
               String code = (String) keys.nextElement();
               String attribute = (String)attributes.get(code);
               
               // Save this attribute
               //
               insertDatabaseAttribute(databaseMeta.getObjectId(), code, attribute);
           }
	}
	catch(KettleDatabaseException dbe)
	{
		throw new KettleException("Error saving database connection or one of its attributes to the repository.", dbe);
	}
}