pt.moredata.xml.db
Class XMLToDBTable

java.lang.Object
  pt.moredata.xml.db.XMLToDBTable

public class XMLToDBTable

extends java.lang.Object

Author:

luism This class provides an easy way to read from a XML file a save into a database To init an DBTable Object you need to provide the XML file or a JDOM's Document

Nested Class Summary

protected class	XMLToDBTable.ConstantField
protected class	XMLToDBTable.DBField
protected class	XMLToDBTable.XMLField

Constructor Summary

XMLToDBTable(java.sql.Connection con, org.jdom.Document doc, java.lang.String tableName, java.lang.String xpath)

XMLToDBTable(java.sql.Connection con, java.lang.String fileName, java.lang.String tableName, java.lang.String xpath)

Method Summary

void	addChildTable(XMLToDBTable table)
void	addField(java.lang.String fieldName, java.lang.Class fieldType, java.lang.String refXpath)
void	addField(java.lang.String fieldName, java.lang.Class fieldType, java.lang.String pattern, java.lang.String refXpath)
void	addField(java.lang.String fieldName, java.lang.Object value)
void	addKey(java.lang.String fieldName, java.lang.Object value)
java.lang.String	createInsertStatement() Write the SQL statment to execute the insert
java.lang.String	createUpdateStatement()
XMLToDBTable	getChildTable(int idx)
java.sql.Connection	getConnection()
org.jdom.Document	getDocument()
int	getNumberOfKeys()
protected java.lang.String	getTableName()
java.lang.String	getXPath()
boolean	isGeneratedKey()
void	process() Prepares the statement
void	process(java.lang.Object context) Prepares the statement
void	setConnection(java.sql.Connection connection)
void	setDocument(org.jdom.Document document)
void	setGeneratedKey(boolean b)
protected void	setTableName(java.lang.String v)
void	setXPath(java.lang.String xpath) Sets the xpath.

Methods inherited from class java.lang.Object

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

Constructor Detail

XMLToDBTable

public XMLToDBTable(java.sql.Connection con,
                    java.lang.String fileName,
                    java.lang.String tableName,
                    java.lang.String xpath)

Parameters:

con -

fileName -

tableName -

XMLToDBTable

public XMLToDBTable(java.sql.Connection con,
                    org.jdom.Document doc,
                    java.lang.String tableName,
                    java.lang.String xpath)

Parameters:

con -

doc -

tableName -

Method Detail

getTableName

protected java.lang.String getTableName()

Returns:

setTableName

protected void setTableName(java.lang.String v)

addField

public void addField(java.lang.String fieldName,
                     java.lang.Object value)

Parameters:

fieldName -

value -

addKey

public void addKey(java.lang.String fieldName,
                   java.lang.Object value)

Parameters:

fieldName -

value -

addField

public void addField(java.lang.String fieldName,
                     java.lang.Class fieldType,
                     java.lang.String refXpath)

Parameters:

fieldName -

fieldType -

addField

public void addField(java.lang.String fieldName,
                     java.lang.Class fieldType,
                     java.lang.String pattern,
                     java.lang.String refXpath)

Parameters:

fieldName -

fieldType -

pattern -

addChildTable

public void addChildTable(XMLToDBTable table)

Parameters:

table -

getChildTable

public XMLToDBTable getChildTable(int idx)

Parameters:

idx -

Returns:

createUpdateStatement

public java.lang.String createUpdateStatement()

createInsertStatement

public java.lang.String createInsertStatement()

Write the SQL statment to execute the insert

Returns:

process

public void process()
             throws java.lang.Exception

Prepares the statement

Returns:

Throws:

java.sql.SQLException

java.lang.Exception

process

public void process(java.lang.Object context)
             throws java.lang.Exception

Prepares the statement

Returns:

Throws:

java.sql.SQLException

java.lang.Exception

getDocument

public org.jdom.Document getDocument()

Returns:

setDocument

public void setDocument(org.jdom.Document document)

Parameters:

document -

getNumberOfKeys

public int getNumberOfKeys()

Returns:

DBField

getConnection

public java.sql.Connection getConnection()

Returns:

setConnection

public void setConnection(java.sql.Connection connection)

Parameters:

connection -

getXPath

public java.lang.String getXPath()

Returns:

String

setXPath

public void setXPath(java.lang.String xpath)

Sets the xpath.

Parameters:

xpath - The xpath to set

isGeneratedKey

public boolean isGeneratedKey()

Returns:

setGeneratedKey

public void setGeneratedKey(boolean b)

Parameters:

b -