Package net.ontopia.topicmaps.db2tm

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 Summary

Fields

Modifier and Type	Field	Description
protected boolean	cleartable
protected String[]	columns
protected Connection	conn
protected boolean	ignorecolumns
protected int	ignorelines
protected char	quoteCharacter
protected char	separator
protected boolean	stripquotes
protected String	table

Method Summary

Modifier and Type	Method	Description
void	importCSV(InputStream csvfile)
static void	main(String[] argv)
void	setClearTable(boolean cleartable)
void	setColumns(String[] columns)
void	setIgnoreColumns(boolean ignorecolumns)
void	setIgnoreLines(int ignorelines)
void	setSeparator(char separator)
void	setStripQuotes(boolean stripquotes)
void	setTable(String table)
protected static void	usage()

Methods inherited from class java.lang.Object

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

Field Detail

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 Detail

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