MyBatis的分页操作(MySQL)

来源：互联网发布：mvr蒸发器设计软件编辑：程序博客网时间：2024/05/16 17:29

.无条件分页：

<?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"><!--namespace写成类的全限定名有好处，在Dao中方便--><mapper namespace="com.winner.entity.Student">    <!--type是类的全限定名，因为mybatis.xml中有别名的设置，所以用别名，短，方便-->    <resultMap id="studentMap" type="Student">        <id property="id" column="id"/>        <result property="name" column="name"/>        <result property="sal" column="sal"/>    </resultMap>    <!--这里做一个约定，返回值类型以后都写resultMap的id-->    <!--SQL语句这样写易读性更好-->    <select id="findAllWithPage" parameterType="map" resultMap="studentMap">        SELECT id,name,sal        FROM student        LIMIT #{pstart},#{psize}    </select></mapper>

public class StudentDao {    /**     * 无条件分页     * @param start 表示在mysql中从第几条记录的索引号开始显示，索引从0开始     * @param size 表示在mysql中最多显示几条记录     */    public List<Student> findAllWithPage(int start,int size) throws Exception{        SqlSession sqlSession = null;        try{            sqlSession = MybatisUtil.getSqlSession();            Map<String,Object> map = new LinkedHashMap<String,Object>();            map.put("pstart",start);            map.put("psize",size);            return sqlSession.selectList(Student.class.getName() + ".findAllWithPage", map);        }catch(Exception ex){            ex.printStackTrace();            throw ex;        }finally{            MybatisUtil.closeSqlSession();        }    }    public static void main(String[] args) throws Exception{        StudentDao dao = new StudentDao();        System.out.println("--------------------第一页");        List<Student> studentList1 = dao.findAllWithPage(0,3);        for(Student s : studentList1){            System.out.println(s.getId() + " : " + s.getName() + " : " + s.getSal());        }        System.out.println("--------------------第二页");        List<Student> studentList2 = dao.findAllWithPage(3,3);        for(Student s : studentList2){            System.out.println(s.getId() + " : " + s.getName() + " : " + s.getSal());        }        System.out.println("--------------------第三页");        List<Student> studentList3 = dao.findAllWithPage(6,3);        for(Student s : studentList3){            System.out.println(s.getId() + " : " + s.getName() + " : " + s.getSal());        }        System.out.println("--------------------第四页");        List<Student> studentList4 = dao.findAllWithPage(9,3);        for(Student s : studentList4){            System.out.println(s.getId() + " : " + s.getName() + " : " + s.getSal());        }    }}

2.带条件的分页

<select id="findAllByNameWithPage" parameterType="map" resultMap="studentMap">    SELECT id,name,sal    FROM student    WHERE name LIKE #{pname}    limit #{pstart},#{psize}</select>

 /** * 有条件分页 */public List<Student> findAllByNameWithPage(String name,int start,int size) throws Exception{    SqlSession sqlSession = null;    try{        sqlSession = MybatisUtil.getSqlSession();        Map<String,Object> map = new LinkedHashMap<String, Object>();        map.put("pname","%"+name+"%");        map.put("pstart",start);        map.put("psize",size);        return sqlSession.selectList(Student.class.getName()+".findAllByNameWithPage",map);    }catch(Exception ex){        ex.printStackTrace();        throw ex;    }finally{       MybatisUtil.closeSqlSession();    }}

0 0