public class DBSelect extends AbstractDBTool
Examples for usage (-credfile option must always be present):
-sql "select * from course where course_id = 1"
-sql "select * from trainer" -outfile C:/temp/out.unl -delim ";"
-script C:/databases/traindb/sql/querytest.sql -skiperrors -header
DBExecute
Constructor and Description |
---|
DBSelect(Credential cred) |
Modifier and Type | Method and Description |
---|---|
de.esprit.appsuite.database.dbase.tools.DBSelect.MyDBSelectCLP |
getDBToolCLP() |
protected java.lang.String |
getDelimiter() |
protected java.io.PrintStream |
getPrintStream() |
protected boolean |
hasHeader() |
static void |
main(java.lang.String[] args) |
protected void |
performDatabaseOperation(java.sql.Connection dbConn) |
void |
setArgDelimiter(java.lang.String argDelim) |
void |
setArgHeader(boolean argHeader) |
void |
setArgOutputFile(java.io.File argOutFile) |
void |
setArgScriptFile(java.io.File argScriptFile) |
void |
setArgSelectStatement(java.lang.String argSelectStmt) |
execute, executeCommand, executeCommandScript, executeQuery, executeQueryScript, isSkipErrors, setArgSkipErrors
getApplicationContext, getLogChannel, isLogDebug, isLogVerbose, logDebug, logDump, logError, logError, logFatal, logInfo, logVerbose, logWarning, setLogChannel
configureDumpHeadlineLength, configureDumpMaxElementsPrinted, copyDumpStringValues, copyToStringValues, createDumpHeader, toDumpString, toDumpString, toString, toString
public DBSelect(Credential cred)
public void setArgDelimiter(java.lang.String argDelim)
public void setArgHeader(boolean argHeader)
public void setArgOutputFile(java.io.File argOutFile)
public void setArgScriptFile(java.io.File argScriptFile)
public void setArgSelectStatement(java.lang.String argSelectStmt)
protected void performDatabaseOperation(java.sql.Connection dbConn) throws java.lang.Exception
performDatabaseOperation
in class AbstractDBTool
java.lang.Exception
public de.esprit.appsuite.database.dbase.tools.DBSelect.MyDBSelectCLP getDBToolCLP()
getDBToolCLP
in class AbstractDBTool
protected java.lang.String getDelimiter()
getDelimiter
in class AbstractDBTool
protected boolean hasHeader()
hasHeader
in class AbstractDBTool
protected java.io.PrintStream getPrintStream() throws java.lang.Exception
getPrintStream
in class AbstractDBTool
java.lang.Exception
public static void main(java.lang.String[] args) throws java.lang.Exception
java.lang.Exception
Copyright © 2014 EsprIT-Systems. All Rights Reserved.