org.pentaho.di.core
Class SQLStatement

java.lang.Object
  extended by org.pentaho.di.core.SQLStatement

public class SQLStatement
extends Object

This class contains all that is needed to execute an SQL statement in a database. --> The Database connection --> The SQL statement

Since:
02-dec-2004
Author:
Matt

Constructor Summary
SQLStatement(String stepname, DatabaseMeta dbinfo, String sql)
          Creates a new SQLStatement
 
Method Summary
 DatabaseMeta getDatabase()
          Get the database connection for this SQL Statement
 String getError()
          Get the error that occurred when obtaining the SQL.
 String getSQL()
          Get the SQL for this SQL Statement
 String getStepname()
          Return the name of the step for which the SQL is intended
 boolean hasError()
          Checks whether or not an error occurred obtaining the SQL.
 boolean hasSQL()
          Checks whether or not SQL statements are present
 void setDatabase(DatabaseMeta dbinfo)
          Sets the database connection for this SQL Statement
 void setError(String error)
          Sets the error that occurred when obtaining the SQL.
 void setSQL(String sql)
          Sets the SQL to execute for this SQL Statement.
 void setStepname(String stepname)
          Set the name of the step for which the SQL is intended
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SQLStatement

public SQLStatement(String stepname,
                    DatabaseMeta dbinfo,
                    String sql)
Creates a new SQLStatement

Parameters:
dbinfo - The database connection
sql - The sql to execute on the connection
Method Detail

setStepname

public void setStepname(String stepname)
Set the name of the step for which the SQL is intended

Parameters:
stepname - the name of the step for which the SQL is intended

getStepname

public String getStepname()
Return the name of the step for which the SQL is intended

Returns:
The name of the step for which the SQL is intended

setDatabase

public void setDatabase(DatabaseMeta dbinfo)
Sets the database connection for this SQL Statement

Parameters:
dbinfo - The databaseconnection

setSQL

public void setSQL(String sql)
Sets the SQL to execute for this SQL Statement.

Parameters:
sql - The sql to execute, without trailing ";" or anything else.

getDatabase

public DatabaseMeta getDatabase()
Get the database connection for this SQL Statement

Returns:
The database connection for this SQL Statement

getSQL

public String getSQL()
Get the SQL for this SQL Statement

Returns:
The SQL to execute for this SQL Statement

setError

public void setError(String error)
Sets the error that occurred when obtaining the SQL.

Parameters:
error - The error that occurred when obtaining the SQL.

getError

public String getError()
Get the error that occurred when obtaining the SQL.

Returns:
the error that occurred when obtaining the SQL.

hasError

public boolean hasError()
Checks whether or not an error occurred obtaining the SQL.

Returns:
true if an error is set, false if no error is set.

hasSQL

public boolean hasSQL()
Checks whether or not SQL statements are present

Returns:
true if changes are present, false if this is not the case.