ssm整合之五 分页以及按时间查询

public interface EmpDao { 
  /**
   * 获取雇员总数量
   * @return
   */
  public int searchAll(Map map);
  public List<Emp> search(Map map);
}

<select id="searchAll"  parameterType="java.util.Map" resultType="int">
        select  count(*) from emp  <where>
         <if test="minSal>0">
              and sal > #{minSal}
          </if>
        </where>  
    </select>
    <select id="search" parameterType="java.util.Map" resultType="com.entity.Emp">
        select  empno,ename,sal from
         (select rownum r ,e.* from emp e
         <if test="minSal>0">
              where  e.sal > #{minSal}
          </if>
         ) a where a.r > #{start}
          and a.r < #{end} 

    </select>

//业务层的接口
public interface IEmpService {

  //分页；
  public PageData getList(Map map);
}

@Service("service")
public class EmpService implements IEmpService {
  //注入，byName类型;
  @Resource
  private EmpDao empDao;//数据层;


  public PageData getList(Map map) {
    PageData pageData=new PageData(empDao.searchAll(map),empDao.search(map));
    return pageData;
  }


}

@Controller
@RequestMapping("/emp") //窄化处理
public class EmpController {
  //自动注入
  @Resource
  private IEmpService service;

  @RequestMapping("/list")
  public String getList(Model model){//Model:模型，只存数据
    List<Emp>list=service.getList();
    model.addAttribute("size",list.size());
    model.addAttribute("list",list);//存放集合
    return "test2";//返回到list页面
  }
  //分页
  @RequestMapping("/list2")
  public String list(Model model,Integer pageNo,Integer minSal,HttpServletRequest request){
    System.out.println("URI地址："+request.getRequestURI());
//    Enumeration  pNames=request.getParameterNames();  
//     while(pNames.hasMoreElements()){  
//      String  name=(String)pNames.nextElement();
//      System.out.println("name:"+name+"="+request.getParameter(name));
//     }
    int pageSize=3;
    if(pageNo==null){
      pageNo=1;
    }
    Map map =new HashMap();
    map.put("start", (pageNo-1)*pageSize);
    map.put("end", pageNo*pageSize+1);
    map.put("minSal",minSal);
    PageData pageData = service.getList(map);
    int count = pageData.getCount();//总数量
    String pageString = new PageUtil(pageSize, pageNo, count, request).getPageString();
    model.addAttribute("list", pageData.getList());
    model.addAttribute("pageString", pageString);
    return "list";
  }

}

<form method="post" action="emp/list2">
        最低工资：<input type="text" name="minSal" value="${param.minSal}"/>
      最高工资：<input type="text" name="maxSal">
        <input type="submit" value="查询"/>
    </form>
    <table border="1" align="center" width="100%">
    <tr align="center">
        <td>工号</td><td>姓名</td><td>工资</td><td>操作</td>
    </tr>
    <c:forEach items="${list }" var="emp">
        <tr>
            <td>${emp.empno }</td>
            <td>${emp.ename }</td>
            <td>${emp.sal }</td>
            <td><!--view->controller->view -->
                <a href='emp/toAddEmp'>增加</a>
                <a href='emp/getEmp/${emp.empno}'>编辑</a>
                <a href='emp/${emp.empno}/deleteEmp'>删除</a>
                <a href='emp/deleteEmp2?empno=${emp.empno}'>删除2</a>
            </td>
        </tr>
    </c:forEach>
    <tr align="center"><td colspan="4">${pageString}</td></tr>
    </table>

@RequestMapping("/getemps")
  public String list(Model model,Integer pageNo,HttpServletRequest request,Integer empno,String ename,Date hiredate){
    System.out.println("URI地址："+request.getRequestURI());
    int pageSize=5;//每页条数
    if(pageNo==null){
      pageNo=1;
    }
    Map map =new HashMap();
    map.put("start", (pageNo-1)*pageSize);
    map.put("end", pageNo*pageSize+1);
    map.put("empno",empno);
    map.put("ename", ename);
    SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
    if(hiredate!=null){
      String s=sdf.format(hiredate);
      System.out.println(s);
      map.put("hiredate", s);
    }
    PageData pageData =empservice.getList(map);
    int count = pageData.getCount();//总数量
    String pageString = new PageUtil(pageSize, pageNo, count, request).getPageString();
    model.addAttribute("emps", pageData.getList());
    model.addAttribute("pageString", pageString);
    return "emp/getemps";
  }