maxlength for customer id column

[Tim Fernandez]

Hi Everyone,

I would like to limit the number of string that can be entered in the customer id field. In this case, i will only allow 8 characters since this is what the urly bird specification requires. ANy thoughts on how I can implement this one?

regards,
tim

[Jason Moors]

In your create and update methods you could compare the length of the String provided against the metadata for each field.

Then if a field is too long you can either throw an exception or you could choose to truncate the string, i.e only insert the x leftmost characters.

Jason.

[ak pillai]

Why not have an InputValidator class and restrict the length. This way, you only need to do it in one location, not in every SQL statements

[Andrew Monkhouse]

Have you looked at what formatted text fields can do for you? Especially the javax.swing.text.MaskFormatter class?

Regards, Andrew

[Tim Fernandez]

Hi Everyone,

I'm sorry about the confusion. I am entering the customer id in the cell in the table. So i do not think Maskformatter will help me. So I am wondering if there is something in the cell that can limit the number of characters you can enter.

regards,
tim

Originally posted by Andrew Monkhouse:
Have you looked at what formatted text fields can do for you? Especially the javax.swing.text.MaskFormatter class?

Regards, Andrew

[Tim Fernandez]

Any thoughts on how to implement this one?

[Andrew Monkhouse]

Hi Tim,

I have condensed Sun's TableFTFEditDemo into what is possibly the smallest bit of code that I can use to discuss this - it creates a simple table where the third column will only allow integers between 100 and 999 to be entered.

See how you go with this and/or see how you go with Sun's tutorials on the subject.

If in doubt, you can always come back and ask questions

Regards, Andrew

[list]import java.awt.*;[/list][list]import java.awt.event.*;[/list][list]import java.text.*;[/list][list]import javax.swing.*;[/list][list]import javax.swing.table.*;[/list][list]import javax.swing.text.*;[/list][list]<li>public class TimTableTest {[/list][list]    private static Object[] columns = {"One", "Two", "Three"};[/list][list]    private static Object[][] data = { [/list][list]                { "a", "x", 111 }, [/list][list]                { "b", "y", 222 },[/list][list]                { "c", "z", 333 } [/list][list]            };[/list][list]    [/list][list]    public static void main(String[] args) throws Exception {[/list][list]        JFrame theFrame = new JFrame("JTable Test");[/list][list]        theFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);[/list][list]        JTable myTable = new JTable(new MyTableModel(data, columns));[/list][list]        myTable.setDefaultEditor(Integer.class, new IntegerEditor());[/list][list]        theFrame.add(myTable);[/list][list]        theFrame.pack();[/list][list]        theFrame.setVisible(true);[/list][list]    }[/list][list]    [/list][list]    private static class MyTableModel extends DefaultTableModel {[/list][list]        public MyTableModel(Object[][] data, Object[] columnNames) {[/list][list]            super(data, columnNames);[/list][list]        }[/list][list]        [/list][list]        public boolean isCellEditable(int row, int column) {[/list][list]            return (column == 2) ? true : false;[/list][list]        }[/list][list]        [/list][list]        public Class<?> getColumnClass(int columnIndex) {[/list][list]            return (super.getValueAt(0, columnIndex) instanceof Integer) [/list][list]                    ? Integer.class[/list][list]                    : Object.class;[/list][list]        }[/list][list]    }[/list][list]<li>    private static class IntegerEditor extends DefaultCellEditor {[/list][list]        JFormattedTextField ftf;[/list][list]        NumberFormat integerFormat;[/list][list]<li>        public IntegerEditor() {[/list][list]            super(new JFormattedTextField());[/list][list]            ftf = (JFormattedTextField)getComponent();[/list][list]<li>            //Set up the editor for the integer cells.[/list][list]            integerFormat = NumberFormat.getIntegerInstance();[/list][list]            NumberFormatter intFormatter = new NumberFormatter(integerFormat);[/list][list]            intFormatter.setFormat(integerFormat);[/list][list]            intFormatter.setMinimum(100);[/list][list]            intFormatter.setMaximum(999);[/list][list]<li>            ftf.setFormatterFactory(new DefaultFormatterFactory(intFormatter));[/list][list]            ftf.setValue(0);[/list][list]            ftf.setHorizontalAlignment(JTextField.TRAILING);[/list][list]            ftf.setFocusLostBehavior(JFormattedTextField.PERSIST);[/list][list]<li>            // React when the user presses Enter while the editor is[/list][list]            // active. (Tab is handled as specified by[/list][list]            // JFormattedTextField's focusLostBehavior property.)[/list][list]            ftf.getInputMap().put(KeyStroke.getKeyStroke(KeyEvent.VK_ENTER, 0),[/list][list]                    "check");[/list][list]            ftf.getActionMap().put("check", new AbstractAction() {[/list][list]                public void actionPerformed(ActionEvent e) {[/list][list]                    if (ftf.isEditValid()) { // The text is invalid.[/list][list]                        try { // The text is valid,[/list][list]                            ftf.commitEdit(); // so use it.[/list][list]                            ftf.postActionEvent(); // stop editing[/list][list]                        } catch (java.text.ParseException exc) {[/list][list]                        }[/list][list]                    }[/list][list]                }[/list][list]            });[/list][list]        }[/list][list]<li>        // Override to invoke setValue on the formatted text field.[/list][list]        public Component getTableCellEditorComponent(JTable table,[/list][list]                Object value, boolean isSelected, int row, int column) {[/list][list]            JFormattedTextField ftf = [/list][list]                    (JFormattedTextField) super.getTableCellEditorComponent([/list][list]                            table, value, isSelected, row, column);[/list][list]            ftf.setValue(value);[/list][list]            return ftf;[/list][list]        }[/list][list]<li>        // Override to ensure that the value remains an Integer.[/list][list]        public Object getCellEditorValue() {[/list][list]        return ((JFormattedTextField)getComponent()).getValue();[/list][list]        }[/list][list]<li>        //Override to check whether the edit is valid,[/list][list]        //setting the value if it is and complaining if[/list][list]        //it isn't.  If it's OK for the editor to go[/list][list]        //away, we need to invoke the superclass's version [/list][list]        //of this method so that everything gets cleaned up.[/list][list]        public boolean stopCellEditing() {[/list][list]            JFormattedTextField ftf = (JFormattedTextField) getComponent();[/list][list]            if (ftf.isEditValid()) {[/list][list]                try {[/list][list]                    ftf.commitEdit();[/list][list]                } catch (java.text.ParseException exc) {[/list][list]                }[/list][list]            } else { // text is invalid[/list][list]                return false; // don't let the editor go away[/list][list]            }[/list][list]            return super.stopCellEditing();[/list][list]        }[/list][list]    }[/list][list]}[/list]