how to use DateChosser in a query

0

Good to the whole community. I have a problem, I'm doing a program with Netbeans and I use the JDateChooser but when I make a query and delete it does not delete the record but it gives me an error.

Code:

  tblinsumos.getSelectionModel().addListSelectionListener(new ListSelectionListener() {
        @Override
        public void valueChanged(ListSelectionEvent lse) {
            if (tblinsumos.getSelectedRow()!=-1) {
                int fila=tblinsumos.getSelectedRow();
                txtgenerico.setText(tblinsumos.getValueAt(fila, 1).toString());
                txtcomercial.setText(tblinsumos.getValueAt(fila, 2).toString());
                cbforma.setSelectedItem(tblinsumos.getValueAt(fila, 3).toString());
                txtconcent.setText(tblinsumos.getValueAt(fila, 4).toString());
                txtstock.setText(tblinsumos.getValueAt(fila, 5).toString());
                jfecha.setDate((Date) tblinsumos.getValueAt(fila, 7));
                txtlote.setText(tblinsumos.getValueAt(fila, 8).toString());
            }
            throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        }
    });
}

The error it throws: ERRORUnknown column ´deres´in ´Where clause´

In the table I have it this way:

1   idinsumos
2   genérico
3   comercial
4   formafarma
5   concentración
6   stock
7   existencia
8   fecha
9   lote

I am not charged with the date, nor the lot number. Please, and I'm sorry, I'm new to this programming, a million thanks.

    
asked by Carlos Ariza 19.10.2018 в 06:47
source

0 answers