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