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 }