pt.moredata.xml.db
Class DBSimpleTable

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

public class DBSimpleTable

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

DBSimpleTable.DBField

Constructor Summary

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

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

Method Summary

void	addField(java.lang.String fieldName, java.lang.Class fieldType, java.lang.String xpath)
void	addField(java.lang.String fieldName, java.lang.Class fieldType, java.lang.String pattern, java.lang.String xpath)
void	addField(java.lang.String fieldName, java.lang.Object value)
java.lang.String	createStatement() Write the SQL statment to execute the insert
java.sql.Connection	getConnection()
org.jdom.Document	getDocument()
protected java.lang.String	getTableName()
java.sql.PreparedStatement	prepareInsertStatement() Prepares the statement
void	setConnection(java.sql.Connection connection)
void	setDocument(org.jdom.Document document)
protected void	setTableName(java.lang.String v)

Methods inherited from class java.lang.Object

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

Constructor Detail

DBSimpleTable

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

Parameters:

con -

fileName -

tableName -

DBSimpleTable

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

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 -

addField

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

Parameters:

fieldName -

fieldType -

xpath -

addField

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

Parameters:

fieldName -

fieldType -

pattern -

xpath -

createStatement

public java.lang.String createStatement()

Write the SQL statment to execute the insert

Returns:

prepareInsertStatement

public java.sql.PreparedStatement prepareInsertStatement()
                                                  throws java.sql.SQLException

Prepares the statement

Returns:

Throws:

java.sql.SQLException

getDocument

public org.jdom.Document getDocument()

Returns:

setDocument

public void setDocument(org.jdom.Document document)

Parameters:

document -

getConnection

public java.sql.Connection getConnection()

Returns:

setConnection

public void setConnection(java.sql.Connection connection)

Parameters:

connection -