ssm实现分页查询的实例

   SELECT * number from user limit #{page},10
 

 
 css" href="css/index.css" rel="external nofollow" >



 

   
    
     
      

     

  

   
username
   
password
   
sex
   
email
   
createTime
   
updateTime
  
  

       
${u.username}
       
${u.password}
       
${u.sex}
       
${u.email}
       

       

      
     
    
    

      

      

      

      

      

     
    
   
  
 
 

  
首页
  
上一页
  
<%=session.getAttribute("page")%>/${ulist[0].number}
  
)">下一页
  
末页
 


 
 

body{
 width: 100%;
 margin: 0;
}
table{
 border:1px solid red;
 text-align: center;
 margin: auto;
 border-collapse: collapse;
}
tr{
 border: 1px solid #ddd
}
th{
 
 font-weight: 700;
 
}
td{
 
}
.page{
 margin: auto;
 
 text-align: center;
 margin-top: 10px;
}
.page_cell{
 float: left;
 
 border:1px solid #F5F5F5;
 margin:2px;
 cursor: pointer;
}
.page_cell:hover{
 -webkit-box-shadow: #777 0px 0px 1px;
}

/**
 * 下一页
 */
function next_page(page){
 var data = {
  "page":page
 };
 $.ajax({
  type:"post",
  url:"/RoleControl/next_page.do",
  data:JSON.stringify(data),
  dataType:"json",
  contentType:"application/json",
  success:function(data){
   var show_data = document.getElementById("show_data")
   show_data.innerHTML = " ";
   for(i=0; i

@RequestMapping("/index.do")
 public String index(ModelMap map, HttpSession session){
  session.setAttribute("page",1);
  List ulist = userService.selectUsersByPage(0);
  map.put("ulist",ulist);
  return "index";
 }

 /**
  * 用户信息分页查询
  * @param params
  * @return
  */
 @RequestMapping(value = "/next_page.do",method = RequestMethod.POST)
 @ResponseBody
 public String getUsersByPage(@RequestBody JSONObject params){
  // Map paramsMap = JSON.parseObject(params,new TypeReference>(){});
  System.out.println(params.get("page").toString());
  List ulist = userService.selectUsersByPage(Integer.parseInt(params.get("page").toString())*10);
  return JSON.toJSONString(ulist);
 }

ByteArrayHttpMessageConverter 
StringHttpMessageConverter 
ResourceHttpMessageConverter 
SourceHttpMessageConverter 
XmlAwareFormHttpMessageConverter 
Jaxb2RootElementHttpMessageConverter 
MappingJacksonHttpMessageConverter

    
      com.fasterxml.jackson.core
      jackson-core
      2.5.2
    

    
      com.fasterxml.jackson.core
      jackson-databind
      2.5.2
    

begin 
  declare pid int;
  set pid = 10000;
  while pid>0 DO
    insert into user values (pid,'pw','sex','email',now(),now());
    set pid = pid-1;
  end while;
end