Copyright 2009,2010, Lapetus Systems Ltd. (All rights reserved)

com.lapetus_ltd._2009.xml.types
Class XLptsDBStatementType

java.lang.Object
  extended by com.lapetus_ltd._2009.xml.types.XLptsDBStatementType
Direct Known Subclasses:
TLptsStatement

public class XLptsDBStatementType
extends java.lang.Object

XSD Generated Class: This class is utilised by TLptsStatement, which inherits the Java Statement, to create SQL statements. This object holds an extensive amount of data about the tables, columns and parameters of the SQL. The columns and tables in this structure are set to SELECT when required by the SQL statement and then the TLptsStatement class generates the SQL statement with the correct formatting for the relative database (quotations). See TLptsStatement for more information (link above).

Java class for XLptsDBStatementType complex type.

The following schema fragment specifies the expected content contained within this class.

 <complexType name="XLptsDBStatementType">
   <complexContent>
     <restriction base="{http://www.w3.org/2001/XMLSchema}anyType">
       <sequence>
         <element name="title" type="{http://www.w3.org/2001/XMLSchema}string"/>
         <element name="connectionId" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsIdentifierType"/>
         <element name="sqlStatementUnformatted" type="{http://www.w3.org/2001/XMLSchema}string"/>
         <element name="sqlStatementExtension" type="{http://www.w3.org/2001/XMLSchema}string"/>
         <element name="sqlStatementUser" type="{http://www.w3.org/2001/XMLSchema}string"/>
         <element name="sqlStatementModified" type="{http://www.w3.org/2001/XMLSchema}boolean"/>
         <element name="charset" type="{http://www.w3.org/2001/XMLSchema}string"/>
         <element name="tableTypesView" type="{http://www.w3.org/2001/XMLSchema}int"/>
         <element name="xResultSetType" type="{http://www.w3.org/2001/XMLSchema}int"/>
         <element name="xResultSetConcurrency" type="{http://www.w3.org/2001/XMLSchema}int"/>
         <element name="sqlStringFormat" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBSqlStringFormatType"/>
         <element name="sqlDatabaseFormat" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBSqlDatabaseFormat"/>
         <element name="criteriaType" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBStatementCriteriaType"/>
         <element name="tableListItem" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBStatementTableType" maxOccurs="unbounded" minOccurs="0"/>
         <element name="columnListItem" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBStatementColumnType" maxOccurs="unbounded" minOccurs="0"/>
         <element name="createRootItem" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBCreateStatementRootType"/>
         <element name="upInsDelListItem" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBUpInsDelType" maxOccurs="unbounded" minOccurs="0"/>
         <element name="typeOfStatement" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsDBTypeOfStatementType"/>
         <element name="executable" type="{http://www.w3.org/2001/XMLSchema}boolean"/>
       </sequence>
       <attribute name="id" use="required" type="{http://www.lapetus-ltd.com/2009/xml/types}XLptsIdentifierType" />
       <attribute name="version" use="required" type="{http://www.w3.org/2001/XMLSchema}string" />
       <attribute name="visible" use="required" type="{http://www.w3.org/2001/XMLSchema}boolean" />
     </restriction>
   </complexContent>
 </complexType>
 


Field Summary
protected  java.lang.String charset
           
protected  java.util.List<XLptsDBStatementColumnType> columnListItem
           
protected  java.lang.String connectionId
           
protected  XLptsDBCreateStatementRootType createRootItem
           
protected  XLptsDBStatementCriteriaType criteriaType
           
protected  boolean executable
           
protected  java.lang.String id
           
protected  XLptsDBSqlDatabaseFormat sqlDatabaseFormat
           
protected  java.lang.String sqlStatementExtension
           
protected  boolean sqlStatementModified
           
protected  java.lang.String sqlStatementUnformatted
           
protected  java.lang.String sqlStatementUser
           
protected  XLptsDBSqlStringFormatType sqlStringFormat
           
protected  java.util.List<XLptsDBStatementTableType> tableListItem
           
protected  int tableTypesView
           
protected  java.lang.String title
           
protected  XLptsDBTypeOfStatementType typeOfStatement
           
