这篇文章主要为大家详细介绍了SpringBoot实现分页功能，文中示例代码介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
本文实例为大家分享了SpringBoot实现分页功能的具体代码，供大家参考，具体内容如下
新建demo\src\main\java\com\example\demo\mapper\UserMapper.java
package com.example.demo.mapper; import com.example.demo.entity.User; import org.apache.ibatis.annotations.Mapper; import java.util.List; Mapper public interface UserMapper { public List findUserByName(String userName); public List ListUser(); public List queryPage(Integer startRows); public int getRowCount(); public int insertUser(User user); public int delete(int userId); public int Update(User user); }
新建demo\src\main\resources\mapper\UserMapper.xml
SELECT * FROM user SELECT * FROM user where userName like concat(concat('%',#{userName}),'%') order by userId desc select * from user order by userId desc limit #{startRows},5 select count(*) from user INSERT INTO user ( userId,userDate,userName,userAddress ) VALUES ( #{userId}, #{userDate, jdbcType=VARCHAR}, #{userName, jdbcType=VARCHAR}, #{userAddress, jdbcType=VARCHAR} ) delete from user where userId=#{userId} update user set user.userDate=#{userDate},user.userName=#{userName},user.userAddress=#{userAddress} where user.userId=#{userId}
新建demo\src\main\java\com\example\demo\service\UserService.java
package com.example.demo.service; import com.example.demo.entity.User; import com.example.demo.mapper.UserMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; Service public class UserService { @Autowired private UserMapper userMapper; public List findByName(String userName) { return userMapper.findUserByName(userName); } public List queryPage(Integer startRows) { return userMapper.queryPage(startRows); } public int getRowCount() { return userMapper.getRowCount(); } public User insertUser(User user) { userMapper.insertUser(user); return user; } public List ListUser(){ return userMapper.ListUser(); } public int Update(User user){ return userMapper.Update(user); } public int delete(int userId){ return userMapper.delete(userId); } }
新建demo\src\main\java\com\example\demo\controller\UserCtrl.java
package com.example.demo.controller; import com.example.demo.entity.User; import com.example.demo.service.UserService; import org.springframework.beans.factory.annotation.Autowire<mark style="color:transparent">来源gaodaimacom搞#代%码网</mark>d; import org.springframework.web.bind.annotation.*; import java.util.List; RestController public class UserCtrl { @Autowired private UserService userService; @RequestMapping(value = "/delete", method = RequestMethod.POST) public Integer delete(Integer userId) { System.out.println(userId); int result = userService.delete(userId); return result; } @RequestMapping(value = "/update", method = RequestMethod.POST) @ResponseBody public String update(User user) { int result = userService.Update(user); if (result >= 1) { return "修改成功"; } else { return "修改失败"; } } @RequestMapping(value = "/insert", method = RequestMethod.POST) public User insert(User user) { return userService.insertUser(user); } @RequestMapping("/ListUser") @ResponseBody public List ListUser() { return userService.ListUser(); } @RequestMapping("/ListByName") @ResponseBody public List ListUserByName(String userName) { return userService.findByName(userName); } /** * 分页 * @return */ @RequestMapping(value="/page") @ResponseBody public List page(Integer page){ int pageNow = page == null ? 1 : page; int pageSize = 5; int startRows = pageSize*(pageNow-1); List list = userService.queryPage(startRows); return list; } /** * rows * @return */ @RequestMapping(value="/rows") @ResponseBody public int rows(){ return userService.getRowCount(); } }
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持gaodaima搞代码网。
以上就是SpringBoot实现分页功能的详细内容，更多请关注gaodaima搞代码网其它相关文章！
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：SpringBoot实现分页功能
转载请注明原文链接：SpringBoot实现分页功能
