lundi 15 mars 2021

Conditional for insert into - Java

I need to create a condition to insert or not the data in a table. There are 11 fields and from 6 to 11 the user may or may not fill it out. If not, It can't save any data in this table. The code was created, but the insert is being made. Does anyone know how to fix? Thank you!

        try {
        PreparedStatement ps_SOFVDISN = connection.prepareStatement(SQL_INSERT_SOFVDISN);

        for (BeanItem beanItem : beanItemLista) {

            ps_SOFVDISN.setString(1, beanItem.getChaveSolicitacao().getCodEstb()); 
            ps_SOFVDISN.setString(2, beanItem.getChaveSolicitacao().getCodPedi()); 
            ps_SOFVDISN.setString(3, beanItem.getChaveSolicitacao().getNumSolcServ()); 
            ps_SOFVDISN.setString(4, beanItem.getItemSs().getNumItemSs()); // NUM_ITEM 
            ps_SOFVDISN.setString(5, " "); 
            ps_SOFVDISN.setString(6, beanItem.getNotaFiscalRef().getSerNfRef()); 
            ps_SOFVDISN.setString(7, beanItem.getNotaFiscalRef().getNumNfRef()); 
            ps_SOFVDISN.setString(8, "");
            ps_SOFVDISN.setString(9, ""); 
            ps_SOFVDISN.setString(10, beanItem.getNotaFiscalRef().getCgcEstbRef());
            ps_SOFVDISN.setString(11, beanItem.getNotaFiscalRef().getQtdUsadaReferencia()); 
        
            if (beanItem.getNotaFiscalRef().getSerNfRef() != null && !beanItem.getNotaFiscalRef().getSerNfRef().trim().equals("") 
                || beanItem.getNotaFiscalRef().getNumNfRef() != null && !beanItem.getNotaFiscalRef().getNumNfRef().trim().equals("")  
                || beanItem.getNotaFiscalRef().getCgcEstbRef() != null && !beanItem.getNotaFiscalRef().getCgcEstbRef().trim().equals("") 
                || beanItem.getNotaFiscalRef().getQtdUsadaReferencia() != null && 
                !beanItem.getNotaFiscalRef().getQtdUsadaReferencia().trim().equals("") && !beanItem.getNotaFiscalRef().getQtdUsadaReferencia().equals(" "))
            {
                        
                if (ps_SOFVDISN.executeUpdate() == 1) {
                    System.out.println("Sucess - Insert ok");
                    retornoResult = true;
                }
            }
            

Aucun commentaire:

Enregistrer un commentaire