A B C D F G I J L M N P R S U V W

A

absolute() - Method in class j3.mssql.JDBCHandler

Move to 3rd record in recordset, and display its contents.

absolute(int) - Method in class j3.mssql.PersonSQL

Retieves the row of data from the resultset at the given position
1 gets the first row, 2 the second....
-1 gets the last row, -2 gets the row before the last one....

actionPerformed(ActionEvent) - Method in class j3.ui.MainFrame

actionPerformed(ActionEvent) - Method in class j3.ui.MainFrame_AboutBox

afterLast() - Method in class j3.mssql.PersonSQL

Set the current cursor position after the last row, if there is a resultset

B

beforeFirst() - Method in class j3.mssql.PersonSQL

Set the current cursor position beofre the first row, if there is a resultset

borderLayout1 - Variable in class j3.ui.MainFrame

borderLayout1 - Variable in class j3.ui.MainFrame_AboutBox

borderLayout2 - Variable in class j3.ui.MainFrame_AboutBox

btnCopy - Variable in class j3.ui.MainFrame

button1 - Variable in class j3.ui.MainFrame_AboutBox

C

callSpParmSQL(Connection) - Method in class j3.mssql.SpParmSQL

Call this method to execute the stored procedure

cancel() - Method in class j3.ui.MainFrame_AboutBox

CLASS - Static variable in class j3.mssql.JDBCHandler

clearProperties() - Method in class j3.mssql.SpParmSQL

Sets this object's properties to null

clearProperties() - Method in class j3.mssql.PersonData

Sets all properties to null

close() - Method in class j3.mssql.SpParmSQL

Close any open ResultSets and Statements

close() - Method in class j3.mssql.JDBCHandler

Close resultsets, statements and the jdbc connection

close() - Method in class j3.mssql.PersonSQL

close all open statements and resutlset, if open

closeCall() - Method in class j3.mssql.SpParmSQL

Closes the myCall member

closeDeleteAll() - Method in class j3.mssql.PersonSQL

Close the PreparedStatement for deleteAll if it is open

closeDeleteByEmail() - Method in class j3.mssql.PersonSQL

Close the PreparedStatement for deleteByEmail if it is open

closeInsert() - Method in class j3.mssql.PersonSQL

Close the PreparedStatement for insert if it is open

closeResultSet() - Method in class j3.mssql.PersonSQL

Closes the resultset member if open

closeSelectAll() - Method in class j3.mssql.PersonSQL

Close the PreparedStatement for selectAll if it is open Also closes the resultset member myResultSet if it is associated with this statement

closeStatements() - Method in class j3.mssql.JDBCHandler

Close all open JDatabase Wizard classes (statements & resultsets)

closeUpdateByEmail() - Method in class j3.mssql.PersonSQL

Close the PreparedStatement for updateByEmail if it is open

comments - Variable in class j3.ui.MainFrame_AboutBox

contentPane - Variable in class j3.ui.MainFrame

copyright - Variable in class j3.ui.MainFrame_AboutBox

cursorTests() - Method in class j3.mssql.JDBCHandler

Test cursor movement methods on PersonSQL

D

deleteAll() - Method in class j3.mssql.JDBCHandler

delete all records

deleteAll(Connection) - Method in class j3.mssql.PersonSQL

Deletes records in the database

deleteByEmail(Connection, String) - Method in class j3.mssql.PersonSQL

Deletes records in the database

deleteOne() - Method in class j3.mssql.JDBCHandler

Delete one record

deleteRow() - Method in class j3.mssql.JDBCHandler

Delete the current ResultSet row

deleteRow() - Method in class j3.mssql.PersonSQL

Delete the current row, if there is a resultset

displayPersonData(PersonData) - Method in class j3.mssql.JDBCHandler

Display passed PersonData in a HTML table

displayPersonDataRow(PersonData) - Method in class j3.mssql.JDBCHandler

Display ONE PersonData record as a HTML table row.

displayResultSetInfo() - Method in class j3.mssql.JDBCHandler

Display all misc.

F

finalize() - Method in class j3.mssql.SpParmSQL

close open statement and resultset

finalize() - Method in class j3.mssql.PersonSQL

close any open statements and resultset

