com.aspc.commander.sql

Class SequenceCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.SequenceCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class SequenceCommand
extends SQLCommand

SEQUENCE command is used for working with next_number table
Syntax

  SEQUENCE [CREATE create_name]|[NEXT sequence_name]|[LIST]
  

Usage

  SEQUENCE NEXT sequence_name
  

THREAD MODE: SINGLE THREADED command

Since:

30 Jan 2012

Author:

Liam

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	TYPE_CREATE the create type
static java.lang.String	TYPE_LIST the create list
static java.lang.String	TYPE_NEXT the create next

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

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
SequenceCommand(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 column type
java.lang.String	getRecordID(int row) the record ID
java.lang.Object	getValue(int row, int col) get the value

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

Field Detail

TYPE_CREATE

public static final java.lang.String TYPE_CREATE

the create type

See Also:

Constant Field Values

TYPE_LIST

public static final java.lang.String TYPE_LIST

the create list

See Also:

Constant Field Values

TYPE_NEXT

public static final java.lang.String TYPE_NEXT

the create next

See Also:

Constant Field Values

Constructor Detail

SequenceCommand

public SequenceCommand(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 column type

Parameters:

col - the column

Returns:

the type

getRecordID

public java.lang.String getRecordID(int row)

the record ID

Parameters:

row - the row

Returns:

the ID

getValue

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

get the value

Parameters:

row - the row

col - the col

Returns:

the value

Throws:

java.sql.SQLException - a problem.