Serialized Form


Package com.billpringle.utils.wrputils

Class com.billpringle.utils.wrputils.WrpBuildZipCodes extends javax.swing.JFrame implements Serializable

serialVersionUID: 1L

Serialized Fields

fc

javax.swing.JFileChooser fc
file chooser


fileIn

java.io.File fileIn
input file from USPS with zipcode information


fileCsv

java.io.File fileCsv
CSV file converted from input file


rdr

java.io.BufferedReader rdr
reader for input file


prt

java.io.PrintStream prt
print stream for output file


desktop

javax.swing.JDesktopPane desktop
desktop for main window


logPane

javax.swing.JPanel logPane
panel for scrolling log messages


logList

javax.swing.JList logList
list of log messages


logModel

javax.swing.DefaultListModel logModel
list model for log


logScroll

javax.swing.JScrollPane logScroll
scroll pane for log messages

Class com.billpringle.utils.wrputils.WrpEditValidationRules extends javax.swing.JFrame implements Serializable

serialVersionUID: 1L

Serialized Fields

db

WrpDb db
the connection to the database


csvLine

int csvLine
the unique line number for this record


csv

WrpCsv csv
The CSV string that can be validated.

When the "Execute" button is clicked, this string will be validated, provided the user hasn't specified a CSV file to validate.


csvFile

java.io.File csvFile
The file containing CSV records that can be validated.

If the user has specified a CSV file, it will be validated when the user clicks on the "Execute" button.


ValTbl

java.lang.String ValTbl
the database table name containing validation rules


Val

WrpValidateCsv Val
CSV validation object


validations

java.util.Vector<E> validations
vector of validation rules


modified

java.util.Vector<E> modified
vector indicating what rules have been modified


rulesRead

int rulesRead
The number of rules read from the database


colWidth

int[] colWidth
The width of the rules columns that was set by the user.

When rules are reloaded, these column widths will be retained.


compileErrors

int compileErrors
number of compile errors (-1 means no compile)


execErrors

int execErrors
number of run-time errors (-1 means no execution)


zipCodes

WrpZipCode zipCodes
list of valid zip code combinations


popup

javax.swing.JPopupMenu popup
pop up menu


pnlTop

javax.swing.JPanel pnlTop
panel at top of page


pnlTopPage

javax.swing.JPanel pnlTopPage
wrapper panel to prevent top of page resizing


lblTitle

javax.swing.JLabel lblTitle
label for title at top of page


tblRules

javax.swing.JTable tblRules
table of validation rules


txtLowSeq

javax.swing.JTextField txtLowSeq
optional lower sequence number to load a subset of the validation rules


txtHighSeq

javax.swing.JTextField txtHighSeq
optional upper sequence number to load a subset of the validation rules


txtTable

javax.swing.JTextField txtTable
optional field to indicate stored procedure


btnGet

javax.swing.JButton btnGet
button to load validation rules


btnSave

javax.swing.JButton btnSave
button to save validation rules


btnCompile

javax.swing.JButton btnCompile
button to compile the validation rules


btnPrint

javax.swing.JButton btnPrint
button to print validation rules


btnCsv

javax.swing.JButton btnCsv
Button to specify a CSV string to parse


btnFile

javax.swing.JButton btnFile
Button to specify a CSV file to parse


btnExecute

javax.swing.JButton btnExecute
Button to validate one or more CSV strings

If the user has specified a CSV file, then all the lines in that file are validated using the current set of validation rules. If no CSV file is specified, then the specified CSV string is validated instead.


btnRenum

javax.swing.JButton btnRenum
button to renumber statements


btnQuit

javax.swing.JButton btnQuit
button to terminate the program


pnlScroll

javax.swing.JPanel pnlScroll
scroll panel for the validation rules


scroll

javax.swing.JScrollPane scroll
scroll pane for the validation rules


topSize

java.awt.Dimension topSize
size of the top portion of the page


fc

javax.swing.JFileChooser fc
a file chooser to select the CSV file

Class com.billpringle.utils.wrputils.WrpScrollFrame extends javax.swing.JFrame implements Serializable

serialVersionUID: 1L

Serialized Fields

scrollData

java.util.Vector<E> scrollData
Vector of strings for this scrolled frame. Each entry in the list will be inserted into the scrolled frame as a separate line in the list. The entries of the list can contain embedded end of line sequences.


scroll

javax.swing.JScrollPane scroll
The scrolled pane. This pane will contain the information to be displayed in the frame.


lst

javax.swing.JList lst
The list that contains the text to be displayed in the frame.

Class com.billpringle.utils.wrputils.WrpScrollResultSet extends WrpScrollTable implements Serializable

serialVersionUID: 1L

Serialized Fields

vec

WrpResultSetVector vec
result set vector to be displayed

Class com.billpringle.utils.wrputils.WrpScrollResultSet.WrpScrollResultModel extends WrpScrollTable.WrpTableModel implements Serializable

serialVersionUID: 1L

Serialized Fields

vec

WrpResultSetVector vec
result set vector


ncols

int ncols
number of columns


colNames

java.lang.String[] colNames
column names


colTypes

java.lang.String[] colTypes
column types


colScroll

int[] colScroll
columns in scroll

Class com.billpringle.utils.wrputils.WrpScrollTable extends javax.swing.JInternalFrame implements Serializable

serialVersionUID: 1L

Serialized Fields

win

javax.swing.JFrame win
main window of application


txtDescription

javax.swing.JTextArea txtDescription
text area for detail description


pnlEntries

javax.swing.JPanel pnlEntries
panel for table


pnlDesc

javax.swing.JPanel pnlDesc
panel for description


tblEntries

javax.swing.JTable tblEntries
the table to display


model

WrpScrollTable.WrpTableModel model
table model for display


scrEntries

javax.swing.JScrollPane scrEntries
scroll pane for table


scrDesc

javax.swing.JScrollPane scrDesc
scroll panel for description

Class com.billpringle.utils.wrputils.WrpScrollTable.WrpTableModel extends javax.swing.table.DefaultTableModel implements Serializable

serialVersionUID: 1L

Class com.billpringle.utils.wrputils.WrpValidateCsv.ValidationRuntimeException extends java.lang.RuntimeException implements Serializable

serialVersionUID: 1L

Serialized Fields

DebugInfo

java.lang.String DebugInfo
additional Exception field used to store debugging information (e.g., values of variables, and indicating of where exception was thrown, etc.)