| Package | Description | 
|---|---|
| bradleyross.j2ee.servlets | 
 Demonstration servlets. 
 | 
| bradleyross.library.database | 
 These are some utility programs for using JDBC to interact with databases. 
 | 
| bradleyross.library.helpers | 
 These are various utility classes that I developed for Java programs. 
 | 
| bradleyross.local.databases | 
 These classes represent the subclasses that are for
   use with this specific installation. 
 | 
| Modifier and Type | Field and Description | 
|---|---|
protected DatabaseProperties | 
ThisPage.data
Used to pass information on database connection. 
 | 
protected DatabaseProperties | 
PulldownList.data
Object containing database connection properties. 
 | 
protected DatabaseProperties | 
csvWriter2.data
Deprecated.  
Object containing database connection information. 
 | 
protected DatabaseProperties | 
CsvWriter.Instance.data
Object containing database connection information. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
protected DatabaseProperties | 
ShowSchema.getData()
Obtain a connection to the database based on the initialization
 parameters for the servlet. 
 | 
DatabaseProperties | 
ThisPage.getDatabase()
Get the object containing database connection properties. 
 | 
DatabaseProperties | 
CsvWriter.Instance.getDatabaseProperties()  | 
protected abstract DatabaseProperties | 
csvWriter2.makeConnection()
Deprecated.  
Obtain the database connection information. 
 | 
protected abstract DatabaseProperties | 
CsvWriter.makeConnection()
Obtain the database connection information. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
protected abstract ResultSet | 
CsvWriter.getResultSet(HttpServletRequest req,
                        DatabaseProperties data)
Will be overridden with the method for obtaining the SQL
 result set. 
 | 
protected boolean | 
ShowSchema.isIncluded(DatabaseProperties data,
                    String catalog,
                    String schema,
                    String item)
Determines whether an item in the database is to be included in the
 reports. 
 | 
void | 
UploadServlet.loadByteArray(DatabaseProperties data,
                          PreparedStatement stmt,
                          UploadServlet.ThisPage thisPage,
                          int position,
                          String element)
Utility method for moving the contents of one of the parts into
 a prepared statement as a string object. 
 | 
void | 
UploadServlet.loadByteArray(DatabaseProperties data,
                          PreparedStatement stmt,
                          UploadServlet.ThisPage thisPage,
                          int position,
                          String element,
                          boolean convertFlag)
Utility method for moving the contents of one of the parts into
 a prepared statement as a string object. 
 | 
void | 
UploadServlet.loadByteArray(DatabaseProperties data,
                          PreparedStatement stmt,
                          UploadServlet.ThisPage thisPage,
                          int position,
                          String element,
                          boolean convertFlag,
                          int SQLType)
Utility method for moving the contents of one of the parts into
 a prepared statement as a string object. 
 | 
protected void | 
ShowSchema.processDatabaseInformation(DatabaseProperties data,
                                                    GenericPrinter output,
                                                    HttpServletRequest req,
                                                    HttpServletResponse res)
Generate a page containing information about the database system. 
 | 
protected void | 
ShowSchema.processDescribeTable(DatabaseProperties data,
                                        GenericPrinter output,
                                        HttpServletRequest req,
                                        HttpServletResponse res)
Generate a web page describing the layout of a table. 
 | 
protected void | 
ShowSchema.processListProcedures(DatabaseProperties data,
                                          GenericPrinter output,
                                          HttpServletRequest req,
                                          HttpServletResponse res)
Generate the list of procedures in the database. 
 | 
protected void | 
ShowSchema.processListTables(DatabaseProperties data,
                                  GenericPrinter output,
                                  HttpServletRequest req,
                                  HttpServletResponse res)
Generate the list of tables in the database. 
 | 
protected void | 
ShowSchema.processListViews(DatabaseProperties data,
                                GenericPrinter output,
                                HttpServletRequest req,
                                HttpServletResponse res)
Generate the list of views in the database. 
 | 
protected void | 
ShowSchema.processRootPage(DatabaseProperties data,
                              GenericPrinter output,
                              HttpServletRequest req,
                              HttpServletResponse res)
Generate the root page for schema information for the database. 
 | 
protected void | 
ShowSchema.processUDTInformation(DatabaseProperties data,
                                          GenericPrinter output,
                                          HttpServletRequest req,
                                          HttpServletResponse res)
Generate the list of user defined types for the database system. 
 | 
void | 
ThisPage.setDatabase(DatabaseProperties databaseValue)
Set the object containing database connection properties. 
 | 
void | 
CsvWriter.Instance.setDatabaseProperties(DatabaseProperties value)  | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
DatabaseInstance  | 
| Modifier and Type | Field and Description | 
|---|---|
protected DatabaseProperties | 
TableHelper.data
Object containing information for connecting to database. 
 | 
(package private) DatabaseProperties | 
ShowObjects.data  | 
| Modifier and Type | Method and Description | 
|---|---|
DatabaseProperties | 
TableHelper.getDatabase()  | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
TableHelper.setDatabase(DatabaseProperties dataValue)  | 
| Constructor and Description | 
|---|
ShowObjects(DatabaseProperties value)  | 
ShowProperties(DatabaseProperties data)
Constructor using my database class. 
 | 
TableHelper(DatabaseProperties data,
                      String catalog,
                      String schema,
                      String table)  | 
| Modifier and Type | Field and Description | 
|---|---|
protected DatabaseProperties | 
ServletHelpers.data  | 
| Constructor and Description | 
|---|
ServletHelpers(DatabaseProperties dataValue)  | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
DatabaseConnection
Information for connecting to databases on my laptop. 
 |