org.apache.derbyTesting.system.nstest.utils
Class DbUtil

java.lang.Object
  org.apache.derbyTesting.system.nstest.utils.DbUtil

public class DbUtil
extends java.lang.Object

DbUtil - a database utility class for all IUD and Select operations

Field Summary

static java.lang.String[]	colnames
static int	NUMTYPES
static int	TCHAR
static int	TDATE
static int	TDECIMAL
static int	TDECIMALNN
static int	TDOUBLE
static int	TFLOAT
private java.lang.String	threadName
static int	TINT
static int	TLONGINT
static int	TNUMERICLARGE
static int	TREAL
static int	TSMALLINT
static int	TTIME
static int	TTIMESTAMP
static int	TVARCHAR

Constructor Summary

DbUtil(java.lang.String thName)

Method Summary

int	add_one_row(java.sql.Connection conn, java.lang.String thread_id)
int	delete_one_row(java.sql.Connection conn, java.lang.String thread_id)
java.lang.String	getThreadName()
long	pick_one(java.sql.Connection conn, java.lang.String thread_id)
void	printException(java.lang.String where, java.lang.Exception e)
int	update_one_row(java.sql.Connection conn, java.lang.String thread_id)

Methods inherited from class java.lang.Object

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

Field Detail

threadName

private java.lang.String threadName

TCHAR

public static final int TCHAR

See Also:

Constant Field Values

TDATE

public static final int TDATE

See Also:

Constant Field Values

TDECIMAL

public static final int TDECIMAL

See Also:

Constant Field Values

TDECIMALNN

public static final int TDECIMALNN

See Also:

Constant Field Values

TDOUBLE

public static final int TDOUBLE

See Also:

Constant Field Values

TFLOAT

public static final int TFLOAT

See Also:

Constant Field Values

TINT

public static final int TINT

See Also:

Constant Field Values

TLONGINT

public static final int TLONGINT

See Also:

Constant Field Values

TNUMERICLARGE

public static final int TNUMERICLARGE

See Also:

Constant Field Values

TREAL

public static final int TREAL

See Also:

Constant Field Values

TSMALLINT

public static final int TSMALLINT

See Also:

Constant Field Values

TTIME

public static final int TTIME

See Also:

Constant Field Values

TTIMESTAMP

public static final int TTIMESTAMP

See Also:

Constant Field Values

TVARCHAR

public static final int TVARCHAR

See Also:

Constant Field Values

NUMTYPES

public static final int NUMTYPES

See Also:

Constant Field Values

colnames

public static java.lang.String[] colnames

Constructor Detail

DbUtil

public DbUtil(java.lang.String thName)

Method Detail

add_one_row

public int add_one_row(java.sql.Connection conn,
                       java.lang.String thread_id)
                throws java.lang.Exception

Throws:

java.lang.Exception

update_one_row

public int update_one_row(java.sql.Connection conn,
                          java.lang.String thread_id)
                   throws java.lang.Exception

Throws:

java.lang.Exception

delete_one_row

public int delete_one_row(java.sql.Connection conn,
                          java.lang.String thread_id)
                   throws java.lang.Exception

Throws:

java.lang.Exception

pick_one

public long pick_one(java.sql.Connection conn,
                     java.lang.String thread_id)
              throws java.lang.Exception

Throws:

java.lang.Exception

printException

public void printException(java.lang.String where,
                           java.lang.Exception e)

getThreadName

public java.lang.String getThreadName()