Class JDPWhereClause

java.lang.Object
   |
   +----java.awt.Component
           |
           +----java.awt.Container
                   |
                   +----java.awt.Panel
                           |
                           +----JDPWhereClause

public class JDPWhereClause
extends Panel
Class JDPWhereClause represents a class for creating a where clause to be used for selecting rows from a database to be loaded into other databound classes such as grids, columns or charts.


Constructor Index

 o JDPWhereClause(JDPUser)
Creates a Where Clause panel.
 o JDPWhereClause(JDPUser, Panel, String, boolean, String, String[], String[], String[][], String[][], String[][], String[][], int[], boolean[])
Creates a Where Clause panel.
 o JDPWhereClause(JDPUser, Panel, String, boolean, String, String[], String[], Vector, Vector, String[][], String[][], int[], boolean[])
Creates a Where Clause panel.
 o JDPWhereClause(JDPUser, Panel, String, boolean, String, String[], String[], Vector, Vector, String[][], String[][], int[], boolean[], String)
Creates a Where Clause panel.
 o JDPWhereClause(JDPUser, String, boolean, String, String[], String[], String[][], String[][], String[][], String[][], int[], boolean[])
Creates a Where Clause panel.

Method Index

 o buildWhereClause()
 o getChooseFrom()
Get the selected entry in the choose from pulldown.
 o getFont()
 o getFromWhereClause()
Get the current value of the from/where clause.
 o getHorizontalLayout()
Get whether the panel is laid out in a horizontal fashion.
 o getMatchConstant()
Get the text in the match constant text field.
 o getMatchUsing()
Get the selected entry in the match using pulldown.
 o getUpperCaseEntry()
Get whether entry is always uppercase.
 o handleEvent(Event)
 o setBackground(Color)
 o setChooseFrom(String)
Select the desired entry in the choose from pulldown.
 o setDataType(int, int)
Set the data type of this element.
 o setDSNType(String)
Set the data type of this element.
 o setFont(Font)
 o setForeground(Color)
 o setHorizontalLayout(boolean)
Set whether the panel is laid out in a horizontal fashion.
 o setMatchConstant(String)
Set the text in the match constant text field.
 o setMatchUsing(String)
Select the desired entry in the match using pulldown.
 o setUpperCaseEntry(boolean)
Set entry to always be uppercase.

Constructors

 o JDPWhereClause
 public JDPWhereClause(JDPUser user,
                       Panel targetPanel,
                       String whereClauseName,
                       boolean smallConfig,
                       String pinitChoice,
                       String pchooseFrom[],
                       String pactualchooseFrom[],
                       Vector pmatchUsing,
                       Vector pactualmatchUsing,
                       String pmatchTo[][],
                       String pactualmatchTo[][],
                       int constantLength[],
                       boolean constantIsString[],
                       String fromWhereClause)
Creates a Where Clause panel.

Parameters:
JDPUser - the global user parameter used to pass handles in JDP.
targetPanel - the parent panel that this one will be added to.
whereClauseName - the name of this where clause component.
smallConfig - select whether layout is in a box or a row.
pinitChoice - the intial choice for the column name pulldown.
pchooseFrom - the display values to place in the column name pulldown.
pactualchooseFrom - the actual SQL values that correspond to the column name pulldown values.
pmatchUsing - the match using values for the entries in the pulldown.
pactualmatchUsing - the corresponding actual SQL values for the match using values.
pmatchTo - the match to values.
pactualmatchTo - the corresponding actual SQL match to values.
constantLength - the required length if the column requires a constant entered.
constantIsString - the constant is a String value.
fromWhereClause - the initial from/where clause.
 o JDPWhereClause
 public JDPWhereClause(JDPUser user,
                       Panel targetPanel,
                       String whereClauseName,
                       boolean smallConfig,
                       String pinitChoice,
                       String pchooseFrom[],
                       String pactualchooseFrom[],
                       Vector pmatchUsing,
                       Vector pactualmatchUsing,
                       String pmatchTo[][],
                       String pactualmatchTo[][],
                       int constantLength[],
                       boolean constantIsString[])
Creates a Where Clause panel.

Parameters:
JDPUser - the global user parameter used to pass handles in JDP.
targetPanel - the parent panel that this one will be added to.
whereClauseName - the name of this where clause component.
smallConfig - select whether layout is in a box or a row.
pinitChoice - the intial choice for the column name pulldown.
pchooseFrom - the display values to place in the column name pulldown.
pactualchooseFrom - the actual SQL values that correspond to the column name pulldown values.
pmatchUsing - the match using values for the entries in the pulldown.
pactualmatchUsing - the corresponding actual SQL values for the match using values.
pmatchTo - the match to values.
pactualmatchTo - the corresponding actual SQL match to values.
constantLength - the required length if the column requires a constant entered.
constantIsString - the constant is a String value.
 o JDPWhereClause
 public JDPWhereClause(JDPUser user,
                       Panel targetPanel,
                       String whereClauseName,
                       boolean smallConfig,
                       String pinitChoice,
                       String pchooseFrom[],
                       String pactualchooseFrom[],
                       String pmatchUsing[][],
                       String pactualmatchUsing[][],
                       String pmatchTo[][],
                       String pactualmatchTo[][],
                       int constantLength[],
                       boolean constantIsString[])
