在ssm框架上實(shí)現(xiàn)分頁(yè)查詢，具體如下：

1. 首先創(chuàng)建一個(gè)分頁(yè)的實(shí)體類

public class Flexigrid {
     //符合條件總記錄數(shù)
      private int total;
      //當(dāng)前查詢的第幾頁(yè)數(shù)據(jù)
      private int page;
      //總頁(yè)數(shù)
      private int totalPage;
      //每頁(yè)查詢結(jié)果結(jié)束序號(hào)
      @JSONField(serialize=false)
      private int rowEnd;
      //每頁(yè)查詢結(jié)果開(kāi)始序號(hào)
      @JSONField(serialize=false)
      private int rowStart;
      //每頁(yè)結(jié)果數(shù)
      private int rp;
      //查詢條件
      @JSONField(serialize=false)
      private Object obj;
      //返回結(jié)果
      @JsonSerialize(include=JsonSerialize.Inclusion.NON_NULL)
      private List<?> rows;
      //......其他get、set方法
      public int getTotalPage() {          
           if(rp == 0) return 1;
           // 提取信息行數(shù)
           int total = this.total;
           this.totalPage = total / rp; 
           int mod = total % this.rp;
           if (mod != 0)
           this.totalPage += 1; 
           return totalPage;
      }
}

2. Controller ，student對(duì)象接收參數(shù)，并將對(duì)象作為查詢參數(shù)存入Flexigrid對(duì)象中。

@Controller
@RequestMapping("/student")
public class StudentController { 
    @RequestMapping(value = "/page")
    @ResponseBody
    public Flexigrid page(@RequestBody Student student) {
        Flexigrid flex = new Flexigrid();        
        flex.setObj(student); // 設(shè)置查詢參數(shù)
        flex.setPage(student.getPageNo()); //查詢的第幾頁(yè)數(shù)據(jù)
        flex.setRp(student.getPageSize()); //每頁(yè)結(jié)果數(shù)
        flex.setRowStart((flex.getPage() - 1) * flex.getRp()); //查詢結(jié)果開(kāi)始序號(hào)
        flex.setRowEnd(flex.getPage() * flex.getRp()); //查詢結(jié)果結(jié)束序號(hào)
        List list = studentService.page(flex); //查詢的結(jié)果集
        int total = studentService.total(flex); //符合查詢條件的總記錄數(shù)
        flex.setTotal(total);
        flex.setRows(list);
        flex.setObj(null); //將查詢條件置為空
        return flex;
    }
}

3. service 提供page 和total方法

@Service
@Transactional(readOnly = true)
public class StudentService {
    /**
     * 查詢分頁(yè)數(shù)據(jù)
     * @param flex 包含查詢條件以及分頁(yè)數(shù)據(jù)
     * @return
     */
    public List page(Flexigrid flex) {
        return studentDao.page(flex);
    }   
    /**
     * 獲取查詢信息總數(shù)量
     * @param flex 包含查詢條件以及分頁(yè)數(shù)據(jù)
     * @return
     */
    public Integer total(Flexigrid flex) {
        return studentDao.total(flex);
    }
}

4. dao層定義接口

@MyBatisDao
public interface StudentDao{
    /**
     * 查詢分頁(yè)數(shù)據(jù)
     * @param flex 包含查詢條件以及分頁(yè)數(shù)據(jù)
     * @return
     */
    List<Student> page(Flexigrid flex);    
    /**
     * 獲取查詢信息總數(shù)量
     * @param flex 包含查詢條件以及分頁(yè)數(shù)據(jù)
     * @return
     */
    Integer total(Flexigrid flex);
}

5. 創(chuàng)建映射文件。

namespace屬性值改為上面定義接口的類的全名稱。

每一個(gè)接口方法對(duì)應(yīng)一個(gè)sql，且sql-id需要與接口方法名稱保持一致。

接口方法的請(qǐng)求參數(shù)對(duì)應(yīng)sql的parameterType屬性。

編寫sql-id為page、total的sql 語(yǔ)句。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<!-- 學(xué)生信息 mapper -->
<!-- namespace指向dao接口 -->
<mapper namespace="com.dao.StudentDao" >    
    <!-- 信息個(gè)數(shù)提取 -->
    <select id="total" resultType="int" parameterType="com.entity.Flexigrid">
        SELECT COUNT(t.ID)
        FROM T_STUDENT t
        <where>           
            <if test="obj != null">
                <if test="obj.id != null">
                    AND t.ID=#{obj.id}
                </if>
                <if test="obj.studentName != null">
                    AND t.STUDENT_NAME like '%${obj.studentName}%'
                </if>
            </if>
        </where>
    </select>     
    <!-- 信息分頁(yè) -->
    <select id="page" resultType="com.entity.Student" parameterType="com.entity.Flexigrid">
        SELECT * FROM (SELECT A.*, rownum r FROM (    
            SELECT t.id
            FROM T_STUDENT t
            <where>           
                <if test="obj != null">
                    <if test="obj.id != null">
                        AND t.ID=#{obj.id}
                    </if>
                    <if test="obj.studentName != null">
                        AND t.STUDENT_NAME like '%${obj.studentName}%'
                    </if>
                </if>
            </where>
            ORDER BY t.STUDENT_NAME
        <![CDATA[ ) A WHERE rownum <=#{rowEnd} )B WHERE r > #{rowStart} ]]>
    </select>
</mapper>