com.ibm.as400.vaccess.SQLQueryTablePane Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of jt400 Show documentation
Show all versions of jt400 Show documentation
The Open Source version of the IBM Toolbox for Java
The newest version!
///////////////////////////////////////////////////////////////////////////////
//
// JTOpen (IBM Toolbox for Java - OSS version)
//
// Filename: SQLQueryTablePane.java
//
// The source code contained herein is licensed under the IBM Public License
// Version 1.0, which has been approved by the Open Source Initiative.
// Copyright (C) 1997-2000 International Business Machines Corporation and
// others. All rights reserved.
//
///////////////////////////////////////////////////////////////////////////////
package com.ibm.as400.vaccess;
import java.awt.BorderLayout;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.FocusAdapter;
import java.awt.event.FocusEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.StringTokenizer;
import java.util.Vector;
import javax.swing.Box;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JComponent;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.ListSelectionModel;
import javax.swing.border.CompoundBorder;
import javax.swing.border.EmptyBorder;
import javax.swing.event.DocumentEvent;
import javax.swing.event.DocumentListener;
import javax.swing.table.DefaultTableModel;
/**
The SQLQueryTablePane class represents a panel which allows a
user to select the tables used to build an SQL query.
This panel is used for a page of the SQLQueryBuilderPane notebook.
**/
class SQLQueryTablePane
extends JComponent
implements Serializable //@B0A - for consistency
{
private static final String copyright = "Copyright (C) 1997-2000 International Business Machines Corporation and others.";
// In i5/OS language, library = schema, system = catalog.
// This class is not meant to be serialized, it should be transient.
// This class has items marked transient even though it is not
// serializable because otherwise errors were received when
// serializing objects that contained this class (even though they
// were transient instances. readObject() was added to be safe.
// The variables and methods which have private commented out
// had to be made package scope since currently Internet Explorer
// does not allow inner class to access private items in their
// containing class.
// GUI components
private JButton tableButton_ = null;
private JLabel catalog_ = null;
private transient JTable tablesTable_; //@B0C - made transient
private boolean tablesShown_ = false;
private JScrollPane tablesPane_;
/*private*/ SQLQueryClause clause_;
/*private*/ JDialog dialog_;
// Data for GUI
private String catalogName_ = "";
private DefaultTableModel tablesTableModel_;
// List of tables the user has chosen.
private String[] tables_;
/*private*/ String[] schemas_;
/*private*/ boolean userSelectTableSchemas_;
private DefaultListModel schemaListModel_;
transient private Connection connection_;
// Tracks if the user changed the clause.
/*private*/ boolean changes_ = false;
transient private DocumentListener_ docListener_;
// Event support.
transient private ErrorEventSupport errors_ = new ErrorEventSupport(this);
transient private WorkingCursorAdapter worker_ = null; // @A2
transient private WorkingEvent workEvent_ = null; //
/*private*/ SQLQueryBuilderPane parent_;
private boolean enabled_ = true; // Whether this pane is enabled
private boolean buttonEnabled_; // Whether the button is enabled
//@B0A: Has this table been init()-ed yet? (Used upon de-serialization)
private boolean inited_ = false; //@B0A
/**
Constructs a SQLQueryTablePane object.
@param parent The parent of this panel.
@param connection The SQL Connection.
@param tables The tables to initialize the clause with.
@param schemas The schemas to display the tables for.
@param userSelectTableSchemas true if the user is allowed
to change the schemas
whose tables are shown; false otherwise.
**/
public SQLQueryTablePane (SQLQueryBuilderPane parent,
Connection connection,
String[] tables,
String[] schemas,
boolean userSelectTableSchemas)
{
super();
parent_ = parent;
connection_ = connection;
tables_ = tables;
schemas_ = schemas;
userSelectTableSchemas_ = userSelectTableSchemas;
tablesTableModel_ = new DefaultTableModel(){
public boolean isCellEditable(int row, int column) {return false;}
};
addFocusListener(new SerializationListener(this)); //@B0A - for safe serialization
}
/**
Adds a listener to be notified when an error occurs.
The listener's errorOccurred method will be called.
@param listener The listener.
**/
public void addErrorListener (ErrorListener listener)
{
errors_.addErrorListener(listener);
}
/**
Parse clause to determine the tables selected.
**/
public void complete()
{
if (changes_)
{
// Parse the text area for the table names.
if (clause_ != null)
{
StringTokenizer clause = new StringTokenizer(clause_.getText(), ",");
Vector tables = new Vector();
while (clause.hasMoreTokens())
{
tables.addElement(clause.nextToken().trim());
}
String[] newTables = new String[tables.size()];
tables.copyInto(newTables);
// Determine if the tables have changed.
boolean different = false;
if (tables_.length == newTables.length)
{
for (int i=0; i < tables_.length; ++i)
{
// note even order changes are considered changes
if (!tables_[i].equals(newTables[i]))
{
different = true;
break;
}
}
}
else
different = true;
if (different)
tables_ = newTables;
}
// Listen for more changes to the tables.
changes_ = false;
}
}
/**
Set the enabled state of the button.
**/
private void enableButton(boolean enable)
{
buttonEnabled_ = enable;
if (enabled_)
tableButton_.setEnabled(enable);
}
/**
Fills the clause with the tables.
**/
private void fillClause()
{
// Add tables to the edit area.
if (clause_ != null)
{
if (tables_.length > 0)
{
StringBuffer temp = new StringBuffer(tables_[0]);
for (int i = 1; i0;)
{
tablesTableModel_.removeRow(--i);
}
tablesShown_ = false;
}
// Get catalog name.
if (connection_ != null) // if null, leave blank
{
enableButton(true);
try
{
catalog_.setText(connection_.getCatalog());
}
catch(SQLException e)
{
errors_.fireError(e);
}
}
else
enableButton(false);
}
/**
Get the list of tables.
**/
void loadTables()
{
worker_.startWorking(workEvent_); // @A2
if (!tablesShown_)
{
// Change button to function as way to change schemas.
tableButton_.setText(ResourceLoader.getQueryText("DBQUERY_BUTTON_CHANGE_SCHEMAS"));
if (userSelectTableSchemas_)
enableButton(true);
else
enableButton(false);
tablesShown_ = true;
}
// Remove any old tables.
for (int i = tablesTableModel_.getRowCount(); i>0;)
{
tablesTableModel_.removeRow(--i);
}
// Add tables to table.
String schema;
ResultSet results = null;
try
{
DatabaseMetaData meta = connection_.getMetaData();
results = meta.getTableTypes();
Vector types1 = new Vector();
while (results.next())
{
types1.addElement(results.getString(1));
}
String[] types = new String[types1.size()];
types1.copyInto(types);
for (int i=0; i 1) // if double click
{
// Get the object that was double clicked, if any.
int tablerow = table2.rowAtPoint(event.getPoint());
if (tablerow != -1) // -1 means no object under mouse
{
rowPicked(tablerow);
}
}
}
}
);
// Edit area for having clause.
clause_ = new SQLQueryClause(5);
fillClause();
// Listen for any changes to the tables.
boolean otherPanesEnabled = tables_.length==0?false:true;
boolean enableOrder = parent_.getSelectedItems().length==0?false:true;
docListener_ = new DocumentListener_(otherPanesEnabled, enableOrder);
clause_.getDocument().addDocumentListener(docListener_);
// Overall layout.
Box overallBox = Box.createVerticalBox();
overallBox.add(Box.createVerticalStrut(10));
overallBox.add(catalogBox);
overallBox.add(Box.createVerticalStrut(10));
overallBox.add(buttonBox);
overallBox.add(Box.createVerticalStrut(10));
overallBox.add(tablesPane_);
overallBox.add(Box.createVerticalStrut(10));
overallBox.add(new LabelledComponent("DBQUERY_LABEL_TABLES", new ScrollingTextPane(clause_)));
setLayout(new BorderLayout());
add("Center", overallBox);
}
/**
Builds the dialog in which the user selects the schemas for which
tables are displayed.
**/
/*private*/ void setupSchemaDialog()
{
JLabel prompt = new JLabel(ResourceLoader.getQueryText("DBQUERY_TEXT_SCHEMAS"));
JLabel prompt2 = new JLabel(ResourceLoader.getQueryText("DBQUERY_TEXT_SCHEMAS2"));
prompt.setBorder(new EmptyBorder(10,10,5,10));
prompt2.setBorder(new EmptyBorder(5,10,10,10));
JPanel promptPanel = new JPanel(new BorderLayout());
promptPanel.add("North",prompt);
promptPanel.add("South",prompt2);
promptPanel.getAccessibleContext().setAccessibleName("PROMPT"); // @A3
final JTextField entry = new JTextField(12);
schemaListModel_ = new DefaultListModel();
for (int i=0; i < schemas_.length; ++i)
{
schemaListModel_.addElement(schemas_[i]);
}
final JList schemas = new JList(schemaListModel_);
JScrollPane listScroll = new JScrollPane(schemas);
schemas.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
final DefaultListModel model = schemaListModel_;
JButton add = new JButton(ResourceLoader.getQueryText("DBQUERY_BUTTON_ADD"));
add.addActionListener(
new ActionListener(){
public void actionPerformed(ActionEvent ev)
{
String s = entry.getText();
if (!s.equals(""))
{
model.addElement(s);
entry.setText("");
}
}
} // end of ActionListenerAdapter
);
JButton remove = new JButton(ResourceLoader.getQueryText("DBQUERY_BUTTON_REMOVE"));
remove.addActionListener(
new ActionListener(){
public void actionPerformed(ActionEvent ev)
{
int[] selected = schemas.getSelectedIndices();
for (int i = selected.length; i>0;)
{
model.removeElementAt(selected[--i]);
}
}
} // end of ActionListenerAdapter
);
JButton okButton = new JButton(ResourceLoader.getQueryText("DBQUERY_BUTTON_OK"));
okButton.addActionListener(
new ActionListener(){
public void actionPerformed(ActionEvent ev)
{
Object[] items = model.toArray();
String[] libs = new String[items.length];
for (int i = 0; i < items.length; ++i)
{
libs[i] = (String)items[i];
}
schemas_ = libs;
loadTables();
// End dialog
dialog_.dispose();
}
} // end of ActionListenerAdapter
);
JButton cancelButton = new JButton(ResourceLoader.getQueryText("DBQUERY_BUTTON_CANCEL"));
cancelButton.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent ev)
{
// Set back the list for next time.
model.removeAllElements();
for (int i=0; i < schemas_.length; ++i)
{
model.addElement(schemas_[i]);
}
dialog_.dispose();
}
}
);
GridBagLayout layout = new GridBagLayout();
JPanel body = new JPanel(layout);
body.getAccessibleContext().setAccessibleName("BODY"); // @A3
GridBagConstraints constraints = new GridBagConstraints();
constraints.insets = new Insets(5,5,5,5);
VUtilities.constrain (entry, body, layout, constraints,
0, 1, 100,
0, 1, 0,
GridBagConstraints.BOTH, GridBagConstraints.CENTER);
VUtilities.constrain (add, body, layout, constraints,
1, 1, 0,
0, 1, 0,
GridBagConstraints.HORIZONTAL, GridBagConstraints.CENTER);
VUtilities.constrain (listScroll, body, layout, constraints,
0, 1, 100,
1, 1, 100,
GridBagConstraints.BOTH, GridBagConstraints.CENTER);
VUtilities.constrain (remove, body, layout, constraints,
1, 1, 0,
1, 1, 100,
GridBagConstraints.HORIZONTAL, GridBagConstraints.CENTER);
JPanel buttonPanel = new JPanel();
buttonPanel.add(okButton);
buttonPanel.add(cancelButton);
buttonPanel.getAccessibleContext().setAccessibleName("BUTTON"); // @A3
dialog_ = new JDialog(VUtilities.getFrame(this), // parent
ResourceLoader.getQueryText("DBQUERY_TITLE_SCHEMAS"), // title
true); // modal
dialog_.getContentPane().setLayout(new BorderLayout());
dialog_.getContentPane().add("North", promptPanel);
dialog_.getContentPane().add("Center", body);
dialog_.getContentPane().add("South", buttonPanel);
dialog_.addWindowListener(
new WindowAdapter() {
public void windowClosing(WindowEvent ev)
{dialog_.dispose();}
}
);
dialog_.pack();
dialog_.setLocationRelativeTo(this);
// @A3
dialog_.addFocusListener(new FocusAdapter()
{
public void focusGained(FocusEvent e)
{
// Set default focus in TextField of main body panel.
for (int index=0; index< dialog_.getContentPane().getComponentCount(); index++) {
JComponent inputPanel = (JComponent) dialog_.getContentPane().getComponent(index);
if (inputPanel.getAccessibleContext().getAccessibleName().equals("BODY")) {
// get TextField component and request focus.
for (int i=0; i © 2015 - 2025 Weber Informatics LLC | Privacy Policy