org.relique.jdbc.csv.ZipFileTableReader Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of csvjdbc Show documentation
Show all versions of csvjdbc Show documentation
a Java JDBC driver for reading comma-separated-value files
The newest version!
/*
* CsvJdbc - a JDBC driver for CSV files
* Copyright (C) 2001 Jonathan Ackerman
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*/
package org.relique.jdbc.csv;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.Reader;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;
import java.util.List;
import java.util.Vector;
import java.util.zip.ZipEntry;
import java.util.zip.ZipFile;
import org.relique.io.TableReader;
/**
* Enables reading CSV files packed in a ZIP file as database tables.
*/
public class ZipFileTableReader implements TableReader
{
private String zipFilename;
private ZipFile zipFile;
private String fileExtension;
private String charset;
public ZipFileTableReader(String zipFilename, String charset) throws IOException
{
this.zipFilename = zipFilename;
this.zipFile = new ZipFile(zipFilename);
this.charset = charset;
}
public void setExtension(String fileExtension)
{
this.fileExtension = fileExtension;
}
public String getZipFilename()
{
return zipFilename;
}
@Override
public Reader getReader(Statement statement, String tableName) throws SQLException
{
try
{
ZipEntry zipEntry = zipFile.getEntry(tableName + fileExtension);
if (zipEntry == null)
throw new SQLException(CsvResources.getString("tableNotFound") + ": " + tableName);
Reader reader;
if (charset != null)
reader = new InputStreamReader(zipFile.getInputStream(zipEntry), charset);
else
reader = new InputStreamReader(zipFile.getInputStream(zipEntry));
return reader;
}
catch (IOException e)
{
throw new SQLException(e);
}
}
@Override
public List getTableNames(Connection connection) throws SQLException
{
Vector v = new Vector<>();
Enumeration extends ZipEntry> en = zipFile.entries();
while (en.hasMoreElements())
{
/*
* Strip file extensions.
*/
String name = ((ZipEntry)en.nextElement()).getName();
if (name.endsWith(fileExtension))
name = name.substring(0, name.length() - fileExtension.length());
v.add(name);
}
return v;
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy