Serialized Form


Package quick.dbtable

Class quick.dbtable.CellPropertiesModel extends java.lang.Object implements Serializable

Class quick.dbtable.Column extends javax.swing.table.TableColumn implements Serializable

Serialized Fields

cellEditorComponent

CellComponent cellEditorComponent

cellRendererComponent

CellComponent cellRendererComponent

oldWidth

int oldWidth

isModifying

boolean isModifying

readOnly

boolean readOnly
whether this a readonly COLUMN


type

int type
The type of the database column, refer to java.sql.Types for the available types


columnName

java.lang.String columnName
The name of the column as in database


scale

int scale
The scale of the column , if this is of type numeric , float, or double


precision

int precision
The precision of the column , if this is of type numeric , float, or double


length

int length
The length of the column, for non numeric


nullable

boolean nullable
set this true , if the column is nullable


signed

boolean signed
set this true , if the column is signed


boundSql

java.lang.String boundSql
If this column is bound with a column in another table, then a combo box celleditor will be used for this column & this sql will be used to fill that combobox, the sql should have only one column, if more than one is found , then the first column will be displayed in combo box


dateFormat

java.lang.String dateFormat
the date format of this column, if this is a date type column


document

javax.swing.text.Document document

dataMap

DataMap dataMap

resultSetMap

ResultSetMap resultSetMap

methodName

java.lang.String methodName

virtualColumn

boolean virtualColumn

visible

boolean visible

dbtableChangeSupport

java.beans.PropertyChangeSupport dbtableChangeSupport
If any PropertyChangeListeners have been registered, the changeSupport field describes them.

Class quick.dbtable.DBTable extends javax.swing.JPanel implements Serializable

Serialized Fields

dbColumnModel

DBTableColumnModel dbColumnModel
Column model used by DBTable


jdbcUrl

java.lang.String jdbcUrl
jdbcUrl used by DBTable to conect to database


dbDriver

java.lang.String dbDriver
driver name, which is used by DBTable to coonect to database


user

java.lang.String user
user name by which the database is logged on


password

java.lang.String password
password for the user specified


selectSql

java.lang.String selectSql
the select query to fetch data from database


rowCountSql

java.lang.String rowCountSql
this sql should return the row count


userRowCountSql

java.lang.String userRowCountSql
this sql should return the total row count


defaultCellModel

CellPropertiesModel defaultCellModel

defaultPropModel

CellPropertiesModel defaultPropModel

skin

Skin skin

firstButton

javax.swing.JButton firstButton

prevButton

javax.swing.JButton prevButton

nextButton

javax.swing.JButton nextButton

lastButton

javax.swing.JButton lastButton

newButton

javax.swing.JButton newButton

delButton

javax.swing.JButton delButton

label1

javax.swing.JLabel label1

evalLabel

javax.swing.JLabel evalLabel

firstTime

boolean firstTime

excelHandler

ExcelHandler excelHandler

messages

java.util.ResourceBundle messages

formatter

java.text.MessageFormat formatter

debug

boolean debug
To get the debug messages , set this variable to true. The default value is false.


showCriticalWarnings

boolean showCriticalWarnings
QuickTable displays various critical warnings, which needs to be corrected by developers. If not corrected, quicktable will not work properly. Developers may want to hide these messages when the application is deployed to users. In these cases they can set this variable to false. This should NEVER be turned off during development. If have enabled debug using dbTable.debug=true;, then critical warnings will be still shown, even if you disable showCriticalWarnings. The default value of this property is true.


showFindReplaceMessages

boolean showFindReplaceMessages
While doing find or replace, quicktable shows informative messages like text not found, search complete, 10 replacements etc. If you do not want these messages to be displayed set this property to false. The default value is true.


sortDisabled

boolean sortDisabled

typeNameHash

java.util.Hashtable typeNameHash

retainConnection

boolean retainConnection
when you switch between the database bound modes and non bound modes, usually the database connections are closed next time when you go to the database bound mode, again a connection will be created. If you feel that you want to use the original connection and keep it alive always even when you want to switch non bound modes set this flag to true


autoCommit

boolean autoCommit
If you want to handle the commit/rollback yourself, instead of quicktable handling it for you, set autoCommit to false. The default value for this property is true, quicktable itself handles the commit/rollback. when you want to handle the commit yourself, you can use getConnection() method and get the connection and then using connection.setAutoCommit(false/true) handle the connection. For commit/rollback use connection.commit()/connection.rollback

