Package ch.pschatzmann.edgar.dataload

Class TableFactory

java.lang.Object

ch.pschatzmann.edgar.dataload.TableFactory

public class TableFactory
extends java.lang.Object

Basic SQL functionality

Author:

pschatzmann

Constructor Summary

Constructors

Constructor	Description
TableFactory()

Method Summary

Modifier and Type	Method	Description
void	addIndex(java.lang.String tableName, java.lang.String index)
void	addRecord(java.lang.String tableName, java.util.List<java.lang.String> attributes, java.util.Map<java.lang.String,java.lang.String> record)
void	addRecord(java.lang.String tableName, java.util.List<java.lang.String> attributes, java.util.Map<java.lang.String,java.lang.String> record, java.lang.String constraint)
void	close()	Close the connection
void	close(java.lang.String table)
void	commit()
boolean	createTable(java.lang.String tableName, java.util.List<java.lang.String> attributes)	Creates a new table with the indicated fields
boolean	execute(java.lang.String sql)
java.util.Collection<java.lang.String>	getList(java.lang.String sql)
java.sql.ResultSet	getResultSet(java.lang.String sql)
java.util.Map<java.lang.String,java.lang.String>	getTypeMap()
boolean	hasNext(java.lang.String sql, boolean defaultValue)
void	openConnection()
void	openConnection(boolean autoCommit)
void	putType(java.lang.String attribute, java.lang.String type)	Provides the possibility to define the type for each attriute
void	rollback()
void	updateCompany(java.util.List<java.lang.String> companyFields, java.util.Map<java.lang.String,java.lang.String> attributes)

Methods inherited from class java.lang.Object

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

Constructor Detail

TableFactory

public TableFactory()

Method Detail

createTable

public boolean createTable(java.lang.String tableName,
                           java.util.List<java.lang.String> attributes)
                    throws java.sql.SQLException

Creates a new table with the indicated fields

Parameters:

tableName -

attributes -

Returns:

Throws:

java.sql.SQLException

openConnection

public void openConnection()
                    throws java.sql.SQLException,
                           java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

openConnection

public void openConnection(boolean autoCommit)
                    throws java.sql.SQLException,
                           java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

execute

public boolean execute(java.lang.String sql)

hasNext

public boolean hasNext(java.lang.String sql,
                       boolean defaultValue)

getList

public java.util.Collection<java.lang.String> getList(java.lang.String sql)
                                               throws java.sql.SQLException,
                                                      java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

getResultSet

public java.sql.ResultSet getResultSet(java.lang.String sql)
                                throws java.lang.ClassNotFoundException,
                                       java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

addRecord

public void addRecord(java.lang.String tableName,
                      java.util.List<java.lang.String> attributes,
                      java.util.Map<java.lang.String,java.lang.String> record)
               throws java.sql.SQLException,
                      java.text.ParseException,
                      java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.text.ParseException

java.lang.ClassNotFoundException

addRecord

public void addRecord(java.lang.String tableName,
                      java.util.List<java.lang.String> attributes,
                      java.util.Map<java.lang.String,java.lang.String> record,
                      java.lang.String constraint)
               throws java.sql.SQLException,
                      java.text.ParseException,
                      java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.text.ParseException

java.lang.ClassNotFoundException

getTypeMap

public java.util.Map<java.lang.String,java.lang.String> getTypeMap()

putType

public void putType(java.lang.String attribute,
                    java.lang.String type)

Provides the possibility to define the type for each attriute

Parameters:

attribute -

type -

close

public void close()
           throws java.sql.SQLException

Close the connection

Throws:

java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

rollback

public void rollback()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

addIndex

public void addIndex(java.lang.String tableName,
                     java.lang.String index)

close

public void close(java.lang.String table)

updateCompany

public void updateCompany(java.util.List<java.lang.String> companyFields,
                          java.util.Map<java.lang.String,java.lang.String> attributes)