接口
public interface UserMapper { //分页 ListgetUserByLimit(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); Mapmap = 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(); }