接口
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},#{pageSize} select> "UserMap" type="user"> "pwd" property= 睿共享 "password">
测试 /*分页*/ @Test public void getUserByLimit(){ SqlSession sqlSession = MybatisUtils.getSqlSessionFactory(); UserMapper mapper = sqlSession.getMapper(UserMa睿共享 pper.class);睿共享 Mapmap = new HashMap<>(); map.put("starIndex",1); map.put("pageSize",2); 睿共享 ListuserList = mapper.getUserByLimit(map); for (User user : u 睿共享 serList) { System.out.println(user); } sqlSession.close(); }