private void actualizarListaProd() {
        abrirBase();
        tablaProd.setRowCount(0);
        prodlista = Articulo.where("codigo like ? or descripcion like ?", "%" + textcodprod.getText() + "%", "%" + textcodprod.getText() + "%");
        Iterator<Articulo> it = prodlista.iterator();
        while (it.hasNext()) {
            Articulo a = it.next();
            String rowArray[] = new String[4];
            rowArray[0] = a.getId().toString();
            rowArray[1] = a.getString("codigo");
            rowArray[2] = a.getString("marca");
            rowArray[3] = a.getString("descripcion");
            tablaProd.addRow(rowArray);
        }
        Articulo a = Articulo.findFirst("codigo = ?", textcodprod.getText());
        if (a != null) {
            String fram = a.getString("equivalencia_fram");
            if (!(fram.equals(""))) {
                prodlista = busqueda.filtroProducto2(fram);
                it = prodlista.iterator();
                while (it.hasNext()) {
                    Articulo b = it.next();
                    if (!(b.getInteger("id").equals(a.getInteger("id")))) {
                        String rowArray[] = new String[4];
                        rowArray[0] = b.getId().toString();
                        rowArray[1] = b.getString("codigo");
                        rowArray[2] = b.getString("marca");
                        rowArray[3] = a.getString("descripcion");
                        tablaProd.addRow(rowArray);
                        {
                        }
                    }
                }

            }
        }
        if (Base.hasConnection()) {
            Base.close();
        }
    }