Project JXTA

net.jxta.impl.shell
Class MysqlDBHandler

java.lang.Object
  |
  +--java.util.Dictionary
        |
        +--java.util.Hashtable
              |
              +--java.util.Properties
                    |
                    +--net.jxta.impl.shell.MysqlDBHandler

public class MysqlDBHandler
extends java.util.Properties

See Also:
Serialized Form

Field Summary
 boolean use_c_pool
           
 
Fields inherited from class java.util.Properties
defaults
 
Constructor Summary
MysqlDBHandler()
          Constructors
MysqlDBHandler(java.lang.String propfile)
           
 
Method Summary
static void clearDebug()
           
 boolean closeAllConnections()
           
 boolean closeConnection(java.sql.Connection con)
           
 void connect()
           
 void createTable(java.sql.Connection con, java.lang.String tablename, java.lang.String fields)
           
 void dropTable(java.sql.Connection con, java.lang.String tablename)
           
 java.sql.Connection getConnection()
          getConnection handles all exceptions internally instead of throwing.
 java.lang.String getDBHost(java.lang.String dbhost)
           
 java.lang.String getDBInst(java.lang.String dbinst)
           
 java.lang.String getDBPass(java.lang.String dbpass)
           
 java.lang.String getDBPort(java.lang.String dbport)
           
 java.lang.String getDBUser(java.lang.String dbuser)
           
 void loadProperties(java.lang.String filename)
           
static void main(java.lang.String[] args)
           
 void makeSQLCommand(java.lang.String sqlcmd)
           
 void returnConnection(java.sql.Connection con)
           
 void setDBHost(java.lang.String dbhost)
           
 void setDBInst(java.lang.String dbinst)
           
 void setDBPass(java.lang.String dbpass)
           
 void setDBPort(java.lang.String dbport)
           
 void setDBProperties(java.lang.String dbhost, java.lang.String dbinst, java.lang.String dbport, java.lang.String dbuser, java.lang.String dbpasswd)
           
 void setDBUser(java.lang.String dbuser)
           
static void setDebug()
           
 void storeProperties(java.lang.String filename)
           
 void useDatabase(java.lang.String database)
           
 
Methods inherited from class java.util.Properties
getProperty, getProperty, list, list, load, propertyNames, save, setProperty, store
 
Methods inherited from class java.util.Hashtable
clear, clone, contains, containsKey, containsValue, elements, entrySet, equals, get, hashCode, isEmpty, keys, keySet, put, putAll, rehash, remove, size, toString, values
 
Methods inherited from class java.lang.Object
finalize, getClass, notify, notifyAll, wait, wait, wait
 

Field Detail

use_c_pool

public boolean use_c_pool
Constructor Detail

MysqlDBHandler

public MysqlDBHandler()
Constructors

MysqlDBHandler

public MysqlDBHandler(java.lang.String propfile)
Method Detail

connect

public void connect()

setDebug

public static void setDebug()

clearDebug

public static void clearDebug()

getConnection

public java.sql.Connection getConnection()
getConnection handles all exceptions internally instead of throwing. This should make it a bit easier to write cleaner code in the classes that invoke it. Since everything is basically going to the same oracle server, and is called by one class at a time (multipass algorithm and the Categorizer runs by itself), this should not present a big problem.

returnConnection

public void returnConnection(java.sql.Connection con)

closeAllConnections

public boolean closeAllConnections()

closeConnection

public boolean closeConnection(java.sql.Connection con)

makeSQLCommand

public void makeSQLCommand(java.lang.String sqlcmd)

createTable

public void createTable(java.sql.Connection con,
                        java.lang.String tablename,
                        java.lang.String fields)

useDatabase

public void useDatabase(java.lang.String database)

dropTable

public void dropTable(java.sql.Connection con,
                      java.lang.String tablename)

setDBProperties

public void setDBProperties(java.lang.String dbhost,
                            java.lang.String dbinst,
                            java.lang.String dbport,
                            java.lang.String dbuser,
                            java.lang.String dbpasswd)

setDBHost

public void setDBHost(java.lang.String dbhost)

setDBInst

public void setDBInst(java.lang.String dbinst)

setDBPort

public void setDBPort(java.lang.String dbport)

setDBUser

public void setDBUser(java.lang.String dbuser)

setDBPass

public void setDBPass(java.lang.String dbpass)

getDBHost

public java.lang.String getDBHost(java.lang.String dbhost)

getDBInst

public java.lang.String getDBInst(java.lang.String dbinst)

getDBPort

public java.lang.String getDBPort(java.lang.String dbport)

getDBUser

public java.lang.String getDBUser(java.lang.String dbuser)

getDBPass

public java.lang.String getDBPass(java.lang.String dbpass)

storeProperties

public void storeProperties(java.lang.String filename)

loadProperties

public void loadProperties(java.lang.String filename)

main

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

Project JXTA