com.aspc.Layers.aspc_app.directdebit

Class UpdateCreditCardDetailsCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.directdebit.UpdateCreditCardDetailsCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class UpdateCreditCardDetailsCommand
extends SQLCommand

This command can be used to insert new credit card details
Syntax

  UPDATE_CREDIT_CARD_DETAILS 
  SUBSCRIPTION_ID subid
  BANK_CARD_EXPIRY expiry 
  BANK_CARD_NAME cardName 
  BANK_CARD_NUMBER cardNumber
  BANK_CARD_TYPE cardType
  [BANK_CARD_CVN verificationNumber]
  

Usage

  UPDATE_CREDIT_CARD_DETAILS 
  SUBSCRIPTION_ID 1234
  BANK_CARD_EXPIRY 25 Apr 2009
  BANK_CARD_NAME Frank
  BANK_CARD_NUMBER 2948574638
  BANK_CARD_TYPE VISA
  

THREAD MODE: SINGLE THREADED command

Since:

30/04/2008

Author:

Lei Gao

Field Summary

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

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
UpdateCreditCardDetailsCommand(Connection connection, Pattern pattern)

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute this command
protected java.lang.String	extMakeThreadName(java.lang.String sql) OVERRIDE THIS METHOD: to change sql text that is used to set the thread name.
java.lang.String	getColumnName(int col) Not mandatory to supply a key for the row as well.
java.lang.String	getColumnType(int col) get the column type
java.lang.String	getRecordID(int row) We are at the last row when we return null for the record ID.
java.lang.Object	getValue(int row, int col) The value for this column/row

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

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, 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

UpdateCreditCardDetailsCommand

public UpdateCreditCardDetailsCommand(Connection connection,
                                      Pattern pattern)

Method Detail

execute

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

execute this command

Specified by:

execute in class Command

Parameters:

p -

Throws:

java.lang.Exception - Exception A serious problem

getRecordID

public java.lang.String getRecordID(int row)

Description copied from interface: CommandBuildResultsPlugin

We are at the last row when we return null for the record ID. All rows must have a unique ID. Nothing else is assumed about a record ID other than it is unique and will return the same value at a later time.

Parameters:

row - the row to use

Returns:

the value

getColumnName

public java.lang.String getColumnName(int col)

Description copied from interface: CommandBuildResultsPlugin

Not mandatory to supply a key for the row as well. If not the ID will be used.

Parameters:

col - the column

Returns:

the value

getColumnType

public java.lang.String getColumnType(int col)
                               throws java.lang.Exception

Description copied from interface: CommandBuildResultsPlugin

get the column type

Parameters:

col - the column

Returns:

the value

Throws:

java.lang.Exception - Exception A serious problem

getValue

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

Description copied from interface: CommandBuildResultsPlugin

The value for this column/row

Parameters:

row - the row to use

col - the column

Returns:

the value

Throws:

java.lang.Exception - Exception A serious problem

extMakeThreadName

protected java.lang.String extMakeThreadName(java.lang.String sql)

OVERRIDE THIS METHOD: to change sql text that is used to set the thread name.

Overrides:

extMakeThreadName in class Command

Parameters:

sql - The sql that will be processed.

Returns:

The thread name.