public class FullTableCopy extends DataStruct
Copy data from one table to another
oInsertTexts, oSelectTexts
Constructor and Description |
---|
FullTableCopy() |
Modifier and Type | Method and Description |
---|---|
void |
insert(java.lang.String sOriginTable,
java.lang.String sTargetTable,
boolean bTruncate)
Copy all data from origin table to target table
|
void |
insert(java.lang.String sOriginTable,
java.lang.String sTargetTable,
java.lang.String sOriginWhere,
boolean bTruncate)
Copy some data from origin table to target table
|
characters, clear, commit, connectOrigin, connectTarget, convert, createClassSource, disconnectAll, endElement, error, fatalError, getOriginConnection, getTargetConnection, insert, mapType, parse, parse, prepareStatements, rollback, setAutoCommit, setOriginConnection, setTargetConnection, startDocument, startElement, update, warning
endDocument, endPrefixMapping, ignorableWhitespace, notationDecl, processingInstruction, resolveEntity, setDocumentLocator, skippedEntity, startPrefixMapping, unparsedEntityDecl
public void insert(java.lang.String sOriginTable, java.lang.String sTargetTable, java.lang.String sOriginWhere, boolean bTruncate) throws java.sql.SQLException, java.lang.ClassNotFoundException, java.io.IOException, java.lang.InstantiationException, java.lang.IllegalAccessException, org.xml.sax.SAXException
sOriginTable
- StringsTargetTable
- StringsOriginWhere
- String Filter clause (SQL WHERE) to be applied to origin tablebTruncate
- boolean if true Truncate target table before insertingjava.sql.SQLException
java.lang.ClassNotFoundException
java.io.IOException
java.lang.InstantiationException
java.lang.IllegalAccessException
org.xml.sax.SAXException
public void insert(java.lang.String sOriginTable, java.lang.String sTargetTable, boolean bTruncate) throws java.sql.SQLException, java.lang.ClassNotFoundException, java.io.IOException, java.lang.InstantiationException, java.lang.IllegalAccessException, org.xml.sax.SAXException
sOriginTable
- StringsTargetTable
- StringbTruncate
- boolean if true Truncate target table before insertingjava.sql.SQLException
java.lang.ClassNotFoundException
java.io.IOException
java.lang.InstantiationException
java.lang.IllegalAccessException
org.xml.sax.SAXException