Since:
2.0.4.3

copyColumnHeaderNames

boolean copyColumnHeaderNames
While copying data from quickTable to clipboard, setting copyColumnHeaderNames will include column headers in the copied data. The default value is false

Since:
2.0.4.3

enableTextOverwriteOnCellEdit

boolean enableTextOverwriteOnCellEdit
If enableTextOverwriteOnCellEdit set to true, Whenever user starts editing a text cell, the previous value will be erased and the new value will be set. This is an excel like behaviour. The default value for this property is false, the text will not be erased, the user will be inserting the text. If you are trying to enable this feature, set this to true, immediately after you instantiate a new DBTable().

Since:
2.0.4.28

listenKeyPressEventsWholeWindow

boolean listenKeyPressEventsWholeWindow
Events like CTRL+F to open find window, HOME, END, PAGE DOWN etc are watched for the whole window where the dbTable is present. This way even if dbtable is not in focus the keys will still work. In some cases we may have more than one DBTable per window, in those cases listeneing for these events at window level would fire the events in wrong DBTable. If you want to prevent that problem, you can listen for these events only when DBtable is in focus, by setting this variable to false. But if you set this to false, the DBTable should be in focus for these events to work.

Since:
2.0.4.5

postponeDBInsert

boolean postponeDBInsert
When you attach a DatabaseChangeListener with quicktable and during beforeInsert(), if you return false that means you don't want quickTable to do the insert, instead you will handle the database insert yourself. But sometimes you still want quickTable to handle the db insert the next time. In this case if you set this property postponeDBInsert to true, then quicktable will postpone the insert until you return true for beforeInsert() for that record. The default value is false

Since:
2.0.4.3
See Also:
DatabaseChangeListener.beforeInsert(int)

defaultClickCountToStartEditor

int defaultClickCountToStartEditor
number of mouse clicks needed to start the editor. This is the default initial settings.
 If you want to change this per column, then use dbTable.getColumn(i).getCellEditor().setClickCountToStart(j);

 If you want to modify the value of this variable, it should be done immediately after you instantiate DBTable.

 The default value is 1. when user clicks on a cell, if the cell is editable, cell editor will be immediately shown.
 You can change this to 2, if you want the editor to be shown only on double click.
 

Since:
2.0.5.28

controlPanelType

int controlPanelType

mode

int mode

useOldColumnProperties

boolean useOldColumnProperties

fixedModel

FixedColumnMap fixedModel

fixedTable

javax.swing.JTable fixedTable

jScrollPane1

javax.swing.JScrollPane jScrollPane1

localeFont

java.awt.Font localeFont

fontResource

javax.swing.plaf.FontUIResource fontResource

lastLoc

int lastLoc

cellValueChangeInProgress

boolean cellValueChangeInProgress

sortOrder

java.util.Vector sortOrder

lastSortIsAscending

boolean lastSortIsAscending

doNotUseDatabaseSort

boolean doNotUseDatabaseSort
If you don't want to use the database query to sort the results and if you always want to sort by quicktable's sort set this to true

Since:
2.0.2

tableSorter

TableSorter tableSorter

oldFont

javax.swing.plaf.FontUIResource oldFont

oldFont1

javax.swing.plaf.FontUIResource oldFont1

jf

javax.swing.RootPaneContainer jf

Class quick.dbtable.DBTableCellEditor extends java.lang.Object implements Serializable

Serialized Fields

listenerList

javax.swing.event.EventListenerList listenerList
Deprecated. 
Event listeners


editorComponent

javax.swing.JComponent editorComponent
Deprecated. 

secondaryEditorComponent

javax.swing.JComponent secondaryEditorComponent
Deprecated. 

delegate

quick.dbtable.DBTableCellEditor.EditorDelegate delegate
Deprecated. 

clickCountToStart

int clickCountToStart
Deprecated. 

cellType

int cellType
Deprecated. 

cellValueToDisplayHash

java.util.Hashtable cellValueToDisplayHash
Deprecated. 

dBTable

DBTable dBTable
Deprecated. 

cc

CellComponent cc
Deprecated. 

Class quick.dbtable.DBTableCellEditor.EditorDelegate extends java.lang.Object implements Serializable

Serialized Fields

value

