Controller
@GetMapping("/getUsers/{currPage}/{pageSize}")
public List<User> getUsers(@PathVariable int currPage, @PathVariable int pageSize){
return userService.getUsers(currPage,pageSize);
}
Mapper
@Mapper
public interface UserMapper {
List<User> getUsers(Map<String,Object> data);
}
Service接口
@Repository
public interface UserService {
List<User> getUsers(@Param("currPage") int currPage, @Param("pageSize") int pageSize);
}
Service实现类
@Service
@Transactional
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public List<User> getUsers(int currPage, int pageSize) {
Map<String,Object> data = new HashMap<String,Object>();
data.put("currPage", (currPage-1)*pageSize);
data.put("pageSize", pageSize);
return userMapper.getUsers(data);
}
}
xml
<?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">
<mapper namespace="com.example.wk_cave.mapper.UserMapper">
<select id="getUsers" resultType="User">
SELECT * FROM user_info limit #{currPage},#{pageSize};
</select>
</mapper>
测试