protected  java.util.List<XLptsDBUpInsDelType> upInsDelListItem
           
protected  java.lang.String version
           
protected  boolean visible
           
protected  int xResultSetConcurrency
           
protected  int xResultSetType
           
 
Constructor Summary
XLptsDBStatementType()
           
 
Method Summary
 java.lang.String getCharset()
          Gets the value of the charset property.
 java.util.List<XLptsDBStatementColumnType> getColumnListItem()
          Gets the value of the columnListItem property.
 java.lang.String getConnectionId()
          Gets the value of the connectionId property.
 XLptsDBCreateStatementRootType getCreateRootItem()
          Gets the value of the createRootItem property.
 XLptsDBStatementCriteriaType getCriteriaType()
          Gets the value of the criteriaType property.
 java.lang.String getId()
          Gets the value of the id property.
 XLptsDBSqlDatabaseFormat getSqlDatabaseFormat()
          Gets the value of the sqlDatabaseFormat property.
 java.lang.String getSqlStatementExtension()
          Gets the value of the sqlStatementExtension property.
 java.lang.String getSqlStatementUnformatted()
          Gets the value of the sqlStatementUnformatted property.
 java.lang.String getSqlStatementUser()
          Gets the value of the sqlStatementUser property.
 XLptsDBSqlStringFormatType getSqlStringFormat()
          Gets the value of the sqlStringFormat property.
 java.util.List<XLptsDBStatementTableType> getTableListItem()
          Gets the value of the tableListItem property.
 int getTableTypesView()
          Gets the value of the tableTypesView property.
 java.lang.String getTitle()
          Gets the value of the title property.
 XLptsDBTypeOfStatementType getTypeOfStatement()
          Gets the value of the typeOfStatement property.
 java.util.List<XLptsDBUpInsDelType> getUpInsDelListItem()
          Gets the value of the upInsDelListItem property.
 java.lang.String getVersion()
          Gets the value of the version property.
 int getXResultSetConcurrency()
          Gets the value of the xResultSetConcurrency property.
 int getXResultSetType()
          Gets the value of the xResultSetType property.
 boolean isExecutable()
          Gets the value of the executable property.
 boolean isSqlStatementModified()
          Gets the value of the sqlStatementModified property.
 boolean isVisible()
          Gets the value of the visible property.
 void setCharset(java.lang.String value)
          Sets the value of the charset property.
 void setConnectionId(java.lang.String value)
          Sets the value of the connectionId property.
 void setCreateRootItem(XLptsDBCreateStatementRootType value)
          Sets the value of the createRootItem property.
 void setCriteriaType(XLptsDBStatementCriteriaType value)
          Sets the value of the criteriaType property.
 void setExecutable(boolean value)
          Sets the value of the executable property.
 void setId(java.lang.String value)
          Sets the value of the id property.
 void setSqlDatabaseFormat(XLptsDBSqlDatabaseFormat value)
          Sets the value of the sqlDatabaseFormat property.
 void setSqlStatementExtension(java.lang.String value)
          Sets the value of the sqlStatementExtension property.
 void setSqlStatementModified(boolean value)
          Sets the value of the sqlStatementModified property.
 void setSqlStatementUnformatted(java.lang.String value)
          Sets the value of the sqlStatementUnformatted property.
 void setSqlStatementUser(java.lang.String value)
          Sets the value of the sqlStatementUser property.
 void setSqlStringFormat(XLptsDBSqlStringFormatType value)
          Sets the value of the sqlStringFormat property.
 void setTableTypesView(int value)
          Sets the value of the tableTypesView property.
 void setTitle(java.lang.String value)
          Sets the value of the title property.
 void setTypeOfStatement(XLptsDBTypeOfStatementType value)
          Sets the value of the typeOfStatement property.
 void setVersion(java.lang.String value)
          Sets the value of the version property.
 void setVisible(boolean value)
          Sets the value of the visible property.
 void setXResultSetConcurrency(int value)
          Sets the value of the xResultSetConcurrency property.
 void setXResultSetType(int value)
          Sets the value of the xResultSetType property.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

charset

protected java.lang.String charset

