com.aspc.commander.sql

Class UpdateCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.UpdateCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class UpdateCommand
extends SQLCommand

allow for records to be updated.
Syntax

  UPDATE table
  SET expression [, ...]
  [WHERE condition]
  

Usage

  /* change country & state of some businesses */
  UPDATE business
  SET    country='AU',
         state='NSW'
  WHERE  name like 'ABC%'
  

THREAD MODE: SINGLE THREADED command

Since:

3 December 2003

Author:

Nigel Leck

Field Summary

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
UpdateCommand(Connection connection, Pattern pattern) std.

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute the command.
java.lang.String	getColumnName(int col) the column name
java.lang.String	getColumnType(int col) get the type
java.lang.String	getRecordID(int row) the record ID
java.lang.Object	getValue(int row, int col) the value for this row, column

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Constructor Detail

UpdateCommand

public UpdateCommand(Connection connection,
                     Pattern pattern)

std. Command.

Parameters:

connection - the connection

pattern - the pattern

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

getColumnName

public java.lang.String getColumnName(int col)

the column name

Parameters:

col - the column

Returns:

the name

getColumnType

public java.lang.String getColumnType(int col)

get the type

Parameters:

col - the column

Returns:

the type

getRecordID

public java.lang.String getRecordID(int row)

the record ID

Parameters:

row - the row id

Returns:

the ID

getValue

public java.lang.Object getValue(int row,
                                 int col)

the value for this row, column

Parameters:

row - the row

col - the column

Returns:

the value