All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class twz1.jdbc.mysql.jdbcMysqlBase

java.lang.Object
   |
   +----twz1.jdbc.mysql.jdbcMysqlBase

public final class jdbcMysqlBase
extends Object

Variable Index

 o applet
Am I an applet?
 o BINARY_FLAG
 o BLOB_FLAG
 o cmds
Commands Hashtable
 o COM_ALTER
 o COM_COMMENT
 o COM_CONNECT
 o COM_CREATE_DB
 o COM_CREATE_T
 o COM_DEBUG
 o COM_DELETE
 o COM_DESCRIBE
 o COM_DROP
 o COM_DROP_DB
 o COM_EXPLAIN
 o COM_FIELD_LIST
 o COM_GRANT
 o COM_INIT_DB
 o COM_INSERT
 o COM_LOCK
 o COM_PROCESS_INFO
 o COM_PROCESS_KILL
 o COM_QUERY
 o COM_QUIT
 o COM_REFRESH
 o COM_REPLACE
 o COM_SELECT
 o COM_SET
 o COM_SHOW
 o COM_SHUTDOWN
 o COM_SLEEP
 o COM_STATISTICS
 o COM_UNLOCK
 o COM_UPDATE
 o debug
The debug object
 o driver
Circular reference to the driver.
 o ENUM_FLAG
 o errs
 o FIELD_TYPE_BLOB
 o FIELD_TYPE_CHAR
 o FIELD_TYPE_DATE
 o FIELD_TYPE_DATETIME
 o FIELD_TYPE_DECIMAL
 o FIELD_TYPE_DOUBLE
 o FIELD_TYPE_ENUM
 o FIELD_TYPE_FLOAT
 o FIELD_TYPE_INT24
 o FIELD_TYPE_INTERVAL
 o FIELD_TYPE_LONG
 o FIELD_TYPE_LONG_BLOB
 o FIELD_TYPE_LONGLONG
 o FIELD_TYPE_MEDIUM_BLOB
 o FIELD_TYPE_NULL
 o FIELD_TYPE_SET
 o FIELD_TYPE_SHORT
 o FIELD_TYPE_STRING
 o FIELD_TYPE_TIME
 o FIELD_TYPE_TIMESTAMP
 o FIELD_TYPE_TINY
 o FIELD_TYPE_TINY_BLOB
 o FIELD_TYPE_VAR_STRING
 o GROUP_FLAG
 o MULTIPLE_KEY_FLAG
 o mysqlDefaults
The default values for our driver.
 o NOT_NULL_FLAG
 o PART_KEY_FLAG
 o pdepth
properties depth.
 o PRI_KEY_FLAG
 o self
Reference self
 o UNIQUE_KEY_FLAG
 o UNSIGNED_FLAG
 o xoid
Discrete ojbect numbers .
 o ZEROFILL_FLAG

Constructor Index

 o jdbcMysqlBase(jdbcMysqlDriver)
Constructor for the defaults

Method Index

 o append(String)
Use properties files potentially nested to a depth of 16 by means of setting "moreProperties" in each.
 o base()
Return a reference to myself
 o boolValue(String, int, int)
Common true or false values of a string.
 o copyDefaults()
Export a copy of the defaults hashtable.
 o debugMessage(String)
 o eMessage(Exception)
Put an emessage as something quasi intelligible
 o errHandlerM(int, Exception)
 o errHandlerP(int, Exception)
 o errHandlerS(int, String)
 o errMessage(int, Exception)
 o errMessage(String)
Common error message handling with write to debug file if operative.
 o getCommand(String)
get a command value matching a string.
 o getDebug()
Return a reference to debug.
 o getDefault(String)
Return a default value for mMysql.
 o getDefaultNames()
Return an array of the names in the Defaults Hashtable.
 o getDriver()
Return the reference to our driver.
 o getLastInsertID(Statement)
Get the last_insert_ID MySQL returns from an insert.
 o getOID()
Get an object id
 o intValue(String, int, int)
Common parse of a string into an integer value.
 o isMultipleQuery(jdbcMysqlConnex)
 o setMultipleQuery(jdbcMysqlConnex, boolean)
 o setReadDump(jdbcMysqlConnex, boolean)
 o setWriteDump(jdbcMysqlConnex, boolean)

