|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--jasp.adodb.Command
A Command object is a definition of a specific command that you intend to execute against a data source.
Constructor Summary | |
Command()
|
Method Summary | |
void |
AssignProps()
Sets all properties of the Command object. |
void |
Cancel()
Cancel execution of a pending, asynchronous execute method call |
Parameter |
CreateParameter()
Creates a new parameter |
Parameter |
CreateParameter(java.lang.String name)
Creates a new parameter with the specific name |
Parameter |
CreateParameter(java.lang.String name,
int type)
Creates a new parameter with the specific name and type. |
Parameter |
CreateParameter(java.lang.String name,
int type,
int direction)
Creates a new Parameter object with the specified name, type, direction. |
Parameter |
CreateParameter(java.lang.String name,
int type,
int direction,
int size)
Creates a new Parameter object with the specified name, type, direction and size. |
Parameter |
CreateParameter(java.lang.String name,
int type,
int direction,
int size,
java.lang.Object val)
Creates a new Parameter object with the specified name, type, direction, size and value. |
Parameter |
CreateParameter(java.lang.String name,
int type,
int direction,
variant size,
java.lang.Object val)
Creates a new Parameter object with the specified name, type, direction, size and value. |
Parameter |
CreateParameter(java.lang.String name,
int type,
variant direction,
int size)
Creates a new Parameter object with the specified name, type, direction and size. |
Parameter |
CreateParameter(java.lang.String name,
int type,
variant direction,
int size,
java.lang.Object val)
Creates a new Parameter object with the specified name, type, direction, size and value. |
Parameter |
CreateParameter(java.lang.String name,
variant type,
int direction)
Creates a new Parameter object with the specified name, type, direction. |
Parameter |
CreateParameter(variant name,
int type)
Creates a new parameter with the specific name and type. |
Parameter |
CreateParameter(variant name,
int type,
int direction)
Creates a new Parameter object with the specified name, type, direction. |
Parameter |
CreateParameter(variant name,
int type,
int direction,
int size)
Creates a new Parameter object with the specified name, type, direction and size. |
Parameter |
CreateParameter(variant name,
variant type,
int direction)
Creates a new Parameter object with the specified name, type and direction. |
Parameter |
CreateParameter(variant name,
variant type,
int direction,
int size)
Creates a new Parameter object with the specified name, type, direction and size. |
Parameter |
CreateParameter(variant name,
variant type,
variant direction,
int size)
Creates a new Parameter object with the specified name, type, direction and size. |
Parameter |
CreateParameter(variant name,
variant type,
variant direction,
variant size,
java.lang.Object val)
Creates a new Parameter object with the specified name, type, direction, size and value. |
Parameter |
CreateParameter(variant name,
variant type,
variant direction,
variant size,
variant val)
Creates a new Parameter object with the specified name, type, direction, size and value. |
Recordset |
Execute()
Execute a SQL statement with the specific CommandText if have reords back, return a Recordset object. |
Recordset |
Execute(variant AffectNum)
Execute a SQL statement with the specific CommandText, and returns the number of records that the operation affected. |
Recordset |
Execute(variant AffectNum,
variant pars)
Execute a SQL statement with the specific CommandText and Parameters array, and returns the number of records that the operation affected. |
Recordset |
Execute(variant AffectNum,
variant pars,
int Option)
Execute a SQL statement with the specific CommandText and Parameters array, and returns the number of records that the operation affected. |
Connection |
getActiveConnection()
Returns the Active Connection object. |
java.lang.String |
getCommandText()
Returns the CommandText of the Command object. |
int |
getCommandTimeout()
Returns the CommandTimeout value of the Command object. |
int |
getCommandType()
Returns the CommandType of the Command object. |
Parameter |
getItem(int idx)
Gets the parameter object |
Parameter |
getItem(java.lang.String name)
Sets the value of the Parameter |
Parameter |
getItem(variant var)
Gets a Parameter. |
java.lang.String |
getName()
Returns the name of Command |
int |
getObjectState()
Returns the objectstate of ActiveConnection. |
Parameters |
getParameters()
Returns the Parameters collection |
Parameter |
getParameters(int idx)
Gets the parameter |
Parameter |
getParameters(java.lang.String name)
Gets the parameter |
Parameter |
getParameters(variant var)
Gets the parameter |
boolean |
getPrepared()
Returns the Prepared flag |
Properties |
getProperties()
Returns the properties collection |
int |
getState()
Returns the state of the ActiveConnection. |
Property |
Properties(int index)
Gets a property from Properties Collection. |
Property |
Properties(java.lang.String name)
Gets the property from Properties Collection. |
Property |
Properties(variant var)
Gets the property item from Properties Collection. |
void |
setActiveConnection(Connection con)
Sets the active connection. |
void |
setActiveConnection(java.lang.String connectStr)
Sets the active connection . |
void |
setCommandText(java.lang.String cmdtxt)
Sets the Commandtext to specific cmdtxt |
void |
setCommandTimeout(int cmdout)
Sets the CommandTimeout to specific value |
void |
setCommandType(int cmdtype)
Sets the CommandType to specific type. |
void |
setItem(int index,
boolean val)
Sets the value of the Parameter |
void |
setItem(int index,
double val)
Sets the value of the Parameter |
void |
setItem(int index,
float val)
Sets the value of the Parameter |
void |
setItem(int index,
int val)
Sets the value of the Parameter |
void |
setItem(int index,
long val)
Sets the value of the Parameter |
void |
setItem(int index,
short val)
Sets the value of the Parameter |
void |
setItem(int index,
java.lang.String val)
Sets the value of the Parameter |
void |
setItem(int index,
variant val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
boolean val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
double val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
float val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
int val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
long val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
short val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
java.lang.String val)
Sets the value of the Parameter |
void |
setItem(java.lang.String name,
variant val)
Sets the value of the Parameter |
void |
setItem(variant var,
variant val)
Sets the value of the Parameter |
void |
setName(java.lang.String name)
Sets the name of Command |
void |
setParameters(int index,
boolean val)
Sets the parameter. |
void |
setParameters(int index,
double val)
Sets the parameter. |
void |
setParameters(int index,
float val)
Sets the parameter. |
void |
setParameters(int index,
int val)
Sets the parameter. |
void |
setParameters(int index,
long val)
Sets the parameter. |
void |
setParameters(int index,
short val)
Sets the parameter. |
void |
setParameters(int index,
java.lang.String val)
Sets the parameter. |
void |
setParameters(int index,
variant val)
Sets the parameter. |
void |
setParameters(java.lang.String name,
boolean val)
Sets the value of the Parameter. |
void |
setParameters(java.lang.String name,
double val)
Sets the value of the Parameter. |
void |
setParameters(java.lang.String name,
float val)
Sets the value of the Parameter. |
void |
setParameters(java.lang.String name,
int val)
Sets the value of the Parameter. |
void |
setParameters(java.lang.String name,
long val)
Sets the value of the Parameter. |
void |
setParameters(java.lang.String name,
short val)
Sets the value of the Parameter. |
void |
setParameters(java.lang.String name,
java.lang.String val)
Sets the value of the Parameter. |
void |
setParameters(java.lang.String name,
variant val)
Sets the value of the Parameter. |
void |
setParameters(variant var,
variant val)
Sets the parameter. |
void |
setPrepared(boolean flag)
Sets the Prepared flag |
void |
setState(int state)
Sets the state of the ActiveConnection. |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public Command()
Method Detail |
public void setActiveConnection(Connection con) throws java.lang.Exception
con
- a Connection ObjectsetActiveConnection(String connectstring)
public void setActiveConnection(java.lang.String connectStr) throws java.lang.Exception
db
- a string valuesetActiveConnection(String connectstring)
public int getState()
public void setState(int state) throws java.lang.Exception
public boolean getPrepared()
public void setPrepared(boolean flag) throws java.lang.Exception
public void setCommandType(int cmdtype)
public int getCommandType()
public int getCommandTimeout()
public void setCommandTimeout(int cmdout)
cmdout
- the specific value.public java.lang.String getCommandText()
public void setCommandText(java.lang.String cmdtxt)
public Properties getProperties() throws java.lang.Exception
public int getObjectState()
public void AssignProps() throws java.lang.Exception
public Property Properties(int index) throws java.lang.Exception
index
- the property index.public Property Properties(java.lang.String name) throws java.lang.Exception
name
- the name of the property.public Property Properties(variant var) throws java.lang.Exception
var
- the name or index of the property.public java.lang.String getName()
public void setName(java.lang.String name)
public Parameter CreateParameter() throws java.lang.Exception
CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name) throws java.lang.Exception
name
- a String representing the name of the Parameter object.CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, int type) throws java.lang.Exception
name
- a String representing the name of the Parameter object.type
- an Integer value specifying the data type of the Parameter object.CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, int type) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- an Integer value specifying the data type of the Parameter object.CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, int type, int direction) throws java.lang.Exception
name
- a String representing the name of the Parameter object.type
- an Integer value specifying the data type of the Parameter object.direction
- an Integer value specifying the type of Parameter objectCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, variant type, int direction) throws java.lang.Exception
name
- a String representing the name of the Parameter object.type
- a variant value specifying the data type of the Parameter object.direction
- an integer value specifying the type of Parameter objectCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, int type, int direction) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- an integer value specifying the data type of the Parameter object.direction
- an integer value specifying the type of Parameter objectCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, variant type, int direction) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- a variant value specifying the data type of the Parameter object.direction
- an integer value specifying the type of Parameter objectCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, int type, int direction, int size) throws java.lang.Exception
name
- a String representing the name of the Parameter object.type
- an Integer value specifying the data type of the Parameter object.direction
- an Integer value specifying the type of Parameter objectsize
- an Integer value specifying the maximum length for the value of the Parameter in characters or bytesCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, variant type, variant direction, int size) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- a variant value specifying the data type of the Parameter object.direction
- a variant value specifying the type of Parameter objectsize
- an Integer value specifying the maximum length for the value of the Parameter in characters or bytesCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, int type, int direction, int size) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- an Integer value specifying the data type of the Parameter object.direction
- an Integer value specifying the type of Parameter objectsize
- an Integer value specifying the maximum length for the value of the Parameter in characters or bytesCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, variant type, int direction, int size) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- a variant value specifying the data type of the Parameter object.direction
- an Integer value specifying the type of Parameter objectsize
- an Integer value specifying the maximum length for the value of the Parameter in characters or bytesCreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, int type, variant direction, int size) throws java.lang.Exception
name
- a String representing the name of the Parameter object.type
- an Integer value specifying the data type of the Parameter object.direction
- an variant value specifying the type of Parameter objectsize
- an Integer value specifying the maximum length for the value of the Parameter in characters or bytes.CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, int type, int direction, int size, java.lang.Object val) throws java.lang.Exception
name
- a String representing the name of the Parameter object.type
- an Integer value specifying the data type of the Parameter object.direction
- an Integer value specifying the type of Parameter objectsize
- an Integer value specifying the maximum length for the value of the Parameter in characters or bytes.val
- the Object specifying the value for the Parameter object.CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, variant type, variant direction, variant size, variant val) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- a variant specifying the data type of the Parameter object.direction
- a variant specifying the type of Parameter objectsize
- a variant specifying the maximum length for the value of the Parameter in characters or bytes.val
- the variant specifying the value for the Parameter object.CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(variant name, variant type, variant direction, variant size, java.lang.Object val) throws java.lang.Exception
name
- a variant representing the name of the Parameter object.type
- a variant specifying the data type of the Parameter object.direction
- a variant specifying the type of Parameter objectsize
- a variant specifying the maximum length for the value of the Parameter in characters or bytes.val
- the Object specifying the value for the Parameter object.CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, int type, variant direction, int size, java.lang.Object val) throws java.lang.Exception
CreateParameter(String name,int type,int direction,int size,Object val)
public Parameter CreateParameter(java.lang.String name, int type, int direction, variant size, java.lang.Object val) throws java.lang.Exception
CreateParameter(String name,int type,int direction,int size,Object val)
public Parameters getParameters() throws java.lang.Exception
public Recordset Execute() throws java.lang.Exception
public Recordset Execute(variant AffectNum) throws java.lang.Exception
AffectNum
- A variant variable to which the provider returns
the number of records that the operation affected.public Recordset Execute(variant AffectNum, variant pars) throws java.lang.Exception
AffectNum
- A variant variable to which the provider returns
the number of records that the operation affected.pars
- A Variant array of parameter values passed with an
SQL statement.public Recordset Execute(variant AffectNum, variant pars, int Option) throws java.lang.Exception
AffectNum
- A variant variable to which the provider returns
the number of records that the operation affected.pars
- A Variant array of parameter values passed with an
SQL statement.Option
- An integer value that indicates how the provider should evaluate the CommandText
property of the Command object.public void Cancel()
public Connection getActiveConnection() throws java.lang.Exception
public void setItem(variant var, variant val) throws java.lang.Exception
var
- the name or index of the parameter.val
- the value of the parameter.public void setItem(int index, java.lang.String val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public void setItem(int index, int val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public void setItem(int index, double val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public void setItem(int index, float val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public void setItem(int index, long val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public void setItem(int index, short val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public void setItem(int index, boolean val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public void setItem(int index, variant val) throws java.lang.Exception
index
- the index of the parameter.val
- the value of the parameter.public Parameter getItem(variant var) throws java.lang.Exception
index
- the name or index of the parameter.public Parameter getItem(int idx) throws java.lang.Exception
index
- the index of the parameter.public void setItem(java.lang.String name, java.lang.String val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public void setItem(java.lang.String name, int val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public void setItem(java.lang.String name, double val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public void setItem(java.lang.String name, float val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public void setItem(java.lang.String name, long val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public void setItem(java.lang.String name, short val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public void setItem(java.lang.String name, boolean val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public void setItem(java.lang.String name, variant val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public Parameter getItem(java.lang.String name) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of the Parameter.public Parameter getParameters(variant var) throws java.lang.Exception
var
- the name or index of the Parameter.public Parameter getParameters(int idx) throws java.lang.Exception
idx
- the index of the Parameter.public Parameter getParameters(java.lang.String name) throws java.lang.Exception
name
- the name of the parameter.public void setParameters(variant var, variant val) throws java.lang.Exception
var
- the name or index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, java.lang.String val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, int val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, double val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, float val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, long val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, short val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, boolean val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(int index, variant val) throws java.lang.Exception
index
- the index of the Parameter.val
- the value of the Parameter.public void setParameters(java.lang.String name, java.lang.String val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.public void setParameters(java.lang.String name, int val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.public void setParameters(java.lang.String name, double val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.public void setParameters(java.lang.String name, float val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.public void setParameters(java.lang.String name, long val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.public void setParameters(java.lang.String name, short val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.public void setParameters(java.lang.String name, boolean val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.public void setParameters(java.lang.String name, variant val) throws java.lang.Exception
name
- the name of the Parameter.val
- the value of teh Parameter.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |