com.buckosoft.util

Class BSDatabase

java.lang.Object

com.buckosoft.util.BSDatabase

public class BSDatabase
extends java.lang.Object

Author:

dick

Field Summary

Fields

Modifier and Type	Field and Description
protected org.apache.commons.logging.Log	logger

Constructor Summary

Constructors

Constructor and Description
BSDatabase() Creates a new instance of BSDatabase

Method Summary

Modifier and Type	Method and Description
boolean	closeInstance(java.sql.Connection con)
void	closeServlet(java.sql.Connection con)
boolean	initInstance(java.sql.Connection con)
java.sql.Connection	initServlet()
protected java.sql.ResultSet	localSQLQuery(java.lang.String s) Perform a query to the database
protected boolean	localSQLUpdate(java.lang.String s) execute a command to the database
void	printError(java.lang.String s) Print one line of an error
protected void	printSQLException(java.sql.SQLException ex, java.lang.String query) Print some details about the SQL exception
void	setHtmlPrintWriter(java.io.PrintWriter _out)
void	setParameters(java.lang.String _url, java.lang.String _user, java.lang.String _passwd)
void	setPrintWriter(java.io.PrintWriter _out)

Methods inherited from class java.lang.Object

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

Field Detail

logger

protected final org.apache.commons.logging.Log logger

Constructor Detail

BSDatabase

public BSDatabase()

Creates a new instance of BSDatabase

Method Detail

setParameters

public void setParameters(java.lang.String _url,
                          java.lang.String _user,
                          java.lang.String _passwd)

setPrintWriter

public void setPrintWriter(java.io.PrintWriter _out)

setHtmlPrintWriter

public void setHtmlPrintWriter(java.io.PrintWriter _out)

printError

public void printError(java.lang.String s)

Print one line of an error

initServlet

public java.sql.Connection initServlet()

initInstance

public boolean initInstance(java.sql.Connection con)

closeInstance

public boolean closeInstance(java.sql.Connection con)

closeServlet

public void closeServlet(java.sql.Connection con)

localSQLUpdate

protected boolean localSQLUpdate(java.lang.String s)

execute a command to the database

Parameters:

s - The SQL string for the update.

Returns:

success

localSQLQuery

protected java.sql.ResultSet localSQLQuery(java.lang.String s)

Perform a query to the database

Parameters:

s - The SQL Query to the database

Returns:

The ResultSet from the query

printSQLException

protected void printSQLException(java.sql.SQLException ex,
                                 java.lang.String query)

Print some details about the SQL exception

Parameters:

ex - The SQLException that was caught

query - The SQL query that generated the exception