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 }