columnListItem

protected java.util.List<XLptsDBStatementColumnType> columnListItem

connectionId

protected java.lang.String connectionId

createRootItem

protected XLptsDBCreateStatementRootType createRootItem

criteriaType

protected XLptsDBStatementCriteriaType criteriaType

executable

protected boolean executable

id

protected java.lang.String id

sqlDatabaseFormat

protected XLptsDBSqlDatabaseFormat sqlDatabaseFormat

sqlStatementExtension

protected java.lang.String sqlStatementExtension

sqlStatementModified

protected boolean sqlStatementModified

sqlStatementUnformatted

protected java.lang.String sqlStatementUnformatted

sqlStatementUser

protected java.lang.String sqlStatementUser

sqlStringFormat

protected XLptsDBSqlStringFormatType sqlStringFormat

tableListItem

protected java.util.List<XLptsDBStatementTableType> tableListItem

tableTypesView

protected int tableTypesView

title

protected java.lang.String title

typeOfStatement

protected XLptsDBTypeOfStatementType typeOfStatement

upInsDelListItem

protected java.util.List<XLptsDBUpInsDelType> upInsDelListItem

version

protected java.lang.String version

visible

protected boolean visible

xResultSetConcurrency

protected int xResultSetConcurrency

xResultSetType

protected int xResultSetType
Constructor Detail

XLptsDBStatementType

public XLptsDBStatementType()
Method Detail

getCharset

public java.lang.String getCharset()
Gets the value of the charset property.

Returns:
possible object is String

getColumnListItem

public java.util.List<XLptsDBStatementColumnType> getColumnListItem()
Gets the value of the columnListItem property.

This accessor method returns a reference to the live list, not a snapshot. Therefore any modification you make to the returned list will be present inside the JAXB object. This is why there is not a set method for the columnListItem property.

For example, to add a new item, do as follows:

    getColumnListItem().add(newItem);
 

Objects of the following type(s) are allowed in the list XLptsDBStatementColumnType


getConnectionId

public java.lang.String getConnectionId()
Gets the value of the connectionId property.

Returns:
possible object is String

getCreateRootItem

public XLptsDBCreateStatementRootType getCreateRootItem()
Gets the value of the createRootItem property.

Returns:
possible object is XLptsDBCreateStatementRootType

getCriteriaType

public XLptsDBStatementCriteriaType getCriteriaType()
Gets the value of the criteriaType property.

Returns:
possible object is XLptsDBStatementCriteriaType

getId

public java.lang.String getId()
Gets the value of the id property.

Returns:
possible object is String

getSqlDatabaseFormat

public XLptsDBSqlDatabaseFormat getSqlDatabaseFormat()
Gets the value of the sqlDatabaseFormat property.

Returns:
possible object is XLptsDBSqlDatabaseFormat

getSqlStatementExtension

public java.lang.String getSqlStatementExtension()
Gets the value of the sqlStatementExtension property.

Returns:
possible object is String

getSqlStatementUnformatted

public java.lang.String getSqlStatementUnformatted()
Gets the value of the sqlStatementUnformatted property.

Returns:
possible object is String

getSqlStatementUser

public java.lang.String getSqlStatementUser()
Gets the value of the sqlStatementUser property.

Returns:
possible object is String

getSqlStringFormat

public XLptsDBSqlStringFormatType getSqlStringFormat()
Gets the value of the sqlStringFormat property.

Returns:
possible object is XLptsDBSqlStringFormatType

getTableListItem

public java.util.List<XLptsDBStatementTableType> getTableListItem()
Gets the value of the tableListItem property.

This accessor method returns a reference to the live list, not a snapshot. Therefore any modification you make to the returned list will be present inside the JAXB object. This is why there is not a set method for the tableListItem property.

For example, to add a new item, do as follows:

    getTableListItem().add(newItem);
 

Objects of the following type(s) are allowed in the list XLptsDBStatementTableType


getTableTypesView

public int getTableTypesView()
Gets the value of the tableTypesView property.


getTitle

public java.lang.String getTitle()
Gets the value of the title property.

Returns:
possible object is String

getTypeOfStatement