first() - Method in class j3.mssql.PersonSQL

Retieves the first row of data from the resultset

firstTests() - Method in class j3.mssql.JDBCHandler

flowLayout1 - Variable in class j3.ui.MainFrame_AboutBox

G

getCallInteger(CallableStatement, int) - Method in class j3.mssql.SpParmSQL

Utility function used to get the procedure's parameter or return value as a Integer

getConcurrency() - Method in class j3.mssql.PersonSQL

Get the current resultset concurrency

getEmail() - Method in class j3.mssql.PersonData

property get for Email

getEmailIn() - Method in class j3.mssql.SpParmSQL

Retrieve the stored procedure parameter EmailIn

getEmailOut() - Method in class j3.mssql.SpParmSQL

Retrieve the stored procedure parameter EmailOut

getFetchDirection() - Method in class j3.mssql.PersonSQL

Get the current fetch direction

getFetchSize() - Method in class j3.mssql.PersonSQL

Get the current fetch size

getFirstName() - Method in class j3.mssql.SpParmSQL

Retrieve the stored procedure parameter FirstName

getFirstName() - Method in class j3.mssql.PersonData

property get for FirstName

getLastName() - Method in class j3.mssql.SpParmSQL

Retrieve the stored procedure parameter LastName

getLastName() - Method in class j3.mssql.PersonData

property get for LastName

getResultSetRecord() - Method in class j3.mssql.PersonSQL

Retieves the current row of data from the resultset

getReturnValue() - Method in class j3.mssql.SpParmSQL

Retrieve the stored procedure return value

getRow() - Method in class j3.mssql.PersonSQL

Get the current row number

getTitle() - Method in class j3.mssql.PersonData

property get for Title

getType() - Method in class j3.mssql.PersonSQL

Get the current resultset scroll type

go() - Method in class j3.mssql.JDBCHandler

Perform JDBC operations using the generated classes.

gridLayout1 - Variable in class j3.ui.MainFrame_AboutBox

I

imageLabel - Variable in class j3.ui.MainFrame_AboutBox

insert() - Method in class j3.mssql.JDBCHandler

Insert six records

insert(Connection, PersonData) - Method in class j3.mssql.PersonSQL

Creates a new record in the database

insertRow() - Method in class j3.mssql.JDBCHandler

Move to insert position, then insert a record using the resultset

insertRow(PersonData) - Method in class j3.mssql.PersonSQL

ResultSet insert method, only columns set for select and insert are inserted

insetsPanel1 - Variable in class j3.ui.MainFrame_AboutBox

insetsPanel2 - Variable in class j3.ui.MainFrame_AboutBox

insetsPanel3 - Variable in class j3.ui.MainFrame_AboutBox

isAfterLast() - Method in class j3.mssql.PersonSQL

Determine if the current cursor is after the last row in the resultset.

isBeforeFirst() - Method in class j3.mssql.PersonSQL

Determine if the current cursor is before the first row in the resultset.

isFirst() - Method in class j3.mssql.PersonSQL

Determine if the current cursor is on the first row in the resultset.

isLast() - Method in class j3.mssql.PersonSQL

Determine if the current cursor is at the last row in the resultset.

J

j3 - package j3

j3.mssql - package j3.mssql

j3.ui - package j3.ui

jbInit() - Method in class j3.ui.MainFrame

jbInit() - Method in class j3.ui.MainFrame_AboutBox

JDBCHandler - class j3.mssql.JDBCHandler.

Please check the JDBC connection constants defined below.

JDBCHandler() - Constructor for class j3.mssql.JDBCHandler

Constructor create JDBC access classes

jMenuBar1 - Variable in class j3.ui.MainFrame

jMenuFile - Variable in class j3.ui.MainFrame

jMenuFileExit - Variable in class j3.ui.MainFrame

jMenuFileExit_actionPerformed(ActionEvent) - Method in class j3.ui.MainFrame

jMenuHelp - Variable in class j3.ui.MainFrame

jMenuHelpAbout - Variable in class j3.ui.MainFrame

jMenuHelpAbout_actionPerformed(ActionEvent) - Method in class j3.ui.MainFrame

jScrollPane1 - Variable in class j3.ui.MainFrame

