Class CSVImport

java.lang.Object
net.ontopia.topicmaps.db2tm.CSVImport

public class CSVImport extends Object
INTERNAL: Command line tool for importing comma- or semicolon separated files into a database.
  • Field Details

    • conn

      protected final Connection conn
    • table

      protected String table
    • columns

      protected String[] columns
    • quoteCharacter

      protected char quoteCharacter
    • separator

      protected char separator
    • cleartable

      protected boolean cleartable
    • stripquotes

      protected boolean stripquotes
    • ignorecolumns

      protected boolean ignorecolumns
    • ignorelines

      protected int ignorelines
  • Method Details

    • setTable

      public void setTable(String table)
    • setColumns

      public void setColumns(String[] columns)
    • setSeparator

      public void setSeparator(char separator)
    • setClearTable

      public void setClearTable(boolean cleartable)
    • setStripQuotes

      public void setStripQuotes(boolean stripquotes)
    • setIgnoreColumns

      public void setIgnoreColumns(boolean ignorecolumns)
    • setIgnoreLines

      public void setIgnoreLines(int ignorelines)
    • importCSV

      public void importCSV(InputStream csvfile) throws Exception
      Throws:
      Exception
    • usage

      protected static void usage()
    • main

      public static void main(String[] argv) throws Exception
      Throws:
      Exception