private void actionGetPage( HttpServletRequest request, HttpServletResponse response, ServletContext sc) { int numpage = Integer.parseInt(request.getParameter("numPage")); BeanResultat beanResultat = (BeanResultat) getVariableSession(request, "beanResultat"); int min = numpage * beanResultat.getNbResultByPage() + 1; int max = min + beanResultat.getNbResultByPage() - 1; String requeteLimite = getRequeteLimite(min, max, beanResultat.getRequete()); System.out.println("RequeteLimite: " + requeteLimite); OracleAccess oracle = (OracleAccess) getVariableSession(request, "oracle"); oracle.initCallFunc("PACKAGE_RECHERCHE", "doSearch", 1); BeanResultat beanResultat2 = oracle.doGetListMovies(requeteLimite); beanResultat.setListMovie(beanResultat2.getListMovie()); addVariableSession(request, "beanResultat", beanResultat); }