Java tutorial
/* * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ /* * SqlViewerDialog.java * Copyright (C) 2005-2012 University of Waikato, Hamilton, New Zealand * */ package weka.gui.sql; import java.awt.BorderLayout; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import javax.swing.JButton; import javax.swing.JCheckBox; import javax.swing.JDialog; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import weka.gui.sql.event.ResultChangedEvent; import weka.gui.sql.event.ResultChangedListener; /** * A little dialog containing the SqlViewer. * * @author FracPete (fracpete at waikato dot ac dot nz) * @version $Revision$ */ public class SqlViewerDialog extends JDialog implements ResultChangedListener { /** for serialization. */ private static final long serialVersionUID = -31619864037233099L; /** the parent frame. */ protected JFrame m_Parent; /** the SQL panel. */ protected SqlViewer m_Viewer; /** the panel for the buttons. */ protected JPanel m_PanelButtons; /** the OK button. */ protected JButton m_ButtonOK = new JButton("OK"); /** the Cancel button. */ protected JButton m_ButtonCancel = new JButton("Cancel"); /** displays the current query. */ protected JLabel m_LabelQuery = new JLabel(""); /** whether to return sparse instances or not. */ protected JCheckBox m_CheckBoxSparseData = new JCheckBox("Generate sparse data"); /** the return value. */ protected int m_ReturnValue = JOptionPane.CANCEL_OPTION; /** the connect string with which the query was run. */ protected String m_URL; /** the user that was used to connect to the DB. */ protected String m_User; /** the password that was used to connect to the DB. */ protected String m_Password; /** the currently selected query. */ protected String m_Query; /** * initializes the dialog. * * @param parent the parent frame */ public SqlViewerDialog(JFrame parent) { super(parent, "SQL-Viewer", ModalityType.DOCUMENT_MODAL); m_Parent = parent; m_URL = ""; m_User = ""; m_Password = ""; m_Query = ""; createDialog(); } /** * builds the dialog and all its components. */ protected void createDialog() { JPanel panel; JPanel panel2; final SqlViewerDialog dialog; dialog = this; setLayout(new BorderLayout()); // sql panel m_Viewer = new SqlViewer(m_Parent); add(m_Viewer, BorderLayout.CENTER); panel2 = new JPanel(new BorderLayout()); add(panel2, BorderLayout.SOUTH); // Buttons panel = new JPanel(new FlowLayout(FlowLayout.RIGHT)); panel2.add(panel, BorderLayout.EAST); m_ButtonOK.setMnemonic('O'); panel.add(m_ButtonOK); m_ButtonOK.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { m_ReturnValue = JOptionPane.OK_OPTION; // remove listener, otherwise does the disposal of resultspanel // change the query again! m_Viewer.removeResultChangedListener(dialog); m_Viewer.saveSize(); dialog.dispose(); } }); m_ButtonCancel.setMnemonic('C'); panel.add(m_ButtonCancel); m_ButtonCancel.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { m_ReturnValue = JOptionPane.CANCEL_OPTION; // remove listener, otherwise does the disposal of resultspanel // change the query again! m_Viewer.removeResultChangedListener(dialog); m_Viewer.saveSize(); dialog.dispose(); } }); // the checkbox for sparse data panel = new JPanel(new FlowLayout(FlowLayout.LEFT)); panel2.add(panel, BorderLayout.WEST); panel.add(m_CheckBoxSparseData); m_CheckBoxSparseData.setMnemonic('s'); addWindowListener(new WindowAdapter() { /** * Invoked when a window is in the process of being closed. */ public void windowClosing(WindowEvent e) { m_Viewer.saveSize(); } }); // current Query panel = new JPanel(new FlowLayout(FlowLayout.CENTER)); panel2.add(panel, BorderLayout.CENTER); panel.add(m_LabelQuery); pack(); getRootPane().setDefaultButton(m_ButtonOK); setResizable(true); // listener m_Viewer.addResultChangedListener(this); } /** * displays the dialog if TRUE. * * @param b if true displaying the dialog, hiding otherwise */ public void setVisible(boolean b) { if (b) m_ReturnValue = JOptionPane.CANCEL_OPTION; super.setVisible(b); // free up memory if (b) m_Viewer.clear(); } /** * returns whether the user clicked OK (JOptionPane.OK_OPTION) or whether he * cancelled the dialog (JOptionPane.CANCEL_OPTION). * @return the return value * @see JOptionPane */ public int getReturnValue() { return m_ReturnValue; } /** * returns the chosen URL, if any. * * @return the URL */ public String getURL() { return m_URL; } /** * returns the chosen user, if any. * * @return the user */ public String getUser() { return m_User; } /** * returns the chosen password, if any. * * @return the password */ public String getPassword() { return m_Password; } /** * returns the chosen query, if any. * * @return the query */ public String getQuery() { return m_Query; } /** * Returns whether sparse data is generated. * * @return true if sparse data is to be generated */ public boolean getGenerateSparseData() { return m_CheckBoxSparseData.isSelected(); } /** * This method gets called when a query has been executed. * * @param evt the event */ public void resultChanged(ResultChangedEvent evt) { m_URL = evt.getURL(); m_User = evt.getUser(); m_Password = evt.getPassword(); m_Query = evt.getQuery(); m_LabelQuery.setText("Current query: " + m_Query); } /** * for testing only. * * @param args ignored */ public static void main(String[] args) { SqlViewerDialog dialog; dialog = new SqlViewerDialog(null); dialog.setDefaultCloseOperation(SqlViewerDialog.DISPOSE_ON_CLOSE); dialog.setVisible(true); System.out.println("ReturnValue = " + dialog.getReturnValue()); if (dialog.getReturnValue() == JOptionPane.OK_OPTION) { System.out.println("URL = " + dialog.getURL()); System.out.println("User = " + dialog.getUser()); System.out.println("Password = " + dialog.getPassword().replaceAll(".", "*")); System.out.println("Query = " + dialog.getQuery()); } } }