org.dlese.dpc.services.mmd

Class DbConn

java.lang.Object

org.dlese.dpc.services.mmd.DbConn

public class DbConn
extends java.lang.Object

Provides a DB Connection and some low level access methods.

Constructor Summary

Constructors

Constructor and Description
DbConn(int bugs, java.lang.String dbUrl)

Method Summary

Modifier and Type	Method and Description
void	closeDb()
static java.lang.String	dbstring(double vv)
static java.lang.String	dbstring(int vv)
static java.lang.String	dbstring(long vv)
static java.lang.String	dbstring(java.lang.String stg)
static java.lang.String	dbstring(java.sql.Timestamp ts)
static java.lang.String	dbstringcom(double vv)
static java.lang.String	dbstringcom(int vv)
static java.lang.String	dbstringcom(long vv)
static java.lang.String	dbstringcom(java.lang.String stg)
static java.lang.String	dbstringcom(java.sql.Timestamp ts)
static java.lang.String	dbstringforce(java.lang.String stg)
static java.lang.String	dbstringforcecom(java.lang.String stg)
static java.lang.String	dbstringsub(java.lang.String stg, boolean forceit) Creates a string suitable for MySQL commands, including escaped quotes and the surrounding single quotes.
java.lang.String	getDbString(java.lang.String sqlstg) Retrieves a single String from the DB.
java.lang.Object[][]	getDbTable(java.lang.String sqlstg, java.lang.String[] types, boolean allownull) Retrieves a table from the DB: each array row represents one DB row, and each array column represents a DB column.
void	updateDb(java.lang.String sqlstg) Updates the DB.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DbConn

public DbConn(int bugs,
              java.lang.String dbUrl)
       throws MmdException

Throws:

MmdException

Method Detail

closeDb

public void closeDb()
             throws MmdException

Throws:

MmdException

getDbString

public java.lang.String getDbString(java.lang.String sqlstg)
                             throws MmdException

Retrieves a single String from the DB.

Parameters:

sqlstg - The SQL string used to query the DB.

Throws:

MmdException

updateDb

public void updateDb(java.lang.String sqlstg)
              throws MmdException

Updates the DB.

Parameters:

sqlstg - The SQL string to be used.

Throws:

MmdException

getDbTable

public java.lang.Object[][] getDbTable(java.lang.String sqlstg,
                                       java.lang.String[] types,
                                       boolean allownull)
                                throws MmdException

Retrieves a table from the DB: each array row represents one DB row, and each array column represents a DB column.

Parameters:

sqlstg - The SQL string used to query the DB.

types - An array of the types of the returned columns. Valid values are:

Specified type	Returned java type
"boolean"	Boolean
"date"	Long (milliseconds since 1970)
"double"	Double
"int"	Integer
"long"	Long
"string"	String

Throws:

MmdException

dbstringcom

public static java.lang.String dbstringcom(java.sql.Timestamp ts)
                                    throws MmdException

Throws:

MmdException

dbstring

public static java.lang.String dbstring(java.sql.Timestamp ts)
                                 throws MmdException

Throws:

MmdException

dbstringcom

public static java.lang.String dbstringcom(double vv)
                                    throws MmdException

Throws:

MmdException

dbstring

public static java.lang.String dbstring(double vv)
                                 throws MmdException

Throws:

MmdException

dbstringcom

public static java.lang.String dbstringcom(int vv)
                                    throws MmdException

Throws:

MmdException

dbstring

public static java.lang.String dbstring(int vv)
                                 throws MmdException

Throws:

MmdException

dbstringcom

public static java.lang.String dbstringcom(long vv)
                                    throws MmdException

Throws:

MmdException

dbstring

public static java.lang.String dbstring(long vv)
                                 throws MmdException

Throws:

MmdException

dbstringcom

public static java.lang.String dbstringcom(java.lang.String stg)
                                    throws MmdException

Throws:

MmdException

dbstring

public static java.lang.String dbstring(java.lang.String stg)
                                 throws MmdException

Throws:

MmdException

dbstringforce

public static java.lang.String dbstringforce(java.lang.String stg)
                                      throws MmdException

Throws:

MmdException

dbstringforcecom

public static java.lang.String dbstringforcecom(java.lang.String stg)
                                         throws MmdException

Throws:

MmdException

dbstringsub

public static java.lang.String dbstringsub(java.lang.String stg,
                                           boolean forceit)
                                    throws MmdException

Creates a string suitable for MySQL commands, including escaped quotes and the surrounding single quotes. Throws MmdException if the input string contains an invalid char, unless forceit == true in which case invalid chars are ouput as format "0xabcd".

Throws:

MmdException