Variables

 o COM_SLEEP
 static final int COM_SLEEP
 o COM_QUIT
 static final int COM_QUIT
 o COM_INIT_DB
 static final int COM_INIT_DB
 o COM_QUERY
 static final int COM_QUERY
 o COM_FIELD_LIST
 static final int COM_FIELD_LIST
 o COM_CREATE_DB
 static final int COM_CREATE_DB
 o COM_DROP_DB
 static final int COM_DROP_DB
 o COM_REFRESH
 static final int COM_REFRESH
 o COM_SHUTDOWN
 static final int COM_SHUTDOWN
 o COM_STATISTICS
 static final int COM_STATISTICS
 o COM_PROCESS_INFO
 static final int COM_PROCESS_INFO
 o COM_CONNECT
 static final int COM_CONNECT
 o COM_PROCESS_KILL
 static final int COM_PROCESS_KILL
 o COM_DEBUG
 static final int COM_DEBUG
 o COM_INSERT
 static final int COM_INSERT
 o COM_UPDATE
 static final int COM_UPDATE
 o COM_DELETE
 static final int COM_DELETE
 o COM_CREATE_T
 static final int COM_CREATE_T
 o COM_DROP
 static final int COM_DROP
 o COM_ALTER
 static final int COM_ALTER
 o COM_LOCK
 static final int COM_LOCK
 o COM_UNLOCK
 static final int COM_UNLOCK
 o COM_SET
 static final int COM_SET
 o COM_GRANT
 static final int COM_GRANT
 o COM_REPLACE
 static final int COM_REPLACE
 o COM_COMMENT
 static final int COM_COMMENT
 o COM_SELECT
 static final int COM_SELECT
 o COM_DESCRIBE
 static final int COM_DESCRIBE
 o COM_EXPLAIN
 static final int COM_EXPLAIN
 o COM_SHOW
 static final int COM_SHOW
 o NOT_NULL_FLAG
 static final int NOT_NULL_FLAG
 o PRI_KEY_FLAG
 static final int PRI_KEY_FLAG
 o UNIQUE_KEY_FLAG
 static final int UNIQUE_KEY_FLAG
 o MULTIPLE_KEY_FLAG
 static final int MULTIPLE_KEY_FLAG
 o BLOB_FLAG
 static final int BLOB_FLAG
 o UNSIGNED_FLAG
 static final int UNSIGNED_FLAG
 o ZEROFILL_FLAG
 static final int ZEROFILL_FLAG
 o BINARY_FLAG
 static final int BINARY_FLAG
 o ENUM_FLAG
 static final int ENUM_FLAG
 o PART_KEY_FLAG
 static final int PART_KEY_FLAG
 o GROUP_FLAG
 static final int GROUP_FLAG
 o FIELD_TYPE_DECIMAL
 static final int FIELD_TYPE_DECIMAL
 o FIELD_TYPE_TINY
 static final int FIELD_TYPE_TINY
 o FIELD_TYPE_CHAR
 static final int FIELD_TYPE_CHAR
 o FIELD_TYPE_SHORT
 static final int FIELD_TYPE_SHORT
 o FIELD_TYPE_LONG
 static final int FIELD_TYPE_LONG
 o FIELD_TYPE_FLOAT
 static final int FIELD_TYPE_FLOAT
 o FIELD_TYPE_DOUBLE
 static final int FIELD_TYPE_DOUBLE
 o FIELD_TYPE_NULL
 static final int FIELD_TYPE_NULL
 o FIELD_TYPE_TIMESTAMP
 static final int FIELD_TYPE_TIMESTAMP
 o FIELD_TYPE_LONGLONG
 static final int FIELD_TYPE_LONGLONG
 o FIELD_TYPE_INT24
 static final int FIELD_TYPE_INT24
 o FIELD_TYPE_DATE
 static final int FIELD_TYPE_DATE
 o FIELD_TYPE_TIME
 static final int FIELD_TYPE_TIME
 o FIELD_TYPE_DATETIME
 static final int FIELD_TYPE_DATETIME
 o FIELD_TYPE_ENUM
 static final int FIELD_TYPE_ENUM
 o FIELD_TYPE_INTERVAL
 static final int FIELD_TYPE_INTERVAL
 o FIELD_TYPE_SET
 static final int FIELD_TYPE_SET
 o FIELD_TYPE_TINY_BLOB
 static final int FIELD_TYPE_TINY_BLOB
 o FIELD_TYPE_MEDIUM_BLOB
 static final int FIELD_TYPE_MEDIUM_BLOB
 o FIELD_TYPE_LONG_BLOB
 static final int FIELD_TYPE_LONG_BLOB
 o FIELD_TYPE_BLOB
 static final int FIELD_TYPE_BLOB
 o FIELD_TYPE_VAR_STRING
 static final int FIELD_TYPE_VAR_STRING
 o FIELD_TYPE_STRING
 static final int FIELD_TYPE_STRING
 o errs
 static final String errs[]
 o self
 private static jdbcMysqlBase self
