Java tutorial
package net.sourceforge.squirrel_sql.client.gui.db; /* * Copyright (C) 2001-2004 Colin Bell and Johan Compagner * colbell@users.sourceforge.net * jcompagner@j-com.nl * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library 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 * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ import com.jgoodies.forms.builder.PanelBuilder; import com.jgoodies.forms.layout.CellConstraints; import com.jgoodies.forms.layout.FormLayout; import net.sourceforge.squirrel_sql.client.IApplication; import net.sourceforge.squirrel_sql.client.resources.SquirrelResources; import net.sourceforge.squirrel_sql.client.gui.IOkClosePanelListener; import net.sourceforge.squirrel_sql.client.gui.OkClosePanel; import net.sourceforge.squirrel_sql.client.gui.OkClosePanelEvent; import net.sourceforge.squirrel_sql.client.gui.desktopcontainer.DialogWidget; import net.sourceforge.squirrel_sql.client.gui.desktopcontainer.WidgetListener; import net.sourceforge.squirrel_sql.client.gui.desktopcontainer.WidgetAdapter; import net.sourceforge.squirrel_sql.client.gui.desktopcontainer.WidgetEvent; import net.sourceforge.squirrel_sql.client.mainframe.action.AliasPropertiesCommand; import net.sourceforge.squirrel_sql.fw.gui.GUIUtils; import net.sourceforge.squirrel_sql.fw.gui.StatusBar; import net.sourceforge.squirrel_sql.fw.sql.ISQLAlias; import net.sourceforge.squirrel_sql.fw.sql.ISQLDriver; import net.sourceforge.squirrel_sql.fw.sql.SQLDriverPropertyCollection; import net.sourceforge.squirrel_sql.fw.util.StringManager; import net.sourceforge.squirrel_sql.fw.util.StringManagerFactory; import net.sourceforge.squirrel_sql.fw.util.log.ILogger; import net.sourceforge.squirrel_sql.fw.util.log.LoggerController; import javax.swing.*; import javax.swing.event.InternalFrameAdapter; import javax.swing.event.InternalFrameEvent; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.KeyEvent; /** * This internal frame allows the user to connect to an alias. * * @author <A HREF="mailto:colbell@users.sourceforge.net">Colin Bell</A> */ public class ConnectionInternalFrame extends DialogWidget { /** Handler called for internal frame actions. */ public interface IHandler { /** * User has clicked the OK button to connect to the alias. * * @param connSheet The connection internal frame. * @param user The user name entered. * @param password The password entered. * @param props SQLDriverPropertyCollection to connect with. */ public void performOK(ConnectionInternalFrame connSheet, String user, String password, SQLDriverPropertyCollection props); /** * User has clicked the Close button. They don't want to * connect to the alias. * * @param connSheet The connection internal frame. */ public void performClose(ConnectionInternalFrame connSheet); /** * User has clicked the Cancel button. They want to cancel * the curently active attempt to connect to the database. * * @param connSheet The connection internal frame. */ public void performCancelConnect(ConnectionInternalFrame connSheet); } /** Internationalized strings for this class. */ private static final StringManager s_stringMgr = StringManagerFactory .getStringManager(ConnectionInternalFrame.class); /** Logger for this class. */ private static final ILogger s_log = LoggerController.createLogger(ConnectionInternalFrame.class); /** Application API. */ private IApplication _app; /** Alias we are going to connect to. */ private ISQLAlias _alias; /** JDBC driver for <TT>_alias</TT>. */ private ISQLDriver _sqlDriver; /** <TT>true</TT> means that an attempt is being made to connect to the alias.*/ private boolean _connecting; // private SQLDriverPropertyCollection _props = new SQLDriverPropertyCollection(); private IHandler _handler; private JLabel _aliasName = new JLabel(); private JLabel _driverName = new JLabel(); private JLabel _url = new JLabel(); private JTextField _user = new JTextField(); private JTextField _password = new JPasswordField(); private OkClosePanel _btnsPnl = new OkClosePanel(s_stringMgr.getString("ConnectionInternalFrame.connect")); private boolean _driverPropertiesLoaded = false; // /** If checked use the extended driver properties. */ // private final JCheckBox _useDriverPropsChk = new JCheckBox(s_stringMgr.getString("ConnectionInternalFrame.userdriverprops")); /** Button that brings up the driver properties dialog. */ private final JButton _driverPropsBtn = new JButton(s_stringMgr.getString("ConnectionInternalFrame.props")); private StatusBar _statusBar = new StatusBar(); /** * Ctor. * * @param app Application API. * @param alias <TT>SQLAlias</TT> that we are going to connect to. * @param handler Handler for internal frame actions. * * @throws IllegalArgumentException * If <TT>null</TT> <TT>IApplication</TT>, <TT>ISQLAlias</TT>, * or <TT>IConnectionInternalFrameHandler</TT> passed. */ public ConnectionInternalFrame(IApplication app, ISQLAlias alias, IHandler handler) { super("", true, app); if (app == null) { throw new IllegalArgumentException("Null IApplication passed"); } if (alias == null) { throw new IllegalArgumentException("Null ISQLAlias passed"); } if (handler == null) { throw new IllegalArgumentException("Null IConnectionInternalFrameHandler passed"); } _app = app; _alias = alias; _handler = handler; _sqlDriver = _app.getDataCache().getDriver(_alias.getDriverIdentifier()); if (_sqlDriver == null) { throw new IllegalStateException( s_stringMgr.getString("ConnectionInternalFrame.error.nodriver", _alias.getName())); } createGUI(); loadData(); pack(); } public void executed(final boolean connected) { _connecting = false; GUIUtils.processOnSwingEventThread(new Runnable() { public void run() { if (connected) { dispose(); } else { setStatusText(null); _user.setEnabled(true); _password.setEnabled(true); _btnsPnl.setExecuting(false); } } }); } /** * If the alias specifies autologon then connect after the Dialog is visible. * * @param visible If <TT>true</TT> dialog is to be made visible. */ public void setVisible(boolean visible) { super.setVisible(visible); if (visible && _alias.isAutoLogon()) { SwingUtilities.invokeLater(new Runnable() { public void run() { connect(); } }); } } /** * Set the text in the status bar. * * @param text The text to place in the status bar. */ public void setStatusText(String text) { _statusBar.setText(text); } /** * Allow base class to create rootpane and add a couple * of listeners for ENTER and ESCAPE to it. */ private void initKeyListeners() { ActionListener escapeListener = new ActionListener() { public void actionPerformed(ActionEvent actionEvent) { ConnectionInternalFrame.this.dispose(); } }; ActionListener enterListener = new ActionListener() { public void actionPerformed(ActionEvent actionEvent) { ConnectionInternalFrame.this.connect(); } }; final JRootPane pane = getRootPane(); KeyStroke ks = KeyStroke.getKeyStroke(KeyEvent.VK_ESCAPE, 0); pane.registerKeyboardAction(escapeListener, ks, JComponent.WHEN_IN_FOCUSED_WINDOW); ks = KeyStroke.getKeyStroke(KeyEvent.VK_ENTER, 0); pane.registerKeyboardAction(enterListener, ks, JComponent.WHEN_IN_FOCUSED_WINDOW); } /** * Load data about selected alias into the UI. */ private void loadData() { if (SwingUtilities.isEventDispatchThread()) { _loadData(); } else { SwingUtilities.invokeLater(new Runnable() { public void run() { _loadData(); } }); } //loadDriverProperties(); } private void _loadData() { String userName = _alias.getUserName(); String password = _alias.getPassword(); _aliasName.setText(_alias.getName()); _driverName.setText(_sqlDriver.getName()); _url.setText(_alias.getUrl()); _user.setText(userName); _password.setText(password); // _useDriverPropsChk.setSelected(_alias.getUseDriverProperties()); // _driverPropsBtn.setEnabled(_useDriverPropsChk.isSelected()); // This is mainly for long URLs that cannot be fully // displayed in the label. _aliasName.setToolTipText(_aliasName.getText()); _driverName.setToolTipText(_driverName.getText()); _url.setToolTipText(_url.getText()); } private void connect() { if (!_connecting) { _connecting = true; _btnsPnl.setExecuting(true); setStatusText(s_stringMgr.getString("ConnectionInternalFrame.connecting")); _user.setEnabled(false); _password.setEnabled(false); SQLDriverPropertyCollection driverProperties = _alias.getDriverPropertiesClone(); if (!_alias.getUseDriverProperties()) { driverProperties.clear(); } _handler.performOK(this, _user.getText(), _password.getText(), driverProperties); } } private void cancelConnect() { if (_connecting) { // abort first.. setStatusText(s_stringMgr.getString("ConnectionInternalFrame.cancelling")); _btnsPnl.enableCloseButton(false); _handler.performCancelConnect(this); _connecting = false; dispose(); } } private void createGUI() { setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE); makeToolWindow(true); final String winTitle = s_stringMgr.getString("ConnectionInternalFrame.title", _alias.getName()); setTitle(winTitle); final JPanel content = new JPanel(new BorderLayout()); content.add(createMainPanel(), BorderLayout.CENTER); content.add(_statusBar, BorderLayout.SOUTH); setContentPane(content); initKeyListeners(); } /** * Create the main panel * * @return main panel. */ private Component createMainPanel() { _user.setColumns(20); _password.setColumns(20); _driverPropsBtn.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { showDriverPropertiesDialog(); } }); _btnsPnl.addListener(new MyOkClosePanelListener()); final FormLayout layout = new FormLayout( // Columns "right:pref, 8dlu, left:min(100dlu;pref):grow", // Rows "pref, 6dlu, pref, 6dlu, pref, 6dlu, pref, 6dlu, pref, 6dlu, " + "pref, 6dlu, pref, 6dlu, pref, 3dlu, pref, 3dlu, pref"); PanelBuilder builder = new PanelBuilder(layout); CellConstraints cc = new CellConstraints(); builder.setDefaultDialogBorder(); int y = 1; builder.addSeparator(getTitle(), cc.xywh(1, y, 3, 1)); y += 2; builder.addLabel(s_stringMgr.getString("ConnectionInternalFrame.alias"), cc.xy(1, y)); builder.add(_aliasName, cc.xywh(3, y, 1, 1)); y += 2; builder.addLabel(s_stringMgr.getString("ConnectionInternalFrame.driver"), cc.xy(1, y)); builder.add(_driverName, cc.xywh(3, y, 1, 1)); y += 2; builder.addLabel(s_stringMgr.getString("ConnectionInternalFrame.url"), cc.xy(1, y)); builder.add(_url, cc.xywh(3, y, 1, 1)); y += 2; builder.addLabel(s_stringMgr.getString("ConnectionInternalFrame.user"), cc.xy(1, y)); builder.add(_user, cc.xywh(3, y, 1, 1)); y += 2; builder.addLabel(s_stringMgr.getString("ConnectionInternalFrame.password"), cc.xy(1, y)); builder.add(_password, cc.xywh(3, y, 1, 1)); y += 2; _driverPropsBtn.setIcon(_app.getResources().getIcon(SquirrelResources.IImageNames.ALIAS_PROPERTIES)); builder.add(_driverPropsBtn, cc.xywh(3, y, 1, 1)); y += 2; builder.addLabel(s_stringMgr.getString("ConnectionInternalFrame.warningcapslock"), cc.xywh(1, y, 3, 1)); y += 2; builder.addSeparator("", cc.xywh(1, y, 3, 1)); y += 2; builder.add(_btnsPnl, cc.xywh(1, y, 3, 1)); // Set focus to password control if default user name has been setup. addWidgetListener(new WidgetAdapter() { private WidgetAdapter _this; public void widgetActivated(WidgetEvent evt) { _this = this; final String userName = _user.getText(); if (userName != null && userName.length() > 0) { SwingUtilities.invokeLater(new Runnable() { public void run() { final String pw = _password.getText(); if (pw != null && pw.length() > 0) { _btnsPnl.getOKButton().requestFocus(); } else { _password.requestFocus(); } ConnectionInternalFrame.this.removeWidgetListener(_this); } }); } } }); return builder.getPanel(); } private void showDriverPropertiesDialog() { new AliasPropertiesCommand(_alias, _app).execute(); } /** * Listener to handle button events in OK/Close panel. */ private final class MyOkClosePanelListener implements IOkClosePanelListener { public void okPressed(OkClosePanelEvent evt) { ConnectionInternalFrame.this.connect(); } public void closePressed(OkClosePanelEvent evt) { ConnectionInternalFrame.this.dispose(); } public void cancelPressed(OkClosePanelEvent evt) { ConnectionInternalFrame.this.cancelConnect(); } } }