Calcul de la somme d'une colonne

?

set

java.lang.IllegalStateException: totalJour fails: 2018-07 2018-09
 at sn.mobilebanking.dao.DaoOperationRetraitImpl.totalOperationRetraitParIntervalleMois(DaoOperationRetraitImpl.java:404)
 at sn.mobilebanking.service.ServiceOperationRetraitImpl.totalOperationRetraitParIntervalleMois(ServiceOperationRetraitImpl.java:68)
 at sn.mobilebanking.presentation.RechercherOperationRetraitMontantSortantIntervalleMoisControlleur.doPost(RechercherOperationRetraitMontantSortantIntervalleMoisControlleur.java:64)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Query returns NULL: SELECT SUM(montant_retrait) FROM operation_retrait WHERE operation_retraitdate like ? AND operation_retraitdate like ?
 at sn.mobilebanking.dao.DaoOperationRetraitImpl.totalOperationRetraitParIntervalleMois(DaoOperationRetraitImpl.java:398)

public double totalOperationRetraitParIntervalleMois(String moisDebut, String moisFin) {
  String sql = "SELECT SUM(montant_retrait) FROM operation_retrait WHERE operation_retraitdate like ? AND operation_retraitdate like ?";
     try (PreparedStatement pst = conn.prepareStatement(sql)) {
         pst.setString(1,moisDebut);
         pst.setString(2,moisFin);
   
         try (ResultSet rs = pst.executeQuery()) {
             if (!rs.next()) {
                 throw new IllegalStateException("Query returns no result: " + sql);
             }
             double sum = rs.getDouble(1);
             if (rs.wasNull()) {
                 throw new IllegalStateException("Query returns NULL: " + sql);
             }
             return sum;
         }
     }
     catch (Exception e) {
         throw new IllegalStateException("totalJour fails: "  + moisDebut + " " + moisFin, e);
     }
 }

 double total=0;
  
  String date1=request.getParameter("date_debut");
  String date2=request.getParameter("date_fin");
  String action=request.getParameter("action");

 total=serv.totalOperationRetraitParIntervalleMois(date1, date2);

  <label>Saisissez les deux mois</label>
                                     <input id=""
           class="footer__email-input form-control form-control--muted"
           name="date_debut" type="text" aria-describedby="footerEmail" 
           placeholder="Année-Mois1" >
     
           <input id=""
           class="footer__email-input form-control form-control--muted"
           name="date_fin" type="text" aria-describedby="footerEmail" 
           placeholder="Année-Mois2" >

@Entity
@Table(name="EMPLOYE")
public class Employe implements Serializable{
 @Id
 @GeneratedValue(strategy=GenerationType.IDENTITY)
 @Column(name="CODE_EMPLOYE")
 private Long codeEmploye;
 private String nomEmploye;
 @ManyToOne
 @JoinColumn(name="CODE_EMPLOYE_SUP")
 private Employe employeSup;
public Employe(String nomEmploye,  Employe employeSup) {
  super();
  this.nomEmploye = nomEmploye;
  this.employeSup = employeSup;
 }
public Employe(String nomEmploye) {
  super();
  this.nomEmploye = nomEmploye;
 }

}

 <div class="form-group">
                  <label for="exampleInputPassword1">Nom complet</label>
                  <input type="text" class="form-control" name="nom"  id="exampleInputPassword1" placeholder="Nom de l'employe" required="required">
                </div>
                <div class="form-group">
       <label for="exampleInputPassword1">Superieur hierarchique</label>
       <select
           class="form-control" name="employeSup">
               <c:forEach var="emp" items="${listeEmployes}">
               <option value="${emp.codeEmploye}">${emp.codeEmploye }- ${emp.nomEmploye}</option>
               </c:forEach>
          </select>
      </div>

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  String nom = request.getParameter("nom");
        String codeEmplSup=request.getParameter("employeSup");
        Employe employeSuperieur=new Employe(codeEmplSup);
        employeSuperieur.setCodeEmploye(Long.parseLong(codeEmplSup));
        
        Employe employe=new Employe();
        employe.setEmployeSup(employeSuperieur);
       
        DaoImpl d=new DaoImpl();
  
  //Appel au constructeur
      Employe e=new Employe(nom);

        d.addEmploye(e, employe.getCodeEmploye());
       
  RequestDispatcher rs = request.getRequestDispatcher("register.jsp");
  rs.forward(request, response);
 }

public Employe addEmploye(Employe e, Long codeSup) {
  
  try {
      entityManagerFactory=Persistence.createEntityManagerFactory("livrablejpa");
      entityManager=entityManagerFactory.createEntityManager();
      entityTransaction=entityManager.getTransaction();
      entityTransaction.begin();  
  
 
      if (codeSup !=null) {
      Employe sup=entityManager.find(Employe.class, codeSup);
      e.setEmployeSup(sup); 
   }
   entityManager.persist(e);
   entityTransaction.commit(); 

  } catch (Exception e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
 return e;
       
       
 }