本文整理汇总了Java中org.pentaho.di.core.SQLStatement.getDatabase方法的典型用法代码示例。如果您正苦于以下问题:Java SQLStatement.getDatabase方法的具体用法?Java SQLStatement.getDatabase怎么用?Java SQLStatement.getDatabase使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.pentaho.di.core.SQLStatement
的用法示例。
在下文中一共展示了SQLStatement.getDatabase方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getData
import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
/**
* Copy information from the meta-data input to the dialog fields.
*/
public void getData()
{
for (int i=0;i<stats.size();i++)
{
SQLStatement stat = (SQLStatement)stats.get(i);
TableItem ti = wFields.table.getItem(i);
String name = stat.getStepname();
DatabaseMeta dbinfo = stat.getDatabase();
String sql = stat.getSQL();
String error = stat.getError();
if (name!=null) ti.setText(1, name);
if (dbinfo!=null) ti.setText(2, dbinfo.getName() );
if (sql!=null) ti.setText(3, sql);
if (error!=null) ti.setText(4, error);
Color col = ti.getBackground();
if (stat.hasError()) col=red;
ti.setBackground(col);
}
wFields.setRowNums();
wFields.optWidth(true);
}
示例2: getSQL
import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
private String getSQL()
{
StringBuffer sql = new StringBuffer();
int idx[] = wFields.table.getSelectionIndices();
// None selected: don't waste users time: select them all!
if (idx.length==0)
{
idx=new int[stats.size()];
for (int i=0;i<stats.size();i++) idx[i]=i;
}
for (int i=0;i<idx.length;i++)
{
SQLStatement stat = (SQLStatement)stats.get(idx[i]);
DatabaseMeta di = stat.getDatabase();
if (i > 0)
sql.append("-------------------------------------------------------------------------------------------").append(Const.CR);
sql.append(Messages.getString("SQLStatementDialog.Log.Step", stat.getStepname()));
sql.append(Messages.getString("SQLStatementDialog.Log.Connection", (di != null ? di.getName() : Messages.getString("SQLStatementDialog.Log.Undefined"))));
if (stat.hasSQL())
{
sql.append("-- SQL : ");
sql.append(stat.getSQL()).append(Const.CR);
}
if (stat.hasError())
{
sql.append(Messages.getString("SQLStatementDialog.Log.Error", stat.getError()));
}
}
return sql.toString();
}
示例3: getSQL
import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
private String getSQL()
{
StringBuffer sql = new StringBuffer();
int idx[] = wFields.table.getSelectionIndices();
// None selected: don't waste users time: select them all!
if (idx.length==0)
{
idx=new int[stats.size()];
for (int i=0;i<stats.size();i++) idx[i]=i;
}
for (int i=0;i<idx.length;i++)
{
SQLStatement stat = (SQLStatement)stats.get(idx[i]);
DatabaseMeta di = stat.getDatabase();
if (i > 0)
sql.append("-------------------------------------------------------------------------------------------").append(Const.CR);
sql.append(BaseMessages.getString(PKG, "SQLStatementDialog.Log.Step", stat.getStepname()));
sql.append(BaseMessages.getString(PKG, "SQLStatementDialog.Log.Connection", (di != null ? di.getName() : BaseMessages.getString(PKG, "SQLStatementDialog.Log.Undefined"))));
if (stat.hasSQL())
{
sql.append("-- SQL : ");
sql.append(stat.getSQL()).append(Const.CR);
}
if (stat.hasError())
{
sql.append(BaseMessages.getString(PKG, "SQLStatementDialog.Log.Error", stat.getError()));
}
}
return sql.toString();
}
示例4: getData
import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
/**
* Copy information from the meta-data input to the dialog fields.
*/
public void getData() {
for ( int i = 0; i < stats.size(); i++ ) {
SQLStatement stat = stats.get( i );
TableItem ti = wFields.table.getItem( i );
String name = stat.getStepname();
DatabaseMeta dbinfo = stat.getDatabase();
String sql = stat.getSQL();
String error = stat.getError();
if ( name != null ) {
ti.setText( 1, name );
}
if ( dbinfo != null ) {
ti.setText( 2, dbinfo.getName() );
}
if ( sql != null ) {
ti.setText( 3, sql );
}
if ( error != null ) {
ti.setText( 4, error );
}
Color col = ti.getBackground();
if ( stat.hasError() ) {
col = red;
}
ti.setBackground( col );
}
wFields.setRowNums();
wFields.optWidth( true );
}
示例5: getSQL
import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
private String getSQL() {
StringBuilder sql = new StringBuilder();
int[] idx = wFields.table.getSelectionIndices();
// None selected: don't waste users time: select them all!
if ( idx.length == 0 ) {
idx = new int[stats.size()];
for ( int i = 0; i < stats.size(); i++ ) {
idx[i] = i;
}
}
for ( int i = 0; i < idx.length; i++ ) {
SQLStatement stat = stats.get( idx[i] );
DatabaseMeta di = stat.getDatabase();
if ( i > 0 ) {
sql
.append( "-------------------------------------------------------------------------------------------" )
.append( Const.CR );
}
sql.append( BaseMessages.getString( PKG, "SQLStatementDialog.Log.Step", stat.getStepname() ) );
sql.append( BaseMessages.getString( PKG, "SQLStatementDialog.Log.Connection", ( di != null
? di.getName() : BaseMessages.getString( PKG, "SQLStatementDialog.Log.Undefined" ) ) ) );
if ( stat.hasSQL() ) {
sql.append( "-- SQL : " );
sql.append( stat.getSQL() ).append( Const.CR );
}
if ( stat.hasError() ) {
sql.append( BaseMessages.getString( PKG, "SQLStatementDialog.Log.Error", stat.getError() ) );
}
}
return sql.toString();
}