L

label1 - Variable in class j3.ui.MainFrame_AboutBox

label2 - Variable in class j3.ui.MainFrame_AboutBox

label3 - Variable in class j3.ui.MainFrame_AboutBox

label4 - Variable in class j3.ui.MainFrame_AboutBox

last() - Method in class j3.mssql.PersonSQL

Retieves the first row of data from the resultset

lastTests() - Method in class j3.mssql.JDBCHandler

M

Main - class j3.Main.

Title: JDBC Wizard Test Suite

Main() - Constructor for class j3.Main

Construct the application's window and show it.

main(String[]) - Static method in class j3.Main

application entry point

MainFrame - class j3.ui.MainFrame.

J3 Tutorial Frame Class.

MainFrame_AboutBox - class j3.ui.MainFrame_AboutBox.

About box Swing class See j3.oracle.JDBCHandler.java for the class which uses JDatabase Wizard generated files.

MainFrame_AboutBox(Frame) - Constructor for class j3.ui.MainFrame_AboutBox

MainFrame() - Constructor for class j3.ui.MainFrame

mnuStartJDBC1Test - Variable in class j3.ui.MainFrame

mnuStartJDBC1Test_actionPerformed(ActionEvent) - Method in class j3.ui.MainFrame

moveToCurrentRow() - Method in class j3.mssql.PersonSQL

set the cursor to the remembered position, usually the current row, if there is a resultset

moveToInsertRow() - Method in class j3.mssql.PersonSQL

move the cursor to the insert position, if there is a resultset

myCall - Variable in class j3.mssql.SpParmSQL

Class wide CallableStatement used to extract data

myConnection - Variable in class j3.mssql.JDBCHandler

myCurrentSelectStatement - Variable in class j3.mssql.PersonSQL

Currently active select statment

myDeleteAllPreparedStatement - Variable in class j3.mssql.PersonSQL

delete method prepared statement

myDeleteByEmailPreparedStatement - Variable in class j3.mssql.PersonSQL

delete method prepared statement

myEmail - Variable in class j3.mssql.PersonData

property for Email

myEmailIn - Variable in class j3.mssql.SpParmSQL

stored procedure parameter EmailIn

myEmailOut - Variable in class j3.mssql.SpParmSQL

stored procedure parameter EmailOut

myFirstName - Variable in class j3.mssql.SpParmSQL

stored procedure parameter FirstName

myFirstName - Variable in class j3.mssql.PersonData

property for FirstName

myInsertPreparedStatement - Variable in class j3.mssql.PersonSQL

insert method PreparedStatement

myLastName - Variable in class j3.mssql.SpParmSQL

stored procedure parameter LastName

myLastName - Variable in class j3.mssql.PersonData

property for LastName

myParmSQL - Variable in class j3.mssql.JDBCHandler

myReport - Variable in class j3.mssql.JDBCHandler

myResultSet - Variable in class j3.mssql.PersonSQL

Class wide resultset used to extract data

myReturnValue - Variable in class j3.mssql.SpParmSQL

stored procedure return value

mySelectAllPreparedStatement - Variable in class j3.mssql.PersonSQL

Select method prepared statement

mySQL - Variable in class j3.mssql.JDBCHandler

myTextPane - Variable in class j3.ui.MainFrame

myTitle - Variable in class j3.mssql.PersonData

property for Title

myUpdateByEmailPreparedStatement - Variable in class j3.mssql.PersonSQL

Update method prepared statement

N

next() - Method in class j3.mssql.PersonSQL

Retieves the next row of data from the resultset

P

packFrame - Variable in class j3.Main

panel1 - Variable in class j3.ui.MainFrame_AboutBox

panel2 - Variable in class j3.ui.MainFrame_AboutBox

PASSWORD - Static variable in class j3.mssql.JDBCHandler

PersonData - class j3.mssql.PersonData.

JDBC table data class
Table Name : Person
Catalog : J3Demo
Schema : dbo
All JDBC resultset data is stored in this class
Generated by JDatabase Wizard build 1466, 24-Oct-02 16:53:48

PersonData() - Constructor for class j3.mssql.PersonData

Empty constructor