java.lang.Object value
Not implemented.

Class quick.dbtable.DBTableCellRenderer extends java.lang.Object implements Serializable

Serialized Fields

unselectedForeground

java.awt.Color unselectedForeground
Deprecated. 

unselectedBackground

java.awt.Color unselectedBackground
Deprecated. 

cellType

int cellType
Deprecated. 

cellValueToDisplayHash

java.util.Hashtable cellValueToDisplayHash
Deprecated. 

comp

javax.swing.JComponent comp
Deprecated. 

dBTable

DBTable dBTable
Deprecated. 

cc

CellComponent cc
Deprecated. 

Class quick.dbtable.DBTableCustomizer extends javax.swing.JPanel implements Serializable

Serialized Fields

borderLayout1

java.awt.BorderLayout borderLayout1

wizardPanel

javax.swing.JPanel wizardPanel

controlPanel

javax.swing.JPanel controlPanel

cardLayout1

java.awt.CardLayout cardLayout1

userPanel

javax.swing.JPanel userPanel

gridBagLayout1

java.awt.GridBagLayout gridBagLayout1

jLabel3

javax.swing.JLabel jLabel3

jLabel4

javax.swing.JLabel jLabel4

userText

javax.swing.JTextField userText

passwordText

javax.swing.JPasswordField passwordText

queryPanel

javax.swing.JPanel queryPanel

tablePanel

javax.swing.JPanel tablePanel

dbTable

DBTable dbTable

pcs_

java.beans.PropertyChangeSupport pcs_

currentPanel

int currentPanel

jLabel1

javax.swing.JLabel jLabel1

driverClassText

javax.swing.JTextField driverClassText

jdbcUrlText

javax.swing.JTextField jdbcUrlText

jLabel2

javax.swing.JLabel jLabel2

borderLayout2

java.awt.BorderLayout borderLayout2

jPanel1

javax.swing.JPanel jPanel1

prevButton

javax.swing.JButton prevButton

nextButton

javax.swing.JButton nextButton

imagePanel

javax.swing.JPanel imagePanel

jLabel6

javax.swing.JLabel jLabel6

imgIcon

javax.swing.ImageIcon imgIcon

flow

java.awt.FlowLayout flow

title

javax.swing.border.Border title

queryBorder

javax.swing.border.Border queryBorder

jPanel2

javax.swing.JPanel jPanel2

errorText

javax.swing.JTextArea errorText

jScrollPane1

javax.swing.JScrollPane jScrollPane1

borderLayout3

java.awt.BorderLayout borderLayout3

jScrollPane2

javax.swing.JScrollPane jScrollPane2

queryText

javax.swing.JTextArea queryText

borderLayout4

java.awt.BorderLayout borderLayout4

borderLayout5

java.awt.BorderLayout borderLayout5

codePanel

javax.swing.JPanel codePanel

jScrollPane3

javax.swing.JScrollPane jScrollPane3

codeText

javax.swing.JTextArea codeText

borderLayout6

java.awt.BorderLayout borderLayout6

jPanel3

javax.swing.JPanel jPanel3

jLabel5

javax.swing.JLabel jLabel5

columnNumberText

javax.swing.JTextField columnNumberText

jLabel7

javax.swing.JLabel jLabel7

columnNameText

javax.swing.JTextField columnNameText

setButton

javax.swing.JButton setButton

borderLayout7

java.awt.BorderLayout borderLayout7

helpText

javax.swing.JTextArea helpText

changeBorder

javax.swing.border.Border changeBorder

columnNameHash

java.util.Hashtable columnNameHash

columnWidthHash

java.util.Hashtable columnWidthHash

propertyHash

java.util.Hashtable propertyHash

help

java.lang.String[] help

Class quick.dbtable.PreviewPanel extends java.awt.Canvas implements Serializable

Serialized Fields

H_GAP

int H_GAP
See Also:
Constant Field Values

V_GAP

int V_GAP
See Also:
Constant Field Values

prn

PrintableTable prn

scale

int scale

imageSource

java.awt.Image imageSource

scaledImage

java.awt.Image scaledImage

scaleChanged

boolean scaleChanged

pageChanged

boolean pageChanged

pageIndex

int pageIndex

size

java.awt.Dimension size

oldPageIndex

int oldPageIndex

Class quick.dbtable.Skin extends java.util.Hashtable implements Serializable