bradleyross.common

Class sqlHelper

java.lang.Object

bradleyross.common.sqlHelper

public class sqlHelper
extends Object

Provide a set of classes to help with the processing of SQL statements.

Author:

Bradley Ross

Field Summary

Fields

Modifier and Type	Field and Description
protected int	debugLevel Determines amount of intermediate diagnostic messages to be printed.

Constructor Summary

Constructors

Constructor and Description
sqlHelper()

Method Summary

Modifier and Type	Method and Description
void	printResultSet(ResultSet rs) Print ResultSet generated by SQL query.
void	printResultSet(ResultSet rs, OutputStream output) Print ResultSet generated by SQL query.
void	printResultSet(ResultSet rs, PrintStream output) Print ResultSet generated by SQL query.
void	setDebugLevel(int level) Set amount of diagnostic messages to be printed.

Methods inherited from class java.lang.Object

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

Field Detail

debugLevel

protected int debugLevel

Determines amount of intermediate diagnostic messages to be printed.

See the description for the setDebugLevel method for more information.

Constructor Detail

sqlHelper

public sqlHelper()

Method Detail

setDebugLevel

public void setDebugLevel(int level)

Set amount of diagnostic messages to be printed. A value of 0 indicates that no diagnostic messages are to be printed. Increased values increase the quantity of diagnostic messages.

Parameters:

level - Desired level of diagnostic messages.

printResultSet

public void printResultSet(ResultSet rs)

Print ResultSet generated by SQL query.

This version has the destination for the listing set to System.out

Parameters:

rs - ResultSet to be printed

See Also:

System

printResultSet

public void printResultSet(ResultSet rs,
                           OutputStream output)

Print ResultSet generated by SQL query.

This version uses a java.io.OutputStream so that the results can be sent to a file or some other container.

A java.io.OutputSteam object can be created using the Java statement java.io.FileOutputStream outputFile = new java.io.FileOutputStream(outputFileName); where outputFileName is a String object containing the name of the output file to be created.

Parameters:

rs - ResultSet object to be displayed

output - Destination for listing

See Also:

FileOutputStream

printResultSet

public void printResultSet(ResultSet rs,
                           PrintStream output)

Print ResultSet generated by SQL query.

The object System.out is a java.io.PrintStream object. This version of the method is therefore suitable for printing to System.out.

Parameters:

rs - ResultSet to be printed

output - Destination for listing

See Also:

System