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.
-
JDPWhereClause(JDPUser)
- Creates a Where Clause panel.
-
JDPWhereClause(JDPUser, Panel, String, boolean, String, String[], String[], String[][], String[][], String[][], String[][], int[], boolean[])
- Creates a Where Clause panel.
-
JDPWhereClause(JDPUser, Panel, String, boolean, String, String[], String[], Vector, Vector, String[][], String[][], int[], boolean[])
- Creates a Where Clause panel.
-
JDPWhereClause(JDPUser, Panel, String, boolean, String, String[], String[], Vector, Vector, String[][], String[][], int[], boolean[], String)
- Creates a Where Clause panel.
-
JDPWhereClause(JDPUser, String, boolean, String, String[], String[], String[][], String[][], String[][], String[][], int[], boolean[])
- Creates a Where Clause panel.
-
buildWhereClause()
-
-
getChooseFrom()
- Get the selected entry in the choose from pulldown.
-
getFont()
-
-
getFromWhereClause()
- Get the current value of the from/where clause.
-
getHorizontalLayout()
- Get whether the panel is laid out in a horizontal fashion.
-
getMatchConstant()
- Get the text in the match constant text field.
-
getMatchUsing()
- Get the selected entry in the match using pulldown.
-
getUpperCaseEntry()
- Get whether entry is always uppercase.
-
handleEvent(Event)
-
-
setBackground(Color)
-
-
setChooseFrom(String)
- Select the desired entry in the choose from pulldown.
-
setDataType(int, int)
- Set the data type of this element.
-
setDSNType(String)
- Set the data type of this element.
-
setFont(Font)
-
-
setForeground(Color)
-
-
setHorizontalLayout(boolean)
- Set whether the panel is laid out in a horizontal fashion.
-
setMatchConstant(String)
- Set the text in the match constant text field.
-
setMatchUsing(String)
- Select the desired entry in the match using pulldown.
-
setUpperCaseEntry(boolean)
- Set entry to always be uppercase.
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.
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.
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.
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.
JDPWhereClause
public JDPWhereClause(JDPUser user)
- Creates a Where Clause panel.
- Parameters:
- JDPUser - the global user parameter used to pass handles in JDP.
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.
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.
handleEvent
public boolean handleEvent(Event e)
- Overrides:
- handleEvent in class Component
buildWhereClause
public void buildWhereClause()
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.
setChooseFrom
public void setChooseFrom(String name)
- Select the desired entry in the choose from pulldown.
- Parameters:
- name - the entry to select.
getChooseFrom
public String getChooseFrom()
- Get the selected entry in the choose from pulldown.
- Returns:
- the entry that is selected.
setMatchUsing
public void setMatchUsing(String name)
- Select the desired entry in the match using pulldown.
- Parameters:
- name - the entry to select.
getMatchUsing
public String getMatchUsing()
- Get the selected entry in the match using pulldown.
- Returns:
- the entry that is selected.
setMatchConstant
public void setMatchConstant(String constant)
- Set the text in the match constant text field.
- Parameters:
- constant - the new value of the constant.
getMatchConstant
public String getMatchConstant()
- Get the text in the match constant text field.
- Returns:
- the text in the match constant text field.
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.
setUpperCaseEntry
public void setUpperCaseEntry(boolean uppercase)
- Set entry to always be uppercase.
- Parameters:
- uppercase - entry should be uppercase only.
getUpperCaseEntry
public boolean getUpperCaseEntry()
- Get whether entry is always uppercase.
- Returns:
- entry should be uppercase only.
getFromWhereClause
public String getFromWhereClause()
- Get the current value of the from/where clause.
- Returns:
- the current value of the from/where clause.
setBackground
public void setBackground(Color plistBgColor)
- Overrides:
- setBackground in class Component
setForeground
public void setForeground(Color plistFgColor)
- Overrides:
- setForeground in class Component
setFont
public void setFont(Font thisFont)
- Overrides:
- setFont in class Component
getFont
public Font getFont()
- Overrides:
- getFont in class Component