Package org.pentaho.di.core

Class SQLStatement

java.lang.Object

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

Constructors

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

Method Summary

Modifier and Type	Method	Description
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

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

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 Details

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.