com.thortech.xl.util.adapters

Class tcUtilJDBCClass

java.lang.Object

com.thortech.xl.util.adapters.tcUtilJDBCClass

public class tcUtilJDBCClass
extends java.lang.Object

JDBC Utility class

Field Summary

Fields

Modifier and Type	Field and Description
static java.sql.Connection	ioCon DB Connection
static java.sql.ResultSet	ioResultSet Result Set
static java.sql.Statement	ioStatement SQL Statement
static int	mnCount Result set Count

Constructor Summary

Constructors

Constructor and Description
tcUtilJDBCClass() Creates a new tcUtilJDBCClass object.

Method Summary

Modifier and Type	Method and Description
void	close() This method closes the conenction
void	connect(java.lang.String s, java.lang.String s1, java.lang.String s2, java.lang.String s3) Creates a coonection to the Database
int	executeDeleteStatement(java.lang.String s) This method executes the Delete Statement
int	executeInsertStatement(java.lang.String s) This method executes the Insert Statement
java.util.Vector	executeSelectStatement(java.lang.String s) This method executes the Select Query
java.lang.Object[]	executeSelectStatementAll(java.lang.String s) This method executes the Select Query
int	executeUpdateStatement(java.lang.String s) This method executes the Update Statement

Methods inherited from class java.lang.Object

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

Field Detail

ioCon

public static java.sql.Connection ioCon

DB Connection

ioStatement

public static java.sql.Statement ioStatement

SQL Statement

ioResultSet

public static java.sql.ResultSet ioResultSet

Result Set

mnCount

public static int mnCount

Result set Count

Constructor Detail

tcUtilJDBCClass

public tcUtilJDBCClass()

Creates a new tcUtilJDBCClass object.

Method Detail

connect

public void connect(java.lang.String s,
                    java.lang.String s1,
                    java.lang.String s2,
                    java.lang.String s3)

Creates a coonection to the Database

Parameters:

s - JDBC Driver

s1 - jdbc URL

s2 - User Name

s3 - Password

close

public void close()

This method closes the conenction

executeSelectStatement

public java.util.Vector executeSelectStatement(java.lang.String s)

This method executes the Select Query

Parameters:

s - SQL Query

Returns:

Vector, having the result set

executeSelectStatementAll

public java.lang.Object[] executeSelectStatementAll(java.lang.String s)

This method executes the Select Query

Parameters:

s - SQL Query

Returns:

Object Array, having the result set

executeInsertStatement

public int executeInsertStatement(java.lang.String s)

This method executes the Insert Statement

Parameters:

s - SQL Query

Returns:

Number of records inserted

executeUpdateStatement

public int executeUpdateStatement(java.lang.String s)

This method executes the Update Statement

Parameters:

s - SQL Query

Returns:

Number of records updated

executeDeleteStatement

public int executeDeleteStatement(java.lang.String s)

This method executes the Delete Statement

Parameters:

s - SQL Query

Returns:

Number of records deleted