data.sqlClient

Class SqlCommand

java.lang.Object

data.sqlClient.SqlCommand

public final class SqlCommand
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
SqlCommand(java.lang.String cmdText, SqlConnection connection)

Method Summary

Methods

Modifier and Type	Method and Description
void	addParameter(int index, java.lang.Object value, int sqlType)
void	addParameters(java.util.List<SqlParameter> parameters)
void	clearParameters()
boolean	executeNonQuery()
java.sql.ResultSet	executeReader()
java.sql.ResultSet	executeReader(java.lang.Boolean scrollable)
java.lang.Object	executeScaler()
int	executeUpdate()
java.lang.String	getCommandText()
CommandType	getCommandType()
SqlConnection	getConnection()
void	removeParameter(int index)
void	removeParameter(SqlParameter parameter)
void	setCommandText(java.lang.String commandText)
void	setCommandType(CommandType commandType)
void	setConnection(SqlConnection connection)

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlCommand

public SqlCommand(java.lang.String cmdText,
          SqlConnection connection)

Method Detail

getCommandText

public java.lang.String getCommandText()

Returns:

the commandText

setCommandText

public void setCommandText(java.lang.String commandText)

Parameters:

commandText - the commandText to set

getConnection

public SqlConnection getConnection()

Returns:

the connection

setConnection

public void setConnection(SqlConnection connection)

Parameters:

connection - the connection to set

getCommandType

public CommandType getCommandType()

Returns:

the commandType

setCommandType

public void setCommandType(CommandType commandType)

Parameters:

commandType - the commandType to set

executeReader

public java.sql.ResultSet executeReader()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

executeReader

public java.sql.ResultSet executeReader(java.lang.Boolean scrollable)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

executeNonQuery

public boolean executeNonQuery()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

executeScaler

public java.lang.Object executeScaler()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

addParameter

public void addParameter(int index,
                java.lang.Object value,
                int sqlType)

addParameters

public void addParameters(java.util.List<SqlParameter> parameters)

removeParameter

public void removeParameter(int index)

removeParameter

public void removeParameter(SqlParameter parameter)

clearParameters

public void clearParameters()