自创的easyui分页

来源：互联网发布：塔吊桩基础计算软件编辑：程序博客网时间：2024/05/01 08:13

//controller 同时在你的实体类中加两个字段

和 easyui插件相对应 int page,int rows

    @RequestMapping("/userList.do")
   @ResponseBody
   public Map<String, Object> userList(int page,int rows, HttpServletResponse response, User user) {

         page=(page-1)*rows;
         user.setPage(page);
         user.setRows(rows);
          List<user> users=userServices.limitPage(user);
          HashMap<String, Object> map = new HashMap<String, Object>();
          map.put("rows", users);
           int queryUserCount = saleServices.queryUserCount(user);
           map.put("total", queryUserCount);
         return map;
   }

//DAO

public List<User> limitPage(User user){
return template.selectList("UserList",user);
}

//SQL

<select id="UserList" resultType="User">
select * from user_tb where DEL_FLG='0'

//灵活的模糊查询

        <if test=" uName !=null and uName !='' ">
         and uName like '%${uName}%'
       </if>

limit #{start},#{rows}

</select>

阅读全文

0 0