001    /*
002     * Copyright (C) 2008-2010 by Holger Arndt
003     *
004     * This file is part of the Universal Java Matrix Package (UJMP).
005     * See the NOTICE file distributed with this work for additional
006     * information regarding copyright ownership and licensing.
007     *
008     * UJMP is free software; you can redistribute it and/or modify
009     * it under the terms of the GNU Lesser General Public License as
010     * published by the Free Software Foundation; either version 2
011     * of the License, or (at your option) any later version.
012     *
013     * UJMP is distributed in the hope that it will be useful,
014     * but WITHOUT ANY WARRANTY; without even the implied warranty of
015     * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
016     * GNU Lesser General Public License for more details.
017     *
018     * You should have received a copy of the GNU Lesser General Public
019     * License along with UJMP; if not, write to the
020     * Free Software Foundation, Inc., 51 Franklin St, Fifth Floor,
021     * Boston, MA  02110-1301  USA
022     */
023    
024    package org.ujmp.gui.actions;
025    
026    import java.awt.event.KeyEvent;
027    
028    import javax.swing.Action;
029    import javax.swing.JComponent;
030    import javax.swing.JOptionPane;
031    
032    import org.ujmp.core.Matrix;
033    import org.ujmp.core.MatrixFactory;
034    import org.ujmp.core.enums.DB;
035    import org.ujmp.core.interfaces.GUIObject;
036    
037    public class LinkMatrixToDatabaseAction extends ObjectAction {
038            private static final long serialVersionUID = -8221902945958386445L;
039    
040            public LinkMatrixToDatabaseAction(JComponent c, GUIObject m) {
041                    super(c, m);
042                    putValue(Action.NAME, "to Database...");
043                    putValue(Action.SHORT_DESCRIPTION, "link a matrix to a JDBC database");
044                    putValue(Action.MNEMONIC_KEY, KeyEvent.VK_D);
045            }
046    
047            
048            public Object call() {
049                    try {
050                            DB type = DB.values()[JOptionPane.showOptionDialog(getComponent(),
051                                            "Select database type", "Link Matrix",
052                                            JOptionPane.OK_OPTION, JOptionPane.QUESTION_MESSAGE, null,
053                                            DB.values(), DB.MySQL)];
054    
055                            String host = null;
056                            while (host == null) {
057                                    host = JOptionPane.showInputDialog("Enter host name:",
058                                                    "localhost");
059                            }
060                            int port = 0;
061                            while (port <= 0) {
062                                    try {
063                                            port = Integer.parseInt(JOptionPane.showInputDialog(
064                                                            "Enter port:", "3306"));
065                                    } catch (Exception e) {
066                                    }
067                            }
068                            String database = null;
069                            while (database == null) {
070                                    database = JOptionPane.showInputDialog("Enter database name:",
071                                                    null);
072                            }
073                            String sql = null;
074                            while (sql == null) {
075                                    sql = JOptionPane.showInputDialog("Enter SQL statement:",
076                                                    "SELECT * FROM ");
077                            }
078                            String username = null;
079                            username = JOptionPane.showInputDialog("Enter user name:", "root");
080                            String password = null;
081                            password = JOptionPane.showInputDialog("Enter password:", null);
082    
083                            Matrix m = MatrixFactory.linkToJDBC(type, host, port, database,
084                                            sql, username, password);
085                            m.showGUI();
086                            return m;
087                    } catch (Exception e) {
088                            e.printStackTrace();
089                            return null;
090                    }
091            }
092    }