接口
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 #{starI睿共享ndex},#{pageSize}
select>
"UserMap" type="user">
"pwd" property="password">
测试
/*分页*/
@Test
public void getUserByLimit(){
SqlSession sqlSession = MybatisUtils.getSqlSessionFactory();
UserMapper mapper = sqlSession.getMapper(UserMapper.clas睿共享s);
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);
}睿共享
sqlSessi睿共享on.close();
}