Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Do not use a KeyListener for this as you'll miss much including pasting of text. Also a KeyListener is a very low-level construct and as such, should be avoided in Swing applications.</p> <p>The solution has been described many times on SO: Use a <a href="http://docs.oracle.com/javase/7/docs/api/javax/swing/text/DocumentFilter.html" rel="noreferrer">DocumentFilter</a>. There are several examples of this on this site, some written by me.</p> <p>For example: <a href="https://stackoverflow.com/questions/9345750/using-documentfilter-filterbypass/9346426#9346426">using-documentfilter-filterbypass</a></p> <p>Also for tutorial help, please look at: <a href="http://docs.oracle.com/javase/tutorial/uiswing/components/generaltext.html#filter" rel="noreferrer">Implementing a DocumentFilter</a>.</p> <p><strong>Edit</strong> </p> <p>For instance:</p> <pre><code>import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JTextField; import javax.swing.text.AttributeSet; import javax.swing.text.BadLocationException; import javax.swing.text.Document; import javax.swing.text.DocumentFilter; import javax.swing.text.PlainDocument; public class DocFilter { public static void main(String[] args) { JTextField textField = new JTextField(10); JPanel panel = new JPanel(); panel.add(textField); PlainDocument doc = (PlainDocument) textField.getDocument(); doc.setDocumentFilter(new MyIntFilter()); JOptionPane.showMessageDialog(null, panel); } } class MyIntFilter extends DocumentFilter { @Override public void insertString(FilterBypass fb, int offset, String string, AttributeSet attr) throws BadLocationException { Document doc = fb.getDocument(); StringBuilder sb = new StringBuilder(); sb.append(doc.getText(0, doc.getLength())); sb.insert(offset, string); if (test(sb.toString())) { super.insertString(fb, offset, string, attr); } else { // warn the user and don't allow the insert } } private boolean test(String text) { try { Integer.parseInt(text); return true; } catch (NumberFormatException e) { return false; } } @Override public void replace(FilterBypass fb, int offset, int length, String text, AttributeSet attrs) throws BadLocationException { Document doc = fb.getDocument(); StringBuilder sb = new StringBuilder(); sb.append(doc.getText(0, doc.getLength())); sb.replace(offset, offset + length, text); if (test(sb.toString())) { super.replace(fb, offset, length, text, attrs); } else { // warn the user and don't allow the insert } } @Override public void remove(FilterBypass fb, int offset, int length) throws BadLocationException { Document doc = fb.getDocument(); StringBuilder sb = new StringBuilder(); sb.append(doc.getText(0, doc.getLength())); sb.delete(offset, offset + length); if (test(sb.toString())) { super.remove(fb, offset, length); } else { // warn the user and don't allow the insert } } } </code></pre> <p>Why is this important?</p> <ul> <li>What if the user uses copy and paste to insert data into the text component? A KeyListener can miss this?</li> <li>You appear to be desiring to check that the data can represent an int. What if they enter numeric data that doesn't fit?</li> <li>What if you want to allow the user to later enter double data? In scientific notation?</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. PORestricting JTextField input to Integers
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USHovercraft Full Of Eels
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORestricting JTextField input to Integers
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 Also consider [`InputVerifier`](http://docs.oracle.com/javase/tutorial/uiswing/misc/focus.html#inputVerification).
      singulars
      1. PO
      1. UStrashgod
    2. COThis is pretty cool. I've been staring at for quite a while now and testing it in a simplfied app. I more or less understand what it does and why (more or less!). It creates one problem for me, though. On my JTextBox, after the user hits the enter key, I call a few methods, which I am still using a KeyListener to accomplish. This seems to work. But the VERY last thing that I need to do with this textbox is to clear it out so that new text can be entered. I was doing this with txtAnswer.setText(""); but now it appears that this document filter is blocking this action. Can anybody suggest? Thank
      singulars
      1. PO
      1. USKate
    3. CO@Randy: alter the test(String text) method. Have it return true if `text.trim().isEmpty()` is true.
      singulars
      1. PO
      1. USHovercraft Full Of Eels
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload