@Override
 public Object execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
   Contexto oContexto = (Contexto) request.getAttribute("contexto");
   oContexto.setVista("jsp/alumno/list.jsp");
   try {
     AlumnoDao oAlumnoDao = new AlumnoDao(oContexto.getEnumTipoConexion());
     Integer intPages =
         oAlumnoDao.getPages(oContexto.getNrpp(), oContexto.getHmFilter(), oContexto.getHmOrder());
     if (oContexto.getPage() >= intPages) {
       oContexto.setPage(intPages);
     }
     ArrayList<AlumnoBean> listado =
         (ArrayList<AlumnoBean>)
             oAlumnoDao.getPage(
                 oContexto.getNrpp(),
                 oContexto.getPage(),
                 oContexto.getHmFilter(),
                 oContexto.getHmOrder());
     ArrayList<String> vecindad =
         (ArrayList<String>)
             oAlumnoDao.getNeighborhood(
                 "<a href=\"Controller?class=alumno&method=list&rpp="
                     + oContexto.getNrpp()
                     + "&page=",
                 oContexto.getPage(),
                 intPages,
                 2);
     ArrayList<Object> a = new ArrayList<>();
     a.add(listado);
     a.add(vecindad);
     return a;
   } catch (Exception e) {
     throw new ServletException("AlumnoList1: View Error: " + e.getMessage());
   }
 }
  @Override
  public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {

    try {
      AlumnoDao oAlumnoDAO = new AlumnoDao(Conexion.getConection());
      AlumnoBean oAlumno = new AlumnoBean();
      oAlumno.setId(Integer.parseInt(request.getParameter("id")));
      Map<String, String> data = new HashMap<>();
      if (oAlumno != null) {
        oAlumnoDAO.remove(oAlumno);
        data.put("status", "200");
        data.put("message", "se ha eliminado el registro con id=" + oAlumno.getId());
      } else {
        data.put("status", "error");
        data.put("message", "error");
      }
      Gson gson = new Gson();
      String resultado = gson.toJson(data);
      return resultado;
    } catch (Exception e) {
      throw new ServletException("AlumnoRemoveJson: View Error: " + e.getMessage());
    }
  }
 @Override
 public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
   String data;
   try {
     ArrayList<FilterBean> alFilter = new ArrayList<>();
     if (request.getParameter("filter") != null) {
       if (request.getParameter("filteroperator") != null) {
         if (request.getParameter("filtervalue") != null) {
           FilterBean oFilterBean = new FilterBean();
           oFilterBean.setFilter(request.getParameter("filter"));
           oFilterBean.setFilterOperator(request.getParameter("filteroperator"));
           oFilterBean.setFilterValue(request.getParameter("filtervalue"));
           oFilterBean.setFilterOrigin("user");
           alFilter.add(oFilterBean);
         }
       }
     }
     if (request.getParameter("systemfilter") != null) {
       if (request.getParameter("systemfilteroperator") != null) {
         if (request.getParameter("systemfiltervalue") != null) {
           FilterBean oFilterBean = new FilterBean();
           oFilterBean.setFilter(request.getParameter("systemfilter"));
           oFilterBean.setFilterOperator(request.getParameter("systemfilteroperator"));
           oFilterBean.setFilterValue(request.getParameter("systemfiltervalue"));
           oFilterBean.setFilterOrigin("system");
           alFilter.add(oFilterBean);
         }
       }
     }
     AlumnoDao oAlumnoDAO = new AlumnoDao(Conexion.getConection());
     int pages = oAlumnoDAO.getCount(alFilter);
     data = "{\"data\":\"" + Integer.toString(pages) + "\"}";
     return data;
   } catch (Exception e) {
     throw new ServletException("AlumnoGetregistersJson: View Error: " + e.getMessage());
   }
 }