A

B

backgroundColor. Variable in class swosnick.database.servlets.SQLGatewayServlet

Background color constant for control of background.

C

checkForWarning(SQLWarning). Static method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

connection. Variable in class swosnick.database.servlets.SQLGatewayServlet

The database connection.

connectionInfo(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

connectToDatabase(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

D

destroy(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

driver. Variable in class swosnick.database.servlets.SQLGatewayServlet

The JDBC Driver.

E

executeTheQuery(String). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

executeTheUpdate(String). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

F

G

getRequestParameters(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

getServletInfo(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

getSQLOperation(String). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

H

I

init(ServletConfig). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

INSERT_UPDATE_DELETE. Variable in class swosnick.database.servlets.SQLGatewayServlet

Constant representing an update, delete or insert operation and will use executeUpdate.

isDEBUGON. Variable in class swosnick.database.servlets.SQLGatewayServlet

DEBUG flag - when true, tracing will be enabled, when false, tracing will be disabled and in addition, the compiler is smart enough to remove blocks it knows can never be reached, so the debugging code in effect is never compiled into the executable, with no overhead.

isExecuteUpdateSuccess. Variable in class swosnick.database.servlets.SQLGatewayServlet

On an executeUpdate operation was it successful - returned rows? Used internally only.

isLoggedOn. Variable in class swosnick.database.servlets.SQLGatewayServlet

If the user is logged on in appropriately, set to true, else remain false.

isSQLExceptionOccurred. Variable in class swosnick.database.servlets.SQLGatewayServlet

Did an exception occur on an SQL action? Used internally only.

J

JDBCDrivers. Variable in class swosnick.database.servlets.SQLGatewayServlet

The list of supported JDBC drivers which will appear in the logon form as a choice.

K

L

lastSQL. Variable in class swosnick.database.servlets.SQLGatewayServlet

Track the last SQL query or command so that the user need not re-enter it.

logonFormHeading. Variable in class swosnick.database.servlets.SQLGatewayServlet

The heading or description for the logon form.

logonFormTitle. Variable in class swosnick.database.servlets.SQLGatewayServlet

The title which is sent to the browser for the initial logon form.

M

N

NO_OPERATION. Variable in class swosnick.database.servlets.SQLGatewayServlet

Constant representing neither a query or an update, indicating an error retrieving the type of operation.

O

outResultSet(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

outstream. Variable in class swosnick.database.servlets.SQLGatewayServlet

The output stream used for HTTP output to create dynamic HTML page.

outUpdateStatus(boolean). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

P

password. Variable in class swosnick.database.servlets.SQLGatewayServlet

The optional password.

processSQLException(SQLException). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

properties. Variable in class swosnick.database.servlets.SQLGatewayServlet

Properties object used to contain username and password to make the database connection.

Q

R

request. Variable in class swosnick.database.servlets.SQLGatewayServlet

The request sent to the servlet.

response. Variable in class swosnick.database.servlets.SQLGatewayServlet

The response prepared by the servlet.

resultSet. Variable in class swosnick.database.servlets.SQLGatewayServlet

Result set for a given query.

S

SELECT. Variable in class swosnick.database.servlets.SQLGatewayServlet

Constant used to represent the SELECT operation which will use executeQuery.

sendHTMLLogonForm(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

sendSQLForm(). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

service(HttpServletRequest, HttpServletResponse). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

servletName. Variable in class swosnick.database.servlets.SQLGatewayServlet

The name of the servlet used in the logon form HTML to call back the servlet with the servlet tag.

sql. Variable in class swosnick.database.servlets.SQLGatewayServlet

The SQL string to use for query or update.

SQLGatewayServlet(). Constructor for class swosnick.database.servlets.SQLGatewayServlet

statement. Variable in class swosnick.database.servlets.SQLGatewayServlet

The Statement used for SQL query or update.

T

tableHeadingBackgroundColor. Variable in class swosnick.database.servlets.SQLGatewayServlet

Table heading background color constant.

tableHeadingForeroundColor. Variable in class swosnick.database.servlets.SQLGatewayServlet

Table heading background color constant.

trace(String). Method in class swosnick.database.servlets.SQLGatewayServlet

This method was created by a SmartGuide.

U

url. Variable in class swosnick.database.servlets.SQLGatewayServlet

The JDBC-style URL with protocol and datasource name.

userName. Variable in class swosnick.database.servlets.SQLGatewayServlet

The user name or ID.

V

W

X

Y

Z

_