com.billpringle.utils.wrputils
Class UtilDb

java.lang.Object
  extended by com.billpringle.utils.wrputils.WrpDb
      extended by com.billpringle.utils.wrputils.UtilDb

public class UtilDb
extends WrpDb

This class provides a connection to a specific database. This class can be used to load ZipCode information from a MySQL database.

This class extends the generic class WrpDb. It is expected that clients will create their own classes in a similar way and supply the correct connection information.

Creative Commons License Creative Commons License Symbols Unless noted otherwise, all materials available for download from my site are copyrighted by Bill Pringle, and are licensed under a Creative Commons License.

Author:
Bill Pringle

Field Summary
static java.lang.String strDatabase
          Name of the database
static java.lang.String strHost
          host name of database server
static java.lang.String strPassword
          password for database
static java.lang.String strUser
          user name for database
 
Fields inherited from class com.billpringle.utils.wrputils.WrpDb
conn, MYSQL, POSTGRES, serialVersionUID, SqlQuote, SQLQUOTE_DOUBLE, SQLQUOTE_SINGLE, stmt, strConnect, strDriver
 
Constructor Summary
UtilDb()
          Default (and only) constructor.
 
Method Summary
 
Methods inherited from class com.billpringle.utils.wrputils.WrpDb
buildConnectString, close, closeConnection, executeQuery, executeUpdate, getColumn, getConnectString, getMoreResults, getMoreResults, getResultSet, getSqlQuote, openConnection, setConnectString, setDbName, setHostName, setPassword, setSqlQuote, setUserName, SqlDate, sqlSafe
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

strDatabase

public static java.lang.String strDatabase
Name of the database


strHost

public static java.lang.String strHost
host name of database server


strUser

public static java.lang.String strUser
user name for database


strPassword

public static java.lang.String strPassword
password for database

Constructor Detail

UtilDb

public UtilDb()
       throws java.lang.ClassNotFoundException,
              java.lang.IllegalAccessException,
              java.lang.InstantiationException,
              java.sql.SQLException
Default (and only) constructor. This class connects to the e-mail database, which contains zip code, e-mail, and shipper validation information for TSA Cargo Security.

Throws:
java.lang.ClassNotFoundException
java.lang.IllegalAccessException
java.lang.InstantiationException
java.sql.SQLException