Reference self

 o mysqlDefaults
 private static Hashtable mysqlDefaults
The default values for our driver.

 o driver
 private static jdbcMysqlDriver driver
Circular reference to the driver.

 o pdepth
 private static int pdepth
properties depth.

 o debug
 private static jdbcMysqlDebug debug
The debug object

 o cmds
 static Hashtable cmds
Commands Hashtable

 o xoid
 static int xoid
Discrete ojbect numbers .

 o applet
 boolean applet
Am I an applet?

Constructors

 o jdbcMysqlBase
 jdbcMysqlBase(jdbcMysqlDriver d)
Constructor for the defaults

Methods

 o getOID
 static int getOID()
Get an object id

 o append
 private boolean append(String fid)
Use properties files potentially nested to a depth of 16 by means of setting "moreProperties" in each.

Parameters:
fid - The file name of the properties file.
Returns:
true if no error, else false.
 o base
 static jdbcMysqlBase base()
Return a reference to myself

 o getDebug
 static jdbcMysqlDebug getDebug()
Return a reference to debug.

 o getDriver
 static jdbcMysqlDriver getDriver()
Return the reference to our driver.

 o copyDefaults
 static Hashtable copyDefaults()
Export a copy of the defaults hashtable.

 o getCommand
 static int getCommand(String s)
get a command value matching a string.

 o getDefaultNames
 public static String[] getDefaultNames()
Return an array of the names in the Defaults Hashtable.

 o getDefault
 public static String getDefault(String what)
Return a default value for mMysql.

Parameters:
what - The name of the property to return.
Returns:
The value of the property as a string.
 o setReadDump
 public static void setReadDump(jdbcMysqlConnex cx,
                                boolean v) throws SQLException
 o setWriteDump
 public static void setWriteDump(jdbcMysqlConnex cx,
                                 boolean v) throws SQLException
 o setMultipleQuery
 public static void setMultipleQuery(jdbcMysqlConnex cx,
                                     boolean v) throws SQLException
 o isMultipleQuery
 public static boolean isMultipleQuery(jdbcMysqlConnex cx) throws SQLException
 o getLastInsertID
 public static long getLastInsertID(Statement st) throws SQLException
Get the last_insert_ID MySQL returns from an insert. The result will be -1 if the last update style statement was not an insert; This result could be problematic if you actually insert a -1 in an auto_increment column.

Parameters:
st - The Statement on which the executeUpdate(insert ...) was actually run.
Throws: SQLException
if st is invalid.
 o errHandlerP
 private void errHandlerP(int n,
                          Exception e) throws SQLException
 o errHandlerS
 private void errHandlerS(int n,
                          String s) throws SQLException
 o errHandlerM
 private void errHandlerM(int n,
                          Exception e) throws SQLException
 o errMessage
 private String errMessage(int n,
                           Exception e)
 o debugMessage
 private void debugMessage(String s)
 o errMessage
 static void errMessage(String s) throws SQLException
Common error message handling with write to debug file if operative.

 o eMessage
 static String eMessage(Exception e)
Put an emessage as something quasi intelligible

Parameters:
e - Exception to show.
Returns:
string of the message.
 o boolValue
 static int boolValue(String s,
                      int nv,
                      int fv)
Common true or false values of a string.

Parameters:
s - The string whose value is returned.
nv - The value returned if the string is null.
fv - The value returned if the string fails to parse.
Returns:
1 if s evaluates true, 0 if false, nv or fv depending.
 o intValue
 static int intValue(String s,
                     int nv,
                     int fv)
Common parse of a string into an integer value.

Parameters:
s - The string of which the value is to be returned.
nv - The value to be returned if the string is null.
fv - The value to be returned if the parse fails.
Returns:
the integer value of the string or nv, or fv.

All Packages  Class Hierarchy  This Package  Previous  Next  Index