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.jdbc;
025    
026    import org.ujmp.core.enums.DB;
027    import org.ujmp.core.exceptions.MatrixException;
028    
029    public class LinkMatrixJDBC {
030    
031            public static AbstractDenseJDBCMatrix2D toDatabase(String url, String sqlStatement, String username, String password)
032                            throws Exception {
033                    if (url.startsWith("jdbc:mysql://")) {
034                            return new DenseMySQLMatrix2D(url, sqlStatement, username, password);
035                    } else if (url.startsWith("jdbc:postgresql://")) {
036                            return new DensePostgreSQLMatrix2D(url, sqlStatement, username, password);
037                    } else if (url.startsWith("jdbc:derby://")) {
038                            return new DenseDerbyMatrix2D(url, sqlStatement, username, password);
039                    } else if (url.startsWith("jdbc:hsqldb://")) {
040                            return new DenseHSQLDBMatrix2D(url, sqlStatement, username, password);
041                    } else {
042                            throw new MatrixException("Database format not supported: " + url);
043                    }
044            }
045    
046            public static AbstractDenseJDBCMatrix2D toDatabase(DB type, String host, int port, String databasename,
047                            String sqlStatement, String username, String password) throws Exception {
048                    switch (type) {
049                    case MySQL:
050                            return toDatabase("jdbc:mysql://" + host + ":" + port + "/" + databasename, sqlStatement, username,
051                                            password);
052                    case PostgreSQL:
053                            return toDatabase("jdbc:postgresql://" + host + ":" + port + "/" + databasename, sqlStatement, username,
054                                            password);
055                    case Derby:
056                            return toDatabase("jdbc:derby://" + host + ":" + port + "/" + databasename, sqlStatement, username,
057                                            password);
058                    case HSQLDB:
059                            return toDatabase("jdbc:hsqldb://" + host + ":" + port + "/" + databasename, sqlStatement, username,
060                                            password);
061                    default:
062                            throw new MatrixException("Database type unknown: " + type);
063                    }
064            }
065    }