A B C D E G H I L M N O P Q R S U

A

addArgs(Object...) - Method in class com.buzzsurf.sql.BuzzSQL

Add objects to the current SQL statement arguments.

args - Variable in class com.buzzsurf.sql.BuzzSQL

B

BuzzSQL - Class in com.buzzsurf.sql

Every SQL object in BuzzSQL extends from the base class com.buzzsurf.sql.BuzzSQL, and therefore all operate in a very similar way.

BuzzSQL() - Constructor for class com.buzzsurf.sql.BuzzSQL

C

close() - Method in class com.buzzsurf.sql.BuzzSQL

Close and commit the SQL object.

close(boolean) - Method in class com.buzzsurf.sql.BuzzSQL

Close the SQL object with a choice to commit.

close() - Method in class com.buzzsurf.sql.Select

Close and commit the SQL object.

com.buzzsurf.sql - package com.buzzsurf.sql

con - Variable in class com.buzzsurf.sql.BuzzSQL

CONFIG_RESOURCE_NAME - Static variable in class com.buzzsurf.sql.DataSourceManager

D

DATABASE_FORMATTER - Static variable in class com.buzzsurf.sql.BuzzSQL

DataSourceManager - Class in com.buzzsurf.sql

DataSource Manager handles loading javax.sql.DataSource objects from a JNDI naming context.

dataSourceName - Variable in class com.buzzsurf.sql.BuzzSQL

DEFAULT_DS_NAME - Static variable in class com.buzzsurf.sql.DataSourceManager

Delete - Class in com.buzzsurf.sql

An Delete object deletes rows from a database table and queries the number of rows deleted.

Delete() - Constructor for class com.buzzsurf.sql.Delete

A zero argument constructor is provided for simplified operation with JavBeans, SOAP, and reflection scenarios where having such a constructor is necessary or convenient.

Delete(String) - Constructor for class com.buzzsurf.sql.Delete

A single argument constructor that accepts your SQL statement and uses the default DataSource.

Delete(String, String) - Constructor for class com.buzzsurf.sql.Delete

A dual argument constructor that accepts your SQL statement and the explicit name of a DataSource to use.

Delete(String, Connection) - Constructor for class com.buzzsurf.sql.Delete

A dual argument constructor that accepts your SQL statement and a java.sql.Connection object.

E

execute() - Method in class com.buzzsurf.sql.BuzzSQL

During execution a database connection is obtained (if needed), SQL and arguments are merged, and the PreparedStatement is executed against the database.

execute() - Method in class com.buzzsurf.sql.Delete

During execution a database connection is obtained (if needed), SQL and arguments are merged, and the PreparedStatement is executed against the database.

execute() - Method in class com.buzzsurf.sql.Insert

During execution a database connection is obtained (if needed), SQL and arguments are merged, and the PreparedStatement is executed against the database.

execute() - Method in class com.buzzsurf.sql.Select

During execution a database connection is obtained (if needed), SQL and arguments are merged, and the PreparedStatement is executed against the database.

execute() - Method in class com.buzzsurf.sql.StoredProcedure

During execution a database connection is obtained (if needed), SQL and arguments are merged, and the PreparedStatement is executed against the database.

execute() - Method in class com.buzzsurf.sql.Update

During execution a database connection is obtained (if needed), SQL and arguments are merged, and the PreparedStatement is executed against the database.

G

getArgs() - Method in class com.buzzsurf.sql.BuzzSQL

Get array of the currently set args.

getBoolean() - Method in class com.buzzsurf.sql.OutParameter