PersonData(PersonData) - Constructor for class j3.mssql.PersonData

Constructor to create a copy of the passed class

PersonSQL - class j3.mssql.PersonSQL.

JDBC database table access class
Table Name : Person
Catalog : J3Demo
Schema : dbo
All JDBC calls to the database object are in this class
Generated by JDatabase Wizard build 1466, 24-Oct-02 16:53:49

PersonSQL() - Constructor for class j3.mssql.PersonSQL

postCall() - Method in class j3.mssql.SpParmSQL

This is called when all resultset rows have been retrieved
This method retrieves the stored procedure's return value and any INOUT / OUT parameter values

previous() - Method in class j3.mssql.PersonSQL

Retieves the previous row of data from the resultset

processWindowEvent(WindowEvent) - Method in class j3.ui.MainFrame

processWindowEvent(WindowEvent) - Method in class j3.ui.MainFrame_AboutBox

product - Variable in class j3.ui.MainFrame_AboutBox

R

refreshRow() - Method in class j3.mssql.PersonSQL

Refreshes and retieves the current row of data from the resultset

relative(int) - Method in class j3.mssql.PersonSQL

Retieves the relative row of data from the resultset.
See JDBC docs (ResultSet) for a discussion of relative() with respect to beforeFirst,....

rowDeleted() - Method in class j3.mssql.PersonSQL

Determine if the current row has been deleted, if the driver detects this.

rowInserted() - Method in class j3.mssql.PersonSQL

Determine if the current row has been inserted, if the driver detects this.

rowUpdated() - Method in class j3.mssql.PersonSQL

Determine if the current row has been updated, if the driver detects this.

S

selectAll() - Method in class j3.mssql.JDBCHandler

select all records and display the resultset contents

selectAll(Connection) - Method in class j3.mssql.PersonSQL

Selects records from the database

setEmail(String) - Method in class j3.mssql.PersonData

property set for Email

setEmailIn(String) - Method in class j3.mssql.SpParmSQL

set the stored procedure parameter EmailIn

setEmailOut(String) - Method in class j3.mssql.SpParmSQL

set the stored procedure parameter EmailOut

setFetchDirection(int) - Method in class j3.mssql.PersonSQL

Set the fetch direction on the reusltset, if there is one.

setFetchSize(int) - Method in class j3.mssql.PersonSQL

Set the fetch size on the reusltset, if there is a resultset.
A value of 0 lets the ResultSet determine the size to use

setFirstName(String) - Method in class j3.mssql.SpParmSQL

set the stored procedure parameter FirstName

setFirstName(String) - Method in class j3.mssql.PersonData

property set for FirstName

setLastName(String) - Method in class j3.mssql.SpParmSQL

set the stored procedure parameter LastName

setLastName(String) - Method in class j3.mssql.PersonData

property set for LastName

setReturnValue(Integer) - Method in class j3.mssql.SpParmSQL

set the stored procedure return value here for completeness

setTitle(String) - Method in class j3.mssql.PersonData

property set for Title

south - Variable in class j3.ui.MainFrame

spParm() - Method in class j3.mssql.JDBCHandler

Call the stored procedure which uses in/out parameters

SpParmSQL - class j3.mssql.SpParmSQL.

JDBC database access class
Procedure Name : spParm
Catalog : J3Demo
Schema : dbo
All JDBC calls to the procedure are in this class
Generated by JDatabase Wizard build 1466, 24-Oct-02 16:53:49

SpParmSQL() - Constructor for class j3.mssql.SpParmSQL

U

updateByEmail(Connection, PersonData, String) - Method in class j3.mssql.PersonSQL

updates records in the database

updateOne() - Method in class j3.mssql.JDBCHandler

Update one record

updateRow(PersonData) - Method in class j3.mssql.PersonSQL

ResultSet update method, only columns set for select and update are updated

URL - Static variable in class j3.mssql.JDBCHandler

USER - Static variable in class j3.mssql.JDBCHandler

V

version - Variable in class j3.ui.MainFrame_AboutBox

W

wrapException(Exception) - Method in class j3.mssql.JDBCHandler

Captures the error message and call stack information from an exception and displays it.

A B C D F G I J L M N P R S U V W