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) {
}
}
