Mybatis

mybatis的分页

rzk · 3月23日 · 2020年本文共548个字 · 预计阅读2分钟131次已读
接口
public
interface UserMapper {   //分页 List getUserByLimit(Map map); }
对应一个xml
"1.0" encoding="UTF-8" ?> DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> namespace="com.rzk.dao.UserMapper"> <select id="getUserByLimit" parameterType="map" resultMap="UserMap"> select * from mybatis.user limit #{starIndex},#{pageS睿共享ize} select> "UserMap" type="user"> "pwd" property="password">
测试
        /*分页*/
    @Test
    public void getUse睿共享rByLimit(){
        SqlSession sqlSession = MybatisUtils.getSqlSessionFactory();
    睿共享    UserMapper mapper = sqlSe睿共享ssion.getMapper(UserMapper.class);
        Map map = new HashMap<>();
        map.put("starIndex",1);
        map.put("pageSize",2);

        List userList = mapper.getUserByLimit(map);
        for (User 睿共享user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }

0 条回应