|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--org.enableit.db.DataLoader
A class to read CSV files and load data into a database.
Field Summary | |
static java.lang.String |
about
CVS info about this class and its current version |
protected static org.apache.log4j.Category |
cat
The Log4J Category doing the logging. |
private java.util.ArrayList |
columns
The columns to load into. |
private java.lang.String |
dataSourceName
The datasource name to use to get a database connection. |
private java.io.File |
file
The file to read. |
private java.lang.String |
table
The Table to load into. |
Constructor Summary | |
DataLoader()
Default Constructor |
|
DataLoader(java.lang.String file)
Constructor setting mandatory properties. |
Method Summary | |
void |
execute()
Do the load. |
static void |
main(java.lang.String[] args)
Used as a simple test of the class. |
private void |
process(java.lang.String line)
Processes a data line. |
private void |
processComment(java.lang.String line)
Processes a comment line, looking for meta data. |
void |
setColumnDatatypes(java.lang.String datatypes)
Set the datatypes of the columns to be inserted into. |
void |
setColumnNames(java.lang.String columns)
Set the names of columns to be inserted into. |
void |
setDataSourceName(java.lang.String dataSourceName)
Set the datasource name to get connections from. |
void |
setFile(java.io.File file)
Set the file to be loaded. |
void |
setFile(java.lang.String file)
Set the file to be loaded. |
void |
setTable(java.lang.String table)
Set the file to be loaded. |
Methods inherited from class java.lang.Object |
|
Field Detail |
protected static org.apache.log4j.Category cat
Category
doing the logging.
Same Category
is used throughout the package.private java.io.File file
private java.lang.String table
private java.util.ArrayList columns
private java.lang.String dataSourceName
public static final java.lang.String about
Constructor Detail |
public DataLoader()
public DataLoader(java.lang.String file)
Method Detail |
public void setFile(java.io.File file)
public void setFile(java.lang.String file)
public void setTable(java.lang.String table)
public void setColumnNames(java.lang.String columns)
columns
- as a comma separated list.public void setColumnDatatypes(java.lang.String datatypes)
columns
- as a comma separated list.public void setDataSourceName(java.lang.String dataSourceName)
public void execute() throws java.io.IOException, java.sql.SQLException
private void processComment(java.lang.String line)
private void process(java.lang.String line)
public static void main(java.lang.String[] args)
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |