public void alteraJobAposExclusao(Connection conn, JobLote job) throws SQLException { ValoresAtualizaJob valores = retornaNovosValores(conn, job); PreparedStatement stmt = null; String update = "update job set qtd_transf = ?, hr_tot = ?, qtd_sucata = ?, status = ? where job = ? and operacao = ? "; stmt = conn.prepareStatement(update); stmt.setDouble(1, valores.getQtdTransf()); stmt.setDouble(2, valores.getHoraTotal()); stmt.setDouble(3, valores.getQtdSucata()); stmt.setString(4, "R"); stmt.setString(5, job.getJob().trim().replace(".", "")); stmt.setInt(6, job.getOperNum()); stmt.executeUpdate(); }