org.vivoweb.harvester.util
Class CSVtoJDBC

java.lang.Object
  org.vivoweb.harvester.util.CSVtoJDBC

public class CSVtoJDBC
extends java.lang.Object

This Class takes the data from a csv file and places it into a database

Author:

James Pence jrpence@ufl.edu

Constructor Summary

CSVtoJDBC(ArgList argList)
ArgList Constructor

CSVtoJDBC(java.lang.String[] args)
Command line Constructor

CSVtoJDBC(java.lang.String filename, java.sql.Connection output, java.lang.String tableName)
Library style Constructor

CSVtoJDBC(java.lang.String filename, java.lang.String jdbcDriverClass, java.lang.String connLine, java.lang.String username, java.lang.String password, java.lang.String tableName)
Library style Constructor

Method Summary

void	execute() Move CSV data into a recordHandler
static void	main(java.lang.String... args) Main method

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CSVtoJDBC

public CSVtoJDBC(java.lang.String filename,
                 java.sql.Connection output,
                 java.lang.String tableName)
          throws org.apache.commons.vfs.FileSystemException

Library style Constructor

Parameters:

filename - CSV to read from

output - The database connection for the output

tableName - table name into which to output

Throws:

org.apache.commons.vfs.FileSystemException - error establishing connection to file

CSVtoJDBC

public CSVtoJDBC(java.lang.String filename,
                 java.lang.String jdbcDriverClass,
                 java.lang.String connLine,
                 java.lang.String username,
                 java.lang.String password,
                 java.lang.String tableName)
          throws java.io.IOException

Library style Constructor

Parameters:

filename - CSV to read from

jdbcDriverClass - jdbc driver class

connLine - the jdbc connection line

username - username with which to connect

password - password with which to connect

tableName - table name into which to output

Throws:

java.io.IOException - error establishing connection to database or file

CSVtoJDBC

public CSVtoJDBC(java.lang.String[] args)
          throws java.io.IOException

Command line Constructor

Parameters:

args - command line arguments

Throws:

java.io.IOException - error establishing connection to database or file

CSVtoJDBC

public CSVtoJDBC(ArgList argList)
          throws java.io.IOException

ArgList Constructor

Parameters:

argList - option set of parsed args

Throws:

java.io.IOException - error establishing connection to database or file

Method Detail

execute

public void execute()
             throws java.io.IOException

Move CSV data into a recordHandler

Throws:

java.io.IOException - error reading from database or file

main

public static void main(java.lang.String... args)

Main method

Parameters:

args - commandline arguments