private void txtKeyReleased(java.awt.event.KeyEvent evt) { try { String sCari = txt.getText(); switch (evt.getKeyCode()) { case java.awt.event.KeyEvent.VK_ENTER: { if (lst.isVisible()) { Object[] obj = lst.getOResult(); if (obj.length > 0) { txt.setText(obj[0].toString()); lbl.setText(obj[1].toString()); System.out.println(lbl.getText()); lst.setVisible(false); } } break; } case java.awt.event.KeyEvent.VK_DOWN: { if (lst.isVisible()) { lst.setFocusableWindowState(true); lst.setVisible(true); lst.requestFocus(); } break; } default: { String sText = sFieldShow; String sWhere = ""; while (sText.contains(",")) { sWhere = sWhere + sText.substring(0, sText.indexOf(",")) + " like '%" + sCari.trim().toUpperCase() + "%' OR "; sText = sText.substring(sText.indexOf(",") + 1, sText.length()); } sWhere = sWhere + sText + " like '%" + sCari.trim().toUpperCase() + "%'"; if (!sExFil.trim().equals("")) { sWhere = "(" + sWhere + ") and " + sExFil; } /* sSql="select "+sFieldShow+" from "+sTable+" where "+sFieldShow.substring(0, sFieldShow.indexOf(","))+ " like '%"+sCari.trim().toUpperCase()+"%' OR "+sFieldShow.substring(sFieldShow.indexOf(",")+1, sFieldShow.length())+ " like '%"+sCari.trim().toUpperCase()+"%' order by "+sFieldShow.substring(0, sFieldShow.indexOf(",")); */ sSql = "select " + sFieldShow + " from " + sTable + " where " + sWhere + " order by " + sFieldShow.substring(0, sFieldShow.indexOf(",")); lst.setSQuery(sSql); // Integer txtY=txt.getY()+tblY; // Integer txtY=tblY; lst.setBounds(tblX + txt.getX(), tblY.intValue() + txt.getHeight(), 200, 200); lst.setFocusableWindowState(false); lst.setTxtCari(txt); lst.setLblDes(new javax.swing.JLabel[] {lbl}); lst.setTable(tbl); lst.setIRow(iRow); // lst.setLblDes(lbl); lst.setColWidth(0, 75); lst.setColWidth(1, 200); lst.setVisible(true); break; } } } catch (SQLException se) { } }