Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

javatools.applications.DBScriptExec
Class DBScriptExec  view DBScriptExec download DBScriptExec.java

java.lang.Object
  extended byjavatools.applications.DBScriptExec.DBScriptExec

public class DBScriptExec
extends java.lang.Object

Application to send a script to a DBMS.

Version:
0.2.0

Field Summary
private static java.lang.String[] argHelpText
           
private static javatools.util.ArgumentProcessor argset
           
private static java.lang.String BATCH_FILENAME
           
private static boolean canCreateDatabase
           
private static java.lang.String connString
           
private static java.lang.String dbAddress
           
private static java.lang.String DBADDRESS_DEFAULT
           
private static java.lang.String dbDir
           
private static java.lang.String dbms
           
private static java.lang.String DBMS_DEFAULT
           
private static java.lang.String dbName
           
private static java.lang.String DBNAME_DEFAULT
           
private static java.lang.String DBSCRIPTEXEC_VERSION
           
private static java.lang.String driver
           
private static java.lang.String DRIVER_DEFAULT
           
private static java.lang.String fileName
           
private static java.lang.String[] flagHelpText
           
private static java.lang.String[] flags
           
private static java.lang.String helpText
           
private static javatools.db.DbManager manager
           
private static java.lang.String noParamsText
           
private static java.lang.String[] parameters
           
private static java.lang.String[] paramName
           
private static java.lang.String password
           
private static java.lang.String PASSWORD_DEFAULT
           
private static boolean pathNeeded
           
private static int port
           
private static int PORT_DEFAULT
           
private static java.lang.String SCRIPT_DEFAULT
           
private static javatools.sql.ScriptExecutor sexec
           
private static java.lang.String userName
           
private static java.lang.String USERNAME_DEFAULT
           
 
Constructor Summary
DBScriptExec()
           
 
Method Summary
private static void createDatabase()
           
private static void createExecutor()
           
private static void createUserAndDatabase()
           
private static void execScript()
           
private static void getParams()
           
private static void initArgumentProcessor()
           
private static void loadScript()
           
static void main(java.lang.String[] args)
          Main method.
static void runScript()
          Runs the assigned script in a non-main session.
static void setParams(java.lang.String pDbms, java.lang.String pDbName, java.lang.String pDriver, java.lang.String pDbAddress, java.lang.String pUserName, java.lang.String pPassword, int pPort, java.lang.String pFileName)
          Sets parameters to be used in a non-main session.
static void setParams(java.lang.String pDbms, java.lang.String pDbDir, java.lang.String pDbName, java.lang.String pDriver, java.lang.String pDbAddress, java.lang.String pUserName, java.lang.String pPassword, int pPort, java.lang.String pFileName)
          Sets parameters to be used in a non-main session.
private static boolean showHelpPage()
           
private static boolean showVersion()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

DBMS_DEFAULT

private static java.lang.String DBMS_DEFAULT

DBNAME_DEFAULT

private static java.lang.String DBNAME_DEFAULT

DRIVER_DEFAULT

private static java.lang.String DRIVER_DEFAULT

DBADDRESS_DEFAULT

private static java.lang.String DBADDRESS_DEFAULT

PORT_DEFAULT

private static int PORT_DEFAULT

USERNAME_DEFAULT

private static java.lang.String USERNAME_DEFAULT

PASSWORD_DEFAULT

private static java.lang.String PASSWORD_DEFAULT

SCRIPT_DEFAULT

private static java.lang.String SCRIPT_DEFAULT

DBSCRIPTEXEC_VERSION

private static java.lang.String DBSCRIPTEXEC_VERSION

BATCH_FILENAME

private static java.lang.String BATCH_FILENAME

parameters

private static java.lang.String[] parameters

flags

private static java.lang.String[] flags

argHelpText

private static java.lang.String[] argHelpText

flagHelpText

private static java.lang.String[] flagHelpText

paramName

private static java.lang.String[] paramName

noParamsText

private static java.lang.String noParamsText

helpText

private static java.lang.String helpText

argset

private static javatools.util.ArgumentProcessor argset

sexec

private static javatools.sql.ScriptExecutor sexec

manager

private static javatools.db.DbManager manager

connString

private static java.lang.String connString

dbms

private static java.lang.String dbms

driver

private static java.lang.String driver

dbDir

private static java.lang.String dbDir

dbName

private static java.lang.String dbName

dbAddress

private static java.lang.String dbAddress

port

private static int port

userName

private static java.lang.String userName

password

private static java.lang.String password

fileName

private static java.lang.String fileName

pathNeeded

private static boolean pathNeeded

canCreateDatabase

private static boolean canCreateDatabase
Constructor Detail

DBScriptExec

public DBScriptExec()
Method Detail

main

public static void main(java.lang.String[] args)
Main method.


setParams

public static void setParams(java.lang.String pDbms,
                             java.lang.String pDbDir,
                             java.lang.String pDbName,
                             java.lang.String pDriver,
                             java.lang.String pDbAddress,
                             java.lang.String pUserName,
                             java.lang.String pPassword,
                             int pPort,
                             java.lang.String pFileName)
Sets parameters to be used in a non-main session.


setParams

public static void setParams(java.lang.String pDbms,
                             java.lang.String pDbName,
                             java.lang.String pDriver,
                             java.lang.String pDbAddress,
                             java.lang.String pUserName,
                             java.lang.String pPassword,
                             int pPort,
                             java.lang.String pFileName)
Sets parameters to be used in a non-main session.


runScript

public static void runScript()
                      throws javatools.db.DbException
Runs the assigned script in a non-main session.


initArgumentProcessor

private static void initArgumentProcessor()

showHelpPage

private static boolean showHelpPage()

showVersion

private static boolean showVersion()

getParams

private static void getParams()

createExecutor

private static void createExecutor()

createDatabase

private static void createDatabase()

createUserAndDatabase

private static void createUserAndDatabase()

loadScript

private static void loadScript()
                        throws javatools.db.DbException

execScript

private static void execScript()
                        throws javatools.db.DbException