com.aspc.Layers.aspc_app.Contact

Class AddContactCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.Contact.AddContactCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class AddContactCommand
extends SQLCommand

ADD_CONTACT
FIRST_NAME sinu
LAST_NAME chandra
Syntax

  ADD_CONTACT       FIRST_NAME client_first_name
                    LAST_NAME client_last_name
                    [BUSINESS_NAME client_business_name] 
                    [ADDRESS_LINE1 client_address_line1]
                    [ADDRESS_LINE2 client_address_line2]
                    [COUNTRY client_country]
                    [STATE client_state]
                    [MAIL_ADDRESS_LINE1 client_mail_address_line1] 
                    [MAIL_ADDRESS_LINE2 client_mail_address_line2]
                    [MAIL_COUNTRY client_mail_country]
                    [MAIL_STATE client_mail_state]
                    [MAIL_POST_CODE client_mail_post_code] 
                    [MAIL_SUBURB_CITY client_mail_suburb_city]
                    [EMAIL client_email]
                    [FAX client_fax]
                    [FIRST_NAME client_first_name]
                    [LAST_NAME client_last_name] 
                    [PHONE client_phone]
                    [POST_CODE client_post_code]
                    [SUBURB_CITY client_suburb_city]
                    
  

Usage

  ADD_CONTACT  
                   FIRST_NAME sinu 
                   LAST_NAME chandra
                   BUSINESS_NAME busines
                   ADDRESS_LINE1 addressline1 
                   ADDRESS_LINE2 addressline2
                   COUNTRY Australia
                   STATE state
                   EMAIL email@yahoo.com
                   FAX 23244555                
                   PHONE 5345344
                   POST_CODE 234876
                   SUBURB_CITY city
                   
  

THREAD MODE: SINGLE THREADED command

Since:

February 19, 2007, 9:33 PM

Author:

Shazia Naz

Field Summary

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

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
AddContactCommand(Connection connection, Pattern pattern) Constructor

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

AddContactCommand

public AddContactCommand(Connection connection,
                         Pattern pattern)

Constructor

Parameters:

connection -

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)

Description copied from interface: CommandBuildResultsPlugin

get the column type

Parameters:

col - The column number ( offset from 1)

Returns:

The column name

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 number ( offset from 1)

Returns:

The record ID

getValue

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

Description copied from interface: CommandBuildResultsPlugin

The value for this column/row

Parameters:

row - The row number ( offset from 1)

col - The column number ( offset from 1)

Returns:

The value