getBoolean(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

getBoolean(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

getBuildNumber() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the build number

getByte() - Method in class com.buzzsurf.sql.OutParameter

getByte(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

getBytes() - Method in class com.buzzsurf.sql.OutParameter

getBytes(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

getBytes(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

getCalendar() - Method in class com.buzzsurf.sql.OutParameter

getCalendar(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a java.util.Calendar object in the Java programming language.

getCalendar(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a java.util.Calendar object in the Java programming language.

getColumnCount() - Method in class com.buzzsurf.sql.Select

Returns the number of columns in this ResultSet object.

getColumnName(int) - Method in class com.buzzsurf.sql.Select

Get the designated column's name.

getConnection() - Method in class com.buzzsurf.sql.BuzzSQL

Get the current database connection.

getConnection() - Static method in class com.buzzsurf.sql.DataSourceManager

Get a java.sql.Connection object from the default dataSource.

getConnection(String) - Static method in class com.buzzsurf.sql.DataSourceManager

DataSources are made available to BuzzSQL using a name that is based on the JNDI path.

getDataSourceName() - Method in class com.buzzsurf.sql.BuzzSQL

Get the current dataSource name.

getDate() - Method in class com.buzzsurf.sql.OutParameter

getDate(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a java.util.Date object in the Java programming language.

getDate(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a java.util.Date object in the Java programming language.

getDefaultDataSourceName() - Static method in class com.buzzsurf.sql.DataSourceManager

Get the name of the default dataSource

getDeleteCount() - Method in class com.buzzsurf.sql.Delete

Get the number of rows deleted.

getDouble() - Method in class com.buzzsurf.sql.OutParameter

getDouble(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

getDouble(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

getFloat() - Method in class com.buzzsurf.sql.OutParameter

getFloat(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

getFloat(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

getGeneratedKey() - Method in class com.buzzsurf.sql.Insert

If the database table contains an auto increment column, the value can be retrieved using getGeneratedKey().

getInsertCount() - Method in class com.buzzsurf.sql.Insert

Get the number of rows inserted.

getInt() - Method in class com.buzzsurf.sql.OutParameter

getInt(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

getInt(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

getInValue() - Method in class com.buzzsurf.sql.InOutParameter

getLicenseInfo() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the license info

getLine() - Method in class com.buzzsurf.sql.Select

getLine(String) - Method in class com.buzzsurf.sql.Select

getLineCSV() - Method in class com.buzzsurf.sql.Select

getLong() - Method in class com.buzzsurf.sql.OutParameter

getLong(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

getLong(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

getMajorVersion() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the major version number

getMetaData() - Method in class com.buzzsurf.sql.Select

Get the internal java.sql.ResultSetMetaData.

getMinorVersion() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the minor version number

getObject() - Method in class com.buzzsurf.sql.OutParameter

getOutSqlType() - Method in class com.buzzsurf.sql.OutParameter

getProductName() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the product name

getReleaseDate() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the release date string

getReleaseInfo() - Static method in class com.buzzsurf.sql.BuzzSQL

Get information on this BuzzSQL release.

getResultSet() - Method in class com.buzzsurf.sql.Select

Get the internal java.sql.ResultSet.

getRowCount() - Method in class com.buzzsurf.sql.Update

Get the number of rows updated.

getShort() - Method in class com.buzzsurf.sql.OutParameter

getShort(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as an short in the Java programming language.

getShort(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

getSQL() - Method in class com.buzzsurf.sql.BuzzSQL

Get SQL statement string.

getStatement() - Method in class com.buzzsurf.sql.BuzzSQL

Get the internal java.sql.PreparedStatement.

getString() - Method in class com.buzzsurf.sql.OutParameter

getString(int) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

getString(String) - Method in class com.buzzsurf.sql.Select

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

getUpdateCount() - Method in class com.buzzsurf.sql.StoredProcedure

Get the number of rows updated.

getUpdateCount() - Method in class com.buzzsurf.sql.Update

Get the number of rows updated.

getVersionString() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the version in formation major.minor.build

getWebsiteString() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the website URL

getWelcome() - Method in class com.buzzsurf.sql.ReleaseInfo

Get the welcome message

H

hasResultSet - Variable in class com.buzzsurf.sql.StoredProcedure

hasResultSet() - Method in class com.buzzsurf.sql.StoredProcedure

Returns a boolean to indicate the form of the first result.

I

initializationFailed() - Static method in class com.buzzsurf.sql.DataSourceManager

Check the status if initialization.

initialize() - Static method in class com.buzzsurf.sql.DataSourceManager

DataSource Manager uses "lazy initialization" to create/lookup/load dataSource from the JNDI naming context.

InOutParameter - Class in com.buzzsurf.sql

An object that models a stored procedure INOUT parameter.

InOutParameter() - Constructor for class com.buzzsurf.sql.InOutParameter

Empty constructor provided for convenience

InOutParameter(int, Object) - Constructor for class com.buzzsurf.sql.InOutParameter

Construct a stored procedure INOUT parameter of the specified type

Insert - Class in com.buzzsurf.sql

An Insert object inserts new rows to a table and queries the number of rows inserted.

Insert() - Constructor for class com.buzzsurf.sql.Insert

A zero argument constructor is provided for simplified operation with JavBeans, SOAP, and reflection scenarios where having such a constructor is necessary or convenient.

Insert(String) - Constructor for class com.buzzsurf.sql.Insert

A single argument constructor that accepts your SQL statement and uses the default DataSource.

Insert(String, String) - Constructor for class com.buzzsurf.sql.Insert

A dual argument constructor that accepts your SQL statement and the explicit name of a DataSource to use.

Insert(String, Connection) - Constructor for class com.buzzsurf.sql.Insert

A dual argument constructor that accepts your SQL statement and a java.sql.Connection object.

inValue - Variable in class com.buzzsurf.sql.InOutParameter

isInitialized() - Static method in class com.buzzsurf.sql.DataSourceManager

Check the status if initialization.

L

LB - Static variable in class com.buzzsurf.sql.ReleaseInfo

listDataSourceNames() - Static method in class com.buzzsurf.sql.DataSourceManager

Get a collection of all available dataSource names

M

merge(PreparedStatement) - Method in class com.buzzsurf.sql.BuzzSQL

N

next() - Method in class com.buzzsurf.sql.Select

Moves the ResultSet cursor down one row from its current position.

O

OutParameter - Class in com.buzzsurf.sql

An object that models a stored procedure OUT parameter.

OutParameter() - Constructor for class com.buzzsurf.sql.OutParameter

Empty constructor provided for convenience

OutParameter(int) - Constructor for class com.buzzsurf.sql.OutParameter

Construct a stored procedure OUT parameter of the specified type

outSqlType - Variable in class com.buzzsurf.sql.OutParameter

outValue - Variable in class com.buzzsurf.sql.OutParameter

P

prepare() - Method in class com.buzzsurf.sql.BuzzSQL

Q

queryToString(String, List<Object>) - Static method in class com.buzzsurf.sql.BuzzSQL

Utility method to create a nice readable representation of the results of merging a statment with ? placeholders with object args.

R

releaseConnection(Connection) - Static method in class com.buzzsurf.sql.DataSourceManager

Release the JDBC connection

releaseConnection(String, Connection) - Static method in class com.buzzsurf.sql.DataSourceManager

Release the JDBC connection to the specified dataSource

ReleaseInfo - Class in com.buzzsurf.sql

Immutable product release information.

rowCount - Variable in class com.buzzsurf.sql.Update

rs - Variable in class com.buzzsurf.sql.Select

rsmd - Variable in class com.buzzsurf.sql.Select

S

Select - Class in com.buzzsurf.sql

A Select object queries a database and can be iterated through to read results.

Select() - Constructor for class com.buzzsurf.sql.Select

A zero argument constructor is provided for simplified operation with JavBeans, SOAP, and reflection scenarios where having such a constructor is necessary or convenient.

Select(String) - Constructor for class com.buzzsurf.sql.Select

A single argument constructor that accepts your SQL statement and uses the default DataSource.

Select(String, String) - Constructor for class com.buzzsurf.sql.Select

A dual argument constructor that accepts your SQL statement and the explicit name of a DataSource to use.

Select(String, Connection) - Constructor for class com.buzzsurf.sql.Select

A dual argument constructor that accepts your SQL statement and a java.sql.Connection object.

setArgs(Object...) - Method in class com.buzzsurf.sql.BuzzSQL

Set the SQL statement arguments.

setCalendar(int, Calendar) - Method in class com.buzzsurf.sql.OutParameter

Set the java.util.Calendar to the value of the out parameter value from the stored procedure if it is an instanceof java.sql.Timestamp

setCalendar(int, Calendar) - Method in class com.buzzsurf.sql.Select

Set the current time of the provided java.util.Calendar object to the value of the designated column in the current row of this ResultSet.

setCalendar(String, Calendar) - Method in class com.buzzsurf.sql.Select

Set the current time of the provided java.util.Calendar object to the value of the designated column in the current row of this ResultSet.

setConnection(Connection) - Method in class com.buzzsurf.sql.BuzzSQL

Set the current connection to an explicit connection.

setDataSourceName(String) - Method in class com.buzzsurf.sql.BuzzSQL

Set the dataSource name.

setInValue(Object) - Method in class com.buzzsurf.sql.InOutParameter

setOutSqlType(int) - Method in class com.buzzsurf.sql.OutParameter

Set the out parameter SQL type from java.sql.Type

setSQL(String) - Method in class com.buzzsurf.sql.BuzzSQL

Set the SQL statement.

sql - Variable in class com.buzzsurf.sql.BuzzSQL

stmt - Variable in class com.buzzsurf.sql.BuzzSQL

StoredProcedure - Class in com.buzzsurf.sql

A StoredProcedure object executes a stored program in a relational database.

StoredProcedure() - Constructor for class com.buzzsurf.sql.StoredProcedure

A zero argument constructor is provided for simplified operation with JavBeans, SOAP, and reflection scenarios where having such a constructor is necessary or convenient.

StoredProcedure(String) - Constructor for class com.buzzsurf.sql.StoredProcedure

A single argument constructor that accepts your SQL statement and uses the default DataSource.

StoredProcedure(String, String) - Constructor for class com.buzzsurf.sql.StoredProcedure

A dual argument constructor that accepts your SQL statement and the explicit name of a DataSource to use.

StoredProcedure(String, Connection) - Constructor for class com.buzzsurf.sql.StoredProcedure

A dual argument constructor that accepts your SQL statement and a java.sql.Connection object.

U

Update - Class in com.buzzsurf.sql

An Update object modifies rows in a database and queries the number of rows updated.

Update() - Constructor for class com.buzzsurf.sql.Update

A zero argument constructor is provided for simplified operation with JavBeans, SOAP, and reflection scenarios where having such a constructor is necessary or convenient.

Update(String) - Constructor for class com.buzzsurf.sql.Update

A single argument constructor that accepts your SQL statement and uses the default DataSource.

Update(String, String) - Constructor for class com.buzzsurf.sql.Update

A dual argument constructor that accepts your SQL statement and the explicit name of a DataSource to use.

Update(String, Connection) - Constructor for class com.buzzsurf.sql.Update

A dual argument constructor that accepts your SQL statement and a java.sql.Connection object.

updateCount - Variable in class com.buzzsurf.sql.StoredProcedure

usingExplicitConnection - Variable in class com.buzzsurf.sql.BuzzSQL

usingExplicitConnection() - Method in class com.buzzsurf.sql.BuzzSQL

usingExplicitConnection() will return true if you pass a java.sql.Connection in via the constructor, or call setConnection(Connection con) with a non-null java.sql.Connection object.

A B C D E G H I L M N O P Q R S U