Creates a Where Clause panel.

Parameters:
JDPUser - the global user parameter used to pass handles in JDP.
targetPanel - the parent panel that this one will be added to.
whereClauseName - the name of this where clause component.
smallConfig - select whether layout is in a box or a row.
pinitChoice - the intial choice for the column name pulldown.
pchooseFrom - the display values to place in the column name pulldown.
pactualchooseFrom - the actual SQL values that correspond to the column name pulldown values.
pmatchUsing - the match using values for the entries in the pulldown.
pactualmatchUsing - the corresponding actual SQL values for the match using values.
pmatchTo - the match to values.
pactualmatchTo - the corresponding actual SQL match to values.
constantLength - the required length if the column requires a constant entered.
constantIsString - the constant is a String value.
 o JDPWhereClause
 public JDPWhereClause(JDPUser user,
                       String whereClauseName,
                       boolean smallConfig,
                       String pinitChoice,
                       String pchooseFrom[],
                       String pactualchooseFrom[],
                       String pmatchUsing[][],
                       String pactualmatchUsing[][],
                       String pmatchTo[][],
                       String pactualmatchTo[][],
                       int constantLength[],
                       boolean constantIsString[])
Creates a Where Clause panel.

Parameters:
JDPUser - the global user parameter used to pass handles in JDP.
whereClauseName - the name of this where clause component.
smallConfig - select whether layout is in a box or a row.
pinitChoice - the intial choice for the column name pulldown.
pchooseFrom - the display values to place in the column name pulldown.
pactualchooseFrom - the actual SQL values that correspond to the column name pulldown values.
pmatchUsing - the match using values for the entries in the pulldown.
pactualmatchUsing - the corresponding actual SQL values for the match using values.
pmatchTo - the match to values.
pactualmatchTo - the corresponding actual SQL match to values.
constantLength - the required length if the column requires a constant entered.
constantIsString - the constant is a String value.
 o JDPWhereClause
 public JDPWhereClause(JDPUser user)
Creates a Where Clause panel.

Parameters:
JDPUser - the global user parameter used to pass handles in JDP.

Methods

 o setHorizontalLayout
 public void setHorizontalLayout(boolean layout)
Set whether the panel is laid out in a horizontal fashion.

Parameters:
layout - whether the panel is laid out in a horizontal fashion.
 o getHorizontalLayout
 public boolean getHorizontalLayout()
Get whether the panel is laid out in a horizontal fashion.

Returns:
whether the panel is laid out in a horizontal fashion.
 o handleEvent
 public boolean handleEvent(Event e)
Overrides:
handleEvent in class Component
 o buildWhereClause
 public void buildWhereClause()
 o setDSNType
 public void setDSNType(String type)
Set the data type of this element.

Parameters:
element - the number of this element.
type - the type of this element.
 o setChooseFrom
 public void setChooseFrom(String name)
Select the desired entry in the choose from pulldown.

Parameters:
name - the entry to select.
 o getChooseFrom
 public String getChooseFrom()
Get the selected entry in the choose from pulldown.

Returns:
the entry that is selected.
 o setMatchUsing
 public void setMatchUsing(String name)
Select the desired entry in the match using pulldown.

Parameters:
name - the entry to select.
 o getMatchUsing
 public String getMatchUsing()
Get the selected entry in the match using pulldown.

Returns:
the entry that is selected.
 o setMatchConstant
 public void setMatchConstant(String constant)
Set the text in the match constant text field.

Parameters:
constant - the new value of the constant.
 o getMatchConstant
 public String getMatchConstant()
Get the text in the match constant text field.

Returns:
the text in the match constant text field.
 o setDataType
 public void setDataType(int element,
                         int type)
Set the data type of this element.

Parameters:
element - the number of this element.
type - the type of this element.
 o setUpperCaseEntry
 public void setUpperCaseEntry(boolean uppercase)
Set entry to always be uppercase.

Parameters:
uppercase - entry should be uppercase only.
 o getUpperCaseEntry
 public boolean getUpperCaseEntry()
Get whether entry is always uppercase.

Returns:
entry should be uppercase only.
 o getFromWhereClause
 public String getFromWhereClause()
Get the current value of the from/where clause.

Returns:
the current value of the from/where clause.
 o setBackground
 public void setBackground(Color plistBgColor)
Overrides:
setBackground in class Component
 o setForeground
 public void setForeground(Color plistFgColor)
Overrides:
setForeground in class Component
 o setFont
 public void setFont(Font thisFont)
Overrides:
setFont in class Component
 o getFont
 public Font getFont()
Overrides:
getFont in class Component