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 }