public XLptsDBTypeOfStatementType getTypeOfStatement()
Gets the value of the typeOfStatement property.

Returns:
possible object is XLptsDBTypeOfStatementType

getUpInsDelListItem

public java.util.List<XLptsDBUpInsDelType> getUpInsDelListItem()
Gets the value of the upInsDelListItem property.

This accessor method returns a reference to the live list, not a snapshot. Therefore any modification you make to the returned list will be present inside the JAXB object. This is why there is not a set method for the upInsDelListItem property.

For example, to add a new item, do as follows:

    getUpInsDelListItem().add(newItem);
 

Objects of the following type(s) are allowed in the list XLptsDBUpInsDelType


getVersion

public java.lang.String getVersion()
Gets the value of the version property.

Returns:
possible object is String

getXResultSetConcurrency

public int getXResultSetConcurrency()
Gets the value of the xResultSetConcurrency property.


getXResultSetType

public int getXResultSetType()
Gets the value of the xResultSetType property.


isExecutable

public boolean isExecutable()
Gets the value of the executable property.


isSqlStatementModified

public boolean isSqlStatementModified()
Gets the value of the sqlStatementModified property.


isVisible

public boolean isVisible()
Gets the value of the visible property.


setCharset

public void setCharset(java.lang.String value)
Sets the value of the charset property.

Parameters:
value - allowed object is String

setConnectionId

public void setConnectionId(java.lang.String value)
Sets the value of the connectionId property.

Parameters:
value - allowed object is String

setCreateRootItem

public void setCreateRootItem(XLptsDBCreateStatementRootType value)
Sets the value of the createRootItem property.

Parameters:
value - allowed object is XLptsDBCreateStatementRootType

setCriteriaType

public void setCriteriaType(XLptsDBStatementCriteriaType value)
Sets the value of the criteriaType property.

Parameters:
value - allowed object is XLptsDBStatementCriteriaType

setExecutable

public void setExecutable(boolean value)
Sets the value of the executable property.


setId

public void setId(java.lang.String value)
Sets the value of the id property.

Parameters:
value - allowed object is String

setSqlDatabaseFormat

public void setSqlDatabaseFormat(XLptsDBSqlDatabaseFormat value)
Sets the value of the sqlDatabaseFormat property.

Parameters:
value - allowed object is XLptsDBSqlDatabaseFormat

setSqlStatementExtension

public void setSqlStatementExtension(java.lang.String value)
Sets the value of the sqlStatementExtension property.

Parameters:
value - allowed object is String

setSqlStatementModified

public void setSqlStatementModified(boolean value)
Sets the value of the sqlStatementModified property.


setSqlStatementUnformatted

public void setSqlStatementUnformatted(java.lang.String value)
Sets the value of the sqlStatementUnformatted property.

Parameters:
value - allowed object is String

setSqlStatementUser

public void setSqlStatementUser(java.lang.String value)
Sets the value of the sqlStatementUser property.

Parameters:
value - allowed object is String

setSqlStringFormat

public void setSqlStringFormat(XLptsDBSqlStringFormatType value)
Sets the value of the sqlStringFormat property.

Parameters:
value - allowed object is XLptsDBSqlStringFormatType

setTableTypesView

public void setTableTypesView(int value)
Sets the value of the tableTypesView property.


setTitle

public void setTitle(java.lang.String value)
Sets the value of the title property.

Parameters:
value - allowed object is String

setTypeOfStatement

public void setTypeOfStatement(XLptsDBTypeOfStatementType value)
Sets the value of the typeOfStatement property.

Parameters:
value - allowed object is XLptsDBTypeOfStatementType

setVersion

public void setVersion(java.lang.String value)
Sets the value of the version property.

Parameters:
value - allowed object is String

setVisible

public void setVisible(boolean value)
Sets the value of the visible property.


setXResultSetConcurrency

public void setXResultSetConcurrency(int value)
Sets the value of the xResultSetConcurrency property.


setXResultSetType

public void setXResultSetType(int value)
Sets the value of the xResultSetType property.



Copyright 2009,2010, Lapetus Systems Ltd. (All rights reserved)