Package com.thortech.xl.util.adapters

Class tcUtilJDBCClass

java.lang.Object

com.thortech.xl.util.adapters.tcUtilJDBCClass

public class tcUtilJDBCClass
extends Object

JDBC Utility class

Version:

$Revision: 1.6 $

Author:

$author$

Field Summary

Fields

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

Constructor Summary

Constructors

Constructor	Description
tcUtilJDBCClass()	Creates a new tcUtilJDBCClass object.

Method Summary

Modifier and Type	Method	Description
void	close()	This method closes the conenction
void	connect(String s, String s1, String s2, String s3)	Creates a coonection to the Database
int	executeDeleteStatement(String s)	This method executes the Delete Statement
int	executeInsertStatement(String s)	This method executes the Insert Statement
Vector	executeSelectStatement(String s)	This method executes the Select Query
Object[]	executeSelectStatementAll(String s)	This method executes the Select Query
int	executeUpdateStatement(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 Details

ioCon

public static Connection ioCon

DB Connection

ioStatement

public static Statement ioStatement

SQL Statement

ioResultSet

public static ResultSet ioResultSet

Result Set

mnCount

public static int mnCount

Result set Count

Constructor Details

tcUtilJDBCClass

public tcUtilJDBCClass()

Creates a new tcUtilJDBCClass object.

Method Details

connect

public void connect(String s,
 String s1,
 String s2,
 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 Vector executeSelectStatement(String s)

This method executes the Select Query

Parameters:

s - SQL Query

Returns:

Vector, having the result set

executeSelectStatementAll

public Object[] executeSelectStatementAll(String s)

This method executes the Select Query

Parameters:

s - SQL Query

Returns:

Object Array, having the result set

executeInsertStatement

public int executeInsertStatement(String s)

This method executes the Insert Statement

Parameters:

s - SQL Query

Returns:

Number of records inserted

executeUpdateStatement

public int executeUpdateStatement(String s)

This method executes the Update Statement

Parameters:

s - SQL Query

Returns:

Number of records updated

executeDeleteStatement

public int executeDeleteStatement(String s)

This method executes the Delete Statement

Parameters:

s - SQL Query

Returns:

Number of records deleted