按条件查询 因为翻页是按刷新实现的 只能把条件写在session里

 查询时，先把查询条件写在session里

 public String search() throws Exception   {
  //applicationDao.insertUser(app);

  String searchname = app.getSearchname();
  String userstatus = app.getUserstatus();

  HttpServletRequest request = ServletActionContext.getRequest();
   HttpSession session = request.getSession();
  session.setAttribute("userstatus", userstatus);
  session.setAttribute("searchname", searchname);

     display();
  return "insert";
 }
 

dao层负责读取session里的查询条件

  //分页查询  
   public List queryByPage (int pageSize, int pageNow) {
    HttpServletRequest request = ServletActionContext.getRequest();
    HttpSession session =  request.getSession();

    String sql_exd="";
    String searchname = (String)session.getAttribute("searchname");
    String userstatus = (String)session.getAttribute("userstatus");
    if(searchname!=null)
    {
     if(!searchname.equals(""))
      sql_exd=sql_exd+"and name='"+searchname+"'";

    }
   

    
     List list = new ArrayList () ;
     String sql=" SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM JITUMS.TB_APPLICATION) A WHERE ROWNUM <="+(pageNow*pageSize)+") WHERE RN > "+(pageNow*pageSize-pageSize)+" ";
     sql=sql+sql_exd+" order by app_id desc";
   // System.out.println(sql);
  
  JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
  list = jdbcTemplate.query(sql,
    new RowMapper() {
     public Object mapRow(ResultSet rs, int rowNum)
       throws SQLException {
      application = new Application () ;
      application.setApp_id(rs.getString("app_id")) ;  
      application.setCode(rs.getString("code")) ;  
            application.setName(rs.getString("name"));   
                  return application;
     }
    });
  return list;
   }