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 ImportMatrixFromDatabaseAction extends ObjectAction {
038            private static final long serialVersionUID = 1708309879911224591L;
039    
040            public ImportMatrixFromDatabaseAction(JComponent c, GUIObject m) {
041                    super(c, m);
042                    putValue(Action.NAME, "from Database...");
043                    putValue(Action.SHORT_DESCRIPTION,
044                                    "import a matrix from a JDBC database");
045                    putValue(Action.MNEMONIC_KEY, KeyEvent.VK_D);
046            }
047    
048            
049            public Object call() {
050                    try {
051                            DB type = DB.values()[JOptionPane.showOptionDialog(getComponent(),
052                                            "Select database type", "Import Matrix",
053                                            JOptionPane.OK_OPTION, JOptionPane.QUESTION_MESSAGE, null,
054                                            DB.values(), DB.MySQL)];
055    
056                            String host = null;
057                            while (host == null) {
058                                    host = JOptionPane.showInputDialog("Enter host name:",
059                                                    "localhost");
060                            }
061                            int port = 0;
062                            while (port <= 0) {
063                                    try {
064                                            port = Integer.parseInt(JOptionPane.showInputDialog(
065                                                            "Enter port:", "3306"));
066                                    } catch (Exception e) {
067                                    }
068                            }
069                            String database = null;
070                            while (database == null) {
071                                    database = JOptionPane.showInputDialog("Enter database name:",
072                                                    null);
073                            }
074                            String sql = null;
075                            while (sql == null) {
076                                    sql = JOptionPane.showInputDialog("Enter SQL statement:",
077                                                    "SELECT * FROM ");
078                            }
079                            String username = null;
080                            username = JOptionPane.showInputDialog("Enter user name:", "root");
081                            String password = null;
082                            password = JOptionPane.showInputDialog("Enter password:", null);
083    
084                            Matrix m = MatrixFactory.importFromJDBC(type, host, port, database,
085                                            sql, username, password);
086                            m.showGUI();
087                            return m;
088                    } catch (Exception e) {
089                            e.printStackTrace();
090                            return null;
091                    }
092            }
093    }